public QuestInfoQuery GetQuery() { QuestInfoQuery entity = new QuestInfoQuery(); if (!IsPostBack) { entity.SendStartDate = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-01"); string yyyymm = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM"); int days = DateTime.DaysInMonth(int.Parse(yyyymm.Split('-')[0]), int.Parse(yyyymm.Split('-')[1])); entity.SendEndDate = yyyymm + "-" + days.ToString(); } if (Request.QueryString["OrderId"] != null) { entity.OrderId = Request.QueryString["OrderId"].ToString(); } if (Request.QueryString["Status"] != null) { entity.Status = Request.QueryString["Status"].ToString(); } if (Request.QueryString["SendStartDate"] != null) { entity.SendStartDate = Request.QueryString["SendStartDate"].ToString(); } if (Request.QueryString["SendEndDate"] != null) { entity.SendEndDate = Request.QueryString["SendEndDate"].ToString(); } if (Request.QueryString["UserName"] != null) { entity.UserName = Request.QueryString["UserName"].ToString(); } if (Request.QueryString["Sort"] != null) { entity.Sort = Request.QueryString["Sort"].ToString(); } entity.UserId = ManagerHelper.GetCurrentManager().SiteId.ToString(); entity.PageIndex = this.pager1.PageIndex; entity.PageSize = this.pager1.PageSize; entity.SortBy = "QuestDate"; entity.SortOrder = SortAction.Asc; if (!string.IsNullOrEmpty(entity.Sort) && entity.Sort == "1") { entity.SortOrder = SortAction.Desc; } return(entity); }
protected void BindData() { QuestInfoQuery questinfoQuery = GetQuery(); DbQueryResult members = VShopHelper.GetQuestList(questinfoQuery); this.grdMemberList.DataSource = members.Data; this.grdMemberList.DataBind(); this.pager1.TotalRecords = (this.pager1.TotalRecords = members.TotalRecords); this.txtOrderId.Text = questinfoQuery.OrderId; this.ddlStatus.SelectedValue = questinfoQuery.Status; this.calendarStartDate.Text = questinfoQuery.SendStartDate; this.calendarEndDate.Text = questinfoQuery.SendEndDate; this.txtUserName.Text = questinfoQuery.UserName; this.ddlSort.SelectedValue = questinfoQuery.Sort; string countinfo = VShopHelper.GetQuestCount(questinfoQuery); NoSend.InnerText = countinfo.Split(',')[0]; alreadySend.InnerText = countinfo.Split(',')[1]; spantotalcount.InnerText = (int.Parse(countinfo.Split(',')[0]) + int.Parse(countinfo.Split(',')[1])).ToString(); if (!string.IsNullOrEmpty(questinfoQuery.SendStartDate) && !string.IsNullOrEmpty(questinfoQuery.SendEndDate)) { DateTime t1 = DateTime.Parse(questinfoQuery.SendStartDate); DateTime t2 = DateTime.Parse(questinfoQuery.SendEndDate); System.TimeSpan t3 = t2 - t1; days.InnerText = (t3.TotalDays + 1).ToString(); } else { spantotaldays.Style.Add("display", "none"); } }
public static string GetQuestCount(QuestInfoQuery query) { return((new DistributorsDao()).GetQuestCount(query)); }
public static DbQueryResult GetQuestList(QuestInfoQuery query) { return((new DistributorsDao()).GetQuestList(query)); }