/// <summary> /// 异步查询数据库最近七天每天增加用户数 /// </summary> /// <param name="startTime">开始时间</param> /// <param name="endTime">结束时间</param> /// <returns>某七天的每天用户增量</returns> public async Task <UserCountList> GetUserChangeCountAsync(string startTime, string endTime) { string sql = $"select count(*) as num,convert(varchar(10),user_main.create_time,120) as dates from user_main " + $"join user_type on user_main.id=user_type.user_id " + $"where user_type.user_type=3 and user_main.create_time BETWEEN '{startTime}' AND '{endTime}'" + $"group by convert(varchar(10),user_main.create_time,120)" + $"order by convert(varchar(10),user_main.create_time,120) asc"; var list = await DapperHelper.GetListAsync <UserCount>(sql, this._conn); UserCount temp = null; UserCountList result = new UserCountList { list = new List <UserCount>() }; foreach (var item in list) { temp = new UserCount { dates = item.dates, num = item.num }; result.list.Add(temp); } return(result); }
public object UserOrgCount(string starttime, string endtime) { List<UserCountList> list = new List<UserCountList>(); UserCountList user = new UserCountList(); user.UsersCount = usersBLL.GetUserOrgCount(out errmsg); user.UsersActCount = usersBLL.GetOrgActCount(starttime, endtime, out errmsg); list.Add(user); return new { rows = list }; }
public object UserSource(string starttime, string endtime) { List<UserCountList> list = new List<UserCountList>(); UserCountList user = new UserCountList(); int UsersLoss = usersBLL.GetUserLoss(starttime, endtime, out errmsg); int UserRete = usersBLL.GetUserRete(starttime, endtime, out errmsg); int UserCount= usersBLL.GetUsersCount(out errmsg); int UserNewcount = usersBLL.GetUsersNewCount(starttime, endtime, out errmsg); double Losscount = Convert.ToDouble(UsersLoss) / Convert.ToDouble(UserCount); double Retcount = Convert.ToDouble(UserRete) / Convert.ToDouble(UserNewcount); user.UsersLoss = string.Format("{0:0.00}", Losscount * 100); user.UsersRete = string.Format("{0:0.00}", Retcount * 100 ); list.Add(user); return new { rows = list }; }