public JsonResult GetUserBankCard(int userId)
{
Tnet_Bank_AccountCollection daAccountColl = new Tnet_Bank_AccountCollection();
daAccountColl.ListByUserId(userId);
List <object> data = daAccountColl.DataTable.ToDynamic();
return(SuccessResultList(data));
}
public bool Validate(int id, bool isValid, string remarks, int op_user_id)
{
BeginTransaction();
Tnet_Bank_Account daAccount = new Tnet_Bank_Account();
daAccount.ReferenceTransactionFrom(Transaction);
if (!daAccount.SelectByPk(id))
{
Rollback();
Alert("找不到银行卡信息");
return(false);
}
Tnet_User_Documents daDocs = new Tnet_User_Documents();
if (!daDocs.SelectByUser_Id_Documents_Type(daAccount.User_Id, (int)DocsType.身份证))
{
Rollback();
Alert("绑定银行卡必须先认证，找不到该会员的认证信息");
return(false);
}
if (daDocs.Status != (int)ValidateStatus.审核通过)
{
Rollback();
Alert("绑定银行卡必须先认证，该会员的认证状态：" + ((ValidateStatus)daDocs.Status).ToString());
return(false);
}
string validMessage = string.Format("{0}|{1}|{2}|{3}", op_user_id, DateTime.Now, isValid, remarks);
daAccount.Remarks = validMessage;
daAccount.Status = (int)(isValid ? ValidateStatus.审核通过 : ValidateStatus.审核未通过);
if (!daAccount.Update())
{
Rollback();
Alert("操作失败，请重试");
return(false);
}
Tnet_Bank_AccountCollection daCollection = new Tnet_Bank_AccountCollection();
daCollection.ReferenceTransactionFrom(Transaction);
daCollection.ListByUserId(daAccount.User_Id);//查询会员已有银行数量
//如果只允许绑定一张卡,并且当前审核状态为成功，且会员当前拥有银行卡数量大于限制
Log.Info($"会员已有银行卡数量：{daCollection.Count},系统允许绑定银行卡数量：{AppConfig.MaxBankCardQuota},审核状态：{isValid},应用配置区域：{Winner.ConfigurationManager.ConfigurationProvider.AppId}");
if (AppConfig.MaxBankCardQuota == 1 && isValid && daCollection.Count > AppConfig.MaxBankCardQuota)
{
Log.Info("作废旧银行卡");
if (!daCollection.DeleteAllExceptById(daAccount.Id, daAccount.User_Id))
{
Alert("作废旧银行卡失败");
Rollback();
return(false);
}
}
Commit();
return(true);
}
public JsonResult GetAuthCards(string userCode, string userName, DateTime?startdate, DateTime?enddate)
{
Tnet_Bank_AccountCollection daAccountColl = new Tnet_Bank_AccountCollection();
daAccountColl.ChangePage = this.ChangePage();
daAccountColl.ListByAdmin(userCode, userName, startdate, enddate);
List <object> dataList = daAccountColl.DataTable.ToDynamic();
return(SuccessResultList(dataList, daAccountColl.ChangePage));
}
public JsonResult List()
{
var user = xUtils.GetUserByCode(Package.UserCode);
if (user == null)
{
return(Json(FuncResult.FailResult("用户未注册", 404)));
}
Tnet_Bank_AccountCollection daAcctColl = new Tnet_Bank_AccountCollection();
daAcctColl.ListByUserId(user.UserId);
List <object> list = new List <object>();
foreach (Tnet_Bank_Account acct in daAcctColl)
{
var card = new
{
Card_Id = acct.Id,
CardHolder = acct.Account_Name,
Card_No = acct.Card_No,
Bank_Id = acct.Bank_Id,
Branch_Name = acct.Branch_Bank,
Branch_No = acct.Branch_No,
Bank_Name = acct.Bank_Name,
Province_Name = acct.Province_Name,
City_Name = acct.City_Name,
Status = acct.Status,
Createtime = acct.Createtime,
RefuseReason = xUtils.GetValidateRemarks(acct.Remarks),
};
list.Add(card);
}
FuncResult <object> result = new FuncResult <object>();
result.Success = true;
result.Message = null;
result.StatusCode = 1;
result.Content = list;
return(Json(result));
}
