/// <summary>
/// 取用户的跟单信息
/// </summary>
/// <param name="userid"></param>
/// <param name="startdate"></param>
/// <param name="enddate"></param>
/// <returns></returns>
public string GetGengDanInfo(int userid, DateTime startdate, DateTime enddate)
{
string str = "";
Model.Userinfo u = GetModel(userid);
if (u == null)
{
return("");
}
Model.VM_User_1DayTongJi vm = GetVMUserMoreDayTongJi(startdate, enddate, userid);
str = $"用户【{u.id} {u.username}】在【{vm.date}】跟单【{vm.zong_count}】次，跟单金额【{vm.zong_je}】，中奖金额【{vm.zc_zjje + vm.teshu_je}】，盈亏【{vm.yinkui}】";
return(str);
}
/// <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);
}
