public JsonResult TeamIntegralData()
{
string json = "";
using (StreamReader sr = new StreamReader(Request.InputStream))
{
json = HttpUtility.UrlDecode(sr.ReadLine());
}
//解析参数
JObject paramJson = JsonConvert.DeserializeObject(json) as JObject;
//统计月份的第一天和最后一天
DateTime MonthFirst = DTime.FirstDayOfMonth(DateTime.Parse("2018-08-08"));
DateTime MonthLast = DTime.LastDayOfMonth(DateTime.Now);
string date = paramJson["date"].ToString();
if (!string.IsNullOrEmpty(date))
{
//统计月份的第一天和最后一天
MonthFirst = DTime.FirstDayOfMonth(DateTime.Parse(date + "-" + "01"));
MonthLast = DTime.LastDayOfMonth(DateTime.Parse(date + "-" + "01 23:59:59"));
}
using (EFDB db = new EFDB())
{
Guid MGid = LCookie.GetMemberGid();;
var b = db.ShopRecord.Where(l => l.MemberGid == MGid && l.Type == 3 && l.AddTime >= MonthFirst && l.AddTime <= MonthLast).GroupJoin(db.ShopOrder,
l => l.OrderGid,
j => j.Gid,
(l, j) => new
{
l.AddTime,
l.MIntegral,
j.FirstOrDefault().OrderNo
}).AsQueryable();
int pageindex = Int32.Parse(paramJson["pageindex"].ToString());
int pagesize = Int32.Parse(paramJson["pagesize"].ToString());
return(Json(new AjaxResult(new
{
other = "",
count = b.Count(),
pageindex,
list = b.OrderByDescending(l => l.AddTime).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList()
})));
}
}
public static String ToDate(string str)
{
try
{
string sTime = str.Trim();
DateTime DTime;
int year;
int month;
int day;
int hour;
int minute;
int second;
year = 0;
month = 0;
day = 0;
hour = 0;
minute = 0;
second = 0;
if (str.Trim() == "")
{
return("");
}
if (CheckNumeric(sTime) == true)
{
if (sTime.Length >= 8)
{
year = Convert.ToInt32(sTime.Substring(0, 4));
month = Convert.ToInt32(sTime.Substring(4, 2));
day = Convert.ToInt32(sTime.Substring(6, 2));
}
if (sTime.Length >= 14)
{
hour = Convert.ToInt32(sTime.Substring(8, 2));
minute = Convert.ToInt32(sTime.Substring(10, 2));
second = Convert.ToInt32(sTime.Substring(12, 2));
}
DTime = new DateTime(year, month, day, hour, minute, second);
}
else
{
DTime = DateTime.Now;
}
if (sTime.Length >= 14)
{
return(DTime.ToLocalTime().ToString());
}
else if (sTime.Length == 8)
{
return(DTime.ToShortDateString());
}
else
{
return(DateTime.Now.ToLocalTime().ToString());
}
}
catch (Exception ex)
{
return(DateTime.Now.ToString());
}
}
public override string ToString()
{
return($"{DTime.ToString("dd.MM.yyyy HH:mm:ss")},{Speed},'{Number}'");
}
