protected void LoadData(int pageIndex) { var search = new ProcurementscheduleheadSearch(); search.Psid = txtSrchPsid.Text; //DateTime startprocurementscheduledate = DateTime.MinValue; //if (DateTime.TryParse(txtSrchStartProcurementscheduledate.Text, out startprocurementscheduledate)) //{ // search.StartProcurementscheduledate = startprocurementscheduledate; //} //DateTime endprocurementscheduledate = DateTime.MinValue; //if (DateTime.TryParse(txtSrchEndProcurementscheduledate.Text, out endprocurementscheduledate)) //{ // search.EndProcurementscheduledate = endprocurementscheduledate; //} //search.Reason = txtSrchReason.Text; //search.Subcompany = txtSrchSubcompany.Text; //search.Applyuser = txtSrchApplyuser.Text; //DateTime startapplydate = DateTime.MinValue; //if (DateTime.TryParse(txtSrchStartApplydate.Text, out startapplydate)) //{ // search.StartApplydate = startapplydate; //} //DateTime endapplydate = DateTime.MinValue; //if (DateTime.TryParse(txtSrchEndApplydate.Text, out endapplydate)) //{ // search.EndApplydate = endapplydate; //} //search.Approveuser = txtSrchApproveuser.Text; //DateTime startapprovedate = DateTime.MinValue; //if (DateTime.TryParse(txtSrchStartApprovedate.Text, out startapprovedate)) //{ // search.StartApprovedate = startapprovedate; //} //DateTime endapprovedate = DateTime.MinValue; //if (DateTime.TryParse(txtSrchEndApprovedate.Text, out endapprovedate)) //{ // search.EndApprovedate = endapprovedate; //} //search.Rejectreason = txtSrchRejectreason.Text; //DateTime startcreateddate = DateTime.MinValue; //if (DateTime.TryParse(txtSrchStartCreateddate.Text, out startcreateddate)) //{ // search.StartCreateddate = startcreateddate; //} //DateTime endcreateddate = DateTime.MinValue; //if (DateTime.TryParse(txtSrchEndCreateddate.Text, out endcreateddate)) //{ // search.EndCreateddate = endcreateddate; //} int recordCount = 0; var list = ProcurementscheduleheadService.RetrieveProcurementscheduleheadsPaging(search, pageIndex, pcData.PageSize, out recordCount); rptProcureList.DataSource = list; rptProcureList.DataBind(); pcData.RecordCount = recordCount; pcData.CurrentIndex = pageIndex; }
protected void LoadData(int pageIndex) { var search = new ProcurementscheduleheadSearch(); search.Psid = txtSrchPsid.Text; search.ApproveResults.Add(ApproveResult.Approved); int recordCount = 0; var list = ProcurementscheduleheadService.RetrieveProcurementscheduleheadsPaging(search, pageIndex, pcData.PageSize, out recordCount); rptProcureList.DataSource = list; rptProcureList.DataBind(); pcData.RecordCount = recordCount; pcData.CurrentIndex = pageIndex; }
public List<Procurementschedulehead> RetrieveProcurementscheduleheadsPaging(ProcurementscheduleheadSearch info,int pageIndex, int pageSize,out int count) { try { var sqlCommand = new StringBuilder(@" SELECT ""PROCUREMENTSCHEDULEHEAD"".""PSID"",""PROCUREMENTSCHEDULEHEAD"".""PROCUREMENTSCHEDULEDATE"",""PROCUREMENTSCHEDULEHEAD"".""REASON"",""SUBCOMPANYINFO"".""SUBCOMPANYNAME"",""PROCUREMENTSCHEDULEHEAD"".""APPLYUSER"", ""PROCUREMENTSCHEDULEHEAD"".""APPLYDATE"",""PROCUREMENTSCHEDULEHEAD"".""APPROVEUSER"",""PROCUREMENTSCHEDULEHEAD"".""APPROVEDATE"",""PROCUREMENTSCHEDULEHEAD"".""APPROVERESULT"",""PROCUREMENTSCHEDULEHEAD"".""REJECTREASON"", ""PROCUREMENTSCHEDULEHEAD"".""CREATEDDATE"" FROM ""PROCUREMENTSCHEDULEHEAD"",""SUBCOMPANYINFO"" WHERE PROCUREMENTSCHEDULEHEAD.SUBCOMPANY=SUBCOMPANYINFO.SUBCOMPANYID"); if (info.ApproveResults.Count > 0) { this.Database.AddInParameter(":State", info.ApproveResults[0]); sqlCommand.AppendLine(@" AND (""PROCUREMENTSCHEDULEHEAD"".""APPROVERESULT""=:State"); for (int i = 1; i < info.ApproveResults.Count; i++) { this.Database.AddInParameter(":State" + i.ToString(), info.ApproveResults[i]); sqlCommand.AppendLine(@" OR ""PROCUREMENTSCHEDULEHEAD"".""APPROVERESULT""=:State" + i.ToString()); } sqlCommand.AppendLine(@" )"); } if (!string.IsNullOrEmpty(info.Psid)) { this.Database.AddInParameter(":Psid",DbType.AnsiString,"%"+info.Psid+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""PSID"" LIKE :Psid"); } if (info.StartProcurementscheduledate.HasValue) { this.Database.AddInParameter(":StartProcurementscheduledate",info.StartProcurementscheduledate.Value.Date); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""PROCUREMENTSCHEDULEDATE"" >= :StartProcurementscheduledate"); } if (info.EndProcurementscheduledate.HasValue) { this.Database.AddInParameter(":EndProcurementscheduledate",info.EndProcurementscheduledate.Value.Date.AddDays(1).AddSeconds(-1)); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""PROCUREMENTSCHEDULEDATE"" <= :EndProcurementscheduledate"); } if (!string.IsNullOrEmpty(info.Reason)) { this.Database.AddInParameter(":Reason", "%"+info.Reason+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""REASON"" LIKE :Reason"); } if (!string.IsNullOrEmpty(info.Subcompany)) { this.Database.AddInParameter(":Subcompany",DbType.AnsiString,"%"+info.Subcompany+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""SUBCOMPANY"" LIKE :Subcompany"); } if (!string.IsNullOrEmpty(info.Applyuser)) { this.Database.AddInParameter(":Applyuser", "%"+info.Applyuser+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""APPLYUSER"" LIKE :Applyuser"); } if (info.StartApplydate.HasValue) { this.Database.AddInParameter(":StartApplydate",info.StartApplydate.Value.Date); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""APPLYDATE"" >= :StartApplydate"); } if (info.EndApplydate.HasValue) { this.Database.AddInParameter(":EndApplydate",info.EndApplydate.Value.Date.AddDays(1).AddSeconds(-1)); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""APPLYDATE"" <= :EndApplydate"); } if (!string.IsNullOrEmpty(info.Approveuser)) { this.Database.AddInParameter(":Approveuser", "%"+info.Approveuser+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""APPROVEUSER"" LIKE :Approveuser"); } if (info.StartApprovedate.HasValue) { this.Database.AddInParameter(":StartApprovedate",info.StartApprovedate.Value.Date); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""APPROVEDATE"" >= :StartApprovedate"); } if (info.EndApprovedate.HasValue) { this.Database.AddInParameter(":EndApprovedate",info.EndApprovedate.Value.Date.AddDays(1).AddSeconds(-1)); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""APPROVEDATE"" <= :EndApprovedate"); } if (!string.IsNullOrEmpty(info.Rejectreason)) { this.Database.AddInParameter(":Rejectreason", "%"+info.Rejectreason+"%"); sqlCommand.AppendLine(@" AND ""PROCUREMENTSCHEDULEHEAD"".""REJECTREASON"" LIKE :Rejectreason"); } sqlCommand.AppendLine(@" ORDER BY ""PROCUREMENTSCHEDULEHEAD"".""PSID"" DESC"); return this.ExecuteReaderPaging<Procurementschedulehead>(sqlCommand.ToString(), pageIndex, pageSize, out count); } finally { this.Database.ClearParameter(); } }
public List<Procurementschedulehead> RetrieveProcurementscheduleheadsPaging(ProcurementscheduleheadSearch info,int pageIndex, int pageSize,out int count) { return Management.RetrieveProcurementscheduleheadsPaging(info,pageIndex,pageSize,out count); }