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));
}
