/// <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()));
}
