protected void LoadRemoveData()
{
var search = new AssetremovedetailSearch();
search.Assetno = Assetno;//设备编号
int recordCount = 0;
var list = AssetremovedetailService.RetrieveAssetremovedetailsPaging(search, 0, 100, out recordCount);
rptRemoveList.DataSource = list;
rptRemoveList.DataBind();
}
public List<Assetremovedetail> RetrieveAssetremovedetailsPaging(AssetremovedetailSearch info,int pageIndex, int pageSize,out int count)
{
return Management.RetrieveAssetremovedetailsPaging(info,pageIndex,pageSize,out count);
}
public List<Assetremovedetail> RetrieveAssetremovedetailsPaging(AssetremovedetailSearch info,int pageIndex, int pageSize,out int count)
{
try
{
StringBuilder sqlCommand = new StringBuilder(@" SELECT ""ASSETREMOVEDETAIL"".""DETAILID"",""ASSETREMOVEDETAIL"".""ASSETREMOVEID"",""ASSETREMOVEDETAIL"".""ASSETNO"",""ASSETREMOVEDETAIL"".""PLANREMOVEDATE"",""ASSETREMOVEDETAIL"".""ACTUALREMOVEDATE"",
""ASSETREMOVEDETAIL"".""REMOVEDCONTENT""
,c.StorageName,c.subcompanyname AS subcompanyname
FROM ""ASSETREMOVEDETAIL""
INNER JOIN ""ASSETREMOVE"" ON ""ASSETREMOVEDETAIL"".""ASSETREMOVEID""=""ASSETREMOVE"".""ASSETREMOVEID""
INNER JOIN v_storage_address c on c.StorageTitle=ASSETREMOVE.STORAGETITLE and c.StorageId=ASSETREMOVE.STORAGEID
WHERE 1=1");
#region ��ϸ���
if (!string.IsNullOrEmpty(info.Detailid))
{
this.Database.AddInParameter(":Detailid",DbType.AnsiString,"%"+info.Detailid+"%");
sqlCommand.AppendLine(@" AND ""ASSETREMOVEDETAIL"".""DETAILID"" LIKE :Detailid");
}
#endregion
#region �ƻ�����
if (!string.IsNullOrEmpty(info.Assetremoveid))
{
this.Database.AddInParameter(":Assetremoveid",DbType.AnsiString,"%"+info.Assetremoveid+"%");
sqlCommand.AppendLine(@" AND ""ASSETREMOVEDETAIL"".""ASSETREMOVEID"" LIKE :Assetremoveid");
}
#endregion
#region �豸���
if (!string.IsNullOrEmpty(info.Assetno))
{
this.Database.AddInParameter(":Assetno", DbType.AnsiString, info.Assetno);
sqlCommand.AppendLine(@" AND ""ASSETREMOVEDETAIL"".""ASSETNO"" = :Assetno");
}
#endregion
#region �ƻ��������
if (info.StartPlanremovedate.HasValue)
{
this.Database.AddInParameter(":StartPlanremovedate",info.StartPlanremovedate.Value.Date);
sqlCommand.AppendLine(@" AND ""ASSETREMOVEDETAIL"".""PLANREMOVEDATE"" >= :StartPlanremovedate");
}
if (info.EndPlanremovedate.HasValue)
{
this.Database.AddInParameter(":EndPlanremovedate",info.EndPlanremovedate.Value.Date.AddDays(1).AddSeconds(-1));
sqlCommand.AppendLine(@" AND ""ASSETREMOVEDETAIL"".""PLANREMOVEDATE"" <= :EndPlanremovedate");
}
#endregion
#region ʵ�ʲ������
if (info.StartActualremovedate.HasValue)
{
this.Database.AddInParameter(":StartActualremovedate",info.StartActualremovedate.Value.Date);
sqlCommand.AppendLine(@" AND ""ASSETREMOVEDETAIL"".""ACTUALREMOVEDATE"" >= :StartActualremovedate");
}
if (info.EndActualremovedate.HasValue)
{
this.Database.AddInParameter(":EndActualremovedate",info.EndActualremovedate.Value.Date.AddDays(1).AddSeconds(-1));
sqlCommand.AppendLine(@" AND ""ASSETREMOVEDETAIL"".""ACTUALREMOVEDATE"" <= :EndActualremovedate");
}
#endregion
#region �ƻ�˵��
if (!string.IsNullOrEmpty(info.Removedcontent))
{
this.Database.AddInParameter(":Removedcontent", "%"+info.Removedcontent+"%");
sqlCommand.AppendLine(@" AND ""ASSETREMOVEDETAIL"".""REMOVEDCONTENT"" LIKE :Removedcontent");
}
#endregion
sqlCommand.AppendLine(@" ORDER BY ""ASSETREMOVEDETAIL"".""DETAILID"" DESC");
return this.ExecuteReaderPaging<Assetremovedetail>(sqlCommand.ToString(), pageIndex, pageSize, out count);
}
finally
{
this.Database.ClearParameter();
}
}
