/// <summary>
/// 银行卡管理
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
int userid = CurrentUserId;
B_member_table b = new B_member_table();
M_member_table pu = new M_member_table();
pu = b.GetModel(userid);
//判断用户是否开户
if (string.IsNullOrEmpty(pu.UsrCustId))
{
string temstr = "/opening_account/Index/" + userid.ToString();
return(Redirect(temstr));
}
//if (pu.isbankcard == 0)
//{
checkbank(pu.UsrCustId);
//}
V_UsrBindCardBank Ucard = new V_UsrBindCardBank();
Ucard = ef.V_UsrBindCardBank.Where(p => p.registerid == userid).OrderByDescending(p => p.defCard).Take(1).FirstOrDefault();
List <V_UsrBindCardBank> cards = ef.V_UsrBindCardBank.Where(c => c.registerid == userid).ToList();
cards = BusinessLogicHelper.LeftOne(cards);
List <V_UsrBindCardBank> listcard = cards; //网银卡列表
List <V_UsrBindCardBank> listquickcard = cards.Where(c => c.BindCardType == 1).ToList(); //快捷卡列表
var flag = listquickcard != null && listquickcard.Count() > 0;
if (flag)
{
ViewBag.listcard = listquickcard;
}
else
{
ViewBag.listcard = listcard;
}
ViewBag.flag = flag;
return(View(Ucard));
}
// GET: BindCard
public ActionResult Index()
{
int userid = Utils.checkloginsession();
B_member_table b = new B_member_table();
M_member_table pu = new M_member_table();
pu = b.GetModel(userid);
//判断用户是否开户
if (string.IsNullOrEmpty(pu.UsrCustId))
{
string temstr = "/opening_account/Index/" + userid.ToString();
return(Redirect(temstr));
}
//if (pu.isbankcard == 0)
//{
checkbank(pu.UsrCustId);
//}
V_UsrBindCardBank Ucard = new V_UsrBindCardBank();
Ucard = ef.V_UsrBindCardBank.Where(p => p.registerid == userid).OrderByDescending(p => p.defCard).Take(1).FirstOrDefault();
List <V_UsrBindCardBank> listcard = ef.V_UsrBindCardBank.Where(c => c.registerid == userid).ToList();
listcard = BusinessLogicHelper.LeftOne(listcard);
ViewBag.listcard = listcard;
return(View(Ucard));
}
/// <summary>
/// 分页列表
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="startdatetime"></param>
/// <param name="enddatetime"></param>
/// <param name="timeday"></param>
/// <param name="pgaesize"></param>
/// <returns></returns>
// GET: Cash
public ActionResult Index(int?pageIndex, string startdatetime, string enddatetime, int timeday = 0, int pgaesize = 5)
{
ViewBag.rndstr = Utils.RndNumChar(10).ToString();
int OrdIdState = DNTRequest.GetInt("OrdIdState", 0);
ViewBag.OrdIdState = OrdIdState;
int userid = Utils.checkloginsession();
int Counts = 0;
int lostCount = 0;
int succCount = 0;
decimal Totals = 0.00M;
decimal lostTotal = 0.00M;
decimal succTotal = 0.00M;
B_member_table b = new B_member_table();
M_member_table pu = new M_member_table();
pu = b.GetModel(userid);
//判断用户是否开户
if (string.IsNullOrEmpty(pu.UsrCustId))
{
string temstr = "/opening_account/Index/" + userid.ToString();
return(Redirect(temstr));
}
new BindCardController().checkbank(pu.UsrCustId);
if (userid > 0)
{
if (Session["retloan1"] != null)
{
}
else
{
UserInfoData ud = new UserInfoData();
ReQueryBalanceBg retloan = ud.Querybalance(userid);
if (retloan.RespCode == "000")
{
// string sql = "update hx_member_table set available_balance=" + decimal.Parse(retloan.AvlBal) + " ,frozen_sum=" + decimal.Parse(retloan.FrzBal) + " where registerid=" + userid.ToString() + "";
//string sql = "update hx_member_table set available_balance=" + decimal.Parse(retloan.AvlBal) + " where registerid=" + userid.ToString() + "";
//DbHelperSQL.RunSql(sql);
B_usercenter bu = new B_usercenter();
bu.DataSync(retloan, userid.ToString());
Session["retloan1"] = "updateUserbalance";
}
}
}
List <V_UsrBindCardBank> vubc = ef.V_UsrBindCardBank.Where(c => c.registerid == userid && c.OpenBankId != null).ToList();
//判断用户是否绑定一行卡
//if (vubc.Count <= 0)
//{
// string temstr = "/BindCard/Index";
// return Redirect(temstr);
//}
var ListByOwner = ef.hx_td_UserCash.Where(l => l.registerid == userid && l.OpenBankId != null).GroupBy(l => l.registerid)
.Select(lg => new
{
Owner = lg.Key,
Counts = lg.Count(),
lostCount = lg.Where(lo => lo.OrdIdState == 0).Count(),
succCount = lg.Where(su => su.OrdIdState == 3).Count(),
Totals = lg.Where(w => w.OrdIdState == 3).Sum(w => w.TransAmt),
lostTotal = lg.Where(w => w.OrdIdState == 0).Sum(w => w.TransAmt),
succTotal = lg.Where(w => w.OrdIdState == 3).Sum(w => w.TransAmt),
});
foreach (var itc in ListByOwner)
{
if (itc.Counts > 0)
{
//Counts = itc.Counts;
// Totals = (decimal)itc.Totals;
int.TryParse(itc.Counts.ToString(), out Counts);
decimal.TryParse(itc.Totals.ToString(), out Totals);
int.TryParse(itc.lostCount.ToString(), out lostCount);
int.TryParse(itc.succCount.ToString(), out succCount);
decimal.TryParse(itc.lostTotal.ToString(), out lostTotal);
decimal.TryParse(itc.succTotal.ToString(), out succTotal);
}
}
Expression <Func <hx_td_UserCash, bool> > where = PredicateExtensionses.True <hx_td_UserCash>();
where = where.And(p => p.UserCashId > 0);
where = where.And(p => p.registerid == userid);
where = where.And(p => p.OpenBankId != null);
if (ViewBag.OrdIdState == 3)
{
where = where.And(p => p.OrdIdState == OrdIdState);
}
DateTime sdatetime = new DateTime();
DateTime edatetime = new DateTime();
if (Utils.IsDate(startdatetime))
{
sdatetime = DateTime.Parse(startdatetime);
}
if (Utils.IsDate(enddatetime))
{
edatetime = DateTime.Parse(enddatetime);
}
if (sdatetime > DateTime.Parse("0001-01-01 00:00:00") && edatetime > DateTime.Parse("0001-01-01 00:00:00"))
{
where = where.And(p => ((DateTime)p.OrdIdTime).CompareTo(sdatetime) >= 0);
DateTime dt2 = Convert.ToDateTime(edatetime.ToString("yyyy-MM-dd") + " 23:59:59");
where = where.And(p => ((DateTime)p.OrdIdTime).CompareTo(dt2) <= 0);
}
else
{
DateTime dt2;
switch (timeday)
{
case 0:
break;
case 1:
sdatetime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00");
dt2 = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59");
where = where.And(p => ((DateTime)p.OrdIdTime).CompareTo(sdatetime) >= 0);
where = where.And(p => ((DateTime)p.OrdIdTime).CompareTo(dt2) <= 0);
break;
case 30:
sdatetime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00").AddDays(-30);
dt2 = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59");
where = where.And(p => ((DateTime)p.OrdIdTime).CompareTo(sdatetime) >= 0);
where = where.And(p => ((DateTime)p.OrdIdTime).CompareTo(dt2) <= 0);
where = where.And(p => ((DateTime)p.OrdIdTime).CompareTo(sdatetime) >= 0);
where = where.And(p => ((DateTime)p.OrdIdTime).CompareTo(dt2) <= 0);
break;
case 90:
sdatetime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00").AddDays(-90);
dt2 = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59");
break;
default:
break;
}
}
var list = ef.hx_td_UserCash.Where(where).OrderByDescending(p => p.UserCashId).ToPagedList(pageIndex ?? 1, pgaesize);
ViewBag.startdatetime = startdatetime;
ViewBag.enddatetime = enddatetime;
ViewBag.timeday = timeday;
ViewBag.pageIndex = pageIndex;
ViewBag.Counts = Counts;
ViewBag.Totals = Totals;
ViewBag.lostCount = lostCount;
ViewBag.lostTotal = lostTotal;
ViewBag.succTotal = succTotal;
ViewBag.succCount = succCount;
ViewBag.users = pu;
vubc = BusinessLogicHelper.LeftOne(vubc);
ViewBag.UsrBindCard = vubc.OrderByDescending(c => c.defCard).ToList();
ViewBag.Isquick = vubc.Where(c => c.Isquick == 1).Count() > 0;
ViewBag.GENERAL = DateTime.Now.AddDays(1).ToString("MM月dd日");
ViewBag.QM = DateTime.Now.ToString("MM月dd日");
if (Request.IsAjaxRequest())
{
return(PartialView("_Cashlist", list));
}
return(View(list));
}