private void CountTotal() { ActivitySearch activitySearch = new ActivitySearch(); activitySearch.status = ActivityStatus.All; activitySearch.IsCount = true; activitySearch.PageIndex = this.pager1.PageIndex; activitySearch.PageSize = this.pager1.PageSize; activitySearch.SortBy = "LimitedTimeDiscountId"; activitySearch.SortOrder = SortAction.Desc; DbQueryResult discountQuery = LimitedTimeDiscountHelper.GetDiscountQuery(activitySearch); System.Data.DataTable dataTable = (System.Data.DataTable)discountQuery.Data; this.lblAll.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0"); activitySearch.status = ActivityStatus.In; discountQuery = LimitedTimeDiscountHelper.GetDiscountQuery(activitySearch); dataTable = (System.Data.DataTable)discountQuery.Data; this.lblIn.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0"); activitySearch.status = ActivityStatus.End; discountQuery = LimitedTimeDiscountHelper.GetDiscountQuery(activitySearch); dataTable = (System.Data.DataTable)discountQuery.Data; this.lblEnd.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0"); activitySearch.status = ActivityStatus.unBegin; discountQuery = LimitedTimeDiscountHelper.GetDiscountQuery(activitySearch); dataTable = (System.Data.DataTable)discountQuery.Data; this.lblUnBegin.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0"); }
private void BindData() { string text = this.txtActivityName.Text; System.DateTime?selectedDate = this.calendarStartDate.SelectedDate; System.DateTime?selectedDate2 = this.calendarEndDate.SelectedDate; DbQueryResult discountQuery = LimitedTimeDiscountHelper.GetDiscountQuery(new ActivitySearch { status = (ActivityStatus)this.status, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "LimitedTimeDiscountId", SortOrder = SortAction.Desc, Name = text, begin = selectedDate, end = selectedDate2 }); System.Data.DataTable dataSource = (System.Data.DataTable)discountQuery.Data; this.grdLimitedTimeDiscountList.DataSource = dataSource; this.grdLimitedTimeDiscountList.DataBind(); this.pager1.TotalRecords = discountQuery.TotalRecords; this.CountTotal(); }
private void CountTotal() { ActivitySearch query = new ActivitySearch { status = ActivityStatus.All, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "LimitedTimeDiscountId", SortOrder = SortAction.Desc }; DataTable data = (DataTable)LimitedTimeDiscountHelper.GetDiscountQuery(query).Data; this.lblAll.Text = (data != null) ? data.Rows.Count.ToString() : "0"; query.status = ActivityStatus.In; data = (DataTable)LimitedTimeDiscountHelper.GetDiscountQuery(query).Data; this.lblIn.Text = (data != null) ? data.Rows.Count.ToString() : "0"; query.status = ActivityStatus.End; data = (DataTable)LimitedTimeDiscountHelper.GetDiscountQuery(query).Data; this.lblEnd.Text = (data != null) ? data.Rows.Count.ToString() : "0"; query.status = ActivityStatus.unBegin; data = (DataTable)LimitedTimeDiscountHelper.GetDiscountQuery(query).Data; this.lblUnBegin.Text = (data != null) ? data.Rows.Count.ToString() : "0"; }