public List<Procurementcontract> RetrieveProcurementcontractsPaging(ProcurementcontractSearch info,int pageIndex, int pageSize,out int count)
{
return Management.RetrieveProcurementcontractsPaging(info,pageIndex,pageSize,out count);
}
public List<Procurementcontract> RetrieveProcurementcontractsPaging(ProcurementcontractSearch info,int pageIndex, int pageSize,out int count)
{
try
{
StringBuilder sqlCommand = new StringBuilder(@" SELECT ""PROCUREMENTCONTRACT"".""CONTRACTID"",""PROCUREMENTCONTRACT"".""CONTENT"",""PROCUREMENTCONTRACT"".""CREATEDDATE"",
""PROCUREMENTCONTRACT"".""CONTRACTDATE"",""PROCUREMENTCONTRACT"".""SUPPLIER"",""SUPPLIERNAME"",
""PROCUREMENTCONTRACT"".""OPERATOR"",""PROCUREMENTCONTRACT"".""SUBCOMPANY""
,""PROCUREMENTCONTRACT"".""CREATOR"",""PROCUREMENTCONTRACT"".""PSID""
,""SUBCOMPANYINFO"".""SUBCOMPANYNAME""
FROM ""PROCUREMENTCONTRACT"" ,""ASSETSUPPLIER"",SUBCOMPANYINFO
WHERE PROCUREMENTCONTRACT.SUPPLIER=ASSETSUPPLIER.SUPPLIERID
AND SUBCOMPANYINFO.SUBCOMPANYID=PROCUREMENTCONTRACT.SUBCOMPANY");
if (!string.IsNullOrEmpty(info.Contractid))
{
this.Database.AddInParameter(":Contractid",DbType.AnsiString,"%"+info.Contractid+"%");
sqlCommand.AppendLine(@" AND ""PROCUREMENTCONTRACT"".""CONTRACTID"" LIKE :Contractid");
}
if (!string.IsNullOrEmpty(info.Content))
{
this.Database.AddInParameter(":Content", "%"+info.Content+"%");
sqlCommand.AppendLine(@" AND ""PROCUREMENTCONTRACT"".""CONTENT"" LIKE :Content");
}
if (info.StartContractdate.HasValue)
{
this.Database.AddInParameter(":StartContractdate",info.StartContractdate.Value.Date);
sqlCommand.AppendLine(@" AND ""PROCUREMENTCONTRACT"".""CONTRACTDATE"" >= :StartContractdate");
}
if (info.EndContractdate.HasValue)
{
this.Database.AddInParameter(":EndContractdate",info.EndContractdate.Value.Date.AddDays(1).AddSeconds(-1));
sqlCommand.AppendLine(@" AND ""PROCUREMENTCONTRACT"".""CONTRACTDATE"" <= :EndContractdate");
}
if (!string.IsNullOrEmpty(info.Supplier))
{
this.Database.AddInParameter(":Supplier", "%"+info.Supplier+"%");
sqlCommand.AppendLine(@" AND ""PROCUREMENTCONTRACT"".""SUPPLIER"" LIKE :Supplier");
}
if (!string.IsNullOrEmpty(info.Operator))
{
this.Database.AddInParameter(":Operator", "%"+info.Operator+"%");
sqlCommand.AppendLine(@" AND ""PROCUREMENTCONTRACT"".""OPERATOR"" LIKE :Operator");
}
if (!string.IsNullOrEmpty(info.Subcompany))
{
this.Database.AddInParameter(":Subcompany",DbType.AnsiString,"%"+info.Subcompany+"%");
sqlCommand.AppendLine(@" AND ""PROCUREMENTCONTRACT"".""SUBCOMPANY"" LIKE :Subcompany");
}
if (!string.IsNullOrEmpty(info.Creator))
{
this.Database.AddInParameter(":Creator", "%"+info.Creator+"%");
sqlCommand.AppendLine(@" AND ""PROCUREMENTCONTRACT"".""CREATOR"" LIKE :Creator");
}
if (!string.IsNullOrEmpty(info.Psid))
{
this.Database.AddInParameter(":Psid",DbType.AnsiString,"%"+info.Psid+"%");
sqlCommand.AppendLine(@" AND ""PROCUREMENTCONTRACT"".""PSID"" LIKE :Psid");
}
sqlCommand.AppendLine(@" ORDER BY ""PROCUREMENTCONTRACT"".""CONTRACTID"" DESC");
return this.ExecuteReaderPaging<Procurementcontract>(sqlCommand.ToString(), pageIndex, pageSize, out count);
}
finally
{
this.Database.ClearParameter();
}
}
