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

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

ProjectType.ProjectTypeCaption, formSetICTDev.FiscalType, FiscalType.FiscalTypeCaption,
formSetICTDev.ResponsiblePerson, formSetICTDev.Coordinator,";
sSql += " CASE WHEN formSetICTDev.SendStatus = 'y' THEN 'ส่งข้อมูลแล้ว' WHEN

formSetICTDev.SendStatus = 'n' THEN 'ยังไม่ส่งข้อมูล' WHEN formSetICTDev.SendStatus = 'R'
THEN 'ข้อมูลถูกตีกลับ' ELSE formSetICTDev.SendStatus END AS SendStatus,";
sSql += " CASE WHEN formSetICTDev.FinishJobStatus = 'y' THEN 'ปิดงานแล้ว' WHEN
formSetICTDev.FinishJobStatus = 'n' THEN 'ยังไม่ปิดงาน' ELSE formSetICTDev.FinishJobStatus

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

sSql += " FROM formSetICTDev INNER JOIN Bureau ON formSetICTDev.Bureau =
Bureau.BureauID INNER JOIN FiscalType ON formSetICTDev.FiscalType = FiscalType.FiscalType
INNER JOIN ProjectType ON formSetICTDev.ProjectType = ProjectType.ProjectType";
sSql += " WHERE (formSetICTDev.FormID is not null)";

if (ddlProjectType.SelectedValue != "All")
sSql += " AND (formSetICTDev.ProjectType = '" + ddlProjectType.SelectedValue + "')";
if (ddlFiscalType.SelectedValue != "All")
sSql += " AND (formSetICTDev.FiscalType = '" + ddlFiscalType.SelectedValue + "')";

if (sType != "Admin" && sType != "Exe")
sSql += " AND (formSetICTDev.RecUser = N'" + sUsername + "')";
else

{ if (!cbAllBureau.Checked)
sSql += " AND (formSetICTDev.Bureau = '" + ddlBureau.SelectedValue + "')"; }
if (txtFiscalYear.Text != "")
sSql += " AND (formSetICTDev.FiscalYear = '" + txtFiscalYear.Text + "')";
if (txtProjectName.Text != "")

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

txtResponsiblePerson.Text + "%')";
if (txtCoordinator.Text != "")
sSql += " AND (formSetICTDev.Coordinator like '%" + txtCoordinator.Text + "%')";
if (ddlSendStatus.SelectedValue != "All")

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