Page 269 - ระบบบริหารจัดการงบประมาณด้านเทคโนโลยีสารสนเทศและการสื่อสาร กรมพัฒนาที่ดิน

ห้องสมุดกรมพัฒนาที่ดิน
ง-14

sSql += " CASE WHEN formSetHSWProcure.ApproveStatus = 'y' THEN 'อนุมัติแล้ว' WHEN
formSetHSWProcure.ApproveStatus = 'n' THEN 'ยังไม่อนุมัติ' WHEN
formSetHSWProcure.ApproveStatus = 'R' THEN 'ข้อมูลถูกตีกลับ' ELSE

formSetHSWProcure.ApproveStatus END AS ApproveStatus";

sSql += " FROM formSetHSWProcure INNER JOIN Bureau ON formSetHSWProcure.Bureau
= Bureau.BureauID INNER JOIN FiscalType ON formSetHSWProcure.FiscalType =

FiscalType.FiscalType INNER JOIN ProjectType ON formSetHSWProcure.ProjectType =
ProjectType.ProjectType";
sSql += " WHERE (formSetHSWProcure.FormID is not null)";
if (ddlProjectType.SelectedValue != "All")

sSql += " AND (formSetHSWProcure.ProjectType ='"+ddlProjectType.SelectedValue + "')";
if (ddlFiscalType.SelectedValue != "All")
sSql += " AND (formSetHSWProcure.FiscalType = '" + ddlFiscalType.SelectedValue + "')";
if (sType != "Admin" && sType != "Exe")

sSql += " AND (formSetHSWProcure.RecUser = N'" + sUsername + "')";
else
{ if (!cbAllBureau.Checked)
sSql += " AND (formSetHSWProcure.Bureau = '" + ddlBureau.SelectedValue + "')";

}
if (txtFiscalYear.Text != "")
sSql += " AND (formSetHSWProcure.FiscalYear = '" + txtFiscalYear.Text + "')";

if (txtProjectName.Text != "")
sSql += " AND (formSetHSWProcure.ProjectName like '%" + txtProjectName.Text +
"%')";
if (txtResponsiblePerson.Text != "")
sSql +="AND (formSetHSWProcure.ResponsiblePerson like'%"+

txtResponsiblePerson.Text + "%')";
if (txtCoordinator.Text != "")
sSql += " AND (formSetHSWProcure.Coordinator like '%" + txtCoordinator.Text + "%')";

if (ddlSendStatus.SelectedValue != "All")
sSql += " AND (formSetHSWProcure.SendStatus ='"+ ddlSendStatus.SelectedValue +
"')";
if (ddlApproveStatus.SelectedValue != "All")

sSql += " AND (formSetHSWProcure.ApproveStatus = '" +
ddlApproveStatus.SelectedValue + "')";
if (ddlFinishJobStatus.SelectedValue != "All")