private bool XingYe(string BankId, string FileName)
{
try
{
DataTable dt = new DataTable();
dt = ExcelToDataTable(System.Web.HttpContext.Current.Server.MapPath("~/UpLoadFiles/ApplyCreditCard/" + FileName), "Sheet1", true);
if (dt == null)
{
return(false);
}
ApplyCreditCard ApplyCreditCard;
DateTime Stime;
DateTime Etime;
string Name = string.Empty;
string Birthday = string.Empty;
foreach (DataRow row in dt.Rows)
{
Stime = Convert.ToDateTime(row[0].ToString());
Etime = Stime.AddDays(1);
Name = row[3].ToString();
Birthday = row[5].ToString().Replace("-", "").Replace("/", "");
string state = row[8].ToString();
switch (state)
{
case "拒件":
ApplyCreditCard = Entity.ApplyCreditCard.FirstOrDefault(f => f.UserName == Name && f.UserIdCard.Contains(Birthday) && f.AddTime > Stime && f.AddTime < Etime);
if (ApplyCreditCard == null)
{
continue;
}
ApplyCreditCard.State = 5;
Entity.SaveChanges();
break;
case "待转人工审核":
ApplyCreditCard = Entity.ApplyCreditCard.FirstOrDefault(f => f.UserName == Name && f.UserIdCard.Contains(Birthday) && f.AddTime > Stime && f.AddTime < Etime);
if (ApplyCreditCard == null)
{
continue;
}
ApplyCreditCard.State = 6;
Entity.SaveChanges();
break;
case "过件未发卡":
ApplyCreditCard = Entity.ApplyCreditCard.FirstOrDefault(f => f.UserName == Name && f.UserIdCard.Contains(Birthday) && f.AddTime > Stime && f.AddTime < Etime);
if (ApplyCreditCard == null)
{
continue;
}
ApplyCreditCard.State = 3;
Entity.SaveChanges();
break;
case "过件已发卡":
ApplyCreditCard = Entity.ApplyCreditCard.FirstOrDefault(f => f.UserName == Name && f.UserIdCard.Contains(Birthday) && f.AddTime > Stime && f.AddTime < Etime);
if (ApplyCreditCard == null)
{
continue;
}
ApplyCreditCard.State = 4;
Entity.SaveChanges();
break;
case "转人工审核中":
ApplyCreditCard = Entity.ApplyCreditCard.FirstOrDefault(f => f.UserName == Name && f.UserIdCard.Contains(Birthday) && f.AddTime > Stime && f.AddTime < Etime);
if (ApplyCreditCard == null)
{
continue;
}
ApplyCreditCard.State = 2;
Entity.SaveChanges();
break;
default:
break;
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
