protected void LoadData(int pageIndex) { var search = new AssetmoveSearch(); search.Assetmoveid = txtSrchAssetmoveid.Text;//移机单号 if (ucSrchStartApplydate.DateValue.HasValue) { search.StartApplydate = ucSrchStartApplydate.DateValue.Value;//申请移机日期 } if (ucSrchEndApplydate.DateValue.HasValue) { search.EndApplydate = ucSrchEndApplydate.DateValue.Value;//申请移机日期 } search.Storagetitle = ucSelectProject.Storagetitle;//区分字段:分公司或项目体 search.Storageid = ucSelectProject.StorageId;//项目体ID或分公司ID int recordCount = 0; var list = this.AssetmoveService.RetrieveAssetmovesPaging(search, pageIndex, pcData.PageSize, out recordCount); rptMoveList.DataSource = list; rptMoveList.DataBind(); pcData.RecordCount = recordCount; pcData.CurrentIndex = pageIndex; }
public List<Assetmove> RetrieveAssetmovesPaging(AssetmoveSearch info,int pageIndex, int pageSize,out int count) { return Management.RetrieveAssetmovesPaging(info,pageIndex,pageSize,out count); }
public List<Assetmove> RetrieveAssetmovesPaging(AssetmoveSearch info,int pageIndex, int pageSize,out int count) { try { StringBuilder sqlCommand = new StringBuilder(@" SELECT ""ASSETMOVE"".""ASSETMOVEID"",""ASSETMOVE"".""ASSETCATEGORYID"",""ASSETMOVE"".""APPLYDATE"",""ASSETMOVE"".""APPLYUSERID"",""ASSETMOVE"".""APPLYCONTENT"", ""ASSETMOVE"".""APPROVEUSER"",""ASSETMOVE"".""APPROVEDATE"",""ASSETMOVE"".""APPROVERESULT"",""ASSETMOVE"".""REJECTREASON"",""ASSETMOVE"".""PLANMOVEDATE"", ""ASSETMOVE"".""ACTUALMOVEDATE"",""ASSETMOVE"".""CONFIRMDATE"",""ASSETMOVE"".""CONFIRMUSER"",""ASSETMOVE"".""MOVEDCONTENT"",""ASSETMOVE"".""STORAGETITLE"", ""ASSETMOVE"".""STORAGEID"",""ASSETMOVE"".""SUBCOMPANY"",""ASSETMOVE"".""SUBCOMPANYCONTACTORID"",""ASSETMOVE"".""CONTACTPHONE"",""ASSETMOVE"".""PROJECTCONTACTORID"", ""ASSETMOVE"".""PROJECTCONTACTORPHONE"",""ASSETMOVE"".""CREATOR"",""ASSETMOVE"".""CREATEDDATE"" ,SYSTEM,c.StorageName,c.subcompanyname,TU.USERNAME AS Applyusername FROM ""ASSETMOVE"" inner join ASSETCATEGORY ON ASSETMOVE.ASSETCATEGORYID=ASSETCATEGORY.ASSETCATEGORYID Inner join v_storage_address c on c.StorageTitle=ASSETMOVE.STORAGETITLE and c.StorageId=ASSETMOVE.STORAGEID INNER JOIN T_USER TU ON TU.ID=ASSETMOVE.APPLYUSERID WHERE 1=1"); #region �ƻ����� if (!string.IsNullOrEmpty(info.Assetmoveid)) { this.Database.AddInParameter(":Assetmoveid",DbType.AnsiString,"%"+info.Assetmoveid+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""ASSETMOVEID"" LIKE :Assetmoveid"); } #endregion #region ��Ŀ��ID��ֹ�˾ID if (!string.IsNullOrEmpty(info.Storageid) && !string.IsNullOrEmpty(info.Storagetitle)) { this.Database.AddInParameter(":Storagetitle", DbType.AnsiString, info.Storagetitle); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""STORAGETITLE"" = :Storagetitle"); this.Database.AddInParameter(":Storageid", DbType.AnsiString, info.Storageid); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""STORAGEID"" = :Storageid"); } #endregion #region (ϵͳ)�豸���� if (!string.IsNullOrEmpty(info.Assetcategoryid)) { this.Database.AddInParameter(":Assetcategoryid",DbType.AnsiString,"%"+info.Assetcategoryid+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""ASSETCATEGORYID"" LIKE :Assetcategoryid"); } #endregion #region �����ƻ����� if (info.StartApplydate.HasValue) { this.Database.AddInParameter(":StartApplydate",info.StartApplydate.Value.Date); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""APPLYDATE"" >= :StartApplydate"); } if (info.EndApplydate.HasValue) { this.Database.AddInParameter(":EndApplydate",info.EndApplydate.Value.Date.AddDays(1).AddSeconds(-1)); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""APPLYDATE"" <= :EndApplydate"); } #endregion #region ������ if (!string.IsNullOrEmpty(info.Applyuserid)) { this.Database.AddInParameter(":Applyuserid",DbType.AnsiString,"%"+info.Applyuserid+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""APPLYUSERID"" LIKE :Applyuserid"); } #endregion #region ����� if (!string.IsNullOrEmpty(info.Approveuser)) { this.Database.AddInParameter(":Approveuser", "%"+info.Approveuser+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""APPROVEUSER"" LIKE :Approveuser"); } #endregion #region ������� if (info.StartApprovedate.HasValue) { this.Database.AddInParameter(":StartApprovedate",info.StartApprovedate.Value.Date); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""APPROVEDATE"" >= :StartApprovedate"); } if (info.EndApprovedate.HasValue) { this.Database.AddInParameter(":EndApprovedate",info.EndApprovedate.Value.Date.AddDays(1).AddSeconds(-1)); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""APPROVEDATE"" <= :EndApprovedate"); } #endregion #region �ƻ��ƻ����� if (info.StartPlanmovedate.HasValue) { this.Database.AddInParameter(":StartPlanmovedate",info.StartPlanmovedate.Value.Date); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""PLANMOVEDATE"" >= :StartPlanmovedate"); } if (info.EndPlanmovedate.HasValue) { this.Database.AddInParameter(":EndPlanmovedate",info.EndPlanmovedate.Value.Date.AddDays(1).AddSeconds(-1)); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""PLANMOVEDATE"" <= :EndPlanmovedate"); } #endregion #region ʵ���ƻ����� if (info.StartActualmovedate.HasValue) { this.Database.AddInParameter(":StartActualmovedate",info.StartActualmovedate.Value.Date); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""ACTUALMOVEDATE"" >= :StartActualmovedate"); } if (info.EndActualmovedate.HasValue) { this.Database.AddInParameter(":EndActualmovedate",info.EndActualmovedate.Value.Date.AddDays(1).AddSeconds(-1)); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""ACTUALMOVEDATE"" <= :EndActualmovedate"); } #endregion #region ȷ������ if (info.StartConfirmdate.HasValue) { this.Database.AddInParameter(":StartConfirmdate",info.StartConfirmdate.Value.Date); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""CONFIRMDATE"" >= :StartConfirmdate"); } if (info.EndConfirmdate.HasValue) { this.Database.AddInParameter(":EndConfirmdate",info.EndConfirmdate.Value.Date.AddDays(1).AddSeconds(-1)); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""CONFIRMDATE"" <= :EndConfirmdate"); } #endregion #region ȷ���� if (!string.IsNullOrEmpty(info.Confirmuser)) { this.Database.AddInParameter(":Confirmuser",DbType.AnsiString,"%"+info.Confirmuser+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""CONFIRMUSER"" LIKE :Confirmuser"); } #endregion #region �ֹ�˾��ϵ�� if (!string.IsNullOrEmpty(info.Subcompanycontactorid)) { this.Database.AddInParameter(":Subcompanycontactorid",DbType.AnsiString,"%"+info.Subcompanycontactorid+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""SUBCOMPANYCONTACTORID"" LIKE :Subcompanycontactorid"); } #endregion #region ��ϵ�˵绰 if (!string.IsNullOrEmpty(info.Contactphone)) { this.Database.AddInParameter(":Contactphone",DbType.AnsiString,"%"+info.Contactphone+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""CONTACTPHONE"" LIKE :Contactphone"); } #endregion #region ��Ŀ����ϵ�� if (!string.IsNullOrEmpty(info.Projectcontactorid)) { this.Database.AddInParameter(":Projectcontactorid",DbType.AnsiString,"%"+info.Projectcontactorid+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""PROJECTCONTACTORID"" LIKE :Projectcontactorid"); } #endregion #region ��Ŀ����ϵ�绰 if (!string.IsNullOrEmpty(info.Projectcontactorphone)) { this.Database.AddInParameter(":Projectcontactorphone",DbType.AnsiString,"%"+info.Projectcontactorphone+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""PROJECTCONTACTORPHONE"" LIKE :Projectcontactorphone"); } #endregion #region ������ if (!string.IsNullOrEmpty(info.Creator)) { this.Database.AddInParameter(":Creator",DbType.AnsiString,"%"+info.Creator+"%"); sqlCommand.AppendLine(@" AND ""ASSETMOVE"".""CREATOR"" LIKE :Creator"); } #endregion #region �ƻ���״̬ if (info.AssetMoveStates.Count > 0) { this.Database.AddInParameter(":APPROVERESULT", info.AssetMoveStates[0]); sqlCommand.AppendLine(@" AND (""ASSETMOVE"".""APPROVERESULT""=:APPROVERESULT"); for (int i = 1; i < info.AssetMoveStates.Count; i++) { this.Database.AddInParameter(":APPROVERESULT" + i.ToString(), info.AssetMoveStates[i]); sqlCommand.AppendLine(@" OR ""ASSETMOVE"".""APPROVERESULT""=:APPROVERESULT" + i.ToString()); } sqlCommand.AppendLine(@" )"); } #endregion sqlCommand.AppendLine(@" ORDER BY ""ASSETMOVE"".""ASSETMOVEID"" DESC"); return this.ExecuteReaderPaging<Assetmove>(sqlCommand.ToString(), pageIndex, pageSize, out count); } finally { this.Database.ClearParameter(); } }