protected void Page_Load(object sender, EventArgs e) { if (Session["login_data"] == null) { Response.Redirect("../index.aspx"); } else { //ตรวจสอบสิทธิ์ login_data = (UserLoginData)Session["login_data"]; if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty)) { /*=============================*/ code = Request.QueryString["token"]; if (!Page.IsPostBack) { string sql = "Select * From SPECIAL_FIELD Where SPEC_FIELD_CODE='" + code + "'"; SpecialFieldData = SpecialFieldObj.getSpecialFieldManual(sql); txtSPEC_FIELD_CODE.Text = SpecialFieldData[0].SpecialField_Code; txtSPEC_FIELD_ENGNAME.Text = SpecialFieldData[0].SpecialField_Eng; txtSPEC_FIELD_SHORTNAME.Text = SpecialFieldData[0].SpecialField_ShortName; //ddlSPEC_FIELD_STATUS.Items.FindByValue(data.SpecialField_Status).Selected = true; txtSPEC_FIELD_THAINAME.Text = SpecialFieldData[0].SpecialField_Thai; facultyData = facultyObj.getFaculty(); foreach (FacultyData d in facultyData) { ddlFACULTY.Items.Insert(ddlFACULTY.Items.Count, new ListItem(d.Faculty_Thai, d.Faculty_Code)); } ddlFACULTY.Items.FindByValue(SpecialFieldData[0].SpecialField_FacultyCode).Selected = true; statusData = statusObj.getSystemStatus(); foreach (StatusData data in statusData) { ddlSPEC_FIELD_STATUS.Items.Insert(ddlSPEC_FIELD_STATUS.Items.Count, new ListItem(data.Status_Thai, data.Status_Code)); } ddlSPEC_FIELD_STATUS.Items.FindByValue(SpecialFieldData[0].SpecialField_Status).Selected = true; } /*=============================*/ } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["login_data"] == null) { Response.Redirect("../index.aspx"); } else { //ตรวจสอบสิทธิ์ login_data = (UserLoginData)Session["login_data"]; if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty)) { /*=============================*/ if (!Page.IsPostBack) { //โหลดแขนงวิชา string sql = "Select * From SPECIAL_FIELD Order By SPEC_FIELD_CODE"; specialFData = specialFObj.getSpecialFieldManual(sql); // Head Table string[] ar = { "รหัส", "ชื่อย่อ", "ชื่อแขนงวิชา (thai)", "ชื่อแขนงวิชา (English)", "คณะ", "สถานะ", "แก้ไข", "ลบ" }; //Table tb1 = new Table(); tblSpecialField.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblSpecialField.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead = new TableHeaderRow(); tRowHead.TableSection = TableRowSection.TableHeader; for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++) { // Create a new cell and add it to the row. TableHeaderCell cellHead = new TableHeaderCell(); cellHead.Text = ar[cellCtr - 1]; tRowHead.Cells.Add(cellHead); } tblSpecialField.Rows.Add(tRowHead); foreach (SpecialFieldData data in specialFData) { //ตรวจสอบสถานะการใช้งานของคณะ if (new Faculty().getFaculty(data.SpecialField_FacultyCode).Faculty_Status != "0001") { continue; } else { TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; TableCell cellCode = new TableCell(); cellCode.Text = data.SpecialField_Code; tRowBody.Cells.Add(cellCode); TableCell cellShortName = new TableCell(); cellShortName.Text = data.SpecialField_ShortName; tRowBody.Cells.Add(cellShortName); TableCell cellThai = new TableCell(); cellThai.Text = data.SpecialField_Thai; tRowBody.Cells.Add(cellThai); TableCell cellEng = new TableCell(); cellEng.Text = data.SpecialField_Eng; tRowBody.Cells.Add(cellEng); TableCell cellFaculty = new TableCell(); FacultyData fac = new Faculty().getFaculty(data.SpecialField_FacultyCode); cellFaculty.Text = fac.Faculty_Thai; tRowBody.Cells.Add(cellFaculty); TableCell cellStatus = new TableCell(); //0001 = ใช้งาน if (data.SpecialField_Status == "0001") { cellStatus.Text = "<h4 class='txt-color-green'><i class='fa fa-check'></i></h4>"; cellStatus.ToolTip = "ใช้งาน"; } //0002 = ไม่ใช้งาน if (data.SpecialField_Status == "0002") { cellStatus.Text = "<h4 class='txt-color-red'><i class='fa fa-times'></i></h4>"; cellStatus.ToolTip = "ไม่ใช้งาน"; } cellStatus.CssClass = "text-center"; tRowBody.Cells.Add(cellStatus); TableCell cellEdit = new TableCell(); string urlEdit = "edit_Special_Field.aspx?token=" + data.SpecialField_Code; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#editSpecial_Field"); hypEdit.Attributes.Add("data-toggle", "modal"); hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>"; hypEdit.NavigateUrl = urlEdit; hypEdit.ToolTip = "Edit"; cellEdit.Controls.Add(hypEdit); cellEdit.CssClass = "text-center"; tRowBody.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); //string urlDel = "#"; string urlDel = "delete_Special_Field.aspx?token=" + data.SpecialField_Code; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteSpecial_Field"); hypDel.Attributes.Add("data-toggle", "modal"); hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>"; hypDel.NavigateUrl = urlDel; hypDel.ToolTip = "Delete"; cellDel.Controls.Add(hypDel); cellDel.CssClass = "text-center"; tRowBody.Cells.Add(cellDel); tblSpecialField.Rows.Add(tRowBody); } } } //end !Page.IsPostBack /*=============================*/ } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }