public List<Assetscrapped> RetrieveAssetscrappedsPaging(AssetscrappedSearch info,int pageIndex, int pageSize,out int count)
{
return Management.RetrieveAssetscrappedsPaging(info,pageIndex,pageSize,out count);
}
public List<Assetscrapped> RetrieveAssetscrappedsPaging(AssetscrappedSearch info, int pageIndex, int pageSize, out int count)
{
try
{
StringBuilder sqlCommand = new StringBuilder(@" SELECT ""ASSET_SCRAPPED"".""ASSET_SCRAPPED_ID"",""ASSET_SCRAPPED"".""SCRAPPEDDATE"",""ASSET_SCRAPPED"".""SCRAPPEDUSER"",""ASSET_SCRAPPED"".""ASSETNO"",""ASSET_SCRAPPED"".""APPROVEUSER"",
""ASSET_SCRAPPED"".""APPROVEDATE"",""ASSET_SCRAPPED"".""REJECTREASON"",""ASSET_SCRAPPED"".""CREATEDDATE"",""ASSET_SCRAPPED"".""CREATOR"",""ASSET_SCRAPPED"".""APPROVEDSTATE""
FROM ""ASSET_SCRAPPED""
WHERE 1=1");
if (!string.IsNullOrEmpty(info.Assetscrappedid))
{
this.Database.AddInParameter(":Assetscrappedid", DbType.AnsiString, "%" + info.Assetscrappedid + "%");
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""ASSET_SCRAPPED_ID"" LIKE :Assetscrappedid");
}
if (info.StartScrappeddate.HasValue)
{
this.Database.AddInParameter(":StartScrappeddate", info.StartScrappeddate.Value.Date);
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""SCRAPPEDDATE"" >= :StartScrappeddate");
}
if (info.EndScrappeddate.HasValue)
{
this.Database.AddInParameter(":EndScrappeddate", info.EndScrappeddate.Value.Date.AddDays(1).AddSeconds(-1));
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""SCRAPPEDDATE"" <= :EndScrappeddate");
}
if (!string.IsNullOrEmpty(info.Scrappeduser))
{
this.Database.AddInParameter(":Scrappeduser", "%" + info.Scrappeduser + "%");
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""SCRAPPEDUSER"" LIKE :Scrappeduser");
}
if (!string.IsNullOrEmpty(info.Assetno))
{
this.Database.AddInParameter(":Assetno", DbType.AnsiString, "%" + info.Assetno + "%");
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""ASSETNO"" LIKE :Assetno");
}
if (!string.IsNullOrEmpty(info.Approveuser))
{
this.Database.AddInParameter(":Approveuser", "%" + info.Approveuser + "%");
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""APPROVEUSER"" LIKE :Approveuser");
}
if (info.StartApprovedate.HasValue)
{
this.Database.AddInParameter(":StartApprovedate", info.StartApprovedate.Value.Date);
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""APPROVEDATE"" >= :StartApprovedate");
}
if (info.EndApprovedate.HasValue)
{
this.Database.AddInParameter(":EndApprovedate", info.EndApprovedate.Value.Date.AddDays(1).AddSeconds(-1));
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""APPROVEDATE"" <= :EndApprovedate");
}
if (!string.IsNullOrEmpty(info.Rejectreason))
{
this.Database.AddInParameter(":Rejectreason", "%" + info.Rejectreason + "%");
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""REJECTREASON"" LIKE :Rejectreason");
}
if (!string.IsNullOrEmpty(info.Creator))
{
this.Database.AddInParameter(":Creator", "%" + info.Creator + "%");
sqlCommand.AppendLine(@" AND ""ASSET_SCRAPPED"".""CREATOR"" LIKE :Creator");
}
if (info.Approvedstates.Count > 0)
{
this.Database.AddInParameter(":Approvedstate", info.Approvedstates[0]);
sqlCommand.AppendLine(@" AND (""ASSET_SCRAPPED"".""APPROVEDSTATE""=:Approvedstate");
for (int i = 1; i < info.Approvedstates.Count; i++)
{
this.Database.AddInParameter(":Approvedstate" + i.ToString(), info.Approvedstates[i]);
sqlCommand.AppendLine(@" OR ""ASSET_SCRAPPED"".""APPROVEDSTATE""=:Approvedstate" + i.ToString());
}
sqlCommand.AppendLine(@" )");
}
sqlCommand.AppendLine(@" ORDER BY ""ASSET_SCRAPPED"".""ASSET_SCRAPPED_ID"" DESC");
return this.ExecuteReaderPaging<Assetscrapped>(sqlCommand.ToString(), pageIndex, pageSize, out count);
}
finally
{
this.Database.ClearParameter();
}
}