public List<ProcurementscheduledetailEx> RetrieveProcurementscheduledetailsPaging(ProcurementscheduledetailSearch info,int pageIndex, int pageSize,out int count) { return Management.RetrieveProcurementscheduledetailsPaging(info,pageIndex,pageSize,out count); }
public List<ProcurementscheduledetailEx> RetrieveProcurementscheduledetailsPaging(ProcurementscheduledetailSearch info,int pageIndex, int pageSize,out int count) { try { StringBuilder sqlCommand = new StringBuilder(@" SELECT ""PROCUREMENTSCHEDULEDETAIL"".""DETAILID"",""PROCUREMENTSCHEDULEDETAIL"".""ASSETCATEGORYID"",""PROCUREMENTSCHEDULEDETAIL"".""ASSETNAME"",""PROCUREMENTSCHEDULEDETAIL"".""ASSETSPECIFICATION"",""PROCUREMENTSCHEDULEDETAIL"".""UNITPRICE"", ""PROCUREMENTSCHEDULEDETAIL"".""PLANNUMBER"",""PROCUREMENTSCHEDULEDETAIL"".""PSID"" FROM ""PROCUREMENTSCHEDULEDETAIL"" INNER JOIN ""PROCUREMENTSCHEDULEHEAD"" ON ""PROCUREMENTSCHEDULEDETAIL"".""PSID""=""PROCUREMENTSCHEDULEHEAD"".""PSID"" WHERE 1=1"); if (!string.IsNullOrEmpty(info.Detailid)) { this.Database.AddInParameter(":Detailid",DbType.AnsiString,"%"+info.Detailid+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEDETAIL"".""DETAILID"" LIKE :Detailid"); } if (!string.IsNullOrEmpty(info.Assetcategoryid)) { this.Database.AddInParameter(":Assetcategoryid",DbType.AnsiString,"%"+info.Assetcategoryid+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEDETAIL"".""ASSETCATEGORYID"" LIKE :Assetcategoryid"); } if (!string.IsNullOrEmpty(info.Assetname)) { this.Database.AddInParameter(":Assetname", "%"+info.Assetname+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEDETAIL"".""ASSETNAME"" LIKE :Assetname"); } if (!string.IsNullOrEmpty(info.Assetspecification)) { this.Database.AddInParameter(":Assetspecification", "%"+info.Assetspecification+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEDETAIL"".""ASSETSPECIFICATION"" LIKE :Assetspecification"); } if (!string.IsNullOrEmpty(info.Psid)) { this.Database.AddInParameter(":Psid",DbType.AnsiString,"%"+info.Psid+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEDETAIL"".""PSID"" LIKE :Psid"); } sqlCommand.AppendLine(@" ORDER BY ""PROCUREMENTSCHEDULEDETAIL"".""DETAILID"" DESC"); return this.ExecuteReaderPaging<ProcurementscheduledetailEx>(sqlCommand.ToString(), pageIndex, pageSize, out count); } finally { this.Database.ClearParameter(); } }