protected void btDGSubmit_Click(object sender, EventArgs e) { #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var strSQL = new StringBuilder(); var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs); #endregion #region Procedure #region SQL Builder for (int i = 0; i < dlDefault.Items.Count; i++) { Label lblDGID = (Label)dlDefault.Items[i].FindControl("lblDGID"); CheckBox cbDGActive = (CheckBox)dlDefault.Items[i].FindControl("cbDGActive"); TextBox txtDGSort = (TextBox)dlDefault.Items[i].FindControl("txtDGSort"); if (lblDGID != null && cbDGActive != null) { #region SQL Query strSQL.Append("UPDATE "); strSQL.Append(tableDefault + " "); strSQL.Append("SET "); strSQL.Append("Sort=" + clsSQL.CodeFilter(txtDGSort.Text) + ","); strSQL.Append("StatusFlag='" + (cbDGActive.Checked ? "A" : "I") + "' "); strSQL.Append("WHERE "); strSQL.Append("UID=" + lblDGID.Text); strSQL.Append(";"); #endregion } } #endregion if (clsSQL.Execute(strSQL.ToString())) { ucColorBox1.Redirect("/Management/" + webDefault + clsDefault.QueryStringMerge(), "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย"); } else { ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะบันทึกข้อมูลลงฐานข้อมูล<br/>" + strSQL.ToString(), AlertImage: ucColorBox.Alerts.Fail); } #endregion }
protected void btDGSubmit_Click(object sender, EventArgs e) { #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var strSQL = new StringBuilder(); var outError = ""; var statusFlag = ""; #endregion #region SQL Builder for (int i = 0; i < dlDefault.Items.Count; i++) { Label lblDGID = (Label)dlDefault.Items[i].FindControl("lblDGID"); Label lblDGName = (Label)dlDefault.Items[i].FindControl("lblDGName"); CheckBox cbDGActive = (CheckBox)dlDefault.Items[i].FindControl("cbDGActive"); if (lblDGID != null && lblDGName != null && cbDGActive != null) { statusFlag = clsSQL.Return("SELECT StatusFlag FROM Highlight WHERE GlobalUID=" + lblDGID.Text + " AND GlobalName='" + lblDGName.Text + "';", dbType, cs); if (statusFlag != "" && statusFlag != (cbDGActive.Checked?"A":"D")) { #region UPDATE SQL Query strSQL.Append("UPDATE "); strSQL.Append("Highlight "); strSQL.Append("SET "); strSQL.Append("MWhen=GETDATE(),"); strSQL.Append("MUser="******","); strSQL.Append("StatusFlag='" + (cbDGActive.Checked?"A":"D") + "' "); strSQL.Append("WHERE "); strSQL.Append("GlobalUID=" + lblDGID.Text + " "); strSQL.Append("AND GlobalName='" + lblDGName.Text + "'"); strSQL.Append(";"); #endregion } else if (statusFlag == "") { if (cbDGActive.Checked) { #region INSERT SQL Query strSQL.Append("INSERT INTO "); strSQL.Append("Highlight "); strSQL.Append("(GlobalUID,GlobalName,CWhen,CUser,MWhen,MUser,Sort,StatusFlag)"); strSQL.Append("VALUES("); strSQL.Append(lblDGID.Text + ","); strSQL.Append("'" + lblDGName.Text + "',"); strSQL.Append("GETDATE(),"); strSQL.Append(clsSecurity.LoginUID + ","); strSQL.Append("GETDATE(),"); strSQL.Append(clsSecurity.LoginUID + ","); strSQL.Append("0,"); strSQL.Append("'A'"); strSQL.Append(")"); strSQL.Append(";"); #endregion } } if (strSQL.Length > 0) { if (!clsSQL.Execute(strSQL.ToString(), dbType, cs, out outError)) { ucColorBox1.Alert("SQL Error", outError, AlertImage: ucColorBox.Alerts.Fail); return; } strSQL.Length = 0; strSQL.Capacity = 0; } } } #endregion ucColorBox1.Redirect("/Management/Highlight.aspx" + clsDefault.QueryStringMerge(), "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย"); }