protected void LoadData(int pageIndex) { var search = new AssetsupplierSearch(); search.Suppliername = txtSrchSuppliername.Text; int recordCount = 0; var list = AssetsupplierService.RetrieveAssetsuppliersPaging(search, pageIndex, pcData.PageSize, out recordCount); gvSuppliers.DataSource = list; gvSuppliers.DataBind(); pcData.RecordCount = recordCount; pcData.CurrentIndex = pageIndex; }
public List<Assetsupplier> RetrieveAssetsuppliersPaging(AssetsupplierSearch info,int pageIndex, int pageSize,out int count) { try { StringBuilder sqlCommand = new StringBuilder(@" SELECT ""ASSETSUPPLIER"".""SUPPLIERID"",""ASSETSUPPLIER"".""SUPPLIERNAME"" FROM ""ASSETSUPPLIER"" WHERE 1=1"); if (!string.IsNullOrEmpty(info.Supplierid)) { this.Database.AddInParameter(":Supplierid", "%"+info.Supplierid+"%"); sqlCommand.AppendLine(@" AND ""ASSETSUPPLIER"".""SUPPLIERID"" LIKE :Supplierid"); } if (!string.IsNullOrEmpty(info.Suppliername)) { this.Database.AddInParameter(":Suppliername", "%"+info.Suppliername+"%"); sqlCommand.AppendLine(@" AND ""ASSETSUPPLIER"".""SUPPLIERNAME"" LIKE :Suppliername"); } sqlCommand.AppendLine(@" ORDER BY ""ASSETSUPPLIER"".""SUPPLIERID"" ASC"); return this.ExecuteReaderPaging<Assetsupplier>(sqlCommand.ToString(), pageIndex, pageSize, out count); } finally { this.Database.ClearParameter(); } }
public List<Assetsupplier> RetrieveAssetsuppliersPaging(AssetsupplierSearch info,int pageIndex, int pageSize,out int count) { return Management.RetrieveAssetsuppliersPaging(info,pageIndex,pageSize,out count); }
protected void LoadSupplierData() { var search = new AssetsupplierSearch(); int recordCount = 0; var list = AssetsupplierService.RetrieveAssetsuppliersPaging(search, 0, 10, out recordCount); list.Insert(0, new Assetsupplier() { Supplierid = string.Empty, Suppliername = "全部" }); ddlSuppliers.DataTextField = "Suppliername"; ddlSuppliers.DataValueField = "Supplierid"; ddlSuppliers.DataSource = list; ddlSuppliers.DataBind(); }