/// <summary> /// 取分页数据,返回 JSON /// </summary> /// <param name="pageindex"></param> /// <param name="pagesize"></param> /// <returns></returns> public ActionResult List(int pageindex, int pagesize, string key, string start, string end, string cabh, string email) { string todaystr = DateTime.Now.ToString("yyyy-MM-dd"); string tomorrow = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"); List <Model.Userinfo> list = dal.GetListArray("*", "id desc", pagesize, pageindex, GetCond(key, start, end, cabh, email)); ArrayList arr = new ArrayList(); foreach (var item in list) { double cztotal = lsdal.GetOneFiled_double("sum(changemoney)", $"userid={item.id} and type=4 and createtime between '{todaystr}' and '{tomorrow}'"); double txtotal = txdal.GetOneFiled_double("sum(money)", $"status=1 and userid={item.id} and createtime between '{todaystr}' and '{tomorrow}'"); int xztotal = xzdal.CalcCount($"userid={item.id} and iszj in (0,1,2)"); string quanxian = ""; List <Model.Admin_quanxian> list_qx = admin_qxdal.GetListArray($"adminid={item.id}"); if (list_qx.Count > 0) { quanxian += "("; foreach (var one_qx in list_qx) { quanxian += one_qx.qxname + ","; } quanxian += ")"; } arr.Add(new { idstr = item.id.ToString("d5"), id = item.id, createtime = item.createtime.ToString("yyyy-MM-dd HH:mm:ss"), username = item.username, email = item.email, password = item.password, txpassword = item.txpassword, mobile = item.mobile, address = item.address, bankno = item.bankno, bankname = item.bankname, remark = item.remark, status = item.status, statusremark = item.statusremark + quanxian, realname = item.realname, idcard = item.idcard, balance = item.balance, cztotal = cztotal, txtotal = txtotal, xztotal = xztotal, parentname = item.parentname, }); } return(Json(arr)); }
/// <summary> /// 取一天的统计模型 /// </summary> /// <param name="date"></param> /// <returns></returns> public Model.VM_1DayTongJi Get1DayTongJiModel(DateTime date, int userid = 0) { DAL.LiushuiDAL lsdal = new DAL.LiushuiDAL(); DAL.QihaoinfoDAL qhdal = new DAL.QihaoinfoDAL(); DAL.XiazhuinfoDAL xzdal = new DAL.XiazhuinfoDAL(); Model.VM_1DayTongJi vm = new Model.VM_1DayTongJi() { date = date.ToString("yyyy-MM-dd"), zhong_count = xzdal.CalcCount(date, 0, userid), zhong_je = xzdal.GetGengDanJE(date, 0, userid), zhong_zjje = xzdal.GetZhongJiangJE(date, 0, userid), teshu_count = qhdal.GetTeShuCount(date), teshu_je = xzdal.GetTeShuJE(date, 0, userid), zhuangjia_count = xzdal.CalcCount(date, 1, userid), zhuangjia_je = xzdal.GetGengDanJE(date, 1, userid), zhuangjia_zjje = xzdal.GetZhongJiangJE(date, 1, userid), zhuangjia_teshu_count = xzdal.GetTeShuCount(date, 1, userid), zhuangjia_teshu_je = xzdal.GetTeShuJE(date, 1, userid), daban_count = xzdal.CalcCount(date, 2, userid), daban_je = xzdal.GetGengDanJE(date, 2, userid), daban_shouxufee = xzdal.GetShouXuFee(date, 2, userid), daban_zjje = xzdal.GetZhongJiangJE(date, 2, userid), daban_teshu_count = xzdal.GetTeShuCount(date, 2, userid), daban_teshu_je = xzdal.GetTeShuJE(date, 2, userid), xiaoban_count = xzdal.CalcCount(date, 3, userid), xiaoban_je = xzdal.GetGengDanJE(date, 3, userid), xiaoban_shouxufee = xzdal.GetShouXuFee(date, 3, userid), xiaoban_zjje = xzdal.GetZhongJiangJE(date, 3, userid), xiaoban_teshu_count = xzdal.GetTeShuCount(date, 3, userid), xiaoban_teshu_je = xzdal.GetTeShuJE(date, 3, userid), danban_count = xzdal.CalcCount(date, 4, userid), danban_je = xzdal.GetGengDanJE(date, 4, userid), danban_shouxufee = xzdal.GetShouXuFee(date, 4, userid), danban_zjje = xzdal.GetZhongJiangJE(date, 4, userid), danban_teshu_count = xzdal.GetTeShuCount(date, 4, userid), danban_teshu_je = xzdal.GetTeShuJE(date, 4, userid), shuangban_count = xzdal.CalcCount(date, 5, userid), shuangban_je = xzdal.GetGengDanJE(date, 5, userid), shuangban_shouxufee = xzdal.GetShouXuFee(date, 5, userid), shuangban_zjje = xzdal.GetZhongJiangJE(date, 5, userid), shuangban_teshu_count = xzdal.GetTeShuCount(date, 5, userid), shuangban_teshu_je = xzdal.GetTeShuJE(date, 5, userid), buchang_je = lsdal.GetBuChangJE(date, userid), lindianfanhuan_je = lsdal.GetFanHuan(date, userid), shangfen_je = lsdal.GetShangfenJE(date, userid), xiafen_je = lsdal.GetXiaFenJE(date, userid), }; return(vm); }
/// <summary> /// 取用户多天的统计模型 /// </summary> /// <param name="date"></param> /// <param name="userid"></param> /// <returns></returns> public Model.VM_User_1DayTongJi GetVMUserMoreDayTongJi(DateTime startdate, DateTime enddate, int userid) { string date1 = startdate.ToString("yyyy-MM-dd HH:mm:ss"); string date2 = enddate.ToString("yyyy-MM-dd HH:mm:ss"); DAL.XiazhuinfoDAL xzdal = new DAL.XiazhuinfoDAL(); DAL.LiushuiDAL lsdal = new DAL.LiushuiDAL(); Model.VM_User_1DayTongJi vm = new Model.VM_User_1DayTongJi() { date = $"{date1} ~ {date2}", zong_count = xzdal.CalcCount($"userid={userid} and iszj in (0,1,2) and kjtime>='{date1}' and kjtime<='{date2}' "), zong_je = xzdal.GetOneFiled_double("sum(buymoney+shouxufee)", $"userid={userid} and iszj in (0,1,2) and kjtime>='{date1}' and kjtime<='{date2}' "), zc_je = xzdal.GetOneFiled_double("sum(buymoney+shouxufee)", $"userid={userid} and iszj in (0,1) and kjtime>='{date1}' and kjtime<='{date2}' "), zc_count = xzdal.CalcCount($"userid={userid} and iszj=1 and kjtime>='{date1}' and kjtime<='{date2}' and kjcode<>'' "), zc_nocount = xzdal.CalcCount($"userid={userid} and iszj=0 and kjtime>='{date1}' and kjtime<='{date2}' and kjcode<>''"), zc_zjje = xzdal.GetOneFiled_double("sum(zjmoney)", $"userid={userid} and iszj=1 and kjtime>='{date1}' and kjtime<='{date2}' "), teshu_count = xzdal.CalcCount($"userid={userid} and iszj=2 and kjtime>='{date1}' and kjtime<='{date2}' and kjcode<>''"), teshu_je = xzdal.GetOneFiled_double("sum(zjmoney)", $"userid={userid} and iszj=2 and kjtime>='{date1}' and kjtime<='{date2}' "), teshu_gdje = xzdal.GetOneFiled_double("sum(buymoney)", $"userid={userid} and iszj=2 and kjtime>='{date1}' and kjtime<='{date2}' "), xiafen_je = lsdal.GetXiaFenJE(startdate, enddate, userid), yinkui = xzdal.GetOneFiled_double("sum(-(buymoney+shouxufee)+zjmoney)", $"userid={userid} and iszj in (0,1,2) and kjtime>='{date1}' and kjtime<='{date2}' and kjcode<>'' "), }; return(vm); }
/// <summary> /// 取总记录数 /// </summary> /// <returns></returns> public ActionResult GetTotalCount(string key, string start, string end, string cabh) { int totalcount = dal.CalcCount(GetCond(key, start, end, cabh)); return(Content(totalcount.ToString())); }