Page 120 - ระบบสารสนเทศเพื่อการบริหารจัดการเอกสารอิเล็กทรอนิกส์ (e-Document)

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

string str =
ConfigurationManager.ConnectionStrings["SqlCon"].ConnectionString;
Utilities ut = new Utilities();

protected void Page_Load(object sender, EventArgs e)
{
FormDDL ddl = new FormDDL(str);

lbl01.Visible = false;
if (!IsPostBack)
{
lbl01.Visible = true;
}
else
{
lblDolD.Text = ddl.createDDLD("ddlDolD",
Request.Form["ddlDolD"], "na", "--วัน--", false);
lblDolM.Text = ddl.createDDLM("ddlDolM",
Request.Form["ddlDolM"], "na", "--เดือน--", false);
lblDolY.Text = ddl.createDDLY("ddlDolY", 2018, 2021,
Request.Form["ddlDolY"], "na", "--ปี--", false);
lblDolD2.Text = ddl.createDDLD("ddlDolD2",
Request.Form["ddlDolD2"], "na", "--วัน--", false);
lblDolM2.Text = ddl.createDDLM("ddlDolM2",
Request.Form["ddlDolM2"], "na", "--เดือน--", false);
lblDolY2.Text = ddl.createDDLY("ddlDolY2", 2018, 2021,
Request.Form["ddlDolY2"], "na", "--ปี--", false);
lblDolD3.Text = ddl.createDDLD("ddlDolD3",
Request.Form["ddlDolD3"], "na", "--วัน--", false);
lblDolM3.Text = ddl.createDDLM("ddlDolM3",
Request.Form["ddlDolM3"], "na", "--เดือน--", false);
lblDolY3.Text = ddl.createDDLY("ddlDolY3", 2018, 2021,
Request.Form["ddlDolY3"], "na", "--ปี--", false);
lblDolD4.Text = ddl.createDDLD("ddlDolD4",
Request.Form["ddlDolD4"], "na", "--วัน--", false);
lblDolM4.Text = ddl.createDDLM("ddlDolM4",
Request.Form["ddlDolM4"], "na", "--เดือน--", false);
lblDolY4.Text = ddl.createDDLY("ddlDolY4", 2018, 2021,
Request.Form["ddlDolY4"], "na", "--ปี--", false);

}
string sSql = "SELECT BureauID AS ID, Bureau AS Value FROM Bureau";
lblBureau.Text = ddl.createDDL("ddlBureau", sSql, "ID", "Value",
Request.Form["ddlBureau"], "na", "---ทุกหน่วยงาน---", false);

if (!IsPostBack)
{
GridView1.Visible = true;
sSql = "";
sSql += "SELECT Letter.Letter_No, Letter.Letter_Number,
Letter.Letter_Title, RIGHT(Letter.Letter_YMD, 2) + '/' +
SUBSTRING(Letter.Letter_YMD, 5, 2) + '/' + CONVERT(varchar(4), CONVERT
(INT, LEFT(Letter.Letter_YMD, 4)) + 543) AS DMY, RIGHT
(Letter.Letter_RecDate, 2) + '/' + SUBSTRING(Letter.Letter_RecDate, 5, 2) +
'/' + CONVERT (varchar(4), CONVERT (INT, LEFT (Letter.Letter_RecDate, 4)) +