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