Page 286 - ระบบบริหารจัดการงบประมาณด้านเทคโนโลยีสารสนเทศและการสื่อสาร กรมพัฒนาที่ดิน
P. 286
ห้องสมุดกรมพัฒนาที่ดิน
ง-31
{ 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 formAlterHSWProcure.FormID, formAlterHSWProcure.FiscalYear,
Bureau.BureauID, Bureau.Bureau, formAlterHSWProcure.ProjectName,
formAlterHSWProcure.ProjectType, ProjectType.ProjectTypeCaption,
formAlterHSWProcure.FiscalType, FiscalType.FiscalTypeCaption,
formAlterHSWProcure.ResponsiblePerson, formAlterHSWProcure.Coordinator,";
sSql += " CASE WHEN formAlterHSWProcure.SendStatus = 'y' THEN 'ส่งข้อมูลแล้ว' WHEN
formAlterHSWProcure.SendStatus = 'n' THEN 'ยังไม่ส่งข้อมูล' WHEN
formAlterHSWProcure.SendStatus = 'R' THEN 'ข้อมูลถูกตีกลับ' ELSE
formAlterHSWProcure.SendStatus END AS SendStatus,";
sSql += " CASE WHEN formAlterHSWProcure.FinishJobStatus = 'y' THEN 'ปิดงานแล้ว'
WHEN formAlterHSWProcure.FinishJobStatus = 'n' THEN 'ยังไม่ปิดงาน' ELSE
formAlterHSWProcure.FinishJobStatus END AS FinishJobStatus,";
sSql += " CASE WHEN formAlterHSWProcure.ApproveStatus = 'y' THEN 'อนุมัติแล้ว' WHEN
formAlterHSWProcure.ApproveStatus = 'n' THEN 'ยังไม่อนุมัติ' WHEN
formAlterHSWProcure.ApproveStatus = 'R' THEN 'ข้อมูลถูกตีกลับ' ELSE
formAlterHSWProcure.ApproveStatus END AS ApproveStatus";
sSql += " FROM formAlterHSWProcure INNER JOIN Bureau ON
formAlterHSWProcure.Bureau = Bureau.BureauID INNER JOIN FiscalType ON
formAlterHSWProcure.FiscalType = FiscalType.FiscalType INNER JOIN ProjectType ON
formAlterHSWProcure.ProjectType = ProjectType.ProjectType";
sSql += " WHERE (formAlterHSWProcure.FormID is not null)";
if (ddlProjectType.SelectedValue != "All")
sSql +="AND (formAlterHSWProcure.ProjectType ='"+ddlProjectType.SelectedValue +
"')";
if (ddlFiscalType.SelectedValue != "All")
sSql += " AND (formAlterHSWProcure.FiscalType ='" + ddlFiscalType.SelectedValue +
"')";