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