mp-adminap/Util/Main2/MerchantChangeSettlementCardRecordUtil.cs

using Library;
using MySystem.Models.Main2;
using MySystem.Service.Main2;
using System.Collections.Generic;
using MySystem.Service.KxsMain;
using System;
using System.Linq;
namespace MySystem.Service.Main2
{
    /// <summary>
    /// 银联商户修改结算卡记录表工具类
    /// </summary>
    public class MerchantChangeSettlementCardRecordUtil
    {

        #region 添加或修改银联商户修改结算卡记录
        /// <summary>
        /// 添加或修改银联商户修改结算卡记录
        /// </summary>
        /// <param name="Id">记录Id</param>
        /// <param name="Operator">操作人</param>
        /// <param name="AlterType">结算类型(0 对公结算银行卡 法人1 对私结算银行卡 2 非法人结算)</param>
        /// <param name="AcctZBankAreas">开户支行地区</param>
        /// <param name="AcctZBankName">开户支行名称</param>
        /// <param name="MchtNo">商户号</param>
        /// <param name="AcctName">开户名称</param>
        /// <param name="AccountNo">卡号</param>
        /// <param name="IdCard">非法人身份证号(结算类型为2时必填，默认传空字符串)</param>
        /// <param name="AgentCardStartDate">非法人身份证有效开始时间(yyyy-MM-dd，结算类型为2时必填，默认传空字符串)</param>
        /// <param name="AgentCardEndDate">非法人身份证有效结束时间(yyyy-MM-dd，结算类型为2时必填，默认传空字符串)</param>
        /// <param name="BankCard">银行卡正面照片(结算类型为1和2时必填，默认传空字符串)</param>
        /// <param name="OpenAccountLicenses">开户许可证(企业类型商户或结算类型为0时必填，默认传空字符串)</param>
        /// <param name="PriLicAgreement">企业法人对私授权书(结算类型为1且为企业商户时必填，默认传空字符串)</param>
        /// <param name="AgentProtocol">委托结算授权书(结算类型为2时必填，默认传空字符串)</param>
        /// <param name="AgentIdCardFront">被委托人身份证人像面(结算类型为2时必填，默认传空字符串)</param>
        /// <param name="AgentIdCardBack">被委托人身份证国徽面(结算类型为2时必填，默认传空字符串)</param>
        /// <param name="HoldAgentProtocol">法人手持委托结算授权书(结算类型为2时必填，默认传空字符串)</param>
        public static string AddOrEditMerchantChangeSettlementCardRecord(int Id, string Operator, string AlterType, string AcctZBankAreas, string AcctZBankName, string MchtNo, string AcctName, string AccountNo, string IdCard, string AgentCardStartDate, string AgentCardEndDate, string BankCard, string OpenAccountLicenses, string PriLicAgreement, string AgentProtocol, string AgentIdCardFront, string AgentIdCardBack, string HoldAgentProtocol)
        {
            WebCMSEntities maindb = new WebCMSEntities();
            var AcctZbankCode = HaoDaAreaCodeService.Query("CityName like '%" + AcctZBankAreas + "%'").CityCode;
            var AcctZbankkNo = OpenBankAllService.Query(" BankChild='" + AcctZBankName + "'").BankChildNo;
            if (string.IsNullOrEmpty(AcctZbankCode) || string.IsNullOrEmpty(AcctZbankkNo))
            {
                return "未找到所选开户地区或开户支行";
            }
            if (Id > 0) //修改
            {
                var info = maindb.MerchantChangeSettlementCardRecord.FirstOrDefault(m => m.Id == Id) ?? new MerchantChangeSettlementCardRecord();
                info.UpdateDate = DateTime.Now;
                info.Operator = Operator;
                info.AlterType = int.Parse(AlterType);
                info.AcctZbankCode = AcctZbankCode;
                info.ZbankNo = AcctZbankkNo;
                info.MchtNo = MchtNo;
                info.AccountName = AcctName;
                info.AccountNo = AccountNo;
                info.IdCard = IdCard;
                info.AgentCardStartDate = DateTime.Parse(AgentCardStartDate);
                info.AgentCardEndDate = DateTime.Parse(AgentCardEndDate);
                info.BankCard = BankCard;
                info.OpenAccountLicenses = OpenAccountLicenses;
                info.PriLicAgreement = PriLicAgreement;
                info.AgentProtocol = AgentProtocol;
                info.AgentIdCardFront = AgentIdCardFront;
                info.AgentIdCardBack = AgentIdCardBack;
                info.HoldAgentProtocol = HoldAgentProtocol;
            }
            else //添加
            {
                var query = maindb.MerchantChangeSettlementCardRecord.Add(new MerchantChangeSettlementCardRecord()
                {
                    CreateDate = DateTime.Now,
                    UpdateDate = DateTime.Now,
                    Operator = Operator,
                    AlterType = int.Parse(AlterType),
                    AcctZbankCode = AcctZbankCode,
                    ZbankNo = AcctZbankkNo,
                    MchtNo = MchtNo,
                    AccountName = AcctName,
                    AccountNo = AccountNo,
                    IdCard = IdCard,
                    AgentCardStartDate = DateTime.Parse(AgentCardStartDate),
                    AgentCardEndDate = DateTime.Parse(AgentCardEndDate),
                    BankCard = BankCard,
                    OpenAccountLicenses = OpenAccountLicenses,
                    PriLicAgreement = PriLicAgreement,
                    AgentProtocol = AgentProtocol,
                    AgentIdCardFront = AgentIdCardFront,
                    AgentIdCardBack = AgentIdCardBack,
                    HoldAgentProtocol = HoldAgentProtocol,
                }).Entity;
            }
            maindb.SaveChanges();
            maindb.Dispose();

            return "success";
        }
        #endregion
    }
}