mp-adminap/Areas/Api/Controllers/v1/Main2/MerchantChangeSettlementCardRecordController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Options;
using Microsoft.AspNetCore.Authorization;
using System.Web;
using MySystem.Models.Main2;
using MySystem.Service.Main2;
using LitJson;
using Library;

namespace MySystem.Areas.Api.Controllers.v1.Main2
{
    [Area("Api")]
    [Route("/v1/QrCodePlateMain/[controller]/[action]")]
    public class MerchantChangeSettlementCardRecordController : BaseController
    {
        public MerchantChangeSettlementCardRecordController(IHttpContextAccessor accessor) : base(accessor)
        {
        }


        #region 商户管理-银联商户修改结算卡记录
        [Authorize]
        public JsonResult UnionPayChangeSettlementCardList(string value)
        {
            value = PublicFunction.DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Other = new Dictionary<string, object>();
            List<Dictionary<string, object>> dataList = UnionPayChangeSettlementCardListDo(value, out Other);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other });
        }
        private List<Dictionary<string, object>> UnionPayChangeSettlementCardListDo(string value, out Dictionary<string, object> Other)
        {
            JsonData data = JsonMapper.ToObject(value);
            string MerchantName = data["MerchantName"].ToString(); //商户名称
            string MchtNo = data["MchtNo"].ToString(); //商户号
            string CreateDate = data["CreateDate"].ToString(); //创建时间
            int pageSize = int.Parse(function.CheckInt(data["page_size"].ToString()));
            int pageNum = int.Parse(function.CheckInt(data["page_num"].ToString()));
            string condition = " and Status>-1";
            if (!string.IsNullOrEmpty(data["MerchantName"].ToString()))
            {
                condition += " and MerchantName='" + MerchantName + "'";
            }
            if (!string.IsNullOrEmpty(data["MchtNo"].ToString()))
            {
                condition += " and MchtNo='" + MchtNo + "'";
            }
            if (!string.IsNullOrEmpty(data["CreateDate"].ToString()))
            {
                string[] datelist = CreateDate.Split(new string[] { " - " }, StringSplitOptions.None);
                string start = datelist[0];
                string end = datelist[1];
                condition += " and CreateDate>='" + start + " 00:00:00' and CreateDate<='" + end + " 23:59:59'";
            }
            List<RelationData> relationData = new List<RelationData>();
            List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
            Other = new Dictionary<string, object>();
            int count = 0;
            List<Dictionary<string, object>> source = MerchantChangeSettlementCardRecordService.List(relationData, condition, out count, pageNum, pageSize);
            foreach (Dictionary<string, object> subdata in source)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("Id", int.Parse(subdata["Id"].ToString())); //Id
                curData.Add("MerchantId", int.Parse(subdata["MerchantId"].ToString())); //商户Id
                curData.Add("MerchantName", subdata["MerchantName"].ToString()); //商户名称
                curData.Add("Status", int.Parse(subdata["Status"].ToString())); //Status(1 待审核 3 审核拒绝 4 任务失效 5 审核通过))
                curData.Add("Remark", subdata["Remark"].ToString()); //审核备注
                curData.Add("CreateDate", subdata["CreateDate"].ToString() == "" ? "" : DateTime.Parse(subdata["CreateDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss")); //交易时间
                curData.Add("MchtNo", subdata["MchtNo"].ToString()); //商户号
                curData.Add("AccountName", subdata["AccountName"].ToString()); //开户名
                curData.Add("AccountNo", subdata["AccountNo"].ToString()); //卡号
                curData.Add("ZBankNo", subdata["ZBankNo"].ToString()); //支行号
                curData.Add("AlterType", subdata["AlterType"].ToString()); //结算类型
                curData.Add("AcctZBankCode", subdata["AcctZBankCode"].ToString()); //开户支行地区码
                curData.Add("IdCard", subdata["IdCard"].ToString()); //非法人身份证号
                curData.Add("AgentCardStartDate", subdata["AgentCardStartDate"].ToString()); //非法人身份证有效开始时间
                curData.Add("AgentCardEndDate", subdata["AgentCardEndDate"].ToString()); //非法人身份证有效结束时间
                curData.Add("TaskId", subdata["TaskId"].ToString()); //任务Id
                curData.Add("BankCard", subdata["BankCard"].ToString()); //银行卡正面照片
                curData.Add("OpenAccountLicenses", subdata["OpenAccountLicenses"].ToString()); //开户许可证
                curData.Add("PriLicAgreement", subdata["PriLicAgreement"].ToString()); //企业法人对私授权书
                curData.Add("AgentProtocol", subdata["AgentProtocol"].ToString()); //委托结算授权书
                curData.Add("AgentIdCardFront", subdata["AgentIdCardFront"].ToString()); //被委托人身份证人像面
                curData.Add("AgentIdCardBack", subdata["AgentIdCardBack"].ToString()); //被委托人身份证国徽面
                curData.Add("HoldAgentProtocol", subdata["HoldAgentProtocol"].ToString()); //法人手持委托结算授权书

                dataList.Add(curData);
            }
            Other.Add("Count", count); //总数
            //批量提交待审核数据
            RedisDbconn.Instance.AddList("UpdateMerchantChangeCardStatus", "1");
            return dataList;
        }
        #endregion


        #region 商户管理-银联查询商户结算卡信息
        [Authorize]
        public JsonResult UnionPaySearchSettlementCardInfo(string value)
        {
            value = PublicFunction.DesDecrypt(value); ;
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Obj = UnionPaySearchSettlementCardInfoDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
        }
        private Dictionary<string, object> UnionPaySearchSettlementCardInfoDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户Id
            Dictionary<string, object> Obj = new Dictionary<string, object>();
            var merchantAddInfo = MerchantAddInfoService.Query(MerchantId);
            var IsChange = 0;
            var check = MerchantChangeSettlementCardRecordService.Query(MerchantId);
            if (check.Id > 0) IsChange = 1;

            Obj.Add("AlterType", merchantAddInfo.AccountType); //结算类型(0 对公结算银行卡 法人1 对私结算银行卡 2 非法人结算)
            Obj.Add("AcctZBankAreas", merchantAddInfo.BankAddressCode); //开户支行地区
            Obj.Add("AcctZBankName", merchantAddInfo.BankName); //开户支行名称
            Obj.Add("MchtNo", merchantAddInfo.MchtNo); //商户号
            Obj.Add("AcctName", merchantAddInfo.AccountName); //开户名称
            Obj.Add("AccountNo", merchantAddInfo.AccountNumber); //卡号(0-对公 时填写对公账号，1-对私 时填写银行卡号)
            Obj.Add("IdCard", ""); //非法人身份证号(结算类型为2时必填，默认传空字符串)
            Obj.Add("AgentCardStartDate", ""); //非法人身份证有效开始时间(yyyy-MM-dd，结算类型为2时必填，默认传空字符串)
            Obj.Add("AgentCardEndDate", ""); //非法人身份证有效结束时间(yyyy-MM-dd，结算类型为2时必填，默认传空字符串)
            Obj.Add("BankCard", merchantAddInfo.BankCard); //银行卡正面照片(结算类型为1和2时必填，默认传空字符串)
            Obj.Add("OpenAccountLicenses", merchantAddInfo.OpenAccountLicenses); //开户许可证(企业类型商户或结算类型为0时必填，默认传空字符串)
            Obj.Add("PriLicAgreement", ""); //企业法人对私授权书(结算类型为1且为企业商户时必填，默认传空字符串)
            Obj.Add("AgentProtocol", ""); //委托结算授权书(结算类型为2时必填，默认传空字符串)
            Obj.Add("AgentIdCardFront", ""); //被委托人身份证人像面(结算类型为2时必填，默认传空字符串)
            Obj.Add("AgentIdCardBack", ""); //被委托人身份证国徽面(结算类型为2时必填，默认传空字符串)
            Obj.Add("HoldAgentProtocol", ""); //法人手持委托结算授权书(结算类型为2时必填，默认传空字符串)
            Obj.Add("MerchantId", MerchantId); //商户Id
            Obj.Add("MerchantName", merchantAddInfo.CertMerchantName); //商户名称
            Obj.Add("AccountType", merchantAddInfo.AccountType); //账户类型(0 对公 1 对私)
            Obj.Add("IsChange", IsChange); //是否已提交修改结算卡(0 否 1 是)
            Obj.Add("CreateDate", check.Id == 0 ? "" : check.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //提交修改时间
            Obj.Add("UpdateDate", check.Id == 0 ? "" : check.UpdateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //提交更新时间
            Obj.Add("ChangeStatus", check.Status); //提交修改状态(1 待审核 3 审核拒绝 4 任务失效 5 审核通过)
            Obj.Add("Remark", check.Remark); //提交备注

            return Obj;
        }
        #endregion


        #region 商户管理-银联提交商户修改结算卡申请
        [Authorize]
        public JsonResult UnionPaySendChangeSettlementCard(string value)
        {
            value = PublicFunction.DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            AppResultJson result = UnionPaySendChangeSettlementCardDo(value);
            return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
        }
        private AppResultJson UnionPaySendChangeSettlementCardDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户Id
            string MerchantName = data["MerchantName"].ToString(); //商户名称
            string MchtNo = data["MchtNo"].ToString(); //商户号
            string AlterType = data["AlterType"].ToString(); //结算类型(0 对公结算银行卡 法人1 对私结算银行卡 2 非法人结算)
            string AcctZBankAreas = data["AcctZBankAreas"].ToString(); //开户支行地区
            string AcctZBankName = data["AcctZBankName"].ToString(); //开户支行名称
            string AcctName = data["AcctName"].ToString(); //开户名称
            string AccountNo = data["AccountNo"].ToString(); //卡号
            string IdCard = data["IdCard"].ToString(); //非法人身份证号(结算类型为2时必填，默认传空字符串)
            string AgentCardStartDate = data["AgentCardStartDate"].ToString(); //非法人身份证有效开始时间(yyyy-MM-dd，结算类型为2时必填，默认传空字符串)
            string AgentCardEndDate = data["AgentCardEndDate"].ToString(); //非法人身份证有效结束时间(yyyy-MM-dd，结算类型为2时必填，默认传空字符串)
            string BankCard = data["BankCard"].ToString(); //银行卡正面照片(结算类型为1和2时必填，默认传空字符串)
            string OpenAccountLicenses = data["OpenAccountLicenses"].ToString(); //开户许可证(企业类型商户或结算类型为0时必填，默认传空字符串)
            string PriLicAgreement = data["PriLicAgreement"].ToString(); //企业法人对私授权书(结算类型为1且为企业商户时必填，默认传空字符串)
            string AgentProtocol = data["AgentProtocol"].ToString(); //委托结算授权书(结算类型为2时必填，默认传空字符串)
            string AgentIdCardFront = data["AgentIdCardFront"].ToString(); //被委托人身份证人像面(结算类型为2时必填，默认传空字符串)
            string AgentIdCardBack = data["AgentIdCardBack"].ToString(); //被委托人身份证国徽面(结算类型为2时必填，默认传空字符串)
            string HoldAgentProtocol = data["HoldAgentProtocol"].ToString(); //法人手持委托结算授权书(结算类型为2时必填，默认传空字符串)

            Dictionary<string, object> Obj = new Dictionary<string, object>();

            //添加或修改银联商户修改结算卡记录
            var info = MerchantChangeSettlementCardRecordUtil.AddOrEditMerchantChangeSettlementCardRecord(MerchantId, MerchantName, Operator, AlterType, AcctZBankAreas, AcctZBankName, MchtNo, AcctName, AccountNo, IdCard, AgentCardStartDate, AgentCardEndDate, BankCard, OpenAccountLicenses, PriLicAgreement, AgentProtocol, AgentIdCardFront, AgentIdCardBack, HoldAgentProtocol);
            if (info == "success")
            {
                return new AppResultJson() { Status = "1", Info = "操作成功", Data = Obj };
            }
            else
            {
                return new AppResultJson() { Status = "-1", Info = info, Data = Obj };
            }
        }
        #endregion

    }
}