private void Get_ParameterList(string strSql) { OrderLog bllOrder = new OrderLog(); int Counts = this.NetPagerParameter.RecordCount; strSql += "and OrderLog.OrderShopID = SysShop.ShopID and OrderLog.OrderMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and OrderLog.OrderUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "OrderShopID", strSql); DataTable db = bllOrder.GetListSP(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[] { strSql }).Tables[0]; this.NetPagerParameter.RecordCount = Counts; this.NetPagerParameter.CustomInfoHTML = string.Format("<div class=\"results\"><span>当前第{0}/{1}页 共{2}条记录 每页{3}条</span></div>", new object[] { this.NetPagerParameter.CurrentPageIndex, this.NetPagerParameter.PageCount, this.NetPagerParameter.RecordCount, this.NetPagerParameter.PageSize }); this.gvRptExpense.DataSource = db; this.gvRptExpense.DataBind(); PageBase.BindSerialGridView(this.gvRptExpense, false, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); PageBase.BindNullSGridView(this.gvRptExpense); }
private void BindMemCountList() { if (this.intMemID != 0) { string strSql = " CountDetailMemID=" + this.intMemID; Chain.BLL.MemCountDetail bllMemCount = new Chain.BLL.MemCountDetail(); DataTable db = bllMemCount.GetQueryMemCountList(strSql).Tables[0]; this.gvMemCountList.DataSource = db; this.gvMemCountList.DataBind(); PageBase.BindSerialGridView(this.gvMemCountList, false, 0); PageBase.BindNullSGridView(this.gvMemCountList); } }
private void Get_SysLogList(string strSql) { SysError bllSysError = new SysError(); int Counts = this.NetPagerParameter.RecordCount; DataTable db = bllSysError.GetListSP(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[] { strSql }).Tables[0]; this.NetPagerParameter.RecordCount = Counts; this.NetPagerParameter.CustomInfoHTML = string.Format("<div class=\"results\"><span>当前第{0}/{1}页 共{2}条记录 每页{3}条</span></div>", new object[] { this.NetPagerParameter.CurrentPageIndex, this.NetPagerParameter.PageCount, this.NetPagerParameter.RecordCount, this.NetPagerParameter.PageSize }); this.gvwSysLogList.DataSource = db; this.gvwSysLogList.DataBind(); PageBase.BindSerialGridView(this.gvwSysLogList, false, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); PageBase.BindNullSGridView(this.gvwSysLogList); }