public void CreateForm1Display(string leaveID)
{
Form1Package f1 = DatabaseManager.GetForm1Package(leaveID);
if (f1 != null)
{
lbLeaveID.Text = f1.LeaveID;
lbReqDate.Text = f1.RequestDate;
lbName.Text = f1.PersonPrefix + f1.PersonFirstName + " " + f1.PersonLastName;
lbPosition.Text = f1.PersonPosition;
lbRank.Text = f1.PersonRank;
lbDepartment.Text = f1.PersonDepartment;
lbLeaveType.Text = f1.LeaveTypeName;
lbFromDate.Text = f1.FromDate;
lbToDate.Text = f1.ToDate;
lbTotalDay.Text = f1.TotalDay + " วัน";
lbReason.Text = f1.Reason;
lbContact.Text = f1.Contact;
lbPhone.Text = f1.Phone;
if (f1.LastFromDate == "")
{
lbLastFromDate.Text = "-";
lbLastToDate.Text = "-";
lbLastTotalDay.Text = "-";
}
else
{
lbLastFromDate.Text = f1.LastFromDate;
lbLastToDate.Text = f1.LastToDate;
lbLastTotalDay.Text = f1.LastTotalDay + " วัน";
}
lbCmdLowName.Text = f1.CommanderLowPrefix + f1.CommanderLowFirstName + " " + f1.CommanderLowLastName;
lbCmdLowPosition.Text = f1.CommanderLowPosition;
lbCmdLowComment.Text = f1.CommanderLowComment;
lbCmdLowDate.Text = f1.CommanderLowDate;
lbCmdHighName.Text = f1.CommanderHighPrefix + f1.CommanderHighFirstName + " " + f1.CommanderHighLastName;
lbCmdHighPosition.Text = f1.CommanderHighPosition;
lbCmdHighComment.Text = f1.CommanderHighComment;
lbCmdHighDate.Text = f1.CommanderHighDate;
lbCmdHighAllow.Text = f1.CommanderHighAllowName;
lbStaffName.Text = f1.StaffPrefix + f1.StaffFirstName + " " + f1.StaffLastName;
lbStaffPosition.Text = f1.StaffPosition;
lbStaffDate.Text = f1.StaffDate;
}
}
public static Form1Package GetForm1Package(string leaveID)
{
try {
int.Parse(leaveID);
} catch {
return(null);
}
using (OleDbConnection con = new OleDbConnection(CONNECTION_STRING)) {
con.Open();
using (OleDbCommand com = new OleDbCommand("SELECT LEV_MAIN.*, LEV_FORM1.*, (SELECT LEAVE_TYPE_NAME FROM LEV_MAIN, LEV_TYPE WHERE LEV_MAIN.LEAVE_TYPE_ID = LEV_TYPE.LEAVE_TYPE_ID AND LEV_MAIN.LEAVE_ID = " + leaveID + "), (SELECT LEAVE_ALLOW_NAME FROM LEV_FORM1, LEV_ALLOW WHERE CMD_HIGH_ALLOW = LEAVE_ALLOW_ID AND LEV_FORM1.LEAVE_ID = " + leaveID + ") FROM LEV_MAIN, LEV_FORM1 WHERE LEV_MAIN.LEAVE_TYPE_ID in(1,2,3) AND LEV_MAIN.LEAVE_ID = LEV_FORM1.LEAVE_ID AND LEV_MAIN.LEAVE_ID = " + leaveID, con)) {
using (OleDbDataReader reader = com.ExecuteReader()) {
while (reader.Read())
{
Form1Package form1Package = new Form1Package();
form1Package.LeaveID = reader.GetValue(0).ToString();
form1Package.LeaveTypeID = reader.GetValue(1).ToString();
form1Package.LeaveState = reader.GetValue(2).ToString();
form1Package.CitizenID = reader.GetValue(3).ToString();
form1Package.RequestDate = Util.PureDatabaseToThaiDate(reader.GetValue(4).ToString());
form1Package.FormID = reader.GetValue(5).ToString();
form1Package.FromDate = Util.PureDatabaseToThaiDate(reader.GetValue(7).ToString());
form1Package.ToDate = Util.PureDatabaseToThaiDate(reader.GetValue(8).ToString());
form1Package.TotalDay = reader.GetValue(9).ToString();
form1Package.Reason = reader.GetValue(10).ToString();
form1Package.Contact = reader.GetValue(11).ToString();
form1Package.Phone = reader.GetValue(12).ToString();
form1Package.PersonPosition = reader.GetValue(13).ToString();
form1Package.PersonRank = reader.GetValue(14).ToString();
form1Package.PersonDepartment = reader.GetValue(15).ToString();
form1Package.LastFromDate = Util.PureDatabaseToThaiDate(reader.GetValue(16).ToString());
form1Package.LastToDate = Util.PureDatabaseToThaiDate(reader.GetValue(17).ToString());
form1Package.LastTotalDay = reader.GetValue(18).ToString();
form1Package.PersonPrefix = reader.GetValue(19).ToString();
form1Package.PersonFirstName = reader.GetValue(20).ToString();
form1Package.PersonLastName = reader.GetValue(21).ToString();
form1Package.CommanderLowID = reader.GetValue(22).ToString();
form1Package.CommanderLowPosition = reader.GetValue(23).ToString();
form1Package.CommanderLowComment = reader.GetValue(24).ToString();
form1Package.CommanderLowDate = Util.PureDatabaseToThaiDate(reader.GetValue(25).ToString());
form1Package.CommanderHighID = reader.GetValue(26).ToString();
form1Package.CommanderHighPosition = reader.GetValue(27).ToString();
form1Package.CommanderHighComment = reader.GetValue(28).ToString();
form1Package.CommanderHighDate = Util.PureDatabaseToThaiDate(reader.GetValue(29).ToString());
form1Package.CommanderHighAllow = reader.GetValue(30).ToString();
form1Package.StaffID = reader.GetValue(31).ToString();
form1Package.StaffPosition = reader.GetValue(32).ToString();
form1Package.StaffDate = Util.PureDatabaseToThaiDate(reader.GetValue(33).ToString());
form1Package.CommanderLowPrefix = reader.GetValue(34).ToString();
form1Package.CommanderLowFirstName = reader.GetValue(35).ToString();
form1Package.CommanderLowLastName = reader.GetValue(36).ToString();
form1Package.CommanderHighPrefix = reader.GetValue(37).ToString();
form1Package.CommanderHighFirstName = reader.GetValue(38).ToString();
form1Package.CommanderHighLastName = reader.GetValue(39).ToString();
form1Package.StaffPrefix = reader.GetValue(40).ToString();
form1Package.StaffFirstName = reader.GetValue(41).ToString();
form1Package.StaffLastName = reader.GetValue(42).ToString();
form1Package.LeaveTypeName = reader.GetValue(43).ToString();
form1Package.CommanderHighAllowName = reader.GetValue(44).ToString();
return(form1Package);
}
}
}
}
return(null);
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
Person loginPerson = ps.LoginPerson;
int count = DatabaseManager.GetLeaveRequiredCountByCommanderLow(loginPerson.CitizenID);;
/*using (OleDbConnection con = new OleDbConnection(DatabaseManager.CONNECTION_STRING)) {
* con.Open();
* using (OleDbCommand com = new OleDbCommand("SELECT COUNT(LEV_MAIN.LEAVE_ID) FROM LEV_MAIN, LEV_FORM1 WHERE LEV_MAIN.LEAVE_ID = LEV_FORM1.LEAVE_ID AND CMD_LOW_ID = '" + loginPerson.CitizenID + "' AND LEAVE_STATE = 1", con)) {
* using (OleDbDataReader reader = com.ExecuteReader()) {
* while (reader.Read()) {
* count = int.Parse(reader.GetValue(0).ToString());
* }
* }
* }
* }*/
if (count == 0)
{
error_area.InnerHtml = "ไม่มีรายการที่ท่านต้องลงความเห็น";
}
else
{
error_area.InnerHtml = "กรุณาเลือกรายการที่ต้องการลงความเห็น";
}
error_area.Attributes["class"] = "alert alert_info";
if (count > 0)
{
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEV_MAIN.LEAVE_ID รหัสการลา, (SELECT PERSON_NAME || ' ' || PERSON_LASTNAME FROM TB_PERSON WHERE CITIZEN_ID = LEV_MAIN.CITIZEN_ID) ชื่อผู้ลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_MAIN.LEAVE_TYPE_ID) ประเภทการลา, LEV_MAIN.REQ_DATE วันที่ข้อมูล FROM LEV_MAIN, LEV_FORM1 WHERE LEV_MAIN.LEAVE_ID = LEV_FORM1.LEAVE_ID AND LEAVE_STATE = 1 AND CMD_LOW_ID = '" + loginPerson.CitizenID + "'");
GridView1.DataSource = sds;
GridView1.DataBind();
Util.NormalizeGridViewDate(GridView1, 3);
TableCell newHeader = new TableCell();
newHeader.Text = "เลือก";
GridView1.HeaderRow.Cells.Add(newHeader);
for (int i = 0; i < GridView1.Rows.Count; ++i)
{
string id = GridView1.Rows[i].Cells[0].Text;
Form1Package f1 = DatabaseManager.GetForm1Package(id);
LinkButton lbu = new LinkButton();
lbu.Text = "เลือก";
lbu.CssClass = "button button_default";
lbu.Click += (e2, e3) => {
lbF1LeaveID.Text = id;
lbF1LeaverName.Text = f1.PersonPrefix + f1.PersonFirstName + " " + f1.PersonLastName;
lbF1PersonPosition.Text = f1.PersonPosition;
lbF1PersonDepartment.Text = f1.PersonDepartment;
lbF1PersonRank.Text = f1.PersonRank;
lbF1ReqDate.Text = f1.RequestDate;
lbF1LeaveTypeName.Text = f1.LeaveTypeName;
if (f1.LastFromDate == "")
{
lbF1LastFTTDate.Text = "ยังไม่เคยลา";
}
else
{
lbF1LastFTTDate.Text = f1.LastFromDate + " - " + f1.LastToDate + " / รวม " + f1.LastTotalDay + " วัน";
}
lbF1FTTDate.Text = f1.FromDate + " - " + f1.ToDate + " / รวม " + f1.TotalDay + " วัน";
lbF1Reason.Text = f1.Reason;
lbF1Contact.Text = f1.Contact;
lbF1Phone.Text = f1.Phone;
MultiView1.ActiveViewIndex = 1;
error_area.Attributes["class"] = "alert alert_info";
error_area.InnerHtml = "กรุณาลงความเห็น";
};
TableCell cell = new TableCell();
cell.Controls.Add(lbu);
GridView1.Rows[i].Cells.Add(cell);
}
/*HTable htable = new HTable(i1);
* htable.AddHeaderRow(new string[] { "รหัสการลา", "วันที่ยื่นเรื่อง", "ผู้ลา", "ประเภทการลา", "เลือก" });
* using (OleDbConnection con = new OleDbConnection(DatabaseManager.CONNECTION_STRING)) {
* con.Open();
* using (OleDbCommand com = new OleDbCommand("SELECT LEV_MAIN.LEAVE_ID, REQ_DATE, (SELECT PERSON_NAME || ' ' || PERSON_LASTNAME FROM TB_PERSON WHERE CITIZEN_ID = LEV_MAIN.CITIZEN_ID), LEAVE_TYPE_NAME FROM LEV_MAIN, LEV_FORM1, LEV_TYPE WHERE LEV_MAIN.LEAVE_ID = LEV_FORM1.LEAVE_ID AND LEV_FORM1.CMD_LOW_ID = '" + loginPerson.CitizenID + "' AND LEV_MAIN.LEAVE_TYPE_ID = LEV_TYPE.LEAVE_TYPE_ID AND LEV_MAIN.LEAVE_STATE = 1", con)) {
* using (OleDbDataReader reader = com.ExecuteReader()) {
* while (reader.Read()) {
*
* string id = reader.GetValue(0).ToString();
* Form1Package f1 = DatabaseManager.GetForm1Package(id);
* string req_date = Util.PureDatabaseToThaiDate(reader.GetValue(1).ToString());
* string name = reader.GetValue(2).ToString();
* string leave_type_name = reader.GetValue(3).ToString();
* htable.AddRow(new string[] {
* id,
* req_date,
* name,
* leave_type_name,
* });
* LinkButton b = new LinkButton();
* b.Text = "เลือก";
* b.CssClass = "hm_button_primary";
* b.Click += (e2, e3) => {
* lbF1LeaveID.Text = id;
* lbF1LeaverName.Text = name;
*
* lbF1PersonPosition.Text = f1.PersonPosition;
* lbF1PersonDepartment.Text = f1.PersonDepartment;
* lbF1PersonRank.Text = f1.PersonRank;
* lbF1ReqDate.Text = req_date;
* lbF1LeaveTypeName.Text = leave_type_name;
* if (f1.LastFromDate == "''") {
* lbF1LastFTTDate.Text = "ยังไม่เคยลา";
* } else {
* lbF1LastFTTDate.Text = f1.LastFromDate + " - " + f1.LastToDate + " / รวม " + f1.LastTotalDay + " วัน";
* }
*
* lbF1FTTDate.Text = f1.FromDate + " - " + f1.ToDate + " / รวม " + f1.TotalDay + " วัน";
*
* lbF1Reason.Text = f1.Reason;
* lbF1Contact.Text = f1.Contact;
* lbF1Phone.Text = f1.Phone;
*
* i1.Style.Add("display", "none");
* i2.Style.Add("display", "block");
* i3.Style.Add("display", "none");
* error_area.Attributes["class"] = "hm_alert_info";
* error_area.InnerHtml = "กรุณาลงความเห็น";
* };
* TableCell c = new TableCell();
* c.Controls.Add(b);
* htable.LastestRow().Cells.Add(c);
* }
* }
* }
* }*/
}
}