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

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

543) AS DMY_INPUT, Letter.Letter_Other, Letter.Letter_Filename,
Bureau.Bureau as Expr1, Piority.PriName ";
sSql += "FROM Letter INNER JOIN Bureau ON Letter.Letter_Bureau
= Bureau.BureauID INNER JOIN Piority ON Letter.Letter_Priority =
Piority.PriID ";
sSql += "WHERE (NOT (Letter.Letter_No IS NULL)) AND
(Letter.Letter_Permission = N'000') AND (Letter.Letter_Status = N'1')";

DateTime dt = new DateTime();
dt = DateTime.Today;
string YMD1 = (dt.Year * 10000 + dt.Month * 100 +
0).ToString();
string YMD2 = (dt.Year * 10000 + dt.Month * 100 +
31).ToString();
sSql += " AND (Letter.Letter_RecDate >= N'" + YMD1 + "') AND
(Letter.Letter_RecDate <= N'" + YMD2 + "')";
sSql += " Order By Letter.Letter_RecDate desc";
DBLetter.SelectCommand = sSql;
Session["SQL"] = sSql;
DBLetter.DataBind();
DbMgt table = new DbMgt(str);
MyDataSet ds = new MyDataSet(table.exReader(sSql));
}
}

protected void reQuery()
{
string 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)) +
543) AS DMY_INPUT, Letter.Letter_Other, Letter.Letter_Filename,
Bureau.Bureau as Expr1, Piority.PriName ";
sSql += "FROM Letter INNER JOIN Bureau ON Letter.Letter_Bureau =
Bureau.BureauID INNER JOIN Piority ON Letter.Letter_Priority =
Piority.PriID ";
sSql += "WHERE (NOT (Letter.Letter_No IS NULL)) AND
(Letter.Letter_Permission = N'000') AND (Letter.Letter_Status = N'1')";

if (txtLetterNumSe.Text != "")
sSql += " AND (Letter.Letter_Number LIKE '%" +
txtLetterNumSe.Text + "%')";

if (txtLetterTitleSe.Text != "")
sSql += " AND (Letter.Letter_Title LIKE '%" +
txtLetterTitleSe.Text + "%')";

if (Request.Form["ddlBureau"] != "na")
sSql += " AND (Bureau.BureauID = '" + Request.Form["ddlBureau"]
+ "')";
string YMD1 = Request.Form["ddlDolY"] + Request.Form["ddlDolM"] +
Request.Form["ddlDolD"];
string YMD2 = Request.Form["ddlDolY2"] + Request.Form["ddlDolM2"] +
Request.Form["ddlDolD2"];