protected void ClearResult_Click(object sender, EventArgs e)
{
try
{
Lib.Center.Account_c acc = (Lib.Center.Account_c)Session["Account"];
Lib.DataUtility du = new Lib.DataUtility();
du.executeNonQueryBysp("Race_ClearData");
Lib.SysSetting.AddLog("清除競賽成績", acc.Account, "競賽成績已被清除", DateTime.Now);
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('已清除競賽成績')", true);
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('" + ex.Message + "')", true);
}
}
protected void submit_Click(object sender, EventArgs e)
{
Lib.Center.Account_c acc = new Lib.Center.Account_c(txtName.Text.Trim(), txtPwd.Text.Trim());
if (acc.LoginStatus == Lib.Center.LoginStatus.Logout)
{
Lib.SysSetting.AddLog("登入", txtName.Text, "進階使用者登入密碼驗證失敗,登入IP : " + Request.UserHostAddress.ToString(), DateTime.Now);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('登入失敗')", true);
}
if (acc.LoginStatus == Lib.Center.LoginStatus.Login)
{
Session["account"] = acc;
Lib.SysSetting.AddLog("登入", acc.Account, "進階使用者登入成功,登入IP : " + Request.UserHostAddress.ToString(), DateTime.Now);
Response.Redirect("~/Index.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if ((CheckBoxList1.Items[0].Selected == true && CheckBoxList1.Items[1].Selected == true) ||
(CheckBoxList1.Items[0].Selected == false && CheckBoxList1.Items[1].Selected == false))
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('請單選一類模式')", true);
}
else
{
if (string.IsNullOrEmpty(txtRemoteIP.Text))
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('請輸入遠端主機位址，若為本機模式請輸入127.0.0.1')", true);
}
else
{
//進行更新資料庫資料
string mode_value = string.Empty;
if (CheckBoxList1.Items[0].Selected)
{
mode_value = CheckBoxList1.Items[0].Value;
}
else
{
mode_value = CheckBoxList1.Items[1].Value;
}
if (Session["Account"] != null)
{
Lib.Center.Account_c acc = (Lib.Center.Account_c)Session["Account"];
Lib.DataUtility du = new Lib.DataUtility();
du.executeNonQueryByText("update sysvalue set value = '" + mode_value + "' where item = 'exchange'");
du.executeNonQueryByText("update sysvalue set value = '" + txtRemoteIP.Text.Trim() + "' where item = 'remote_ip'");
Lib.SysSetting.AddLog("更新競賽系統設定值", acc.Account, "競賽系統設定值已被更改", DateTime.Now);
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('更新成功')", true);
ShowSystemMode();
//Response.Redirect("~/index.aspx");
}
else
{
Response.Redirect("~/Login.aspx");
}
}
}
}
protected void btnSwitch_Click(object sender, EventArgs e)
{
Lib.DataUtility du = new Lib.DataUtility();
try
{
if (Session["Account"] != null)
{
Lib.Center.Account_c acc = (Lib.Center.Account_c)Session["Account"];
du.executeNonQueryBysp("SwitchSystem");
Lib.SysSetting.AddLog("更新系統模式", acc.Account, LB_mode.Text + "已被切換", DateTime.Now);
}
else
{
Response.Redirect("~/Login.aspx");
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('" + ex.Message + "')", true);
}
ShowSystemMode();
}
//新增帳號
protected void btn_AddAccount_Click(object sender, EventArgs e)
{
//檢查必填欄位有無空白
if (!string.IsNullOrEmpty(txtAcc.Text) && !string.IsNullOrEmpty(txtID.Text) && !string.IsNullOrEmpty(txtPwd.Text) &&
!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrEmpty(txtRank.Text))
{
//檢查帳號有無重複
Lib.DataUtility du = new Lib.DataUtility();
DataTable AccDt = du.getDataTableByText("select account from Account_c where account='" + txtAcc.Text + "'");
if (AccDt.Rows.Count == 0)
{
//檢查id是否有註冊過帳號
DataTable IdDt = du.getDataTableByText("select id from Account_c where id='" + txtID.Text + "' and role_code='" + roleType.SelectedValue + "'");
if (IdDt.Rows.Count == 0)
{
Lib.Center.Account_c a = (Lib.Center.Account_c)Session["account"];
Dictionary <string, object> d = new Dictionary <string, object>();
d.Add("account", txtAcc.Text.Trim());
d.Add("password", txtPwd.Text.Trim());
d.Add("rold_code", roleType.SelectedValue); // 3 = 鑑測站主任代碼, 4 = 鑑測官代碼
d.Add("name", txtName.Text.Trim());
d.Add("id", txtID.Text.Trim());
d.Add("rank_code", txtRank.Text.Trim());
d.Add("tel", txtTel.Text.Trim());
d.Add("cellphone", txtCell.Text.Trim());
d.Add("mail", txtMail.Text.Trim());
d.Add("ip", txtIP.Text.Trim());
d.Add("pwdChange", "0");
d.Add("status", "1");
d.Add("byAcc", ((Lib.Center.Account_c)Session["account"]).Account);
du.executeNonQueryByText("insert into account_c (account,password,role_code,name,id,rank_code,tel,cellphone,mail,ip,pwdChange,status,byAcc) values (@account,@password,@rold_code,@name,@id,@rank_code,@tel,@cellphone,@mail,@ip,@pwdChange,@status,@byAcc)", d);
Lib.SysSetting.AddLog("帳號管理", a.Account, "新增帳號:" + txtAcc.Text.Trim(), System.DateTime.Now);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('新增成功');", true);
txtAcc.Text = "";
txtPwd.Text = "";
txtName.Text = "";
txtID.Text = "";
txtRank.Text = "";
txtTel.Text = "";
txtCell.Text = "";
txtMail.Text = "";
txtIP.Text = "";
txb_checkId.Text = "";
tabconatiner.ActiveTabIndex = 0;
DropDownList1.DataBind();
this.div_inq.Style.Value = "";
this.div_data.Style.Value = "display:none";
}
else
{
if (roleType.SelectedValue == "3")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('此身份證字號已註冊過「鑑測主任」之帳號，無法再新增!!');", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('此身份證字號已註冊過「鑑測官」之帳號，無法再新增!!');", true);
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('帳號重複，無法使用!!');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('帳號、姓名、身份證字號、密碼、級職代碼欄位不可空白!!');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
}
if (Page.IsPostBack)
{
var v = submitType.Value;
Lib.Center.Account_c a = (Lib.Center.Account_c)Session["account"];
Dictionary <string, object> d = new Dictionary <string, object>();
Lib.DataUtility du = new Lib.DataUtility();
try
{
switch (v)
{
case "add":
#region 新增帳號管理員
d.Clear();
d.Add("acc", txtAcc.Text.Trim());
DataTable dt = du.getDataTableBysp("CheckAccExist", d);
if (dt.Rows.Count == 0)
{
d.Add("account", txtAcc.Text.Trim());
d.Add("password", txtPwd.Text.Trim());
d.Add("rold_code", roleType.SelectedValue); // 3 = 鑑測站主任代碼, 4 = 鑑測官代碼
d.Add("name", txtName.Text.Trim());
d.Add("id", txtID.Text.Trim());
// d.Add("unit_code", txtUnit.Text.Trim());
d.Add("rank_code", txtRank.Text.Trim());
d.Add("tel", txtTel.Text.Trim());
d.Add("cellphone", txtCell.Text.Trim());
d.Add("mail", txtMail.Text.Trim());
d.Add("ip", txtIP.Text.Trim());
d.Add("pwdChange", "0");
d.Add("status", "1");
d.Add("byAcc", ((Lib.Center.Account_c)Session["account"]).Account);
du.executeNonQueryByText("insert into account_c (account,password,role_code,name,id,rank_code,tel,cellphone,mail,ip,pwdChange,status,byAcc) values (@account,@password,@rold_code,@name,@id,@rank_code,@tel,@cellphone,@mail,@ip,@pwdChange,@status,@byAcc)", d);
Lib.SysSetting.AddLog("帳號管理", a.Account, "新增帳號:" + txtAcc.Text.Trim(), System.DateTime.Now);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('新增成功');", true);
txtAcc.Text = "";
txtPwd.Text = "";
txtName.Text = "";
txtID.Text = "";
//txtUnit.Text = "";
txtRank.Text = "";
txtTel.Text = "";
txtCell.Text = "";
txtMail.Text = "";
txtIP.Text = "";
tabconatiner.ActiveTabIndex = 0;
DropDownList1.DataBind();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('帳號已存在請使用其他帳號');", true);
txtAcc.Text = "";
txtPwd.Text = "";
txtName.Text = "";
txtID.Text = "";
//txtUnit.Text = "";
txtRank.Text = "";
txtTel.Text = "";
txtCell.Text = "";
txtMail.Text = "";
txtIP.Text = "";
tabconatiner.ActiveTabIndex = 0;
}
#endregion
break;
case "update":
#region 更新帳號管理員
d.Add("password", _txtPwd.Text.Trim());
d.Add("name", _txtName.Text.Trim());
d.Add("id", _txtID.Text.Trim());
// d.Add("unit_code", _txtUnit.Text.Trim());
d.Add("rank_code", _txtRank.Text.Trim());
d.Add("tel", _txtTel.Text.Trim());
d.Add("cellphone", _txtCell.Text.Trim());
d.Add("mail", _txtMail.Text.Trim());
d.Add("ip", _txtIP.Text.Trim());
d.Add("account", DropDownList1.SelectedValue);
du.executeNonQueryByText("update account_c set password = @password, name = @name, id = @id, rank_code = @rank_code, tel = @tel, cellphone = @cellphone, mail = @mail, ip = @ip where account = @account", d);
Lib.SysSetting.AddLog("帳號管理", a.Account, "更新帳號:" + DropDownList1.SelectedValue, System.DateTime.Now);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('更新成功');", true);
#endregion
break;
case "delete":
#region
d.Add("account", DropDownList1.SelectedValue);
du.executeNonQueryBysp("DelAccount", d);
Lib.SysSetting.AddLog("帳號管理", a.Account, "刪除帳號:" + DropDownList1.SelectedValue, System.DateTime.Now);
_txtName.Text = "";
_txtID.Text = "";
_txtPwd.Text = "";
_txtRank.Text = "";
_txtTel.Text = "";
_txtMail.Text = "";
_txtCell.Text = "";
_txtIP.Text = "";
_txtFun.Text = "";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('成功刪除');", true);
DropDownList1.Items.Remove(DropDownList1.SelectedItem);
DropDownList1_OnDataBound(DropDownList1, e);
#endregion
break;
default:
break;
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert(\"" + ex.Message + "\");", true);
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
}
d.Clear();
submitType.Value = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if ((Lib.Center.Account_c)Session["account"] != null)
{
Lib.Center.Account_c acc = (Lib.Center.Account_c)Session["account"];
txtName.Text = acc.Name;
txtID.Text = acc.ID;
txtPwd.Text = acc.Password;
pwd_HF.Value = acc.Password;
txtRank.Text = acc.Rank_Code;
txtTel.Text = acc.Tel;
txtCell.Text = acc.Cell;
txtMail.Text = acc.Mail;
txtIP.Text = acc.IP;
}
}
else
{
if ((Lib.Center.Account_c)Session["account"] != null)
{
Lib.Center.Account_c acc = (Lib.Center.Account_c)Session["account"];
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
try
{
if (submitType.Value == "profile")
{
d.Add("id", txtID.Text.Trim());
d.Add("name", txtName.Text.Trim());
d.Add("pwd", txtPwd.Text.Trim());
d.Add("rank", txtRank.Text.Trim());
d.Add("tel", txtTel.Text.Trim());
d.Add("cell", txtCell.Text.Trim());
d.Add("mail", txtMail.Text.Trim());
d.Add("ip", txtIP.Text.Trim());
d.Add("acc", acc.Account);
du.executeNonQueryByText("update account_c set id = @id, name = @name, password = @pwd, rank_code = @rank, tel = @tel, cellphone = @cell, mail = @mail, ip = @ip where account = @acc", d);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('更新成功');", true);
TabContainer1.ActiveTabIndex = 0;
Lib.Center.Account_c newacc = new Lib.Center.Account_c(acc.Account, txtPwd.Text.Trim());
Session["account"] = newacc;
}
if (submitType.Value == "pwdchange")
{
var newPwd = pwd_HF.Value;
d.Add("password", newPwd);
d.Add("account", acc.Account);
du.executeNonQueryByText("update account_c set password = @password where account = @account", d);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('更新成功');", true);
acc.Password = newPwd;
Session["account"] = acc;
TabContainer1.ActiveTabIndex = 1;
}
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('" + ex.Message + "');", true);
}
finally
{
d.Clear();
submitType.Value = "";
}
}
}
}