/// <summary> /// เรียกดูข้อมูลจากตาราง TQF1 /// </summary> /// <returns>ข้อมูลจากตาราง TQF1</returns> public List <TQF1> getTQF1() { List <TQF1> TQF1Data = new List <TQF1>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From TQF1 Order By YEAR"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { TQF1 TQF1Row = new TQF1(); TQF1Row.NumTQF1 = rowData["NUMTQF1"].ToString(); TQF1Row.Year = rowData["YEAR"].ToString(); TQF1Row.LevelCode = rowData["LEVELCODE"].ToString(); TQF1Row.TQF1Major = rowData["MAJORNAME"].ToString(); TQF1Row.FileName = rowData["FILENAME"].ToString(); TQF1Data.Add(TQF1Row); } return(TQF1Data); }
protected void btnOK_Click(object sender, EventArgs e) { try { //ลบข้อมูล Learning Outcome ออกจากตาราง TQF1LEANING string sql = "Delete From TQF1LEANING Where NUMTQF1 ='" + NumTQF1 + "'"; string deleteTQF1LEANING = new TQF1Leaning().deleteTQF1LeaningManual(sql); //เช็คค่่าก่อนลบข้อมูลจากตาราง string sql2 = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "'"; List <TQF1Leaning> getNum = new TQF1Leaning().getTQF1LeaningManual(sql2); if (deleteTQF1LEANING == "Success" || getNum.Count == 0) { //ลบไฟล์ มคอ.1 ออกจาก server string FileName = new TQF1().getTQF1(NumTQF1).FileName; string FolderPath = ConfigurationManager.AppSettings["TQF1UploadFolder"]; string FilePath = Server.MapPath(FolderPath + FileName); string fileName = FilePath; if (fileName != null || fileName != string.Empty) { if ((System.IO.File.Exists(FolderPath + fileName))) { System.IO.File.Delete(FolderPath + fileName); } } //ลบข้อมูล ออกจากตาราง TQF1 string result = new TQF1().deleteTQF1(NumTQF1); if (result == "Success") { Response.Redirect("list_TQF1.aspx?path=" + fileName); } else { Response.Redirect("list_TQF1.aspx?path=" + fileName); } } else { Response.Redirect("list_TQF1.aspx"); } } catch { Response.Redirect("list_TQF1.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { //lblDegree.Text = new TQF1().getTqf1Id(); if (file_Attachment.HasFile) { FileName = Path.GetFileName(file_Attachment.PostedFile.FileName); Extension = Path.GetExtension(file_Attachment.PostedFile.FileName); FolderPath = ConfigurationManager.AppSettings["TQF1UploadFolder"]; //หากต้องการเปลี่ยนชื่อไฟล์ที่ใช้ upload //string newName = new TQF1().getTqf1Id(); //FileName = newName + Extension; string FilePath = Server.MapPath(FolderPath + FileName); if (Extension == ".pdf") { file_Attachment.SaveAs(FilePath); } else { Session["response"] = "add_TQF1: ไฟล์ upload ต้องเป็นไฟล์นามสกุล .pdf เท่านั้น"; Response.Redirect("../err_response.aspx"); } } TQF1 tqf1Data = new TQF1(); string id = new TQF.TQFUtility().getMaxID("NUMTQF1", "TQF1"); tqf1Data.NumTQF1 = id; tqf1Data.Year = txtACADEMIC_YEAR.Text; tqf1Data.LevelCode = ddlDegree.SelectedValue; tqf1Data.TQF1Major = txtMajor.Text; tqf1Data.FileName = FileName; string resulte = new TQF1().insertTQF1(tqf1Data); if (resulte == "Success") { Response.Redirect("edit_TQF1.aspx?token=" + id); } else { Session["response"] = "add_TQF1: ไม่สามารถดำเนินการได้ในขณะนี้ (1)"; Response.Redirect("../err_response.aspx"); } }
/// <summary> /// เพิ่มข้อมูลลงตาราง TQF1 /// </summary> /// <param name="dataInsert"></param> /// <returns></returns> public string insertTQF1(TQF1 dataInsert) { string response = ""; int sleepTime = 5000; string NumTQF1 = dataInsert.NumTQF1; for (int i = 0; i < 10; i++) { if (getTQF1(NumTQF1).NumTQF1 != null) { Thread.Sleep(sleepTime); NumTQF1 = new TQF.TQFUtility().getMaxID("NUMTQF1", "TQF1"); sleepTime += 5000; } else { dataInsert.NumTQF1 = NumTQF1; break; } } ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into TQF1 (NUMTQF1, YEAR, LEVELCODE, MAJORNAME, FILENAME) values ('" + dataInsert.NumTQF1 + "','" + dataInsert.Year + "','" + dataInsert.LevelCode + "','" + dataInsert.TQF1Major + "','" + dataInsert.FileName + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertTQF1: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
//protected void btnNEXT_Click(object sender, EventArgs e) //{ // Response.RedirectPermanent("./addCURR_GEN_EDU2.aspx"); //} protected void ddlDegree1_SelectedIndexChanged(object sender, EventArgs e) { string sql = "Select * From TQF1 Where LEVELCODE='" + ddlDegree1.SelectedValue + "'"; List <TQF1> tqf1 = new TQF1().getTQF1Manual(sql); ddlTQF1.Items.Clear(); if (tqf1.Count == 0) { ddlTQF1.Items.Clear(); ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem("ไม่มีมาตรฐานคุณวุฒิสาขา", "000")); } else { foreach (TQF1 row in tqf1) { ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem(row.TQF1Major, row.NumTQF1)); } } }
/// <summary> /// เรียกดูข้อมูลจากตาราง TQF1 /// </summary> /// <param name="NumTQF1">รหัสมคอ.1</param> /// <returns>ข้อมูลจากตาราง TQF1</returns> public TQF1 getTQF1(string NumTQF1) { TQF1 TQF1Data = new TQF1(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From TQF1 Where NUMTQF1='" + NumTQF1 + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { TQF1Data.NumTQF1 = rowData["NUMTQF1"].ToString(); TQF1Data.Year = rowData["YEAR"].ToString(); TQF1Data.LevelCode = rowData["LEVELCODE"].ToString(); TQF1Data.TQF1Major = rowData["MAJORNAME"].ToString(); TQF1Data.FileName = rowData["FILENAME"].ToString(); } return(TQF1Data); }
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 =========== 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"); } } }