public DbQueryResult DistributorGradeCommission(DistributorGradeCommissionQuery query) { string table = "vw_Hishop_DistributorGradeCommission"; StringBuilder builder = new StringBuilder(); if (!string.IsNullOrEmpty(query.Title)) { builder.AppendFormat(" StoreName LIKE '%{0}%' ", DataHelper.CleanSearchString(query.Title)); } if (query.StartTime.HasValue) { if (!string.IsNullOrEmpty(builder.ToString())) { builder.Append(" AND "); } builder.AppendFormat(" PubTime>='{0}' ", query.StartTime.Value.ToString("yyyy-MM-dd")); } if (query.EndTime.HasValue) { if (!string.IsNullOrEmpty(builder.ToString())) { builder.Append(" AND "); } builder.AppendFormat(" PubTime<'{0}' ", query.EndTime.Value.AddDays(1.0).ToString("yyyy-MM-dd")); } return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, table, "ID", (builder.Length > 0) ? builder.ToString() : null, "*")); }
private void BindData(int pageno, int sendtype) { DistributorGradeCommissionQuery entity = new DistributorGradeCommissionQuery { SortBy = "ID", SortOrder = SortAction.Desc }; Globals.EntityCoding(entity, true); entity.PageIndex = pageno; entity.PageSize = this.pager.PageSize; string str = Globals.RequestQueryStr("starttime"); string str2 = Globals.RequestQueryStr("endtime"); string str3 = Globals.RequestQueryStr("title"); if (!string.IsNullOrEmpty(str3)) { entity.Title = str3; this.txtKey.Text = str3; } try { if (!string.IsNullOrEmpty(str)) { entity.StartTime = new DateTime?(DateTime.Parse(str)); this.calendarStartDate.Text = entity.StartTime.Value.ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(str2)) { entity.EndTime = new DateTime?(DateTime.Parse(str2)); this.calendarEndDate.Text = entity.EndTime.Value.ToString("yyyy-MM-dd"); } } catch { } DbQueryResult result = DistributorGradeCommissionHelper.DistributorGradeCommission(entity); this.rptList.DataSource = result.Data; this.rptList.DataBind(); int totalRecords = result.TotalRecords; this.pager.TotalRecords = totalRecords; this.recordcount = totalRecords; if (this.pager.TotalRecords <= this.pager.PageSize) { this.pager.Visible = false; } }
private void BindData(int pageno, int sendtype) { DistributorGradeCommissionQuery distributorGradeCommissionQuery = new DistributorGradeCommissionQuery(); distributorGradeCommissionQuery.SortBy = "ID"; distributorGradeCommissionQuery.SortOrder = SortAction.Desc; Globals.EntityCoding(distributorGradeCommissionQuery, true); distributorGradeCommissionQuery.PageIndex = pageno; distributorGradeCommissionQuery.PageSize = this.pager.PageSize; string text = Globals.RequestQueryStr("starttime"); string text2 = Globals.RequestQueryStr("endtime"); string text3 = Globals.RequestQueryStr("title"); if (!string.IsNullOrEmpty(text3)) { distributorGradeCommissionQuery.Title = text3; this.txtKey.Text = text3; } try { if (!string.IsNullOrEmpty(text)) { distributorGradeCommissionQuery.StartTime = new System.DateTime?(System.DateTime.Parse(text)); this.calendarStartDate.Text = distributorGradeCommissionQuery.StartTime.Value.ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(text2)) { distributorGradeCommissionQuery.EndTime = new System.DateTime?(System.DateTime.Parse(text2)); this.calendarEndDate.Text = distributorGradeCommissionQuery.EndTime.Value.ToString("yyyy-MM-dd"); } } catch { } DbQueryResult dbQueryResult = DistributorGradeCommissionHelper.DistributorGradeCommission(distributorGradeCommissionQuery); this.rptList.DataSource = dbQueryResult.Data; this.rptList.DataBind(); int totalRecords = dbQueryResult.TotalRecords; this.pager.TotalRecords = totalRecords; this.recordcount = totalRecords; if (this.pager.TotalRecords <= this.pager.PageSize) { this.pager.Visible = false; } }
public static DbQueryResult DistributorGradeCommission(DistributorGradeCommissionQuery query) { return(new DistributorGradeCommissionDao().DistributorGradeCommission(query)); }