public static DbQueryResult GetCardInfoList(CardInfoQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(query.CardNumber))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" CardNumber = '{0}'", DataHelper.CleanSearchString(query.CardNumber));
}
if (!string.IsNullOrEmpty(query.UserName))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" UserName like '%{0}%'", DataHelper.CleanSearchString(query.UserName));
}
if (!string.IsNullOrEmpty(query.StartTime))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" CreateTime >= '{0}'", DataHelper.CleanSearchString(query.StartTime));
}
if (!string.IsNullOrEmpty(query.EndTime))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" CreateTime <= '{0}'", DataHelper.CleanSearchString(query.EndTime));
}
if (!string.IsNullOrEmpty(query.UserPhone))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" CellPhone = '{0}'", DataHelper.CleanSearchString(query.UserPhone));
}
if (!string.IsNullOrEmpty(query.Status))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND");
}
stringBuilder.AppendFormat(" c.Status = {0}", DataHelper.CleanSearchString(query.Status));
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "CardInfo c left join aspnet_Members am on am.userid=c.memberId left join cardtypeinfo ct on c.CardTypeId = ct.id left join ShopInfo si on c.ShopId = si.ID ", "ID", (stringBuilder.Length > 0) ? stringBuilder.ToString() : null, "c.*,am.UserName,am.CellPhone,ct.typename,ct.amountlevel,si.ShopName"));
}
protected void BindData()
{
CardInfoQuery cardinfoQuery = GetQuery();
DbQueryResult cardlist = CardInfoBusiness.GetCardInfoList(cardinfoQuery);
this.grdCardList.DataSource = cardlist.Data;
this.grdCardList.DataBind();
this.pager1.TotalRecords = (this.pager1.TotalRecords = cardlist.TotalRecords);
this.txtCardNumber.Text = cardinfoQuery.CardNumber;
this.ddlStatus.SelectedValue = cardinfoQuery.Status;
this.calendarStartDate.Text = cardinfoQuery.StartTime;
this.calendarEndDate.Text = cardinfoQuery.EndTime;
this.txtUserName.Text = cardinfoQuery.UserName;
return;
}
public CardInfoQuery GetQuery()
{
CardInfoQuery entity = new CardInfoQuery();
if (Request.QueryString["UserName"] != null)
{
entity.UserName = Request.QueryString["UserName"].ToString();
}
if (Request.QueryString["Status"] != null)
{
entity.Status = Request.QueryString["Status"].ToString();
}
if (Request.QueryString["StartTime"] != null)
{
entity.StartTime = Request.QueryString["StartTime"].ToString();
}
if (Request.QueryString["EndTime"] != null)
{
entity.EndTime = Request.QueryString["EndTime"].ToString();
}
if (Request.QueryString["CardNumber"] != null)
{
entity.CardNumber = Request.QueryString["CardNumber"].ToString();
}
entity.PageIndex = this.pager1.PageIndex;
entity.PageSize = this.pager1.PageSize;
entity.SortBy = "CreateTime";
entity.SortOrder = SortAction.Desc;
return(entity);
}
public static DbQueryResult GetCardInfoList(CardInfoQuery query)
{
return(CardInfoManager.GetCardInfoList(query));
}
