protected void LoadData(int pageIndex)
{
var search = new AssetsetupinfoSearch();
search.Setupid = txtSrchSetupid.Text;
search.StartApplydate = ucSrchStartApplydate.DateValue;
search.EndApplydate = ucSrchEndApplydate.DateValue;
search.Storagetitle = ucSelectProject.Storagetitle;//区分字段：分公司或项目体
search.Storageid = ucSelectProject.StorageId;//项目体ID或分公司ID
int recordCount = 0;
var list = AssetSetupinfoService.RetrieveAssetsetupinfosPaging(search, pageIndex, pcData.PageSize, out recordCount);
rptAssetSetupList.DataSource = list;
rptAssetSetupList.DataBind();
pcData.RecordCount = recordCount;
pcData.CurrentIndex = pageIndex;
}
public List<Assetsetupinfo> RetrieveAssetsetupinfosPaging(AssetsetupinfoSearch info, int pageIndex, int pageSize, out int count)
{
try
{
var sqlCommand = new StringBuilder(@" SELECT ""ASSETSETUPINFO"".""SETUPID"",""ASSETSETUPINFO"".""APPLYSETUPDATE"",""ASSETSETUPINFO"".""APPLYDATE"",""ASSETSETUPINFO"".""APPLYUSERID"",""ASSETSETUPINFO"".""CONTACTPHONE"",
""ASSETSETUPINFO"".""PROJECTCONTACTORID"",""ASSETSETUPINFO"".""PROJECTCONTACTORPHONE"",""ASSETSETUPINFO"".""PLANSETUPDATE"",""ASSETSETUPINFO"".""ACTUALSETUPDATE"",""ASSETSETUPINFO"".""APPLYCONTENT"",
""ASSETSETUPINFO"".""SUBCOMPANY"",""ASSETSETUPINFO"".""REJECTREASON"",""ASSETSETUPINFO"".""APPROVEUSER"",""ASSETSETUPINFO"".""APPROVEDATE"",""ASSETSETUPINFO"".""APPROVERESULT"",
""ASSETSETUPINFO"".""CREATEDDATE"",""ASSETSETUPINFO"".""SUBCOMPANYCONTACTORID"",""ASSETSETUPINFO"".""CREATOR"",""ASSETSETUPINFO"".""ASSETCATEGORYID"",""ASSETSETUPINFO"".""SETUPCONTENT"",
""ASSETSETUPINFO"".""CONFIRMDATE"",""ASSETSETUPINFO"".""CONFIRMUSER"",""ASSETSETUPINFO"".""STORAGETITLE"",""ASSETSETUPINFO"".""STORAGEID""
,SYSTEM,c.StorageName,c.subcompanyname,TU.USERNAME AS Applyusername
FROM ""ASSETSETUPINFO"" inner join ASSETCATEGORY ON ASSETSETUPINFO.ASSETCATEGORYID=ASSETCATEGORY.ASSETCATEGORYID
INNER JOIN v_storage_address c on c.StorageTitle=ASSETSETUPINFO.STORAGETITLE and c.StorageId=ASSETSETUPINFO.STORAGEID
INNER JOIN T_USER TU ON TU.ID=ASSETSETUPINFO.APPLYUSERID
WHERE 1=1");
#region ���뵥��
if (!string.IsNullOrEmpty(info.Setupid))
{
this.Database.AddInParameter(":Setupid", DbType.AnsiString, "%" + info.Setupid + "%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""SETUPID"" LIKE :Setupid");
}
#endregion
#region ��Ŀ��ID��ֹ�˾ID
if (!string.IsNullOrEmpty(info.Storageid) && !string.IsNullOrEmpty(info.Storagetitle))
{
this.Database.AddInParameter(":Storagetitle", DbType.AnsiString, info.Storagetitle);
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""STORAGETITLE"" = :Storagetitle");
this.Database.AddInParameter(":Storageid", DbType.AnsiString, info.Storageid);
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""STORAGEID"" = :Storageid");
}
#endregion
#region (ϵͳ)�豸����
if (!string.IsNullOrEmpty(info.Assetcategoryid))
{
this.Database.AddInParameter(":Assetcategoryid", DbType.AnsiString, "%" + info.Assetcategoryid + "%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""ASSETCATEGORYID"" LIKE :Assetcategoryid");
}
#endregion
#region ��������
if (info.StartApplydate.HasValue)
{
this.Database.AddInParameter(":StartApplydate", info.StartApplydate.Value.Date);
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""APPLYDATE"" >= :StartApplydate");
}
if (info.EndApplydate.HasValue)
{
this.Database.AddInParameter(":EndApplydate", info.EndApplydate.Value.Date.AddDays(1).AddSeconds(-1));
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""APPLYDATE"" <= :EndApplydate");
}
#endregion
#region ������
if (!string.IsNullOrEmpty(info.Applyuserid))
{
this.Database.AddInParameter(":Applyuserid", DbType.AnsiString, "%" + info.Applyuserid + "%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""APPLYUSERID"" LIKE :Applyuserid");
}
#endregion
#region �����
if (!string.IsNullOrEmpty(info.Approveuser))
{
this.Database.AddInParameter(":Approveuser", "%" + info.Approveuser + "%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""APPROVEUSER"" LIKE :Approveuser");
}
#endregion
#region �������
if (info.StartApprovedate.HasValue)
{
this.Database.AddInParameter(":StartApprovedate", info.StartApprovedate.Value.Date);
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""APPROVEDATE"" >= :StartApprovedate");
}
if (info.EndApprovedate.HasValue)
{
this.Database.AddInParameter(":EndApprovedate", info.EndApprovedate.Value.Date.AddDays(1).AddSeconds(-1));
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""APPROVEDATE"" <= :EndApprovedate");
}
#endregion
#region ȷ������
if (info.StartConfirmdate.HasValue)
{
this.Database.AddInParameter(":StartConfirmdate", info.StartConfirmdate.Value.Date);
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""CONFIRMDATE"" >= :StartConfirmdate");
}
if (info.EndConfirmdate.HasValue)
{
this.Database.AddInParameter(":EndConfirmdate", info.EndConfirmdate.Value.Date.AddDays(1).AddSeconds(-1));
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""CONFIRMDATE"" <= :EndConfirmdate");
}
#endregion
#region ȷ����
if (!string.IsNullOrEmpty(info.Confirmuser))
{
this.Database.AddInParameter(":Confirmuser", DbType.AnsiString, "%" + info.Confirmuser + "%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""CONFIRMUSER"" LIKE :Confirmuser");
}
#endregion
#region �ֹ�˾��ϵ��
if (!string.IsNullOrEmpty(info.Subcompanycontactorid))
{
this.Database.AddInParameter(":Subcompanycontactorid", DbType.AnsiString, "%" + info.Subcompanycontactorid + "%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""SUBCOMPANYCONTACTORID"" LIKE :Subcompanycontactorid");
}
#endregion
#region ������
if (!string.IsNullOrEmpty(info.Creator))
{
this.Database.AddInParameter(":Creator", DbType.AnsiString, "%" + info.Creator + "%");
sqlCommand.AppendLine(@" AND ""ASSETSETUPINFO"".""CREATOR"" LIKE :Creator");
}
#endregion
#region װ����״̬
if (info.SetupStates.Count > 0)
{
this.Database.AddInParameter(":APPROVERESULT", info.SetupStates[0]);
sqlCommand.AppendLine(@" AND (""ASSETSETUPINFO"".""APPROVERESULT""=:APPROVERESULT");
for (int i = 1; i < info.SetupStates.Count; i++)
{
this.Database.AddInParameter(":APPROVERESULT" + i.ToString(), info.SetupStates[i]);
sqlCommand.AppendLine(@" OR ""ASSETSETUPINFO"".""APPROVERESULT""=:APPROVERESULT" + i.ToString());
}
sqlCommand.AppendLine(@" )");
}
#endregion
sqlCommand.AppendLine(@" ORDER BY ""ASSETSETUPINFO"".""SETUPID"" DESC");
return this.ExecuteReaderPaging<Assetsetupinfo>(sqlCommand.ToString(), pageIndex, pageSize, out count);
}
finally
{
this.Database.ClearParameter();
}
}
public List<Assetsetupinfo> RetrieveAssetsetupinfosPaging(AssetsetupinfoSearch info,int pageIndex, int pageSize,out int count)
{
return Management.RetrieveAssetsetupinfosPaging(info,pageIndex,pageSize,out count);
}
