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