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);
 }