public List<Baccount> RetrieveBaccountsPaging(BaccountSearch info,int pageIndex, int pageSize,out int count)
{
try
{
StringBuilder sqlCommand = new StringBuilder(@" SELECT ""BACCOUNT"".""ASSETNO"",""BACCOUNT"".""ASSETNAME"",""BACCOUNT"".""ACCOUNTEDDATE"",""BACCOUNT"".""ACCOUNTEDUSER"",""BACCOUNT"".""CREATEDDATE"",
""BACCOUNT"".""CREATEDUSER""
FROM ""BACCOUNT""
WHERE 1=1");
if (!string.IsNullOrEmpty(info.Assetno))
{
this.Database.AddInParameter(":Assetno",DbType.AnsiString,"%"+info.Assetno+"%");
sqlCommand.AppendLine(@" AND ""BACCOUNT"".""ASSETNO"" LIKE :Assetno");
}
if (!string.IsNullOrEmpty(info.Assetname))
{
this.Database.AddInParameter(":Assetname", "%"+info.Assetname+"%");
sqlCommand.AppendLine(@" AND ""BACCOUNT"".""ASSETNAME"" LIKE :Assetname");
}
if (info.StartAccounteddate.HasValue)
{
this.Database.AddInParameter(":StartAccounteddate",info.StartAccounteddate.Value.Date);
sqlCommand.AppendLine(@" AND ""BACCOUNT"".""ACCOUNTEDDATE"" >= :StartAccounteddate");
}
if (info.EndAccounteddate.HasValue)
{
this.Database.AddInParameter(":EndAccounteddate",info.EndAccounteddate.Value.Date.AddDays(1).AddSeconds(-1));
sqlCommand.AppendLine(@" AND ""BACCOUNT"".""ACCOUNTEDDATE"" <= :EndAccounteddate");
}
if (!string.IsNullOrEmpty(info.Accounteduser))
{
this.Database.AddInParameter(":Accounteduser",DbType.AnsiString,"%"+info.Accounteduser+"%");
sqlCommand.AppendLine(@" AND ""BACCOUNT"".""ACCOUNTEDUSER"" LIKE :Accounteduser");
}
if (!string.IsNullOrEmpty(info.Createduser))
{
this.Database.AddInParameter(":Createduser",DbType.AnsiString,"%"+info.Createduser+"%");
sqlCommand.AppendLine(@" AND ""BACCOUNT"".""CREATEDUSER"" LIKE :Createduser");
}
sqlCommand.AppendLine(@" ORDER BY ""BACCOUNT"".""ASSETNO"" DESC");
return this.ExecuteReaderPaging<Baccount>(sqlCommand.ToString(), pageIndex, pageSize, out count);
}
finally
{
this.Database.ClearParameter();
}
}
public List<Baccount> RetrieveBaccountsPaging(BaccountSearch info,int pageIndex, int pageSize,out int count)
{
return Management.RetrieveBaccountsPaging(info,pageIndex,pageSize,out count);
}