public List<Assetsetupdetail> RetrieveAssetsetupdetailsPaging(AssetsetupdetailSearch info,int pageIndex, int pageSize,out int count)
{
try
{
StringBuilder sqlCommand = new StringBuilder(@" SELECT ""ASSETSETUPDETAIL"".""DETAILID"",""ASSETSETUPDETAIL"".""SETUPID"",""ASSETSETUPDETAIL"".""ASSETNO"",""ASSETSETUPDETAIL"".""PLANSETUPDATE"",""ASSETSETUPDETAIL"".""ACTUALSETUPDATE"",
""ASSETSETUPDETAIL"".""SETUPCONTENT""
,c.StorageName,c.subcompanyname AS subcompanyname
FROM ""ASSETSETUPDETAIL""
INNER JOIN ""ASSETSETUPINFO"" ON ""ASSETSETUPDETAIL"".""SETUPID""=""ASSETSETUPINFO"".""SETUPID""
INNER JOIN v_storage_address c on c.StorageTitle=ASSETSETUPINFO.STORAGETITLE and c.StorageId=ASSETSETUPINFO.STORAGEID
WHERE 1=1");
if (!string.IsNullOrEmpty(info.Detailid))
{
this.Database.AddInParameter(":Detailid",DbType.AnsiString,"%"+info.Detailid+"%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPDETAIL"".""DETAILID"" LIKE :Detailid");
}
if (!string.IsNullOrEmpty(info.Setupid))
{
this.Database.AddInParameter(":Setupid",DbType.AnsiString,"%"+info.Setupid+"%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPDETAIL"".""SETUPID"" LIKE :Setupid");
}
if (!string.IsNullOrEmpty(info.Assetno))
{
//this.Database.AddInParameter(":Assetno",DbType.AnsiString,"%"+info.Assetno+"%");
//sqlCommand.AppendLine(@" AND ""ASSETSETUPDETAIL"".""ASSETNO"" LIKE :Assetno");
this.Database.AddInParameter(":Assetno", DbType.AnsiString, info.Assetno );
sqlCommand.AppendLine(@" AND ""ASSETSETUPDETAIL"".""ASSETNO"" = :Assetno");
}
if (!string.IsNullOrEmpty(info.Setupcontent))
{
this.Database.AddInParameter(":Setupcontent", "%"+info.Setupcontent+"%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPDETAIL"".""SETUPCONTENT"" LIKE :Setupcontent");
}
sqlCommand.AppendLine(@" ORDER BY ""ASSETSETUPDETAIL"".""DETAILID"" DESC");
return this.ExecuteReaderPaging<Assetsetupdetail>(sqlCommand.ToString(), pageIndex, pageSize, out count);
}
finally
{
this.Database.ClearParameter();
}
}
protected void LoadSetupData()
{
var search = new AssetsetupdetailSearch();
search.Assetno = Assetno;//设备编号
int recordCount = 0;
var list = AssetsetupdetailService.RetrieveAssetsetupdetailsPaging(search, 0, 100, out recordCount);
rptSetupList.DataSource = list;
rptSetupList.DataBind();
}
public List<Assetsetupdetail> RetrieveAssetsetupdetailsPaging(AssetsetupdetailSearch info,int pageIndex, int pageSize,out int count)
{
return Management.RetrieveAssetsetupdetailsPaging(info,pageIndex,pageSize,out count);
}