public DbQueryResult Query(ShareActivitySearch query)
{
StringBuilder builder = new StringBuilder("1=1 ");
if (!string.IsNullOrEmpty(query.CouponName))
{
builder.AppendFormat(" and CouponName like '%{0}%' ", query.CouponName);
}
if (query.status != ShareActivityStatus.All)
{
if (query.status == ShareActivityStatus.In)
{
builder.AppendFormat("and [BeginDate] <= '{0}' and [EndDate] >= '{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
else if (query.status == ShareActivityStatus.End)
{
builder.AppendFormat("and [EndDate] < '{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
else if (query.status == ShareActivityStatus.unBegin)
{
builder.AppendFormat("and [BeginDate] > '{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_ShareActivity", "id", builder.ToString(), "*"));
}
private void CountTotal(string name)
{
ShareActivitySearch query = new ShareActivitySearch
{
status = ShareActivityStatus.All,
IsCount = true,
PageIndex = this.pager1.PageIndex,
PageSize = this.pager1.PageSize,
SortBy = "Id",
SortOrder = SortAction.Desc,
CouponName = name
};
DataTable data = (DataTable)ShareActHelper.Query(query).Data;
this.lblAll.Text = (data != null) ? data.Rows.Count.ToString() : "0";
query.status = ShareActivityStatus.In;
data = (DataTable)ShareActHelper.Query(query).Data;
this.lblIn.Text = (data != null) ? data.Rows.Count.ToString() : "0";
query.status = ShareActivityStatus.End;
data = (DataTable)ShareActHelper.Query(query).Data;
this.lblEnd.Text = (data != null) ? data.Rows.Count.ToString() : "0";
query.status = ShareActivityStatus.unBegin;
data = (DataTable)ShareActHelper.Query(query).Data;
this.lblUnBegin.Text = (data != null) ? data.Rows.Count.ToString() : "0";
}
private void CountTotal(string name)
{
ShareActivitySearch shareActivitySearch = new ShareActivitySearch();
shareActivitySearch.status = ShareActivityStatus.All;
shareActivitySearch.IsCount = true;
shareActivitySearch.PageIndex = this.pager1.PageIndex;
shareActivitySearch.PageSize = this.pager1.PageSize;
shareActivitySearch.SortBy = "Id";
shareActivitySearch.SortOrder = SortAction.Desc;
shareActivitySearch.CouponName = name;
DbQueryResult dbQueryResult = ShareActHelper.Query(shareActivitySearch);
System.Data.DataTable dataTable = (System.Data.DataTable)dbQueryResult.Data;
this.lblAll.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0");
shareActivitySearch.status = ShareActivityStatus.In;
dbQueryResult = ShareActHelper.Query(shareActivitySearch);
dataTable = (System.Data.DataTable)dbQueryResult.Data;
this.lblIn.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0");
shareActivitySearch.status = ShareActivityStatus.End;
dbQueryResult = ShareActHelper.Query(shareActivitySearch);
dataTable = (System.Data.DataTable)dbQueryResult.Data;
this.lblEnd.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0");
shareActivitySearch.status = ShareActivityStatus.unBegin;
dbQueryResult = ShareActHelper.Query(shareActivitySearch);
dataTable = (System.Data.DataTable)dbQueryResult.Data;
this.lblUnBegin.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0");
}
private void BindData()
{
string name = this.txt_name.Text.Trim();
ShareActivitySearch query = new ShareActivitySearch {
status = this.status,
IsCount = true,
PageIndex = this.pager1.PageIndex,
PageSize = this.pager1.PageSize,
SortBy = "Id",
SortOrder = SortAction.Desc,
CouponName = name
};
DbQueryResult result = ShareActHelper.Query(query);
DataTable data = (DataTable)result.Data;
this.grdDate.DataSource = data;
this.grdDate.DataBind();
this.pager1.TotalRecords = result.TotalRecords;
this.CountTotal(name);
}
public static DbQueryResult Query(ShareActivitySearch query)
{
return(_share.Query(query));
}
