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 Other = new Dictionary(); List> dataList = UnionPayChangeSettlementCardListDo(value, out Other); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other }); } private List> UnionPayChangeSettlementCardListDo(string value, out Dictionary 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 = new List(); List> dataList = new List>(); Other = new Dictionary(); int count = 0; List> source = MerchantChangeSettlementCardRecordService.List(relationData, condition, out count, pageNum, pageSize); foreach (Dictionary subdata in source) { Dictionary curData = new Dictionary(); 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 Obj = UnionPaySearchSettlementCardInfoDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj }); } private Dictionary UnionPaySearchSettlementCardInfoDo(string value) { JsonData data = JsonMapper.ToObject(value); int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户Id Dictionary Obj = new Dictionary(); 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 Obj = new Dictionary(); //添加或修改银联商户修改结算卡记录 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 } }