public void Add(BasicBank BasicBank)
{
BasicBank = Request.ConvertRequestToModel <BasicBank>(BasicBank, BasicBank);
Entity.BasicBank.AddObject(BasicBank);
Entity.SaveChanges();
BaseRedirect();
}
public ActionResult Index(BasicBank BasicBank, EFPagingInfo <BasicBank> p, int IsFirst = 0)
{
if (IsFirst == 0)
{
PageOfItems <BasicBank> BasicBankList1 = new PageOfItems <BasicBank>(new List <BasicBank>(), 0, 10, 0, new Hashtable());
ViewBag.BasicBankList = BasicBankList1;
ViewBag.BasicBank = BasicBank;
ViewBag.Add = this.checkPower("Add");
ViewBag.Edit = this.checkPower("Edit");
ViewBag.Delete = this.checkPower("Delete");
ViewBag.Save = this.checkPower("Save");
return(View());
}
if (!BasicBank.Name.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Name.Contains(BasicBank.Name));
}
p.OrderByList.Add("Id", "DESC");
IPageOfItems <BasicBank> BasicBankList = Entity.Selects <BasicBank>(p);
ViewBag.BasicBankList = BasicBankList;
ViewBag.BasicBank = BasicBank;
ViewBag.Add = this.checkPower("Add");
ViewBag.Edit = this.checkPower("Edit");
ViewBag.Delete = this.checkPower("Delete");
ViewBag.Save = this.checkPower("Save");
return(View());
}
public void Save(BasicBank BasicBank)
{
BasicBank baseBasicBank = Entity.BasicBank.FirstOrDefault(n => n.Id == BasicBank.Id);
baseBasicBank = Request.ConvertRequestToModel <BasicBank>(baseBasicBank, BasicBank);
Entity.SaveChanges();
BaseRedirect();
}
public void Delete(BasicBank BasicBank, string InfoList, int?IsDel)
{
if (string.IsNullOrEmpty(InfoList))
{
InfoList = BasicBank.Id.ToString();
}
int Ret = Entity.MoveToDeleteEntity <BasicBank>(InfoList, IsDel, AdminUser.UserName);
Entity.SaveChanges();
Response.Write(Ret);
}
public void ChangeStatus(BasicBank BasicBank, string InfoList, string Clomn, string Value)
{
if (string.IsNullOrEmpty(InfoList))
{
InfoList = BasicBank.Id.ToString();
}
int Ret = Entity.ChangeEntity <BasicBank>(InfoList, Clomn, Value);
Entity.SaveChanges();
Response.Write(Ret);
}
public ActionResult Edit(BasicBank BasicBank)
{
if (BasicBank.Id != 0)
{
BasicBank = Entity.BasicBank.FirstOrDefault(n => n.Id == BasicBank.Id);
}
if (BasicBank == null)
{
ViewBag.ErrorMsg = "数据不存在";
return(View("Error"));
}
ViewBag.BasicBank = BasicBank;
if (Request.UrlReferrer != null)
{
Session["Url"] = Request.UrlReferrer.ToString();
}
return(View());
}
public void Post()
{
string Data = DataObj.GetData();
if (Data.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
JObject json = new JObject();
try
{
json = (JObject)JsonConvert.DeserializeObject(Data);
}
catch (Exception Ex)
{
Log.Write("[BasicCity]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
BasicBank BasicBank = new BasicBank();
BasicBank = JsonToObject.ConvertJsonToModel(BasicBank, json);
var query = Entity.BasicBank.AsQueryable();
if (BasicBank.CanCredit == 1)//支持信用卡
{
query = query.Where(o => o.State == 1 && o.CanCredit == 1);
}
else
{
query = query.Where(n => n.State == 1 && n.IsPayCard == 1);
}
IList <BasicBank> BasicBankList = query.ToList();
DataObj.Data = BasicBankList.EntityToJson();
DataObj.Code = "0000";
DataObj.OutString();
}
public void Post()
{
SysSet SysSet = Entity.SysSet.FirstOrNew();
string[] BankArray = new string[] { "工商银行", "建设银行", "农业银行", "中国银行", "邮政储蓄银行", "中信银行", "光大银行", "华夏银行", "民生银行", "上海银行", "北京银行", "东亚银行", "兴业银行", "宁波银行", "浦东发展银行", "广发银行", "平安银行", "长沙银行", "成都农村商业银行", "重庆农村商业银行", "重庆银行", "大连银行", "东营市商业银行", "福建农村信用社", "贵阳银行", "广州银行", "广州农村商业银行", "哈尔滨银行", "湖南省农村信用社", "徽商银行", "河北银行", "杭州银行", "常熟农商银行", "江苏银行", "江阴农商银行", "九江银行", "兰州银行", "龙江银行", "南昌银行", "南京银行", "青海银行", "上海农商银行", "上饶银行", "顺德农商银行", "台州银行", "温州银行", "乌鲁木齐商业银行", "无锡农村商业银行", "吴江农村商业银行", "浙江稠州商业银行", "浙江泰隆商业银行", "浙江民泰商业银行", "锦州银行" };
int i = 1;
IList <BasicBank> List = new List <BasicBank>();
bool Show = false;
if (Equipment.RqType == "Apple")
{
if (SysSet.IosSet10 == 6)
{
Show = true;
}
}
if (Equipment.RqType == "Android")
{
if (SysSet.ApkSet10 == 6)
{
Show = true;
}
}
if (Show)
{
foreach (var p in BankArray)
{
BasicBank BB = new BasicBank();
BB.Id = i;
BB.Name = p;
BB.Cols = "Id,Name";
List.Add(BB);
i++;
}
}
DataObj.Data = List.EntityToJson();
DataObj.Code = "0000";
DataObj.OutString();
}
public void Post()
{
string Data = DataObj.GetData();
if (Data.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
JObject json = new JObject();
try
{
json = (JObject)JsonConvert.DeserializeObject(Data);
}
catch (Exception Ex)
{
Log.Write("[CreditCardAdd]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
UserCard UserCard = new UserCard();
UserCard = JsonToObject.ConvertJsonToModel(UserCard, json);
UserTrack UserTrack = new UserTrack();
UserTrack = JsonToObject.ConvertJsonToModel(UserTrack, json);
if (UserTrack.X.IsNullOrEmpty() || UserTrack.Y.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
string Token = UserCard.Token;
if (!UserCard.Card.IsNullOrEmpty() && !UserCard.ValidYear.IsNullOrEmpty() && !UserCard.ValidMonth.IsNullOrEmpty() && !UserCard.CVV.IsNullOrEmpty() && !UserCard.Mobile.IsNullOrEmpty() && !UserCard.BillDay.IsNullOrEmpty() && !UserCard.BillDay.IsNullOrEmpty() && !UserCard.ValidateCode.IsNullOrEmpty())
{
if (UserCard.ValidYear.Length == 4)
{
UserCard.ValidYear = UserCard.ValidYear.Substring(UserCard.ValidYear.Length - 2, 2);
}
}
else
{
DataObj.OutError("1000");
return;
}
if (UserCard.Card.Length < 6)
{
DataObj.OutError("1000");
return;
}
#region 基础验证
//获取用户信息
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
DataObj.OutError("2006");
return;
}
UserBlackList UserBlackList = Entity.UserBlackList.FirstOrDefault(UBL => UBL.CardNumber == UserCard.Card && UBL.State == 3);
if (UserBlackList != null)
{
//提示暂不支持该卡绑定
DataObj.OutError("2017");
return;
}
UserCard UserCard_ = Entity.UserCard.FirstOrDefault(n => n.UId == baseUsers.Id && n.Card == UserCard.Card && n.Type == 2 && n.State == 1);//信用卡已绑定
if (UserCard_ != null)
{
DataObj.OutError("2015");
return;
}
UserCard.Card = UserCard.Card.Replace(" ", "");
string cardbin = UserCard.Card.Substring(0, 6);
var BasicCardBin = this.Entity.BasicCardBin.Where(o => o.BIN == cardbin).FirstOrDefault();
if (BasicCardBin == null)
{
byte UsedCardType = this.GetCardType(UserCard.Card);
if (UsedCardType == 0)
{
DataObj.OutError("7005");//查询次数用完了
return;
}
else if (UsedCardType != 2)
{
DataObj.Msg = "请使用信用卡绑定";
DataObj.OutError("1000");
return;
}
}
else
{
if (BasicCardBin.CardType != 2)
{
DataObj.Msg = "请使用信用卡绑定";
DataObj.OutError("1000");
return;
}
}
BasicBank BasicBank = Entity.BasicBank.FirstOrDefault(n => n.Name == UserCard.Bank);
if (BasicBank == null)
{
DataObj.OutError("1000");
return;
}
else
{
if (BasicBank.BIN.IsNullOrEmpty())
{
DataObj.Msg = "卡BIN未设置";
DataObj.OutError("1000");
return;
}
}
#endregion
UserCard.Type = 2;
UserCard.BId = BasicBank.Id;
UserCard.Bin = BasicBank.BIN;
UserCard.UId = baseUsers.Id;
UserCard.Name = baseUsers.TrueName;
//=======================================
UserTrack.ENo = DataObj.ENo;
UserTrack.OPType = "添加信用卡";
UserTrack.GPSAddress = UserTrack.GPSAddress;
UserTrack.GPSX = UserTrack.X;
UserTrack.GPSY = UserTrack.Y;
baseUsers.SeavGPSLog(UserTrack, Entity);
//=======================================
string RetString = ""; //三方接口返回数据
string bindId = string.Empty; //绑卡需记录字符串
bool IsSuccess = false; //绑卡状态
JobPayWay JobPayWay = Entity.JobPayWay.Where(n => n.State == 1 && n.GroupType == "Pay").OrderBy(n => n.Sort).FirstOrDefault(); //目前只支持一条
if (JobPayWay == null)
{
DataObj.Msg = "暂无可用通道";
DataObj.OutError("1000");
return;
}
#region 第三方鉴权
string[] JobPayWayArr = JobPayWay.QueryArray.Split(',');
if (JobPayWay.DllName == "HLBPay" && JobPayWayArr.Length == 2)
{
#region 合利宝
string MerId = JobPayWayArr[0];
string MerKey = JobPayWayArr[1];
string postUrl = "http://pay.trx.helipay.com/trx/quickPayApi/interface.action";
string orderId = Guid.NewGuid().ToString("N");
Dictionary <string, string> map = new Dictionary <string, string>();
map.Add("P1_bizType", "QuickPayBindCard");
map.Add("P2_customerNumber", MerId);
map.Add("P3_userId", "HF_" + baseUsers.Id.ToString()); //用户ID唯一
map.Add("P4_orderId", orderId);
map.Add("P5_timestamp", DateTime.Now.ToString("yyyyMMddHHmmss"));
map.Add("P6_payerName", baseUsers.TrueName);
map.Add("P7_idCardType", "IDCARD"); //IDCARD：身份证
map.Add("P8_idCardNo", baseUsers.CardId); //身份证
map.Add("P9_cardNo", UserCard.Card); //银行卡
map.Add("P10_year", UserCard.ValidYear); //当银行卡是信用卡时必输 信用卡有效期年
map.Add("P11_month", UserCard.ValidMonth); //当银行卡是信用卡时必输 信用卡有效期月
map.Add("P12_cvv2", UserCard.CVV); //当银行卡是信用卡时必输 信用卡有效期月
map.Add("P13_phone", UserCard.Mobile);
map.Add("P14_validateCode", UserCard.ValidateCode); //选填 鉴权绑卡短信接口下发给用户的短信
//签名串，把参数值拼接
string data = Utils.CreateLinkString(map, false);
//MD5签名KEY
string sign = ("&" + data + "&" + MerKey).GetMD5();
map.Add("sign", sign);
if (map["P6_payerName"] != null) //编码
{
map.Remove("P6_payerName");
map.Add("P6_payerName", HttpUtility.UrlEncode(baseUsers.TrueName));
}
string send_data = Utils.CreateLinkString(map);
RetString = Utils.PostRequest(postUrl, send_data, "utf-8");
//================================================
//这里记录日志
JobLog JobLog = new JobLog();
JobLog.PayWay = JobPayWay.Id;
JobLog.ReqNo = orderId;
JobLog.TNum = baseUsers.Mobile;
JobLog.Trade = "";
JobLog.Amount = 0;
JobLog.Way = "CardAdd";
JobLog.AddTime = DateTime.Now;
JobLog.Data = RetString;
JobLog.State = 1;
Entity.JobLog.AddObject(JobLog);
Entity.SaveChanges();
//================================================
JObject obj = new JObject();
try
{
obj = (JObject)JsonConvert.DeserializeObject(RetString);
}
catch (Exception)
{
Utils.WriteLog("[CreditCardAdd]:" + RetString, "HLBPayError");
DataObj.OutError("1000");
return;
}
string rt2_retCode = obj["rt2_retCode"].ToString();
string rt3_retMsg = obj["rt3_retMsg"].ToString();
if (rt2_retCode == "0000")
{
string rt7_bindStatus = obj["rt7_bindStatus"].ToString(); //绑卡状态结果 /成功/失败
if (rt7_bindStatus == "SUCCESS")
{
IsSuccess = true;
bindId = obj["rt10_bindId"].ToString();
}
else
{
DataObj.Msg = rt3_retMsg;
DataObj.OutError("1010");
return;
}
}
else
{
DataObj.Msg = rt3_retMsg;
DataObj.OutError("1010");
return;
}
#endregion
}
else if (JobPayWay.DllName == "HFJSPay" && JobPayWayArr.Length == 3)
{
#region 结算系统
string Code = JobPayWayArr[0];
string CodeKey = JobPayWayArr[1];
string PayWayCode = JobPayWayArr[2];
JobUserPay JobUserPay = Entity.JobUserPay.FirstOrDefault(n => n.UId == baseUsers.Id && n.PayWay == JobPayWay.Id);
fastcardauthModel fastcardauthModel = new fastcardauthModel()
{
bankcard = UserCard.Card,
mcode = UserCard.ValidateCode,
merid = JobUserPay.MerId,
paywaycode = PayWayCode
};
ErrorCode errorCode = HFJSTools.fastcardauth(fastcardauthModel, JobUserPay.MerKey);
if (errorCode.respcode == "00")
{
IsSuccess = true;
}
else
{
DataObj.Msg = errorCode.respmsg;
DataObj.OutError("1010");
return;
}
#endregion
}
#endregion
if (IsSuccess)
{
//系统要限制每条通道每张卡只能存在一个授权，所以这里要处理
UserCardOpen UserCardOpen = Entity.UserCardOpen.FirstOrDefault(n => n.CardNum == UserCard.Card && n.UId == baseUsers.Id && n.PayWay == JobPayWay.Id);
if (UserCardOpen == null)
{
UserCardOpen = new UserCardOpen()
{
UId = baseUsers.Id,
CardNum = UserCard.Card,
Mobile = UserCard.Mobile,
PayWay = JobPayWay.Id,
State = 1,
STime = new DateTime(1990, 1, 1),
ETime = new DateTime(2099, 1, 1),
Token = bindId,
RqData = RetString
};
Entity.UserCardOpen.AddObject(UserCardOpen);
}
else
{
UserCardOpen.Mobile = UserCard.Mobile;
UserCardOpen.State = 1;
UserCardOpen.Token = bindId;
UserCardOpen.RqData = RetString;
}
UserCard.Pic = string.Empty;
UserCard.ScanNo = string.Empty;
UserCard.State = 1;
UserCard.Deposit = string.Empty;
Entity.UserCard.AddObject(UserCard);
Entity.SaveChanges();
}
DataObj.OutError("0000");
}
public void XLSDo(ApplyCredit ApplyCredit, EFPagingInfo <ApplyCredit> p)
{
if (ApplyCredit.STime.IsNullOrEmpty())
{
ApplyCredit.STime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
}
if (ApplyCredit.ETime.IsNullOrEmpty())
{
//ApplyCredit.ETime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
ApplyCredit.ETime = DateTime.Now;
}
if (!ApplyCredit.TrueName.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TrueName == ApplyCredit.TrueName);
}
if (!ApplyCredit.BankId.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.BankId == ApplyCredit.BankId);
}
if (!ApplyCredit.Education.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Education.Contains(ApplyCredit.Education));
}
if (!ApplyCredit.HasSheBao.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasSheBao == (ApplyCredit.HasSheBao == 99 ? 0 : ApplyCredit.HasSheBao));
}
if (!ApplyCredit.Marry.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Marry == ApplyCredit.Marry);
}
if (!ApplyCredit.HasCar.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCar == (ApplyCredit.HasCar == 99 ? 0 : ApplyCredit.HasCar));
}
if (!ApplyCredit.House.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.House == ApplyCredit.House);
}
if (!ApplyCredit.HasCredit.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCredit == ApplyCredit.HasCredit);
}
if (!ApplyCredit.State.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.State == ApplyCredit.State);
}
if (!ApplyCredit.AgentPay.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AgentPay == (ApplyCredit.AgentPay == 99 ? 0 : ApplyCredit.AgentPay));
}
if (!ApplyCredit.AgentAId.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AgentAId == ApplyCredit.AgentAId);
}
if (!ApplyCredit.STime.IsNullOrEmpty() && !ApplyCredit.ETime.IsNullOrEmpty())
{
DateTime ETime = ApplyCredit.ETime;
p.SqlWhere.Add(f => f.PayTime > ApplyCredit.STime && f.PayTime < ETime);
}
p.SqlWhere.Add(f => f.PayState == 1);
p.PageSize = 99999999;
p.OrderByList.Add("Id", "DESC");
IPageOfItems <ApplyCredit> ApplyCreditList = Entity.Selects <ApplyCredit>(p);
IList <BasicBank> BasicBankList = Entity.BasicBank.Where(n => n.State == 1).ToList();
IList <ApplyCredit> List = ApplyCreditList.GroupBy(n => n.AgentId).Select(n => n.First()).ToList();
List <int> AgentId = new List <int>();
foreach (var pp in List)
{
AgentId.Add(pp.AgentId);
}
IList <SysAgent> SysAgentList = Entity.SysAgent.Where(n => AgentId.Contains(n.Id) && n.Tier == 1).ToList();
if (SysAgentList.Count > 0)
{
//加载对应银行模板
string tempname = "AgentCredit.xlsx";
string file = Server.MapPath("/template") + "\\" + tempname;
ExcelPackage package = new ExcelPackage(new FileInfo(file), true);
//设置数据开始行
int Befor = 2;
int maxCol = 7;//最大列数
//加载模板第一张表
var sheet = package.Workbook.Worksheets[1];
var cells = sheet.Cells;
decimal TotalMoney = 0; //计算总金额
decimal TotalPrice = 0; //计算总金额
int Rows = ApplyCreditList.Count() + SysAgentList.Count();
sheet.InsertRow(Befor + 1, Rows - 1, Befor);
int i = Befor;
foreach (var item in SysAgentList)
{
IList <ApplyCredit> ListSub = ApplyCreditList.Where(n => n.AgentId == item.Id).ToList();
decimal AgentMoney = 0; //计算供应商金额
decimal AgentPrice = 0; //计算供应商金额
foreach (var s in ListSub)
{
sheet.Row(i).Height = 20;//设置行高
BasicBank BasicBank = BasicBankList.FirstOrNew(n => n.Id == s.BankId);
//分支机构
cells["A" + i].Value = item.Name;
//编号
cells["B" + i].Value = s.Id;
//姓名
cells["C" + i].Value = s.TrueName;
//申请银行
cells["D" + i].Value = BasicBank.Name;
//售出金额
cells["E" + i].Value = s.Amoney;
//售出时间
cells["F" + i].Value = s.PayTime;
//结算金额
cells["G" + i].Value = s.AgentMoney;
AgentMoney += s.Amoney;
AgentPrice += s.AgentMoney;
i++;
}
sheet.Row(i).Height = 28;//设置行高
//交易金额汇总
cells["E" + i].Value = AgentMoney;
//结算金额汇总
cells["G" + i].Value = AgentPrice;
Color bgColor = ColorTranslator.FromHtml("#DDDDDD");
Color fColor = ColorTranslator.FromHtml("#FF0000");
sheet.Cells[i, 1, i, maxCol].Style.Fill.PatternType = ExcelFillStyle.Solid;
sheet.Cells[i, 1, i, maxCol].Style.Fill.BackgroundColor.SetColor(bgColor);
sheet.Cells[i, 1, i, maxCol].Style.Font.Size = 16;
sheet.Cells[i, 1, i, maxCol].Style.Font.Bold = true;
sheet.Cells[i, 1, i, maxCol].Style.Font.Color.SetColor(fColor);
TotalMoney += AgentMoney;
TotalPrice += AgentPrice;
i++;
}
Color bgColor_ = ColorTranslator.FromHtml("#7030A0");
Color fColor_ = ColorTranslator.FromHtml("#FFFFFF");
sheet.Cells[i, 1, i, maxCol].Style.Fill.PatternType = ExcelFillStyle.Solid;
sheet.Cells[i, 1, i, maxCol].Style.Fill.BackgroundColor.SetColor(bgColor_);
sheet.Cells[i, 1, i, maxCol].Style.Font.Size = 20;
sheet.Cells[i, 1, i, maxCol].Style.Font.Bold = true;
sheet.Cells[i, 1, i, maxCol].Style.Font.Color.SetColor(fColor_);
sheet.Row(i).Height = 40;//设置行高
//交易金额汇总
cells["E" + i].Value = TotalMoney;
//结算金额汇总
cells["G" + i].Value = TotalPrice;
sheet.Cells[Befor, 1, i, maxCol].Style.Border.Left.Style = ExcelBorderStyle.Thin;
sheet.Cells[Befor, 1, i, maxCol].Style.Border.Right.Style = ExcelBorderStyle.Thin;
sheet.Cells[Befor, 1, i, maxCol].Style.Border.Top.Style = ExcelBorderStyle.Thin;
sheet.Cells[Befor, 1, i, maxCol].Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
sheet.Cells[Befor, 5, i, 5].Style.Numberformat.Format = "\"¥\"#,##0.00_);[Red](\"¥\"#,##0.00)";
sheet.Cells[Befor, 6, i, 6].Style.Numberformat.Format = "yyyy-mm-dd hh:mm";
sheet.Cells[Befor, 7, i, 7].Style.Numberformat.Format = "\"¥\"#,##0.00_);[Red](\"¥\"#,##0.00)";
Response.BinaryWrite(package.GetAsByteArray());//输出
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + new Random().Next(10, 99) + ".xlsx");
}
else
{
Response.Write("暂无符合条件数据");
}
}
public void Post()
{
string Data = DataObj.GetData();
if (Data.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
JObject json = new JObject();
try
{
json = (JObject)JsonConvert.DeserializeObject(Data);
}
catch (Exception Ex)
{
Log.Write("[UserCardAdd]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
UserCard UserCard = new UserCard();
UserCard = JsonToObject.ConvertJsonToModel(UserCard, json);
#region 校验
if (UserCard.PayPwd.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
if (UserCard.PayPwd.Length < 6)//6位及以上
{
DataObj.OutError("1000");
return;
}
var Bank = this.Entity.BasicBank.Where(o => o.Name == UserCard.Bank).FirstOrDefault();
if (Bank == null)
{
DataObj.OutError("1103");
return;
}
var BasicBankInfo = this.Entity.BasicBankInfo.Where(o => o.BId == Bank.Id && o.BIN == UserCard.Bin).FirstOrDefault();
if (BasicBankInfo == null)
{
DataObj.OutError("1102");
return;
}
//获取用户信息
string Token = UserCard.Token;
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
DataObj.OutError("2006");
return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
DataObj.OutError("2008");
return;
}
UserBlackList UserBlackList = Entity.UserBlackList.FirstOrDefault(UBL => UBL.CardNumber == UserCard.Card && UBL.State == 3);
if (UserBlackList != null)
{
//提示暂不支持该卡绑定
DataObj.OutError("2016");
return;
}
UserCard UserCard_ = Entity.UserCard.FirstOrDefault(n => n.UId == baseUsers.Id && n.Card == UserCard.Card && n.State == 1);//已绑定本张银行卡
if (UserCard_ != null)
{
DataObj.OutError("2015");
return;
}
if (baseUsers.PayLock == 1)//密码错误太多次锁定
{
DataObj.OutError("2050");
return;
}
#region 验证是否是借记卡 by anjing 2018-01-03
if (GetCardType(UserCard.Card) != 1)
{
DataObj.OutError("2016");
return;
}
#endregion
#region 密码验证
//这里是执行指纹解锁
bool IfCheckOk = true;
if (UserCard.PayPwd.Substring(0, 3) == "HF_")
{
string PassWord = UserCard.PayPwd;
PassWord = PassWord.Replace("HF_", "");
string token = baseUsers.Token;
token = token + "GoodPay";
string Md5Token = token.GetMD5().ToUpper();
string Pass = Md5Token.Substring(0, 4) + Md5Token.Substring(Md5Token.Length - 4, 4);
if (Pass != PassWord)
{
IfCheckOk = false;
}
}
else if (baseUsers.PayPwd != UserCard.PayPwd.GetPayMD5())
{
//原支付密码错误
IfCheckOk = false;
}
if (!IfCheckOk)
{
//付密码错误
SysSet SysSet = Entity.SysSet.FirstOrNew();
//系统统一修改标识SAME002
baseUsers.PayErr++;
if (baseUsers.PayErr >= SysSet.PayLock)
{
baseUsers.PayLock = 1;
}
Entity.SaveChanges();
Users Out = new Users();
Out.PayErr = SysSet.PayLock - baseUsers.PayErr;
Out.Cols = "PayErr";
DataObj.Data = Out.OutJson();
DataObj.Code = "2002";
if (Out.PayErr == 0)
{
DataObj.Msg = "用户支付密码不正确，请明日再试或取回支付密码";
}
else
{
DataObj.Msg = "用户支付密码不正确，您还可以尝试" + Out.PayErr + "次";
}
DataObj.OutString();
return;
}
baseUsers.PayErr = 0;
#endregion
BasicBank BasicBank = Entity.BasicBank.FirstOrDefault(n => n.Name == UserCard.Bank);
if (BasicBank == null)
{
DataObj.OutError("1000");
return;
}
#endregion
Users cacheUsers = CacheBuilder.EntityCache.Get(baseUsers.Id.ToString() + "CardPicTemp") as Users;
if (cacheUsers != null)
{
UserCard.Pic = cacheUsers.CardPic;
UserCard.ScanNo = cacheUsers.CardNum ?? string.Empty;
}
else
{
UserCard.Pic = string.Empty;
UserCard.ScanNo = string.Empty;
}
UserCard.UId = baseUsers.Id;
UserCard.BId = BasicBank.Id;
UserCard.Mobile = UserCard.Mobile.IsNullOrEmpty() ? string.Empty : UserCard.Mobile;
UserCard.State = 1;
UserCard.AddTime = DateTime.Now;
Entity.UserCard.AddObject(UserCard);
Entity.SaveChanges();
//if (HasCache)
//{
// string CashName = "UserCard_" + UserCard.Type + "_" + Token;
// CacheBuilder.EntityCache.Remove(CashName, null);
//}
DataObj.Data = UserCard.OutJson();
DataObj.Code = "0000";
DataObj.OutString();
}
