/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
BankcardTypeInfoModel bankcardtypeinfo = new BankcardTypeInfoModel();
ret = DbUtil.Current.DeleteMultiple(bankcardtypeinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="bankcardtypeinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(BankcardTypeInfoModel bankcardtypeinfo)
{
int ret = 0;
bankcardtypeinfo.ModifiedBy = SessionUtil.Current.UserId;
bankcardtypeinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(bankcardtypeinfo);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="bankcardtypeinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(BankcardTypeInfoModel bankcardtypeinfo, ParameterCollection pc)
{
int ret = 0;
bankcardtypeinfo.ModifiedBy = SessionUtil.Current.UserId;
bankcardtypeinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(bankcardtypeinfo, pc);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="bankcardtypeid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string bankcardtypeid)
{
int ret = 0;
BankcardTypeInfoModel bankcardtypeinfo = new BankcardTypeInfoModel();
bankcardtypeinfo.BankcardTypeId = bankcardtypeid;
ret = DbUtil.Current.Delete(bankcardtypeinfo);
return(ret);
}
/// <summary>
/// 新建银行卡信息。
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool NewBankCardTypeInfo(BankcardTypeInfoModel info)
{
bool result = false;
if (Create(info) > 0)
{
result = true;
BankCardTypeTable = null;
}
return(result);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <BankcardTypeInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <BankcardTypeInfoModel> bankcardtypeinfos = new List <BankcardTypeInfoModel>();
BankcardTypeInfoModel bankcardtypeinfo = new BankcardTypeInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(bankcardtypeinfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
bankcardtypeinfo = new BankcardTypeInfoModel();
bankcardtypeinfo.ConvertFrom(dt, i);
bankcardtypeinfos.Add(bankcardtypeinfo);
}
return(bankcardtypeinfos);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="bankcardtypeid"></param>
/// <returns>实体</returns>
public BankcardTypeInfoModel Retrieve(string bankcardtypeid)
{
BankcardTypeInfoModel bankcardtypeinfo = new BankcardTypeInfoModel();
bankcardtypeinfo.BankcardTypeId = bankcardtypeid;
DataTable dt = DbUtil.Current.Retrieve(bankcardtypeinfo);
if (dt.Rows.Count < 1)
{
return(null);
}
bankcardtypeinfo.ConvertFrom(dt);
return(bankcardtypeinfo);
}
public BankcardTypeInfoModel GetBankCardInfoByBinCode(string binCode)
{
if (binCode == null)
{
return(null);
}
BankcardTypeInfoModel result = null;
string filterSQL = string.Format("card_bin_code = " + binCode);
DataRow[] hasRows = BankCardTypeTable.Select(filterSQL);
if (hasRows.Length > 0)
{
result = new BankcardTypeInfoModel();
ModelConvertFrom(result, hasRows[0]);
}
return(result);
}
/// <summary>
/// 根据ID获取银行卡信息。
/// </summary>
/// <param name="cardTypeId"></param>
/// <returns></returns>
public BankcardTypeInfoModel GetBankCardInfoById(string cardTypeId)
{
if (cardTypeId == null)
{
return(null);
}
BankcardTypeInfoModel result = null;
string filterSQL = string.Format("bankcard_type_id = " + cardTypeId);
DataRow[] hasRows = BankCardTypeTable.Select(filterSQL);
if (hasRows.Length > 0)
{
result = new BankcardTypeInfoModel();
ModelConvertFrom(result, hasRows[0]);
}
return(result);
}
public JsonResult DoEditBankCardInfo()
{
BankcardTypeInfoModel model = new BankcardTypeInfoModel();
model.BankcardEnumValue = GetFormData("card_fun");
model.BankcardTypeId = GetFormData("cardId");
model.BankEnumValue = GetFormData("openBankId");
model.CardBinCode = GetFormData("card_bin_code");
model.CardBrand = GetFormData("card_brand");
model.CardLevel = GetFormData("card_level");
model.CardNature = GetFormData("card_nav");
model.CardType = GetFormData("card_type");
model.CurrencyType = GetFormData("card_curreny");
if (model.BankcardTypeId == null ||
model.BankcardEnumValue == null ||
model.BankEnumValue == null ||
model.CardBinCode == null ||
model.CardBrand == null ||
model.CardLevel == null ||
model.CardNature == null ||
model.CardType == null ||
model.CurrencyType == null)
{
LogUtil.Debug("更新卡信息操作失败，提交数据异常，请与管理员联系");
return(FailedJson("操作失败，提交数据异常，请与管理员联系"));
}
if (BankcardTypeInfoService.Instance.UpdateBankCardInfo(model))
{
return(SuccessedJson("成功更新银行卡信息", "System_BankCardInfo", "System_BankCardInfo", "forward", "/system/bankcardinfo"));
}
else
{
return(FailedJson("操作失败，请与管理员联系"));
}
}
// 在此添加你的代码...
public bool UpdateCreditcardInfo(CustomerCreditcardInfoModel creditInfo, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
if (creditInfo == null)
{
message = "参数错误，请与管理员联系";
return(false);
}
CustomerDomainModel customer = CustomerInfoService.Instance.GetCustomerDomainModelById(creditInfo.CustomerId, false);
if (customer == null)
{
message = "参数错误，不存在的客户ID,请与管理员联系";
return(false);
}
CustomerSecurityInfoDomainModel securityInfo = CustomerInfoService.Instance.GetCustomerSecurityInfo(creditInfo.IvrDataId, false);
if (securityInfo == null)
{
message = "未能从IVR系统获取客户输入的敏感信息,请与管理员联系";
return(false);
}
creditInfo.CreditcardNumber = securityInfo.CreditCardNumber;
creditInfo.IdcardNumber = securityInfo.IdCardNumber;
creditInfo.Period = securityInfo.PeriodCode;
creditInfo.SecurityCode = securityInfo.SecurityCode;
if (creditInfo.CreditcardNumber.Length > 6)
{
BankcardTypeInfoModel bankCardTypeModel = BankcardTypeInfoService.Instance.GetBankCardInfoByBinCode(creditInfo.CreditcardNumber.Substring(0, 6));
if (bankCardTypeModel != null)
{
creditInfo.CardType = bankCardTypeModel.CardType;
creditInfo.CardLevel = bankCardTypeModel.CardLevel;
creditInfo.CardBrand = bankCardTypeModel.CardBrand;
creditInfo.CanbeStage = (bankCardTypeModel.BankcardEnumValue == "FEB39D81-26EC-4A20-97F2-F148FDC87AFD") ? 0 : 1;
}
}
if (string.IsNullOrEmpty(creditInfo.CreditcardNumber))
{
message = "未能从IVR系统获取客户输入的敏感信息,请检查输入";
return(false);
}
try
{
BeginTransaction();
if (Update(creditInfo) == 1)
{
CommitTransaction();
message = "成功更新客户持卡信息";
result = true;
CustomerInfoService.Instance.GetCustomerDomainModelById(creditInfo.CustomerId, true);
}
else
{
RollbackTransaction();
message = "更新客户持卡信息失败，请与管理员联系";
result = false;
}
}
catch (Exception ex)
{
RollbackTransaction();
LogUtil.Error("更新客户持卡信息异常", ex);
throw ex;
}
return(result);
}
