public DbQueryResult GetOneyuanTao(OneyuanTaoQuery query) { StringBuilder builder = new StringBuilder(); builder.Append(" 1=1 "); if (!string.IsNullOrEmpty(query.title)) { builder.AppendFormat(" and Title like '%{0}%' ", query.title); } if (query.ReachType > 0) { builder.AppendFormat(" and ReachType={0} ", query.ReachType); } if (query.state > 0) { string str = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (query.state == 1) { builder.AppendFormat(" and IsOn=1 and StartTime<'{0}' and EndTime>='{0}' and IsEnd=0 ", str); } else if (query.state == 2) { builder.AppendFormat(" and IsOn=1 and IsEnd=0 and StartTime>'{0}'", str); } else if (query.state == 3) { builder.AppendFormat(" and (EndTime<'{0}' or IsEnd=1) ", str); } } return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Vshop_OneyuanTao_Detail", "ActivityId", (builder.Length > 0) ? builder.ToString() : null, "*")); }
private void DoAction(string Action) { string s = "{\"state\":false,\"msg\":\"未定义操作\"}"; int num = Globals.RequestFormNum("pageIndex"); if (num > 0) { this.Otype = Globals.RequestQueryNum("Otype"); OneyuanTaoQuery oneyuanTaoQuery = new OneyuanTaoQuery(); oneyuanTaoQuery.PageIndex = num; oneyuanTaoQuery.PageSize = 10; oneyuanTaoQuery.title = ""; oneyuanTaoQuery.state = 1; oneyuanTaoQuery.ReachType = 0; if (this.Otype == 0) { this.Otype = 1; } if (this.Otype == 3) { oneyuanTaoQuery.SortBy = "(FinishedNum*1.0/ReachNum)"; } else if (this.Otype == 2) { oneyuanTaoQuery.SortBy = "ActivityId"; } else if (this.Otype == 4) { oneyuanTaoQuery.state = 3; oneyuanTaoQuery.SortBy = "ActivityId"; } else { this.Otype = 1; oneyuanTaoQuery.SortBy = "FinishedNum"; } DbQueryResult oneyuanTao = OneyuanTaoHelp.GetOneyuanTao(oneyuanTaoQuery); IsoDateTimeConverter isoDateTimeConverter = new IsoDateTimeConverter(); isoDateTimeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; string str = JsonConvert.SerializeObject(oneyuanTao.Data, new JsonConverter[] { isoDateTimeConverter }); s = "{\"state\":true,\"msg\":\"读取成功\",\"Data\":" + str + "}"; } this.Page.Response.ClearContent(); this.Page.Response.ContentType = "application/json"; this.Page.Response.Write(s); this.Page.Response.End(); }
void BindData() { OneyuanTaoQuery query = new OneyuanTaoQuery(); query.PageIndex = pager.PageIndex; query.PageSize = pager.PageSize; query.title = atitle; query.state = state; query.ReachType = ReachType; DbQueryResult ListData = OneyuanTaoHelp.GetOneyuanTao(query); if (ListData.Data != null) { DataTable dt = (DataTable)ListData.Data; dt.Columns.Add("ActionBtn"); //显示的按钮 dt.Columns.Add("ASate"); //当前状态 dt.Columns.Add("PrizeState"); //开奖状态 dt.Columns.Add("CanDel"); //开奖状态 foreach (DataRow Item in dt.Rows) { OneyuanTaoInfo tempItem = OneyuanTaoHelp.DataRowToOneyuanTaoInfo(Item); OneTaoState rowState = OneyuanTaoHelp.getOneTaoState(tempItem); OneTaoPrizeState rowPrizeState = OneyuanTaoHelp.getPrizeState(tempItem); Item["ASate"] = rowState; Item["PrizeState"] = rowPrizeState; Item["CanDel"] = 0; if (rowPrizeState == OneTaoPrizeState.成功开奖) { Item["PrizeState"] = "<span class='success'>" + rowPrizeState + "<span>"; } else if (rowPrizeState == OneTaoPrizeState.已关闭) { Item["PrizeState"] = "<span class='normal'>" + rowPrizeState + "<span>"; } else if (rowPrizeState == OneTaoPrizeState.待退款) { Item["PrizeState"] = "<span class='green'>" + rowPrizeState + "<span>"; } else { Item["PrizeState"] = "<span class='errcss'>" + rowPrizeState + "<span>"; } string btnstr = "<a class=\"btn btn-xs btn-primary\" onclick=\"AView('" + Item["ActivityId"] + "')\" >查看</a> "; if (rowState == OneTaoState.进行中 || rowState == OneTaoState.未开始) { btnstr += "<a class=\"btn btn-xs btn-primary\" onclick=\"AEdit('" + Item["ActivityId"] + "')\" >编辑</a> "; } if (rowState == OneTaoState.未开始) { btnstr += "<a class=\"btn btn-xs btn-success\" onclick=\"AStart('" + Item["ActivityId"] + "')\" >开启</a> "; } if (rowState == OneTaoState.进行中) { btnstr += "<a class=\"btn btn-xs btn-danger\" onclick=\"AEnd('" + Item["ActivityId"] + "','" + Item["FinishedNum"] + "','" + Item["ReachType"] + "','" + Item["ReachNum"] + "')\" >结束</a> "; } if ((rowState == OneTaoState.已结束 && (int)Item["FinishedNum"] == 0) || rowState == OneTaoState.未开始) { //可删除的活动,1未开始,2已结束且没有人参与的活动 btnstr += "<a class=\"btn btn-xs btn-danger\" onclick=\"ADel('" + Item["ActivityId"] + "')\" >删除</a> "; Item["CanDel"] = 1; } if (rowState == OneTaoState.开奖失败) { btnstr += "<a class=\"btn btn-xs btn-danger\" onclick=\"BatchRefund('" + Item["ActivityId"] + "')\" >批量退款</a> "; } Item["ActionBtn"] = btnstr; } Datalist.DataSource = dt; Datalist.DataBind(); pager.TotalRecords = ListData.TotalRecords; int hasStart = 0; int waitStart = 0; int Total = 0; int hasEnd = 0; Total = OneyuanTaoHelp.GetOneyuanTaoTotalNum(out hasStart, out waitStart, out hasEnd); ListTotal.Text = "所有夺宝(" + Total.ToString() + ")"; ListStart.Text = "进行中(" + hasStart.ToString() + ")"; ListWait.Text = "未开始(" + waitStart.ToString() + ")"; Listend.Text = "已结束(" + hasEnd.ToString() + ")"; } //DataTable dt = (DataTable)productSet.Data; //dt.Columns.Add("setStatus"); pager.TotalRecords = ListData.TotalRecords; }
public static DbQueryResult GetOneyuanTao(OneyuanTaoQuery query) { return(new OneyuanTaoDao().GetOneyuanTao(query)); }
private void BindData() { OneyuanTaoQuery query = new OneyuanTaoQuery { PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, title = this.atitle, state = this.state, ReachType = this.ReachType }; DbQueryResult oneyuanTao = OneyuanTaoHelp.GetOneyuanTao(query); if (oneyuanTao.Data != null) { DataTable data = (DataTable)oneyuanTao.Data; data.Columns.Add("ActionBtn"); data.Columns.Add("ASate"); data.Columns.Add("PrizeState"); data.Columns.Add("CanDel"); foreach (DataRow row in data.Rows) { OneyuanTaoInfo info = OneyuanTaoHelp.DataRowToOneyuanTaoInfo(row); OneTaoPrizeState state = OneyuanTaoHelp.getPrizeState(info); row["PrizeState"] = state; row["CanDel"] = 0; switch (state) { case OneTaoPrizeState.成功开奖: row["PrizeState"] = "<span class='success'>" + state + "<span>"; break; case OneTaoPrizeState.已关闭: row["PrizeState"] = "<span class='normal'>" + state + "<span>"; break; case OneTaoPrizeState.待退款: if (OneyuanTaoHelp.CheckIsAll(row["ActivityId"].ToString())) { info.IsAllRefund = true; row["PrizeState"] = "<span class='errcss'>已退款<span>"; } else { row["PrizeState"] = "<span class='green'>" + state + "<span>"; } break; default: row["PrizeState"] = "<span class='errcss'>" + state + "<span>"; break; } OneTaoState state2 = OneyuanTaoHelp.getOneTaoState(info); row["ASate"] = state2; string str2 = "<a class=\"btn btn-xs btn-primary\" onclick=\"AView('" + row["ActivityId"] + "')\" >查看</a> "; switch (state2) { case OneTaoState.进行中: case OneTaoState.未开始: { object obj2 = str2; str2 = string.Concat(new object[] { obj2, "<a class=\"btn btn-xs btn-primary\" onclick=\"AEdit('", row["ActivityId"], "')\" >编辑</a> " }); break; } } switch (state2) { case OneTaoState.未开始: { object obj3 = str2; str2 = string.Concat(new object[] { obj3, "<a class=\"btn btn-xs btn-success\" onclick=\"AStart('", row["ActivityId"], "')\" >开启</a> " }); break; } case OneTaoState.进行中: { object obj4 = str2; str2 = string.Concat(new object[] { obj4, "<a class=\"btn btn-xs btn-danger\" onclick=\"AEnd('", row["ActivityId"], "','", row["FinishedNum"], "','", row["ReachType"], "','", row["ReachNum"], "')\" >结束</a> " }); break; } } if (((state2 == OneTaoState.已结束) && (((int)row["FinishedNum"]) == 0)) || ((state2 == OneTaoState.未开始) || (state2 == OneTaoState.退款完成))) { object obj5 = str2; str2 = string.Concat(new object[] { obj5, "<a class=\"btn btn-xs btn-danger\" onclick=\"ADel('", row["ActivityId"], "')\" >删除</a> " }); row["CanDel"] = 1; } if (state2 == OneTaoState.开奖失败) { object obj6 = str2; str2 = string.Concat(new object[] { obj6, "<a class=\"btn btn-xs btn-danger\" onclick=\"BatchRefund('", row["ActivityId"], "')\" >批量退款</a> " }); } row["ActionBtn"] = str2; } this.Datalist.DataSource = data; this.Datalist.DataBind(); this.pager.TotalRecords = oneyuanTao.TotalRecords; int hasStart = 0; int waitStart = 0; int hasEnd = 0; this.ListTotal.Text = "所有夺宝(" + OneyuanTaoHelp.GetOneyuanTaoTotalNum(out hasStart, out waitStart, out hasEnd).ToString() + ")"; this.ListStart.Text = "进行中(" + hasStart.ToString() + ")"; this.ListWait.Text = "未开始(" + waitStart.ToString() + ")"; this.Listend.Text = "已结束(" + hasEnd.ToString() + ")"; } this.pager.TotalRecords = oneyuanTao.TotalRecords; }