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(), "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย");
}
