private DataGridViewModel <Dictionary <string, object> > GetDataList(FightGroupActivitiyQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
PageModel <FightGroupModel> fightGroupList = VShopHelper.GetFightGroupList(query);
dataGridViewModel.rows = new List <Dictionary <string, object> >();
dataGridViewModel.total = fightGroupList.Total;
foreach (FightGroupModel model in fightGroupList.Models)
{
Dictionary <string, object> dictionary = model.ToDictionary();
string value = "";
switch (model.GroupStatus)
{
case FightGroupStatus.FightGroupFail:
value = "组团失败";
break;
case FightGroupStatus.FightGroupIn:
value = "组团中";
break;
case FightGroupStatus.FightGroupSuccess:
value = "组团成功";
break;
}
dictionary.Add("GroupStatusText", value);
dictionary.Add("CreateTimeText", model.CreateTime.ToDateTime());
dataGridViewModel.rows.Add(dictionary);
}
}
return(dataGridViewModel);
}
public void GetList(HttpContext context)
{
int num = 1;
int num2 = 10;
num = base.GetIntParam(context, "page", false).Value;
if (num < 1)
{
num = 1;
}
num2 = base.GetIntParam(context, "rows", false).Value;
if (num2 < 1)
{
num2 = 10;
}
int?intParam = base.GetIntParam(context, "GroupStatus", true);
FightGroupActivitiyQuery fightGroupActivitiyQuery = new FightGroupActivitiyQuery();
if (intParam > -1)
{
fightGroupActivitiyQuery.GroupStatus = (FightGroupStatus?)intParam;
}
fightGroupActivitiyQuery.StartDate = base.GetDateTimeParam(context, "StartDate");
fightGroupActivitiyQuery.EndDate = base.GetDateTimeParam(context, "EndDate");
fightGroupActivitiyQuery.FightGroupActivityId = base.GetIntParam(context, "FightGroupActivityId", false).Value;
fightGroupActivitiyQuery.PageIndex = num;
fightGroupActivitiyQuery.PageSize = num2;
fightGroupActivitiyQuery.SortBy = "FightGroupActivityId";
fightGroupActivitiyQuery.SortOrder = SortAction.Desc;
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(fightGroupActivitiyQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
public void GetList(HttpContext context)
{
int num = 1;
int num2 = 10;
num = base.GetIntParam(context, "page", false).Value;
if (num < 1)
{
num = 1;
}
num2 = base.GetIntParam(context, "rows", false).Value;
if (num2 < 1)
{
num2 = 10;
}
FightGroupActivitiyQuery fightGroupActivitiyQuery = new FightGroupActivitiyQuery();
fightGroupActivitiyQuery.ProductName = context.Request["ProductName"];
fightGroupActivitiyQuery.Status = (EnumFightGroupActivitiyStatus)base.GetIntParam(context, "Status", false).Value;
fightGroupActivitiyQuery.PageIndex = num;
fightGroupActivitiyQuery.PageSize = num2;
fightGroupActivitiyQuery.SortBy = "DisplaySequence DESC,FightGroupActivityId";
fightGroupActivitiyQuery.SortOrder = SortAction.Desc;
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(fightGroupActivitiyQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
public PageModel <FightGroupModel> GetFightGroupList(FightGroupActivitiyQuery query)
{
string text = " FightGroupActivityId = " + query.FightGroupActivityId + " and IsFightGroupHead = 1 and OrderStatus not in( " + 1 + "," + 4 + ")";
if (query.GroupStatus.HasValue)
{
text = text + " AND GroupStatus = " + (int)query.GroupStatus.Value;
}
if (query.StartDate.HasValue)
{
text = text + " AND StartTime >= '" + query.StartDate.Value + "'";
}
if (query.EndDate.HasValue)
{
DateTime dateTime = query.EndDate.Value;
dateTime = dateTime.AddDays(1.0);
DateTime dateTime2 = dateTime.AddSeconds(-1.0);
text = text + " AND EndTime <= '" + dateTime2 + "'";
}
PageModel <FightGroupModel> pageModel = DataHelper.PagingByRownumber <FightGroupModel>(query.PageIndex, query.PageSize, "CreateTime", SortAction.Desc, true, "vw_Hishop_FightGroups", "FightGroupId", text, "*");
List <int> list = new List <int>();
list.Add(1);
list.Add(4);
foreach (FightGroupModel model in pageModel.Models)
{
model.JoinGroupCount = new OrderDao().GetJoinGroupCount(model.FightGroupId, string.Join(",", list));
}
return(pageModel);
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(FightGroupActivitiyQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
PageModel <FightGroupActivitiyModel> fightGroupActivities = VShopHelper.GetFightGroupActivities(query);
dataGridViewModel.rows = new List <Dictionary <string, object> >();
dataGridViewModel.total = fightGroupActivities.Total;
foreach (FightGroupActivitiyModel model in fightGroupActivities.Models)
{
Dictionary <string, object> item = model.ToDictionary();
dataGridViewModel.rows.Add(item);
}
}
return(dataGridViewModel);
}
public PageModel <FightGroupActivityInfo> GetFightGroupActivities(FightGroupActivitiyQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" 1=1 ");
if (query.ProductId.HasValue)
{
stringBuilder.AppendFormat(" AND ProductId={0}", query.ProductId.Value);
}
if (!string.IsNullOrEmpty(query.ProductName))
{
stringBuilder.AppendFormat(" AND ProductId in (SELECT ProductId FROM Hishop_Products WHERE 1=1");
query.ProductName = DataHelper.CleanSearchString(query.ProductName);
string[] array = Regex.Split(query.ProductName.Trim(), "\\s+");
stringBuilder.AppendFormat(" AND ProductName LIKE '%{0}%'", DataHelper.CleanSearchString(array[0]));
for (int i = 1; i < array.Length && i <= 4; i++)
{
stringBuilder.AppendFormat(" AND ProductName LIKE '%{0}%'", DataHelper.CleanSearchString(array[i]));
}
stringBuilder.AppendFormat(")");
}
switch (query.Status)
{
case EnumFightGroupActivitiyStatus.Ended:
stringBuilder.AppendFormat(" AND EndDate<='{0}'", DateTime.Now);
break;
case EnumFightGroupActivitiyStatus.BeingCarried:
stringBuilder.AppendFormat(" AND StartDate<='{0}' AND EndDate>='{0}'", DateTime.Now);
break;
case EnumFightGroupActivitiyStatus.BeginInAMinute:
stringBuilder.AppendFormat(" AND StartDate>'{0}'", DateTime.Now);
break;
}
return(DataHelper.PagingByRownumber <FightGroupActivityInfo>(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_FightGroupActivities", "FightGroupActivityId", stringBuilder.ToString(), "*"));
}
