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.officer_department) || autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { // ======== Process =========== if (!Page.IsPostBack) { List <TQF.Levels> level = new TQF.Levels().getLevels(); foreach (TQF.Levels row in level) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } //02 = ปริญญาตรี ddlDegree.Items.FindByValue("02").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.curriculum)) { // ======== Process =========== if (!Page.IsPostBack) { txtCURR_CODE.Text = "999999999"; List <TQF.Levels> levels = new TQF.Levels().getLevels(); ddlDegree.Items.Clear(); ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem("--- เลือกระดับการศึกษา ---", "00")); ddlDegree1.Items.Clear(); ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem("--- เลือกระดับการศึกษา ---", "00")); foreach (TQF.Levels row in levels) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } List <FacultyData> faculty = new Faculty().getFaculty(); ddlCURR_FACULTY.Items.Clear(); //ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00")); foreach (FacultyData row in faculty) { //FacultyCode == "99" -> ใช้ร่วมทุกคณะ if (row.Faculty_Code == "99") { ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code)); } } ddlTQF1.Items.Clear(); ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem("--- เลือกมาตรฐานคุณวุฒิสาขา ---", "000")); } //============================= } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }
/// <summary> /// เรียกข้อมูลจากตาราง LEVELS /// </summary> /// <param name="sql">SQL command</param> /// <returns></returns> public List <Levels> getLevelsrManual(string sql) { List <Levels> LevelsData = new List <Levels>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { Levels LevelsRow = new Levels(); LevelsRow.LevelCode = rowData["LEVELCODE"].ToString(); LevelsRow.LevelName = rowData["LEVELNAME"].ToString(); LevelsData.Add(LevelsRow); } return(LevelsData); }
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.curriculum) || autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { // ======== Process =========== bool editable = false; code = Request.QueryString["token"]; TQF.Course course = new TQF.Course().getCourse(code); //หลักสูตร if (autro_obj.CheckGroupUser(login_data, group_var.curriculum)) { editable = true; } // วิชาการคณะ else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty); foreach (string fac in faculty_authorized) { if (fac == course.FacultyCode) { editable = true; break; } } } // วิชาการภาค else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department); foreach (string dep in department_authorized) { if (dep.Substring(0, 2) == course.FacultyCode) { editable = true; break; } } } if (editable == true) { if (!Page.IsPostBack) { rBtnOpen.Checked = true; List <TQF.Levels> levels = new TQF.Levels().getLevels(); foreach (TQF.Levels row in levels) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } ddlDegree.Items.FindByValue(course.LevelCode).Selected = true; List <CourseFlag> courseFlag = new CourseFlag().getCourseFlag(); foreach (CourseFlag row in courseFlag) { ddlCOURSE_Flag.Items.Insert(ddlCOURSE_Flag.Items.Count, new ListItem(row.CourseFlagName, row.CourseFlagCode)); } ddlCOURSE_Flag.Items.FindByValue(course.CourseFlagCode).Selected = true; List <TQF.CourseType> courseType = new TQF.CourseType().getCourseType(); foreach (TQF.CourseType row in courseType) { ddlCOURSE_TYPE.Items.Insert(ddlCOURSE_TYPE.Items.Count, new ListItem(row.CourseTypeThaiName, row.CourseTypeCode)); } ddlCOURSE_TYPE.Items.FindByValue(course.CourseTypeCode).Selected = true; List <SuFlage> suFlage = new SuFlage().getSuFlage(); foreach (SuFlage row in suFlage) { ddlSU_Flag.Items.Insert(ddlSU_Flag.Items.Count, new ListItem(row.SuFlageName, row.SuFlagCode)); } ddlSU_Flag.Items.FindByValue(course.SuFlage).Selected = true; List <ServiceStatus> serviceStatus = new ServiceStatus().getServiceStatus(); foreach (ServiceStatus row in serviceStatus) { ddl_SERVICESTATUS.Items.Insert(ddl_SERVICESTATUS.Items.Count, new ListItem(row.ServiceStatusName, row.ServiceStatusValue)); } ddl_SERVICESTATUS.Items.FindByValue(course.ServiceStatus).Selected = true; //หลักสูตร if (autro_obj.CheckGroupUser(login_data, group_var.curriculum)) { List <FacultyData> faculty = new Faculty().getFaculty(); foreach (FacultyData row in faculty) { ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code)); } } // วิชาการคณะ else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty); List <FacultyData> facultyData = new List <FacultyData>(); // คณะ facultyData = new Faculty().getFaculty(faculty_authorized); foreach (FacultyData data in facultyData) { ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(data.Faculty_Thai, data.Faculty_Code)); } } // วิชาการภาค else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { List <DepartmentData> departmentData = new List <DepartmentData>(); List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department); // คณะ departmentData = new Department().getDepartment(department_authorized); foreach (DepartmentData data in departmentData) { FacultyData faculty_data = new Faculty().getFaculty(data.Department_Code.Substring(0, 2)); ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(faculty_data.Faculty_Thai, faculty_data.Faculty_Code)); } } ddlCURR_FACULTY.Items.FindByValue(course.FacultyCode).Selected = true; txtCOURSE_CODE.Text = course.CourseCode; txtSHORT_COURSENAME.Text = course.CourseEnShortName; txtCOURSE_THAINAME.Text = course.CourseThName; txtCOURSE_ENGNAME.Text = course.CourseEnName; txtCOURSE_CREDIT.Text = course.Credit; txtTHEORY.Text = course.TheoryHour; txtPRACTICE.Text = course.PracticeHour; txtSELF_STUDY.Text = course.SelfStudyHour; txtCOURSE_DESC_TH.Text = course.CourseThDesc; txtCOURSE_DESC_EN.Text = course.CourseEnDesc; MIN_CREDITS.Text = course.MinCredits; txtdate.Text = course.DateApprove; if (course.CourseStatus == "Y") { rBtnOpen.Checked = true; } if (course.CourseStatus == "N") { rBtnClose.Checked = true; } COURSE_COMMENT.Text = course.Comments; } } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } //============================= } 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.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { // ======== Process =========== if (!Page.IsPostBack) { rBtnOpen.Checked = true; List <TQF.Levels> levels = new TQF.Levels().getLevels(); foreach (TQF.Levels row in levels) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } List <CourseFlag> courseFlag = new CourseFlag().getCourseFlag(); foreach (CourseFlag row in courseFlag) { ddlCOURSE_Flag.Items.Insert(ddlCOURSE_Flag.Items.Count, new ListItem(row.CourseFlagName, row.CourseFlagCode)); } List <TQF.CourseType> courseType = new TQF.CourseType().getCourseType(); foreach (TQF.CourseType row in courseType) { ddlCOURSE_TYPE.Items.Insert(ddlCOURSE_TYPE.Items.Count, new ListItem(row.CourseTypeThaiName, row.CourseTypeCode)); } List <SuFlage> suFlage = new SuFlage().getSuFlage(); foreach (SuFlage row in suFlage) { ddlSU_Flag.Items.Insert(ddlSU_Flag.Items.Count, new ListItem(row.SuFlageName, row.SuFlagCode)); } List <ServiceStatus> serviceStatus = new ServiceStatus().getServiceStatus(); foreach (ServiceStatus row in serviceStatus) { ddl_SERVICESTATUS.Items.Insert(ddl_SERVICESTATUS.Items.Count, new ListItem(row.ServiceStatusName, row.ServiceStatusValue)); } //หลักสูตร if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { List <FacultyData> faculty = new Faculty().getAllFaculty(); foreach (FacultyData row in faculty) { ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code)); if (row.Faculty_Code == "11") { ddlCURR_FACULTY.Items.FindByValue(row.Faculty_Code).Selected = true; } } } // วิชาการคณะ //else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) //{ // List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty); // List<FacultyData> facultyData = new List<FacultyData>(); // // คณะ // facultyData = new Faculty().getFaculty(faculty_authorized); // foreach (FacultyData data in facultyData) // { // ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(data.Faculty_Thai, data.Faculty_Code)); // } //} // วิชาการภาค else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { List <DepartmentData> departmentData = new List <DepartmentData>(); List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department); // คณะ departmentData = new Department().getDepartment(department_authorized); foreach (DepartmentData data in departmentData) { FacultyData faculty_data = new Faculty().getFaculty(data.Department_Code.Substring(0, 2)); ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(faculty_data.Faculty_Thai, faculty_data.Faculty_Code)); } } } //============================= } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { NumTQF1 = Request.QueryString["token"]; Session["NumTQF1"] = Request.QueryString["token"]; this.DataBind(); if (!Page.IsPostBack) { try { List <TQF.Levels> levelData = new TQF.Levels().getLevels(); ddlDegree.Items.Clear(); foreach (TQF.Levels row in levelData) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } TQF1 tqf1Data = new TQF1().getTQF1(NumTQF1); ddlDegree.Items.FindByValue(tqf1Data.LevelCode).Selected = true; txtMajor.Text = tqf1Data.TQF1Major; txtACADEMIC_YEAR.Text = tqf1Data.Year; } catch { Session["response"] = "ข้อมูลผิดพลาด ไม่สามารถใช้งานได้ในขณะนี้"; Response.Redirect("../err_response.aspx"); } } ////// tblType1 ////// // Head Table //string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" }; tblType1.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblType1.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead = new TableHeaderRow(); tRowHead.TableSection = TableRowSection.TableHeader; // Create a new cell and add it to the row. TableHeaderCell cellHead1 = new TableHeaderCell(); cellHead1.Text = "ข้อที่"; cellHead1.Attributes.Add("class", "text-center"); cellHead1.Width = 50; tRowHead.Cells.Add(cellHead1); TableHeaderCell cellHead2 = new TableHeaderCell(); cellHead2.Text = "รายละเอียด"; tRowHead.Cells.Add(cellHead2); TableHeaderCell cellHead3 = new TableHeaderCell(); cellHead3.Text = "แก้ไข"; cellHead3.Attributes.Add("class", "text-center"); cellHead3.Width = 50; tRowHead.Cells.Add(cellHead3); TableHeaderCell cellHead4 = new TableHeaderCell(); cellHead4.Text = "ลบ"; cellHead4.Attributes.Add("class", "text-center"); cellHead4.Width = 50; tRowHead.Cells.Add(cellHead4); tRowHead.Cells[0].Visible = false; //Hidden Cells[0] for UUID.. tblType1.Rows.Add(tRowHead); //End Head Table if (Session["addType1"] != null) { listTableRow1 = new List <TableRow>(); listTableRow1 = (List <TableRow>)Session["addType1"]; int i; foreach (TableRow item in listTableRow1) { tblType1.Rows.Add(item); i = tblType1.Rows.GetRowIndex(item); tblType1.Rows[i].Cells[0].Visible = false; } } else { //เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx //สร้าง session เอาไว้เก็บแถว List <TableRow> dummyRow = new List <TableRow>(); Session["addType1"] = (List <TableRow>)dummyRow; //1. ด้านคุณธรรม จริยธรรม string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='1'"; List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql); int i; int numOfrow = 0; foreach (TQF1Leaning data in tqf1LearningData) { TableRow row = new TableRow(); TableCell cellNumber = new TableCell(); cellNumber.Text = data.UUIDNumber; row.Cells.Add(cellNumber); numOfrow++; TableCell cellDetail = new TableCell(); //cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype; cellDetail.Text = data.Detailtype; row.Cells.Add(cellDetail); TableCell cellEdit = new TableCell(); string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT"); 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"; row.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT"); 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"; row.Cells.Add(cellDel); tblType1.Rows.Add(row); //เก็บแถวลง session dummyRow = (List <TableRow>)Session["addType1"]; dummyRow.Add(row); Session["addType1"] = (List <TableRow>)dummyRow; //ซ่อน คอลัมน์ที่ 0 i = tblType1.Rows.GetRowIndex(row); tblType1.Rows[i].Cells[0].Visible = false; } } ////// end tblType1 ////// ////// tblType2 ////// // Head Table //string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" }; tblType2.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblType2.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead2 = new TableHeaderRow(); tRowHead2.TableSection = TableRowSection.TableHeader; // Create a new cell and add it to the row. TableHeaderCell cellHead12 = new TableHeaderCell(); cellHead12.Text = "ข้อที่"; cellHead12.Attributes.Add("class", "text-center"); cellHead12.Width = 50; tRowHead2.Cells.Add(cellHead12); TableHeaderCell cellHead22 = new TableHeaderCell(); cellHead22.Text = "รายละเอียด"; tRowHead2.Cells.Add(cellHead22); TableHeaderCell cellHead32 = new TableHeaderCell(); cellHead32.Text = "แก้ไข"; cellHead32.Attributes.Add("class", "text-center"); cellHead32.Width = 50; tRowHead2.Cells.Add(cellHead32); TableHeaderCell cellHead42 = new TableHeaderCell(); cellHead42.Text = "ลบ"; cellHead42.Attributes.Add("class", "text-center"); cellHead42.Width = 50; tRowHead2.Cells.Add(cellHead42); tRowHead2.Cells[0].Visible = false; //Hidden Cells[0] for UUID.. tblType2.Rows.Add(tRowHead2); //End Head Table if (Session["addType2"] != null) { listTableRow2 = new List <TableRow>(); listTableRow2 = (List <TableRow>)Session["addType2"]; int i; foreach (TableRow item in listTableRow2) { tblType2.Rows.Add(item); i = tblType2.Rows.GetRowIndex(item); tblType2.Rows[i].Cells[0].Visible = false; } } else { //เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx //สร้าง session เอาไว้เก็บแถว List <TableRow> dummyRow = new List <TableRow>(); Session["addType2"] = (List <TableRow>)dummyRow; //2. ด้านความรู้ string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='2'"; List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql); int i; int numOfrow = 0; foreach (TQF1Leaning data in tqf1LearningData) { TableRow row = new TableRow(); TableCell cellNumber = new TableCell(); cellNumber.Text = data.UUIDNumber; row.Cells.Add(cellNumber); numOfrow++; TableCell cellDetail = new TableCell(); //cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype; cellDetail.Text = data.Detailtype; row.Cells.Add(cellDetail); TableCell cellEdit = new TableCell(); string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT"); 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"; row.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT"); 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"; row.Cells.Add(cellDel); tblType2.Rows.Add(row); //เก็บแถวลง session dummyRow = (List <TableRow>)Session["addType2"]; dummyRow.Add(row); Session["addType2"] = (List <TableRow>)dummyRow; //ซ่อน คอลัมน์ที่ 0 i = tblType2.Rows.GetRowIndex(row); tblType2.Rows[i].Cells[0].Visible = false; } } ////// end tblType2 ////// ////// tblType3 ////// // Head Table //string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" }; tblType3.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblType3.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead3 = new TableHeaderRow(); tRowHead3.TableSection = TableRowSection.TableHeader; // Create a new cell and add it to the row. TableHeaderCell cellHead13 = new TableHeaderCell(); cellHead13.Text = "ข้อที่"; cellHead13.Attributes.Add("class", "text-center"); cellHead13.Width = 50; tRowHead3.Cells.Add(cellHead13); TableHeaderCell cellHead23 = new TableHeaderCell(); cellHead23.Text = "รายละเอียด"; tRowHead3.Cells.Add(cellHead23); TableHeaderCell cellHead33 = new TableHeaderCell(); cellHead33.Text = "แก้ไข"; cellHead33.Attributes.Add("class", "text-center"); cellHead33.Width = 50; tRowHead3.Cells.Add(cellHead33); TableHeaderCell cellHead43 = new TableHeaderCell(); cellHead43.Text = "ลบ"; cellHead43.Attributes.Add("class", "text-center"); cellHead43.Width = 50; tRowHead3.Cells.Add(cellHead43); tRowHead3.Cells[0].Visible = false; //Hidden Cells[0] for UUID.. tblType3.Rows.Add(tRowHead3); //End Head Table if (Session["addType3"] != null) { listTableRow3 = new List <TableRow>(); listTableRow3 = (List <TableRow>)Session["addType3"]; int i; foreach (TableRow item in listTableRow3) { tblType3.Rows.Add(item); i = tblType3.Rows.GetRowIndex(item); tblType3.Rows[i].Cells[0].Visible = false; } } else { //เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx //สร้าง session เอาไว้เก็บแถว List <TableRow> dummyRow = new List <TableRow>(); Session["addType3"] = (List <TableRow>)dummyRow; //3. ด้านทักษะทางปัญญา string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='3'"; List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql); int i; int numOfrow = 0; foreach (TQF1Leaning data in tqf1LearningData) { TableRow row = new TableRow(); TableCell cellNumber = new TableCell(); cellNumber.Text = data.UUIDNumber; row.Cells.Add(cellNumber); numOfrow++; TableCell cellDetail = new TableCell(); //cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype; cellDetail.Text = data.Detailtype; row.Cells.Add(cellDetail); TableCell cellEdit = new TableCell(); string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT"); 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"; row.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT"); 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"; row.Cells.Add(cellDel); tblType3.Rows.Add(row); //เก็บแถวลง session dummyRow = (List <TableRow>)Session["addType3"]; dummyRow.Add(row); Session["addType3"] = (List <TableRow>)dummyRow; //ซ่อน คอลัมน์ที่ 0 i = tblType3.Rows.GetRowIndex(row); tblType3.Rows[i].Cells[0].Visible = false; } } ////// end tblType3 ////// ////// tblType4 ////// // Head Table //string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" }; tblType4.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblType4.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead4 = new TableHeaderRow(); tRowHead4.TableSection = TableRowSection.TableHeader; // Create a new cell and add it to the row. TableHeaderCell cellHead14 = new TableHeaderCell(); cellHead14.Text = "ข้อที่"; cellHead14.Attributes.Add("class", "text-center"); cellHead14.Width = 50; tRowHead4.Cells.Add(cellHead14); TableHeaderCell cellHead24 = new TableHeaderCell(); cellHead24.Text = "รายละเอียด"; tRowHead4.Cells.Add(cellHead24); TableHeaderCell cellHead34 = new TableHeaderCell(); cellHead34.Text = "แก้ไข"; cellHead34.Attributes.Add("class", "text-center"); cellHead34.Width = 50; tRowHead4.Cells.Add(cellHead34); TableHeaderCell cellHead44 = new TableHeaderCell(); cellHead44.Text = "ลบ"; cellHead44.Attributes.Add("class", "text-center"); cellHead44.Width = 50; tRowHead4.Cells.Add(cellHead44); tRowHead4.Cells[0].Visible = false; //Hidden Cells[0] for UUID.. tblType4.Rows.Add(tRowHead4); //End Head Table if (Session["addType4"] != null) { listTableRow4 = new List <TableRow>(); listTableRow4 = (List <TableRow>)Session["addType4"]; int i; foreach (TableRow item in listTableRow4) { tblType4.Rows.Add(item); i = tblType4.Rows.GetRowIndex(item); tblType4.Rows[i].Cells[0].Visible = false; } } else { //เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx //สร้าง session เอาไว้เก็บแถว List <TableRow> dummyRow = new List <TableRow>(); Session["addType4"] = (List <TableRow>)dummyRow; //4. ด้านทักษะความสัมพันธ์ระหว่างบุคคล และความรับผิดชอบ string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='4'"; List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql); int i; int numOfrow = 0; foreach (TQF1Leaning data in tqf1LearningData) { TableRow row = new TableRow(); TableCell cellNumber = new TableCell(); cellNumber.Text = data.UUIDNumber; row.Cells.Add(cellNumber); numOfrow++; TableCell cellDetail = new TableCell(); //cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype; cellDetail.Text = data.Detailtype; row.Cells.Add(cellDetail); TableCell cellEdit = new TableCell(); string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT"); 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"; row.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT"); 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"; row.Cells.Add(cellDel); tblType4.Rows.Add(row); //เก็บแถวลง session dummyRow = (List <TableRow>)Session["addType4"]; dummyRow.Add(row); Session["addType4"] = (List <TableRow>)dummyRow; //ซ่อน คอลัมน์ที่ 0 i = tblType4.Rows.GetRowIndex(row); tblType4.Rows[i].Cells[0].Visible = false; } } ////// end tblType4 ////// ////// tblType5 ////// // Head Table //string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" }; tblType5.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblType5.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead5 = new TableHeaderRow(); tRowHead5.TableSection = TableRowSection.TableHeader; // Create a new cell and add it to the row. TableHeaderCell cellHead15 = new TableHeaderCell(); cellHead15.Text = "ข้อที่"; cellHead15.Attributes.Add("class", "text-center"); cellHead15.Width = 50; tRowHead5.Cells.Add(cellHead15); TableHeaderCell cellHead25 = new TableHeaderCell(); cellHead25.Text = "รายละเอียด"; tRowHead5.Cells.Add(cellHead25); TableHeaderCell cellHead35 = new TableHeaderCell(); cellHead35.Text = "แก้ไข"; cellHead35.Attributes.Add("class", "text-center"); cellHead35.Width = 50; tRowHead5.Cells.Add(cellHead35); TableHeaderCell cellHead45 = new TableHeaderCell(); cellHead45.Text = "ลบ"; cellHead45.Attributes.Add("class", "text-center"); cellHead45.Width = 50; tRowHead5.Cells.Add(cellHead45); tRowHead5.Cells[0].Visible = false; //Hidden Cells[0] for UUID.. tblType5.Rows.Add(tRowHead5); //End Head Table if (Session["addType5"] != null) { listTableRow5 = new List <TableRow>(); listTableRow5 = (List <TableRow>)Session["addType5"]; int i; foreach (TableRow item in listTableRow5) { tblType5.Rows.Add(item); i = tblType5.Rows.GetRowIndex(item); tblType5.Rows[i].Cells[0].Visible = false; } } else { //เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx //สร้าง session เอาไว้เก็บแถว List <TableRow> dummyRow = new List <TableRow>(); Session["addType5"] = (List <TableRow>)dummyRow; //5. ด้านทักษะการวิเคราะห์เชิงตัวเลข การสื่อสาร และการใช้เทคโนโลยีสารสนเทศ string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='5'"; List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql); int i; int numOfrow = 0; foreach (TQF1Leaning data in tqf1LearningData) { TableRow row = new TableRow(); TableCell cellNumber = new TableCell(); cellNumber.Text = data.UUIDNumber; row.Cells.Add(cellNumber); numOfrow++; TableCell cellDetail = new TableCell(); //cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype; cellDetail.Text = data.Detailtype; row.Cells.Add(cellDetail); TableCell cellEdit = new TableCell(); string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT"); 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"; row.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT"); 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"; row.Cells.Add(cellDel); tblType5.Rows.Add(row); //เก็บแถวลง session dummyRow = (List <TableRow>)Session["addType5"]; dummyRow.Add(row); Session["addType5"] = (List <TableRow>)dummyRow; //ซ่อน คอลัมน์ที่ 0 i = tblType5.Rows.GetRowIndex(row); tblType5.Rows[i].Cells[0].Visible = false; } } ////// end tblType5 ////// ////// tblType6 ////// // Head Table //string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" }; tblType6.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblType6.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead6 = new TableHeaderRow(); tRowHead6.TableSection = TableRowSection.TableHeader; // Create a new cell and add it to the row. TableHeaderCell cellHead16 = new TableHeaderCell(); cellHead16.Text = "ข้อที่"; cellHead16.Attributes.Add("class", "text-center"); cellHead16.Width = 50; tRowHead6.Cells.Add(cellHead16); TableHeaderCell cellHead26 = new TableHeaderCell(); cellHead26.Text = "รายละเอียด"; tRowHead6.Cells.Add(cellHead26); TableHeaderCell cellHead36 = new TableHeaderCell(); cellHead36.Text = "แก้ไข"; cellHead36.Attributes.Add("class", "text-center"); cellHead36.Width = 50; tRowHead6.Cells.Add(cellHead36); TableHeaderCell cellHead46 = new TableHeaderCell(); cellHead46.Text = "ลบ"; cellHead46.Attributes.Add("class", "text-center"); cellHead46.Width = 50; tRowHead6.Cells.Add(cellHead46); tRowHead6.Cells[0].Visible = false; //Hidden Cells[0] for UUID.. tblType6.Rows.Add(tRowHead6); //End Head Table if (Session["addType6"] != null) { listTableRow6 = new List <TableRow>(); listTableRow6 = (List <TableRow>)Session["addType6"]; int i; foreach (TableRow item in listTableRow6) { tblType6.Rows.Add(item); i = tblType6.Rows.GetRowIndex(item); tblType6.Rows[i].Cells[0].Visible = false; } } else { //เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx //สร้าง session เอาไว้เก็บแถว List <TableRow> dummyRow = new List <TableRow>(); Session["addType6"] = (List <TableRow>)dummyRow; //6. ด้านทักษะพิสัย string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='6'"; List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql); int i; int numOfrow = 0; foreach (TQF1Leaning data in tqf1LearningData) { TableRow row = new TableRow(); TableCell cellNumber = new TableCell(); cellNumber.Text = data.UUIDNumber; row.Cells.Add(cellNumber); numOfrow++; TableCell cellDetail = new TableCell(); //cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype; cellDetail.Text = data.Detailtype; row.Cells.Add(cellDetail); TableCell cellEdit = new TableCell(); string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT"); 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"; row.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT"); 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"; row.Cells.Add(cellDel); tblType6.Rows.Add(row); //เก็บแถวลง session dummyRow = (List <TableRow>)Session["addType6"]; dummyRow.Add(row); Session["addType6"] = (List <TableRow>)dummyRow; //ซ่อน คอลัมน์ที่ 0 i = tblType6.Rows.GetRowIndex(row); tblType6.Rows[i].Cells[0].Visible = false; } } ////// end tblType6 ////// }
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.curriculum)) { // ======== Process =========== CurrCode = Request.QueryString["CurrCode"]; YearVersion = Request.QueryString["YearVersion"]; TQF.Curriculum curriculum = new TQF.Curriculum(); TQF.Curriculum curriculumData = curriculum.getCurriculum(CurrCode, YearVersion); if (!Page.IsPostBack) { if (curriculumData.CurrStatus == "1") { //สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง) rBtnNEW_CURR.Checked = true; } else if (curriculumData.CurrStatus == "2") { //สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง) rBtnMINOR_MODI_CURR.Checked = true; } else { //สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง) rBtnNEW_CURR.Checked = true; } txtCURR_CODE.Text = curriculumData.CurrCode; txtCURR_YEAR_VERSION.Text = curriculumData.YearVersion; ddlCURR_SEMESTER.Items.FindByValue(curriculumData.BeginSemester).Selected = true; txtCURR_YEAR.Text = curriculumData.BeginYear; List <TQF.Levels> levels = new TQF.Levels().getLevels(); ddlDegree.Items.Clear(); ddlDegree1.Items.Clear(); foreach (TQF.Levels row in levels) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } ddlDegree.Items.FindByValue(curriculumData.LevelCode).Selected = true; ddlDegree1.Items.FindByValue(curriculumData.LevelCode).Selected = true; txtCURR_THAINAME.Text = curriculumData.CurrThName; txtCURR_ENGNAME.Text = curriculumData.CurrEnName; List <FacultyData> faculty = new Faculty().getFaculty(); ddlCURR_FACULTY.Items.Clear(); //ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00")); foreach (FacultyData row in faculty) { //FacultyCode == "99" -> ใช้ร่วมทุกคณะ if (row.Faculty_Code == "99") { ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code)); } } ddlTQF1.Items.Clear(); List <TQF1> tqf1 = new TQF1().getTQF1(); ddlTQF1.Items.Clear(); foreach (TQF1 row in tqf1) { ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem(row.TQF1Major, row.NumTQF1)); } ddlTQF1.Items.FindByValue(curriculumData.NumTQF1).Selected = true; } //============================= } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { login_data = (UserLoginData)Session["login_data"]; if (!Page.IsPostBack) { //ล้าง session Session.Remove("NumTQF1"); Session.Remove("addType1"); Session.Remove("addType2"); Session.Remove("addType3"); Session.Remove("addType4"); Session.Remove("addType5"); Session.Remove("addType6"); List <TQF.Levels> levelData = new TQF.Levels().getLevels(); ddlDegree.Items.Clear(); foreach (TQF.Levels row in levelData) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } ddlDegree.Items.FindByValue("02").Selected = true; // Head Table string[] ar = { "ระดับ", "สาขาวิชา", "ปี พ.ศ. ประกาศราชกิจจาฯ", "Download", "แก้ไข", "ลบ" }; tblTQF1.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblTQF1.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); } tblTQF1.Rows.Add(tRowHead); // End Head Table List <TQF1> tqf1Data = new TQF1().getTQF1(); foreach (TQF1 data in tqf1Data) { TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; TQF.Levels level = new TQF.Levels(); TableCell cellLevel = new TableCell(); cellLevel.Text = level.getLevels(data.LevelCode).LevelName; tRowBody.Cells.Add(cellLevel); TableCell cellMajor = new TableCell(); cellMajor.Text = data.TQF1Major; tRowBody.Cells.Add(cellMajor); TableCell cellYear = new TableCell(); cellYear.Text = data.Year; tRowBody.Cells.Add(cellYear); TableCell cellDownload = new TableCell(); string urlDownload = "../TQF1_Upload/" + data.FileName; HyperLink hypDownload = new HyperLink(); hypDownload.Attributes.Add("target", "_blnk"); hypDownload.Text = "<h4><i class='fa fa-download'></i></h4>"; hypDownload.NavigateUrl = urlDownload; hypDownload.ToolTip = "Download"; cellDownload.Controls.Add(hypDownload); cellDownload.CssClass = "text-center"; tRowBody.Cells.Add(cellDownload); if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { TableCell cellEdit = new TableCell(); string urlEdit = "edit_TQF1.aspx?token=" + data.NumTQF1; HyperLink hypEdit = new HyperLink(); //hypEdit.Attributes.Add("data-target", "#editDegree_Admission"); //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 = "delete_TQF1.aspx?token=" + data.NumTQF1;; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteModal"); 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); } else { TableCell cellEdit = new TableCell(); string urlEdit = "#"; HyperLink hypEdit = new HyperLink(); //hypEdit.Attributes.Add("data-target", "#editDegree_Admission"); //hypEdit.Attributes.Add("data-toggle", "modal"); hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>"; hypEdit.NavigateUrl = urlEdit; hypEdit.ToolTip = "Lock"; cellEdit.Controls.Add(hypEdit); cellEdit.CssClass = "text-center"; tRowBody.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "#"; HyperLink hypDel = new HyperLink(); hypDel.Text = "<h4><i class='fa fa-lock'></i></h4>"; hypDel.NavigateUrl = urlDel; hypDel.ToolTip = "Lock"; cellDel.Controls.Add(hypDel); cellDel.CssClass = "text-center"; tRowBody.Cells.Add(cellDel); } tblTQF1.Rows.Add(tRowBody); } } }
protected void btnSEARCH_Click(object sender, EventArgs e) { // Head Table string[] ar = { "ระดับ", "สาขาวิชา", "ปี พ.ศ. ประกาศราชกิจจาฯ", "Download", "แก้ไข", "ลบ" }; tblTQF1.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblTQF1.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); } tblTQF1.Rows.Add(tRowHead); // End Head Table string sql = "Select * From TQF1 Where LEVELCODE='" + ddlDegree.SelectedValue + "'"; List <TQF1> tqf1Data = new TQF1().getTQF1Manual(sql); foreach (TQF1 data in tqf1Data) { TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; TQF.Levels level = new TQF.Levels(); TableCell cellLevel = new TableCell(); cellLevel.Text = level.getLevels(data.LevelCode).LevelName; tRowBody.Cells.Add(cellLevel); TableCell cellMajor = new TableCell(); cellMajor.Text = data.TQF1Major; tRowBody.Cells.Add(cellMajor); TableCell cellYear = new TableCell(); cellYear.Text = data.Year; tRowBody.Cells.Add(cellYear); //<a target="_blnk" title="Download" href="Files/engineer_m1.pdf"> // <h4><i class="fa fa-download"></i></h4> TableCell cellDownload = new TableCell(); string urlDownload = "../TQF1_Upload/" + data.FileName; HyperLink hypDownload = new HyperLink(); //hypEdit.Attributes.Add("data-target", "#editDegree_Admission"); hypDownload.Attributes.Add("target", "_blnk"); hypDownload.Text = "<h4><i class='fa fa-download'></i></h4>"; hypDownload.NavigateUrl = urlDownload; hypDownload.ToolTip = "Download"; cellDownload.Controls.Add(hypDownload); cellDownload.CssClass = "text-center"; tRowBody.Cells.Add(cellDownload); TableCell cellEdit = new TableCell(); string urlEdit = "edit_Degree_Admission.aspx?token="; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#editDegree_Admission"); 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 = "delete_Degree_Admission.aspx?token="; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteDegree_Admission"); 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); tblTQF1.Rows.Add(tRowBody); } }
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.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { // ======== Process =========== if (!Page.IsPostBack) { //หลักสูตร if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { List <FacultyData> faculty = new Faculty().getFaculty(); ddlCURR_FACULTY.Items.Clear(); ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00")); foreach (FacultyData row in faculty) { ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code)); } ddlCURR_DEPARTMENT.Items.Clear(); ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem("--- เลือกภาควิชา ---", "00")); } // วิชาการคณะ //else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) //{ // List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty); // List<FacultyData> facultyData = new List<FacultyData>(); // // คณะ // facultyData = new Faculty().getFaculty(faculty_authorized); // ddlCURR_FACULTY.Items.Clear(); // ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00")); // foreach (FacultyData data in facultyData) // { // ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(data.Faculty_Thai, data.Faculty_Code)); // } // ddlCURR_DEPARTMENT.Items.Clear(); // ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem("--- เลือกภาควิชา ---", "00")); //} // วิชาการภาค else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { ddlCURR_FACULTY.Enabled = false; ddlCURR_FACULTY.BackColor = System.Drawing.ColorTranslator.FromHtml("#CCCCCC"); ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00")); List <DepartmentData> departmentData = new List <DepartmentData>(); List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department); // ภาควิชา departmentData = new Department().getDepartment(department_authorized); ddlCURR_DEPARTMENT.Items.Clear(); ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem("--- เลือกภาควิชา ---", "00")); foreach (DepartmentData data in departmentData) { ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem(data.Department_Thai, data.Department_Code)); } // คณะ //FacultyData faculty_data = new Faculty().getFaculty(ddlCURR_DEPARTMENT.SelectedValue.Substring(0, 2)); //ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(faculty_data.Faculty_Thai, faculty_data.Faculty_Code)); } List <TQF.Levels> levels = new TQF.Levels().getLevels(); ddlDegree.Items.Clear(); ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem("--- เลือกระดับการศึกษา ---", "00")); ddlDegree1.Items.Clear(); ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem("--- เลือกระดับการศึกษา ---", "00")); foreach (TQF.Levels row in levels) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } ddlCURR_MAJOR.Items.Clear(); //ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem("--- เลือกสาขาวิชา ---", "00")); List <SysUser> sysUser = new SysUser().getSysUser(); ddlLECTURER.Items.Clear(); foreach (SysUser row in sysUser) { string sql = "Select * From ABOUTLECTURER Where LECTIDENTITY='" + row.IdCode + "'"; List <AboutLecturer> aboutLecturer = new AboutLecturer().getAboutLecturerManual(sql); //เช็คว่าอาจารย์ประจำหลักสูตรไปแล้วหรือยัง if (aboutLecturer.Count > 0) { continue; } else { ddlLECTURER.Items.Insert(ddlLECTURER.Items.Count, new ListItem(row.ThName + " " + row.ThSurName + " (" + row.ShortName + ")", row.IdCode)); } } ddlTQF1.Items.Clear(); ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem("--- เลือกมาตรฐานคุณวุฒิสาขา ---", "000")); } //============================= } 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.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { // ======== Process =========== bool editable = false; CurrCode = Request.QueryString["CurrCode"]; YearVersion = Request.QueryString["YearVersion"]; TQF.Curriculum curriculum = new TQF.Curriculum(); TQF.Curriculum curriculumData = curriculum.getCurriculum(CurrCode, YearVersion); //หลักสูตร if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { editable = true; } // วิชาการคณะ //else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) //{ // List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty); // foreach (string fac in faculty_authorized) // { // if (fac == curriculumData.FacultyCode) // { // editable = true; // break; // } // } //} // วิชาการภาค else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department); foreach (string dep in department_authorized) { if (dep == curriculumData.DepartmentCode) { editable = true; break; } } } if (!Page.IsPostBack) { if (editable == true) { if (curriculumData.CurrStatus == "1") { //สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง) rBtnNEW_CURR.Checked = true; } else if (curriculumData.CurrStatus == "2") { //สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง) rBtnMINOR_MODI_CURR.Checked = true; } else { //สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง) rBtnNEW_CURR.Checked = true; } txtCURR_CODE.Text = curriculumData.CurrCode; txtCURR_YEAR_VERSION.Text = curriculumData.YearVersion; try { ddlCURR_SEMESTER.Items.FindByValue(curriculumData.BeginSemester).Selected = true; } catch { } txtCURR_YEAR.Text = curriculumData.BeginYear; List <TQF.Levels> levels = new TQF.Levels().getLevels(); ddlDegree.Items.Clear(); ddlDegree1.Items.Clear(); foreach (TQF.Levels row in levels) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } try { ddlDegree.Items.FindByValue(curriculumData.LevelCode).Selected = true; ddlDegree1.Items.FindByValue(curriculumData.LevelCode).Selected = true; } catch { } txtCURR_THAINAME.Text = curriculumData.CurrThName; txtCURR_ENGNAME.Text = curriculumData.CurrEnName; //txtCURR_SHORT_THAINAME.Text = curriculumData.CurrShortThName; //txtCURR_SHORT_ENGNAME.Text = curriculumData.CurrShortEnName; txtDIP_THAINAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainThName; txtDIP_ENGNAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainEnName; txtDIP_SHORT_THAINAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainThShortName; txtDIP_SHORT_ENGNAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainEnShortName; List <FacultyData> faculty = new Faculty().getFaculty(); ddlCURR_FACULTY.Items.Clear(); foreach (FacultyData row in faculty) { ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code)); } try { ddlCURR_FACULTY.Items.FindByValue(curriculumData.FacultyCode).Selected = true; } catch { } List <DepartmentData> department = new Department().getDepartment(); ddlCURR_DEPARTMENT.Items.Clear(); foreach (DepartmentData row in department) { ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem(row.Department_Thai, row.Department_Code)); } try { ddlCURR_DEPARTMENT.Items.FindByValue(curriculumData.DepartmentCode).Selected = true; } catch { } string sqlDivision = "Select * From DIVISION Where DEPARTMENTCODE = " + curriculumData.DepartmentCode; List <TQF.Division> division = new TQF.Division().getDivisionManual(sqlDivision); ddlCURR_MAJOR.Items.Clear(); foreach (TQF.Division row in division) { ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem(row.DivisionThName + " ( " + row.DivisionEnShortName + " )", row.DivisionCode)); } string sqlDivisionExtension = "Select * From DIVISIONEXTENSION Where DIVISIONNO='" + curriculumData.DivisionCode + "'"; List <DivisionExtension> divisionExtension = new DivisionExtension().getDivisionExtensionManual(sqlDivisionExtension); foreach (DivisionExtension row in divisionExtension) { try { ddlCURR_MAJOR.Items.FindByValue(row.DivisionCode).Selected = true; } catch { } } txtSTUDY_YEAR.Text = curriculumData.NumYear; txtTOTAL_STUDY_YEAR.Text = curriculumData.MaxNumYear; List <SysUser> sysUser = new SysUser().getSysUser(); ddlLECTURER.Items.Clear(); foreach (SysUser row in sysUser) { string sql = "Select * From ABOUTLECTURER Where LECTIDENTITY='" + row.IdCode + "'"; List <AboutLecturer> aboutLecturer = new AboutLecturer().getAboutLecturerManual(sql); //เช็คว่าอาจารย์ประจำหลักสูตรไปแล้วหรือยัง if (aboutLecturer.Count > 0) { string sql2 = "Select * From ABOUTLECTURER Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And LECTIDENTITY='" + row.IdCode + "' And LOADTYPECODE='1'"; List <AboutLecturer> aboutLecturer2 = new AboutLecturer().getAboutLecturerManual(sql2); foreach (AboutLecturer li in aboutLecturer2) { if (li.LectIdentity == row.IdCode) { ddlLECTURER.Items.Insert(ddlLECTURER.Items.Count, new ListItem(row.ThName + " " + row.ThSurName + " (" + row.ShortName + ")", row.IdCode)); ddlLECTURER.Items.FindByValue(row.IdCode).Selected = true; } } continue; } else { ddlLECTURER.Items.Insert(ddlLECTURER.Items.Count, new ListItem(row.ThName + " " + row.ThSurName + " (" + row.ShortName + ")", row.IdCode)); } } try { ddlMAJORSTATUS.Items.FindByValue(curriculumData.MajorStatus).Selected = true; } catch { } List <TQF1> tqf1 = new TQF1().getTQF1(); ddlTQF1.Items.Clear(); foreach (TQF1 row in tqf1) { ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem(row.TQF1Major, row.NumTQF1)); if (curriculumData.NumTQF1 == row.NumTQF1) { ddlTQF1.Items.FindByValue(curriculumData.NumTQF1).Selected = true; } } //ddlTQF1.Items.FindByValue(curriculumData.NumTQF1).Selected = true; txtDateApprove.Text = curriculumData.ApprovedDate; } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } //========================= } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }