private DataGridViewModel <Dictionary <string, object> > GetDataList(LotteryActivityQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
PageModel <ActivityInfo> activityList = ActivityHelper.GetActivityList(query);
dataGridViewModel.rows = new List <Dictionary <string, object> >();
dataGridViewModel.total = activityList.Total;
foreach (ActivityInfo model in activityList.Models)
{
List <ActivityAwardItemInfo> activityItemList = ActivityHelper.GetActivityItemList(model.ActivityId);
Dictionary <string, object> dictionary = model.ToDictionary();
dictionary.Add("StatusText", this.GetAcitivityStateus(model.StartDate, model.EndDate));
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
foreach (ActivityAwardItemInfo item in activityItemList)
{
Dictionary <string, object> dictionary2 = new Dictionary <string, object>();
dictionary2.Add("AwardGradeText", this.GetWeekCN(item.AwardGrade));
dictionary2.Add("PrizeType", this.GetPrizeType((PrizeTypes)item.PrizeType, item.PrizeValue));
list.Add(dictionary2);
}
dictionary.Add("AwardItem", list);
dataGridViewModel.rows.Add(dictionary);
}
}
return(dataGridViewModel);
}
public PageModel <ActivityInfo> GetActivityList(LotteryActivityQuery page)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat("1=1");
if (page.ActivityType != 0)
{
stringBuilder.AppendFormat("and ActivityType={0}", (int)page.ActivityType);
}
if (!string.IsNullOrEmpty(page.ActivityName))
{
stringBuilder.AppendFormat("and ActivityName like '%{0}%'", page.ActivityName);
}
if (page.Stateus == ActivityTypeStateus.Doing)
{
stringBuilder.AppendFormat("and StartDate<=getdate() and EndDate>=getdate()");
}
else if (page.Stateus == ActivityTypeStateus.Done)
{
stringBuilder.AppendFormat("and EndDate<getdate()");
}
else if (page.Stateus == ActivityTypeStateus.Will)
{
stringBuilder.AppendFormat("and StartDate>getdate()");
}
return(DataHelper.PagingByRownumber <ActivityInfo>(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "Hishop_Activity", "ActivityId", stringBuilder.ToString(), "*"));
}
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;
}
LotteryActivityQuery lotteryActivityQuery = new LotteryActivityQuery();
lotteryActivityQuery.ActivityName = context.Request["ActivityName"];
lotteryActivityQuery.Stateus = (ActivityTypeStateus)base.GetIntParam(context, "Stateus", false).Value;
lotteryActivityQuery.ActivityType = (LotteryActivityType)base.GetIntParam(context, "ActivityType", false).Value;
lotteryActivityQuery.PageIndex = num;
lotteryActivityQuery.PageSize = num2;
lotteryActivityQuery.SortBy = "ActivityId";
lotteryActivityQuery.SortOrder = SortAction.Desc;
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(lotteryActivityQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
public DbQueryResult GetLotteryActivityList(LotteryActivityQuery page)
{
StringBuilder stringBuilder = new StringBuilder();
if (page.ActivityType != (LotteryActivityType)0)
{
stringBuilder.AppendFormat("ActivityType={0}", (int)page.ActivityType);
}
return(DataHelper.PagingByRownumber(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "Vshop_LotteryActivity", "ActivityId", stringBuilder.ToString(), "*"));
}
public LotteryActivityQuery GetGameSearch(HttpContext context)
{
LotteryActivityQuery lotteryActivityQuery = new LotteryActivityQuery();
lotteryActivityQuery.ActivityType = (LotteryActivityType)Enum.ToObject(typeof(LotteryActivityType), (context.Request.Form["type"] == null) ? 1 : context.Request.Form["type"].ToInt(0));
lotteryActivityQuery.PageIndex = ((context.Request.Form["p"] == null) ? 1 : Convert.ToInt32(context.Request.Form["p"]));
lotteryActivityQuery.SortOrder = SortAction.Desc;
lotteryActivityQuery.SortBy = "ActivityId";
return(lotteryActivityQuery);
}
protected void BindMaterial()
{
LotteryActivityQuery page = new LotteryActivityQuery {
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortBy = "ActivityId",
SortOrder = SortAction.Desc
};
DbQueryResult lotteryTicketList = VShopHelper.GetLotteryTicketList(page);
this.rpMaterial.DataSource = lotteryTicketList.Data;
this.rpMaterial.DataBind();
this.pager.TotalRecords = lotteryTicketList.TotalRecords;
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(LotteryActivityQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult lotteryTicketList = VShopHelper.GetLotteryTicketList(query);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(lotteryTicketList.Data);
dataGridViewModel.total = lotteryTicketList.TotalRecords;
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
DateTime t = Convert.ToDateTime(row["StartTime"]);
DateTime t2 = Convert.ToDateTime(row["EndTime"]);
DateTime t3 = Convert.ToDateTime(row["OpenTime"]);
row.Add("CanStart", t <DateTime.Now && t3> DateTime.Now && t2 > DateTime.Now);
}
}
return(dataGridViewModel);
}
public static DbQueryResult GetLotteryTicketList(LotteryActivityQuery page)
{
return(new LotteryActivityDao().GetLotteryTicketList(page));
}
public static PageModel <ActivityInfo> GetActivityList(LotteryActivityQuery page)
{
return(new ActivityDao().GetActivityList(page));
}
