public void applyLoan(ApplyLoan al)
{
MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Port=3306; Database=mybank; Uid=aeo; Pwd=@300;");
// SqlConnection con = new SqlConnection();
// con.ConnectionString = ConfigurationManager.ConnectionStrings["BankManagmentConn"].ConnectionString;
conn.Open();
// string source = @"C:\Users\saivenkatas\Desktop\doc\hackathon_participation.jpg";
//al.Payslip = SaveFile(source);
//al.Photo = SaveFile(source);
//al.Signature = SaveFile(source);
try
{
MySqlCommand cmd = new MySqlCommand("applyLoan", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@accountNumber", al.AccountNumber);
cmd.Parameters.AddWithValue("@loanType", al.LoanType);
cmd.Parameters.AddWithValue("@income", al.Income);
//cmd.Parameters.AddWithValue("@payslip", al.Payslip);
//cmd.Parameters.AddWithValue("@photo", al.Photo);
//cmd.Parameters.AddWithValue("@signature", al.Signature);
cmd.Parameters.AddWithValue("@loanAmount", al.LoanAmount);
cmd.Parameters.AddWithValue("@empType", al.EmpType);
cmd.Parameters.AddWithValue("@city", al.City);
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
public void applyLoan(ApplyLoan al)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["BankManagmentConn"].ConnectionString;
con.Open();
try
{
SqlCommand cmd = new SqlCommand("applyLoan", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@accountNumber", al.AccountNumber);
cmd.Parameters.AddWithValue("@loanType", al.LoanType);
cmd.Parameters.AddWithValue("@income", al.Income);
cmd.Parameters.AddWithValue("@payslip", al.Payslip);
cmd.Parameters.AddWithValue("@photo", al.Photo);
cmd.Parameters.AddWithValue("@signature", al.Signature);
cmd.Parameters.AddWithValue("@loanAmount", al.LoanAmount);
cmd.Parameters.AddWithValue("@empType", al.EmpType);
cmd.Parameters.AddWithValue("@city", al.City);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public ActionResult Edit(ApplyLoan ApplyLoan)
{
if (ApplyLoan.Id != 0)
{
ApplyLoan = Entity.ApplyLoan.FirstOrDefault(n => n.Id == ApplyLoan.Id);
}
if (ApplyLoan.PayState != 1)
{
ViewBag.ErrorMsg = "未支付，不能结算！";
return(View("Error"));
}
if (ApplyLoan.AgentPay != 0)
{
ViewBag.ErrorMsg = "已经结算，不能重复结算！";
return(View("Error"));
}
if (ApplyLoan == null)
{
ViewBag.ErrorMsg = "数据不存在";
return(View("Error"));
}
ViewBag.ApplyLoan = ApplyLoan;
if (Request.UrlReferrer != null)
{
Session["Url"] = Request.UrlReferrer.ToString();
}
return(View());
}
public void applyLoan(HttpRequestMessage request)
{
string ss = request.Content.ReadAsStringAsync().Result;
ApplyLoan ls = JsonConvert.DeserializeObject <ApplyLoan>(ss);
userservice.applyLoan(ls);
}
public void Save(ApplyLoan ApplyLoan)
{
ApplyLoan baseApplyLoan = Entity.ApplyLoan.FirstOrDefault(n => n.Id == ApplyLoan.Id);
baseApplyLoan = Request.ConvertRequestToModel <ApplyLoan>(baseApplyLoan, ApplyLoan);
Entity.SaveChanges();
BaseRedirect();
}
public void Save(ApplyLoan ApplyLoan)
{
ApplyLoan baseApplyLoan = Entity.ApplyLoan.FirstOrDefault(n => n.Id == ApplyLoan.Id);
baseApplyLoan.AgentPay = 1;
Entity.SaveChanges();
BaseRedirect();
}
public void ChangeStatus(ApplyLoan ApplyLoan, string InfoList, string Clomn, string Value)
{
if (string.IsNullOrEmpty(InfoList))
{
InfoList = ApplyLoan.Id.ToString();
}
int Ret = Entity.ChangeEntity <ApplyLoan>(InfoList, Clomn, Value);
Entity.SaveChanges();
Response.Write(Ret);
}
public ActionResult Edit(ApplyLoan ApplyLoan)
{
if (ApplyLoan.Id != 0)
{
ApplyLoan = Entity.ApplyLoan.FirstOrDefault(n => n.Id == ApplyLoan.Id);
}
if (ApplyLoan == null)
{
ViewBag.ErrorMsg = "数据不存在";
return(View("Error"));
}
ViewBag.ApplyLoan = ApplyLoan;
ViewBag.BasicProvince = Entity.BasicProvince.FirstOrNew(n => n.Id == ApplyLoan.ComProvince);
ViewBag.BasicCity = Entity.BasicCity.FirstOrNew(n => n.Id == ApplyLoan.ComCity);
ViewBag.BasicDistrict = Entity.BasicDistrict.FirstOrNew(n => n.Id == ApplyLoan.ComDistrict);
if (Request.UrlReferrer != null)
{
Session["Url"] = Request.UrlReferrer.ToString();
}
return(View());
}
public void Add(ApplyLoan ApplyLoan, string code, string comeurl)
{
if (code.ToUpper() != Session.GetCheckCode())
{
Response.Write("<script>alert('验证码错误');history.go(-1);</script>");
return;
}
Session.ClearCheckCode();
ApplyLoan.UId = 0;
ApplyLoan.AId = 0;
ApplyLoan.State = 1;
ApplyLoan.AddTime = DateTime.Now;
ApplyLoan.AgentId = 0;
ApplyLoan.AgentAId = 0;
ApplyLoan.PayState = 0;
ApplyLoan.AgentPay = 0;
//这里是利润计算==========
ApplyLoan.Amoney = ApplyLoan.GetPrice(Entity); //获取价格
ApplyLoan.AIdMoney = ApplyLoan.Amoney; //总利润
ApplyLoan.AgentMoney = 0; //分支机构佣金设置为0，待分润计算后再写入
Entity.ApplyLoan.AddObject(ApplyLoan);
Entity.SaveChanges();
Response.Write("<script>location.href=\"success.html?comeurl=" + comeurl + "\";</script>");
}
public ActionResult Index(ApplyLoan ApplyLoan, EFPagingInfo <ApplyLoan> p, int IsFirst = 0)
{
if (ApplyLoan.STime.IsNullOrEmpty())
{
ApplyLoan.STime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
}
if (ApplyLoan.ETime.IsNullOrEmpty())
{
// ApplyLoan.ETime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
ApplyLoan.ETime = DateTime.Now;
}
if (IsFirst == 0)
{
PageOfItems <ApplyLoan> ApplyLoanList1 = new PageOfItems <ApplyLoan>(new List <ApplyLoan>(), 0, 10, 0, new Hashtable());
ViewBag.ApplyLoanList = ApplyLoanList1;
ViewBag.ApplyLoan = ApplyLoan;
return(View());
}
if (!ApplyLoan.TrueName.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TrueName == ApplyLoan.TrueName);
}
if (!ApplyLoan.Education.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Education.Contains(ApplyLoan.Education));
}
if (!ApplyLoan.SheBao.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.SheBao == ApplyLoan.SheBao);
}
if (!ApplyLoan.Marry.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Marry == ApplyLoan.Marry);
}
if (!ApplyLoan.HasCar.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCar == (ApplyLoan.HasCar == 99 ? 0 : ApplyLoan.HasCar));
}
if (!ApplyLoan.House.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.House == ApplyLoan.House);
}
if (!ApplyLoan.HasCredit.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCredit == ApplyLoan.HasCredit);
}
if (!ApplyLoan.State.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.State == ApplyLoan.State);
}
if (!ApplyLoan.AgentPay.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AgentPay == (ApplyLoan.AgentPay == 99 ? 0 : ApplyLoan.AgentPay));
}
if (!ApplyLoan.AgentAId.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AgentAId == ApplyLoan.AgentAId);
}
if (checkPower("ALL"))
{
p.SqlWhere.Add(f => f.AgentId == BasicAgent.Id);//读取全部分支机构
}
else
{
p.SqlWhere.Add(f => f.AgentAId == AdminUser.Id);//读取用户
}
if (!ApplyLoan.STime.IsNullOrEmpty() && !ApplyLoan.ETime.IsNullOrEmpty())
{
DateTime ETime = ApplyLoan.ETime;
p.SqlWhere.Add(f => f.PayTime > ApplyLoan.STime && f.PayTime < ETime);
}
p.PageSize = 99999999;
p.OrderByList.Add("Id", "DESC");
IPageOfItems <ApplyLoan> ApplyLoanList = Entity.Selects <ApplyLoan>(p);
ViewBag.ApplyLoanList = ApplyLoanList;
ViewBag.ApplyLoan = ApplyLoan;
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("[ApplyLoan]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
ApplyLoan ApplyLoan = new ApplyLoan();
ApplyLoan = JsonToObject.ConvertJsonToModel(ApplyLoan, json);
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == ApplyLoan.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;
}
EFPagingInfo <ApplyLoan> p = new EFPagingInfo <ApplyLoan>();
if (!ApplyLoan.Pg.IsNullOrEmpty())
{
p.PageIndex = ApplyLoan.Pg;
}
if (!ApplyLoan.Pgs.IsNullOrEmpty())
{
p.PageSize = ApplyLoan.Pgs;
}
p.SqlWhere.Add(f => f.UId == baseUsers.Id);
p.SqlWhere.Add(f => f.State > 0);
p.OrderByList.Add("Id", "DESC");
IPageOfItems <ApplyLoan> List = Entity.Selects <ApplyLoan>(p);
IList <ApplyLoan> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
public ActionResult Index(ApplyLoan ApplyLoan, EFPagingInfo <ApplyLoan> p, bool?IsShowSupAgent, int IsFirst = 0)
{
if (IsShowSupAgent == null)
{
IsShowSupAgent = false;
}
if (!ApplyLoan.TrueName.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TrueName == ApplyLoan.TrueName);
}
if (!ApplyLoan.Education.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Education.Contains(ApplyLoan.Education));
}
if (!ApplyLoan.SheBao.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.SheBao == ApplyLoan.SheBao);
}
if (!ApplyLoan.Marry.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Marry == ApplyLoan.Marry);
}
if (!ApplyLoan.HasCar.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCar == (ApplyLoan.HasCar == 99 ? 0 : ApplyLoan.HasCar));
}
if (!ApplyLoan.House.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.House == ApplyLoan.House);
}
if (!ApplyLoan.HasCredit.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCredit == ApplyLoan.HasCredit);
}
if (!ApplyLoan.State.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.State == ApplyLoan.State);
}
if (!ApplyLoan.AgentPay.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AgentPay == (ApplyLoan.AgentPay == 99 ? 0 : ApplyLoan.AgentPay));
}
if (!ApplyLoan.AgentAId.IsNullOrEmpty())
{
//是否要显示下级
if ((bool)IsShowSupAgent)
{
SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == ApplyLoan.AgentAId).FirstOrNew();
IList <SysAgent> SysAgentList = LowerLevelAgent.GetSupAgent(Entity);
IList <int> UID = new List <int>();
foreach (var s in SysAgentList)
{
UID.Add(s.Id);
}
p.SqlWhere.Add(f => UID.Contains(f.AgentAId));
}
else
{
p.SqlWhere.Add(f => f.AgentAId == ApplyLoan.AgentAId);
}
}
p.OrderByList.Add("Id", "DESC");
IPageOfItems <ApplyLoan> ApplyLoanList = null;
if (IsFirst == 0)
{
ApplyLoanList = new PageOfItems <ApplyLoan>(new List <ApplyLoan>(), 0, 10, 0, new Hashtable());
}
else
{
ApplyLoanList = Entity.Selects <ApplyLoan>(p);
}
ViewBag.ApplyLoanList = ApplyLoanList;
ViewBag.ApplyLoan = ApplyLoan;
ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.Tier == 1).ToList();
ViewBag.IsShowSupAgent = IsShowSupAgent;
ViewBag.Save = this.checkPower("Save");
return(View());
}
public ActionResult Index(ApplyLoan ApplyLoan, EFPagingInfo <ApplyLoan> p, bool?IsShowSupAgent, int IsFirst = 0)
{
if (IsShowSupAgent == null)
{
IsShowSupAgent = false;
}
if (ApplyLoan.STime.IsNullOrEmpty())
{
ApplyLoan.STime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
}
if (ApplyLoan.ETime.IsNullOrEmpty())
{
// ApplyLoan.ETime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
ApplyLoan.ETime = DateTime.Now;
}
if (IsFirst == 0)
{
PageOfItems <ApplyLoan> ApplyLoanList1 = new PageOfItems <ApplyLoan>(new List <ApplyLoan>(), 0, 10, 0, new Hashtable());
ViewBag.ApplyLoanList = ApplyLoanList1;
ViewBag.ApplyLoan = ApplyLoan;
ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.Tier == 1).ToList();
ViewBag.IsShowSupAgent = IsShowSupAgent;
ViewBag.Xls = this.checkPower("Xls");
return(View());
}
if (!ApplyLoan.TrueName.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TrueName == ApplyLoan.TrueName);
}
if (!ApplyLoan.Education.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Education.Contains(ApplyLoan.Education));
}
if (!ApplyLoan.HasSheBao.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasSheBao == (ApplyLoan.HasSheBao == 99 ? 0 : ApplyLoan.HasSheBao));
}
if (!ApplyLoan.Marry.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Marry == ApplyLoan.Marry);
}
if (!ApplyLoan.HasCar.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCar == (ApplyLoan.HasCar == 99 ? 0 : ApplyLoan.HasCar));
}
if (!ApplyLoan.House.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.House == ApplyLoan.House);
}
if (!ApplyLoan.HasCredit.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCredit == ApplyLoan.HasCredit);
}
if (!ApplyLoan.State.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.State == ApplyLoan.State);
}
if (!ApplyLoan.AgentPay.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AgentPay == (ApplyLoan.AgentPay == 99 ? 0 : ApplyLoan.AgentPay));
}
if (!ApplyLoan.AgentAId.IsNullOrEmpty())
{
//是否要显示下级
if ((bool)IsShowSupAgent)
{
SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == ApplyLoan.AgentAId).FirstOrNew();
IList <SysAgent> SysAgentList = LowerLevelAgent.GetSupAgent(Entity);
IList <int> UID = new List <int>();
foreach (var s in SysAgentList)
{
UID.Add(s.Id);
}
p.SqlWhere.Add(f => UID.Contains(f.AgentAId));
}
else
{
p.SqlWhere.Add(f => f.AgentAId == ApplyLoan.AgentAId);
}
}
if (!ApplyLoan.STime.IsNullOrEmpty() && !ApplyLoan.ETime.IsNullOrEmpty())
{
DateTime ETime = ApplyLoan.ETime;
p.SqlWhere.Add(f => f.PayTime > ApplyLoan.STime && f.PayTime < ETime);
}
p.SqlWhere.Add(f => f.PayState == 1);
p.PageSize = 99999999;
p.OrderByList.Add("Id", "DESC");
IPageOfItems <ApplyLoan> ApplyLoanList = Entity.Selects <ApplyLoan>(p);
ViewBag.ApplyLoanList = ApplyLoanList;
ViewBag.ApplyLoan = ApplyLoan;
IList <ApplyLoan> List = ApplyLoanList.GroupBy(n => n.AgentId).Select(n => n.First()).ToList();
List <int> AgentId = new List <int>();
foreach (var pp in List)
{
AgentId.Add(pp.AgentId);
}
ViewBag.SysAgentList = Entity.SysAgent.Where(n => AgentId.Contains(n.Id) && n.Tier == 1).ToList();
ViewBag.IsShowSupAgent = IsShowSupAgent;
ViewBag.Xls = this.checkPower("Xls");
return(View());
}
public void XLSDo(ApplyLoan ApplyLoan, EFPagingInfo <ApplyLoan> p)
{
if (ApplyLoan.STime.IsNullOrEmpty())
{
ApplyLoan.STime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
}
if (ApplyLoan.ETime.IsNullOrEmpty())
{
//ApplyLoan.ETime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
ApplyLoan.ETime = DateTime.Now;
}
if (!ApplyLoan.TrueName.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TrueName == ApplyLoan.TrueName);
}
if (!ApplyLoan.Education.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Education.Contains(ApplyLoan.Education));
}
if (!ApplyLoan.HasSheBao.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasSheBao == (ApplyLoan.HasSheBao == 99 ? 0 : ApplyLoan.HasSheBao));
}
if (!ApplyLoan.Marry.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Marry == ApplyLoan.Marry);
}
if (!ApplyLoan.HasCar.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCar == (ApplyLoan.HasCar == 99 ? 0 : ApplyLoan.HasCar));
}
if (!ApplyLoan.House.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.House == ApplyLoan.House);
}
if (!ApplyLoan.HasCredit.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.HasCredit == ApplyLoan.HasCredit);
}
if (!ApplyLoan.State.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.State == ApplyLoan.State);
}
if (!ApplyLoan.AgentPay.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AgentPay == (ApplyLoan.AgentPay == 99 ? 0 : ApplyLoan.AgentPay));
}
if (!ApplyLoan.AgentAId.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AgentAId == ApplyLoan.AgentAId);
}
if (!ApplyLoan.STime.IsNullOrEmpty() && !ApplyLoan.ETime.IsNullOrEmpty())
{
DateTime ETime = ApplyLoan.ETime;
p.SqlWhere.Add(f => f.PayTime > ApplyLoan.STime && f.PayTime < ETime);
}
p.SqlWhere.Add(f => f.PayState == 1);
p.PageSize = 99999999;
p.OrderByList.Add("Id", "DESC");
IPageOfItems <ApplyLoan> ApplyLoanList = Entity.Selects <ApplyLoan>(p);
IList <ApplyLoan> List = ApplyLoanList.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 => n.State == 1 && AgentId.Contains(n.Id)).ToList();
if (SysAgentList.Count > 0)
{
//加载对应银行模板
string tempname = "AgentLoan.xlsx";
string file = Server.MapPath("/template") + "\\" + tempname;
ExcelPackage package = new ExcelPackage(new FileInfo(file), true);
//设置数据开始行
int Befor = 2;
int maxCol = 6;//最大列数
//加载模板第一张表
var sheet = package.Workbook.Worksheets[1];
var cells = sheet.Cells;
decimal TotalMoney = 0; //计算总金额
decimal TotalPrice = 0; //计算总金额
int Rows = ApplyLoanList.Count() + SysAgentList.Count();
sheet.InsertRow(Befor + 1, Rows - 1, Befor);
int i = Befor;
foreach (var item in SysAgentList)
{
IList <ApplyLoan> ListSub = ApplyLoanList.Where(n => n.AgentId == item.Id).ToList();
decimal AgentMoney = 0; //计算供应商金额
decimal AgentPrice = 0; //计算供应商金额
foreach (var s in ListSub)
{
sheet.Row(i).Height = 20;//设置行高
//分支机构
cells["A" + i].Value = item.Name;
//编号
cells["B" + i].Value = s.Id;
//姓名
cells["C" + i].Value = s.TrueName;
//售出金额
cells["D" + i].Value = s.Amoney;
//售出时间
cells["E" + i].Value = s.PayTime;
//结算金额
cells["F" + i].Value = s.AgentMoney;
AgentMoney += s.Amoney;
AgentPrice += s.AgentMoney;
i++;
}
sheet.Row(i).Height = 28;//设置行高
//交易金额汇总
cells["D" + i].Value = AgentMoney;
//结算金额汇总
cells["F" + 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["D" + i].Value = TotalMoney;
//结算金额汇总
cells["F" + 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, 4, i, 4].Style.Numberformat.Format = "\"¥\"#,##0.00_);[Red](\"¥\"#,##0.00)";
sheet.Cells[Befor, 5, i, 5].Style.Numberformat.Format = "yyyy-mm-dd hh:mm";
sheet.Cells[Befor, 6, i, 6].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 applyLoan(ApplyLoan ls)
{
repo.applyLoan(ls);
}
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("[ApplyLoanAdd]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
ApplyLoan ApplyLoan = new ApplyLoan();
ApplyLoan = JsonToObject.ConvertJsonToModel(ApplyLoan, json);
if (ApplyLoan.Token.IsNullOrEmpty() || ApplyLoan.Amount.IsNullOrEmpty() || ApplyLoan.TrueName.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == ApplyLoan.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;
}
ApplyLoan.UId = baseUsers.Id;
ApplyLoan.AId = 0;
ApplyLoan.State = 1;
ApplyLoan.AddTime = DateTime.Now;
ApplyLoan.AgentId = baseUsers.Agent;
ApplyLoan.AgentAId = baseUsers.AId;
ApplyLoan.PayState = 0;
ApplyLoan.AgentPay = 0;
//这里是利润计算==========
ApplyLoan.Amoney = ApplyLoan.GetPrice(Entity); //获取价格
ApplyLoan.AIdMoney = ApplyLoan.Amoney; //总利润
ApplyLoan.AgentMoney = 0; //分支机构佣金设置为0，待分润计算后再写入
Entity.ApplyLoan.AddObject(ApplyLoan);
Entity.SaveChanges();
DataObj.Data = "";
DataObj.Code = "0000";
DataObj.OutString();
}
