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

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

{ lblRecUserCaption.Visible = true;
lblUsername.Visible = true;
lblBureauCaption.Visible = false;

ddlBureau.Visible = false;
cbAllBureau.Checked = false;//--
cbAllBureau.Visible = false;//--
}

}
protected void refreshTable()
{ string sSql;
sSql = "SELECT formAlterICTDev.FormID, formAlterICTDev.FiscalYear, Bureau.BureauID,

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

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

END AS FinishJobStatus,";
sSql += " CASE WHEN formAlterICTDev.ApproveStatus = 'y' THEN 'อนุมัติแล้ว' WHEN
formAlterICTDev.ApproveStatus = 'n' THEN 'ยังไม่อนุมัติ' WHEN formAlterICTDev.ApproveStatus

= 'R' THEN 'ข้อมูลถูกตีกลับ' ELSE formAlterICTDev.ApproveStatus END AS ApproveStatus";
sSql += " FROM formAlterICTDev INNER JOIN Bureau ON formAlterICTDev.Bureau =
Bureau.BureauID INNER JOIN FiscalType ON formAlterICTDev.FiscalType =
FiscalType.FiscalType INNER JOIN ProjectType ON formAlterICTDev.ProjectType =
ProjectType.ProjectType";

sSql += " WHERE (formAlterICTDev.FormID is not null)";
if (ddlProjectType.SelectedValue != "All")
sSql += " AND (formAlterICTDev.ProjectType = '" + ddlProjectType.SelectedValue + "')";

if (ddlFiscalType.SelectedValue != "All")
sSql += " AND (formAlterICTDev.FiscalType = '" + ddlFiscalType.SelectedValue + "')";
if (sType != "Admin" && sType != "Exe")
sSql += " AND (formAlterICTDev.RecUser = N'" + sUsername + "')";

else
{ if (!cbAllBureau.Checked)
sSql += " AND (formAlterICTDev.Bureau = '" + ddlBureau.SelectedValue + "')"; }