protected void Btn_Save_Click(object sender, EventArgs e) { try { //取得登入user資料 databind(); #region 取得畫面元件的值 //新密碼 = 登入者帳號 DateTime processtime = DateTime.Now; //密碼解密 SYSModel.CryptographyHelper Cry = new SYSModel.CryptographyHelper(); string UserPwd = Cry.Decrypt(dt_Result.Rows[0]["PASSWORD"].ToString()); #endregion if (TextBoxOldPassword.Text != UserPwd) { ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('舊密碼不正確');", true); } else if (TextBoxNewPassword.Text != TextBoxConfirmNewPassword.Text) { ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('新密碼與確認新密碼不一致');", true); } else if (TextBoxNewPassword.Text.Length < 8) { ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('新密碼不可小於8碼');", true); } else { //密碼加密 string CryPassword = Cry.Encrypt(TextBoxNewPassword.Text); #region 加入更新條件 ParameterList.Clear(); //舊值 ParameterList.Add(dt_Result.Rows[0]["ID"]); ParameterList.Add(dt_Result.Rows[0]["CODE"]); ParameterList.Add(dt_Result.Rows[0]["NAME"]); ParameterList.Add(dt_Result.Rows[0]["CREATEDATE"]); ParameterList.Add(dt_Result.Rows[0]["CREATEUID"]); ParameterList.Add(dt_Result.Rows[0]["UPDATEDATE"]); ParameterList.Add(dt_Result.Rows[0]["UPDATEUID"]); ParameterList.Add(dt_Result.Rows[0]["ENABLE"]); ParameterList.Add(dt_Result.Rows[0]["PASSWORD"]); ParameterList.Add(dt_Result.Rows[0]["MEMO"]); //需要更新值 ParameterList.Add(dt_Result.Rows[0]["NAME"]); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(CryPassword); ParameterList.Add(dt_Result.Rows[0]["MEMO"]); #endregion SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); int UpdateRecord = BCO.UpdateUser(ParameterList, null); if (UpdateRecord == 0) { throw new Exception("更新0筆資料!"); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('更改完成');", true); } } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// 查詢資料庫取得資料 /// </summary> private void databind() { //抓取本頁初次登記的時間 string SessionIDName = "SYS041_" + PageTimeStamp.Value; SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConntionDB); ParameterList.Clear(); ParameterList.Add(TextBoxCode.Text.Trim()); ParameterList.Add(TextBoxName.Text.Trim()); ParameterList.Add(TextBoxCreateDate.StartDate.Trim()); ParameterList.Add(TextBoxCreateDate.EndDate.Trim()); ParameterList.Add(TextBoxCreateUID.Text.Trim()); ParameterList.Add(TextBoxUpdateDate.StartDate.Trim()); ParameterList.Add(TextBoxUpdateDate.EndDate.Trim()); ParameterList.Add(TextBoxUpdateUID.Text.Trim()); ParameterList.Add(TextBoxMemo.Text.Trim()); ParameterList.Add(TextBoxRowCountLimit.Text.Trim()); DataTable Dt = BCO.QueryRow(ParameterList, CheckBoxLikeSearch.Checked); Session[SessionIDName] = Dt; GridView1.DataSource = Dt; //設定分頁大小 if (TextBoxPagesize.Text == "0") { GridView1.PageSize = 1; } else { GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); } GridView1.PageIndex = 0; GridView1.DataBind(); #region 將Key值存到Session中 ArrayList arl_Key = new ArrayList(); foreach (DataRow drRow in Dt.Rows) { arl_Key.Add("id=" + drRow["ID"].ToString()); } Session["SYS04_SortKey" + this.PageTimeStamp.Value] = arl_Key; #endregion if (Dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; } }
protected void btnExport_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; DataTable Dt; #region 檢查是否已匯入檔案 if (Session["SYS203_" + PageTimeStamp.Value] != null) { Dt = (DataTable)Session["SYS203_" + PageTimeStamp.Value]; } else { throw new Exception("請先匯入檔案"); } #endregion string strPassword = string.Empty; string strCryPassword = string.Empty; SYSModel.CryptographyHelper Cry = new SYSModel.CryptographyHelper(); SYSModel.MaintainUser BCO2 = new SYSModel.MaintainUser(ConnectionDB); for (int i = 0; i < Dt.Rows.Count; i++) { strPassword = Dt.Rows[i][0].ToString(); strCryPassword = Cry.Encrypt(strPassword); ParameterList.Clear(); ParameterList.Add(strPassword); dt_Result = BCO2.QuerySwitch(SYSModel.MaintainUser.QueryType.CODE, ParameterList ); ParameterList.Clear(); //舊值 ParameterList.Add(dt_Result.Rows[0]["ID"]); ParameterList.Add(dt_Result.Rows[0]["CODE"]); ParameterList.Add(dt_Result.Rows[0]["NAME"]); ParameterList.Add(dt_Result.Rows[0]["CREATEDATE"]); ParameterList.Add(dt_Result.Rows[0]["CREATEUID"]); ParameterList.Add(dt_Result.Rows[0]["UPDATEDATE"]); ParameterList.Add(dt_Result.Rows[0]["UPDATEUID"]); ParameterList.Add(dt_Result.Rows[0]["ENABLE"]); ParameterList.Add(dt_Result.Rows[0]["PASSWORD"]); ParameterList.Add(dt_Result.Rows[0]["MEMO"]); //需要更新值 DateTime processtime = DateTime.Now; ParameterList.Add(dt_Result.Rows[0]["NAME"]); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(strCryPassword); ParameterList.Add(dt_Result.Rows[0]["MEMO"]); int UpdateRecord = 0; UpdateRecord = BCO2.UpdateUser(ParameterList, null); if (UpdateRecord == 0) { throw new Exception("更新失敗!"); } //UpdateExcelRecords(strPassword, strCryPassword.Trim()); } this.ErrorMsgLabel.Text = "匯入完成!"; //DownLoadFile(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// 查詢資料庫取得資料 /// </summary> private void databind() { try { SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); dt_Result = BCO.QuerySwitch(SYSModel.MaintainUser.QueryType.CODE, ParameterList ); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
public User() { co_main = new BCO.MaintainUser(ConntionDB); }
/// <summary> /// 使用者登入所需作業 /// </summary> /// <param name="UserName">使用者名稱</param> public void UserLogin(string UserName) { //記錄使用者ID Session["UID"] = UserName; //統計人數 #region 傳入使用者ID ParameterList.Clear(); ParameterList.Add(UserName); #endregion //載入使用者資訊 SYSModel.MaintainUser user = new SYSModel.MaintainUser(ConnectionDB); Session["UserInfo"] = user.QueryUserByCode(ParameterList); //載入使用者功能表單 SYSModel.MaintainProgram prog = new SYSModel.MaintainProgram(ConnectionDB); DataTable Dt = prog.QueryAllProgramForUser(ParameterList); SYSModel.MaintainProgauthrel progth = new SYSModel.MaintainProgauthrel(ConnectionDB); DataTable Dt2 = progth.QueryCustProgramForUser(ParameterList); //如果為admin if (ParameterList[0].ToString() == __AdminUser) { for (int i = 0; i < Dt.Rows.Count; i++) { Dt.Rows[i]["Status"] = 1; } } Session["UserProgramStatus"] = Dt; Session["Cust_UserProgramStatus"] = Dt2; }
protected void Btn_Save_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; int UpdateRecord = 0; try { //取得登入user資料 databind(); if (dt_Result.Rows.Count == 0) { throw new Exception("讀取不到使用者,更新失敗!"); } #region 取得畫面元件的值 //新密碼 = 登入者帳號 DateTime processtime = DateTime.Now; string v_Password = TextBoxCode.Text; //密碼加密 SYSModel.CryptographyHelper Cry = new SYSModel.CryptographyHelper(); string CryPassword = Cry.Encrypt(v_Password); #endregion #region 加入更新條件 ParameterList.Clear(); //舊值 ParameterList.Add(dt_Result.Rows[0]["ID"]); ParameterList.Add(dt_Result.Rows[0]["CODE"]); ParameterList.Add(dt_Result.Rows[0]["NAME"]); ParameterList.Add(dt_Result.Rows[0]["CREATEDATE"]); ParameterList.Add(dt_Result.Rows[0]["CREATEUID"]); ParameterList.Add(dt_Result.Rows[0]["UPDATEDATE"]); ParameterList.Add(dt_Result.Rows[0]["UPDATEUID"]); ParameterList.Add(dt_Result.Rows[0]["ENABLE"]); ParameterList.Add(dt_Result.Rows[0]["PASSWORD"]); ParameterList.Add(dt_Result.Rows[0]["MEMO"]); //需要更新值 ParameterList.Add(dt_Result.Rows[0]["NAME"]); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(CryPassword); ParameterList.Add(dt_Result.Rows[0]["MEMO"]); #endregion SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); UpdateRecord = BCO.UpdateUser(ParameterList, null); if (UpdateRecord == 0) { throw new Exception("更新0筆資料!"); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('更改完成');", true); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//Initiziatoin_Component private void dataget() { ParameterList.Clear(); SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConntionDB); ParameterList.Add(_Code); if (_Code != "") { DataTable Dt = BCO.QueryForSLP(ParameterList); if (Dt.Rows.Count > 0) { _Name = Dt.Rows[0]["NAME"].ToString().Trim(); } else { _Name = "查無資料"; } } HiddenField1.Value = _Name; TextBoxName.Text = _Name; }//dataget
}//end InsertCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; int AddRecord = 0; try { #region 取得畫面元件的值 DateTime processtime = DateTime.Now; string v_UserCode = ((WUI.SLP.User)this.FormView1.FindControl("TextBoxUserCode")).Text; string v_RoleCode = ((WUI.SLP.Role)this.FormView1.FindControl("TextBoxRoleCode")).Text; //TextBox rolename = ((TextBox)this.FormView1.FindControl("TextBoxRoleCode").FindControl("TextBoxName")); string v_RoleName = ""; SYSModel.MaintainUser BCO1 = new SYSModel.MaintainUser(ConnectionDB); ParameterList.Clear(); ParameterList.Add(v_UserCode); DataTable Chkuser = BCO1.QueryUserByCode(ParameterList); if (Chkuser.Rows.Count != 1) { ErrorMsgLabel.Text = "請輸入正確人員代號"; return; } SYSModel.MaintainRole BCO2 = new SYSModel.MaintainRole(ConnectionDB); ParameterList.Clear(); ParameterList.Add(v_RoleCode); DataTable Chkrole = BCO2.QueryRoleByCode(ParameterList); if (Chkrole.Rows.Count != 1) { ErrorMsgLabel.Text = "請輸入正確角色代號"; return; } else { v_RoleName = Chkrole.Rows[0]["NAME"].ToString(); } ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_UserCode); ParameterList.Add("SYS_USERROLEREL"); ParameterList.Add("USERCODE"); ParameterList.Add(""); DataTable Dup = Uniq.QuerySwitch(SYSModel.MaintainProgram.QueryType.Duplicate, ParameterList ); if (Dup.Rows.Count > 0) { if (Dup.Rows[0]["ENABLE"].ToString() == "1") { throw new Exception("人員已存在角色關連!"); } } #endregion #region 加入輸入條件 ParameterList.Clear(); ParameterList.Add("");//ParameterList.Add(v_Code); ParameterList.Add(v_RoleName);//ParameterList.Add(v_Name); ParameterList.Add(processtime); //vCreateDate ParameterList.Add(Session["UID"].ToString()); //vCreateUID ParameterList.Add(processtime); //vUpdateDate ParameterList.Add(Session["UID"].ToString()); //vUpdateUID ParameterList.Add(v_UserCode); ParameterList.Add(v_RoleCode); #endregion SYSModel.MaintainUserRoleRel BCO = new SYSModel.MaintainUserRoleRel(ConnectionDB); AddRecord = BCO.CreateUserRoleRel(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { Response.Write("<script>alert('新增完成');location.replace('SYS052.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// 登入相關事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LoginImgBtn_Click(object sender, ImageClickEventArgs e) { bool LoginIsVaild = false; try { ErrorMsgLabel.Text = ""; //UserNameTxtBox.Text = "admin"; //PasswordTxtBox.Text = "admin"; #region 驗證輸入 if (UserNameTxtBox.Text.Trim().Length == 0 ) { throw new Exception("使用者名稱須輸入"); } if (PasswordTxtBox.Text.Trim().Length == 0) { throw new Exception("密碼不得為空白"); } #endregion SYSModel.MaintainUser usr = new SYSModel.MaintainUser(ConnectionDB); LoginIsVaild = usr.LoginVaild(UserNameTxtBox.Text, PasswordTxtBox.Text ); if (LoginIsVaild) { //登入 PageModel.BasePage ProcessPage = new PageModel.BasePage(); ProcessPage.UserLogin(UserNameTxtBox.Text); } } catch (System.Exception ex) { ErrorMsgLabel.Text = "※ 帳號或密碼錯誤(原因:" + ex.Message +")"; } finally { if (LoginIsVaild) { Response.Redirect("FMain.aspx"); } } }
/// <summary> /// 於檢視模式,按下刪除鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void DeleteButton_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; int DeleteRecord = 0; #region 取得畫面元件的值 DateTime processtime = DateTime.Now; #endregion #region 取得刪除前舊值 #region 使用XML轉回DataSet DataSet Ds = new DataSet(); DataTable Dt = dt_Result; #endregion if (Dt.Rows.Count == 0) { throw new Exception("抓取不到舊值,更新失敗!"); } #endregion #region 加入更新條件 ParameterList.Clear(); //舊值 ParameterList.Add(Dt.Rows[0]["ID"]); ParameterList.Add(Dt.Rows[0]["CODE"]); ParameterList.Add(Dt.Rows[0]["NAME"]); ParameterList.Add(Dt.Rows[0]["CREATEDATE"]); ParameterList.Add(Dt.Rows[0]["CREATEUID"]); ParameterList.Add(Dt.Rows[0]["UPDATEDATE"]); ParameterList.Add(Dt.Rows[0]["UPDATEUID"]); ParameterList.Add(Dt.Rows[0]["ENABLE"]); ParameterList.Add(Dt.Rows[0]["PASSWORD"]); ParameterList.Add(Dt.Rows[0]["MEMO"]); //需要更新值 ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); #endregion SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); DeleteRecord = BCO.DeleteUser(ParameterList, null); if (DeleteRecord == 0) { throw new Exception("刪除失敗!"); } else { LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("U");//2 ParameterList.Add(Dt.Rows[0]["CODE"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); Response.Write("<script>alert('刪除完成');location.replace('SYS041.aspx?Code=SYS04');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//end EditCancelButton_Click /// <summary> /// 編輯模式,按下更新確認鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void EditCommitButton_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; int UpdateRecord = 0; #region 取得畫面元件的值 string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim(); DateTime processtime = DateTime.Now; string v_Memo = ((TextBox)FormView1.FindControl("TextBoxMemo")).Text.Trim(); string v_Password = ((TextBox)FormView1.FindControl("TextBoxPassword")).Text.Trim(); if (v_Password.Length <8) throw new Exception("密碼長度不足8碼!"); //密碼加密 SYSModel.CryptographyHelper Cry = new SYSModel.CryptographyHelper(); string CryPassword = Cry.Encrypt(v_Password); #endregion #region 取得更新前舊值 #region 使用XML轉回DataSet DataSet Ds = new DataSet(); DataTable Dt = dt_Result; #endregion if (Dt.Rows.Count == 0) { throw new Exception("抓取不到舊值,更新失敗!"); } #endregion #region 加入更新條件 ParameterList.Clear(); //舊值 ParameterList.Add(Dt.Rows[0]["ID"]); ParameterList.Add(Dt.Rows[0]["CODE"]); ParameterList.Add(Dt.Rows[0]["NAME"]); ParameterList.Add(Dt.Rows[0]["CREATEDATE"]); ParameterList.Add(Dt.Rows[0]["CREATEUID"]); ParameterList.Add(Dt.Rows[0]["UPDATEDATE"]); ParameterList.Add(Dt.Rows[0]["UPDATEUID"]); ParameterList.Add(Dt.Rows[0]["ENABLE"]); ParameterList.Add(Dt.Rows[0]["PASSWORD"]); ParameterList.Add(Dt.Rows[0]["MEMO"]); //需要更新值 ParameterList.Add(v_Name); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(CryPassword); ParameterList.Add(v_Memo); #endregion SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); UpdateRecord = BCO.UpdateUser(ParameterList, null); if (UpdateRecord == 0) { throw new Exception("更新0筆資料!"); } else { LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("U");//2 ParameterList.Add(Dt.Rows[0]["CODE"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); //ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "SYS042", string.Format("<script>alert('更改完成');location.replace('SYS042.aspx?mode=readonly&ID={0}');</script>", Dt.Rows[0]["ID"].ToString()),false); Response.Write(string.Format("<script>alert('更改完成');location.replace('SYS042.aspx?mode=readonly&ID={0}');</script>", Dt.Rows[0]["ID"].ToString())); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//end InsertCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { try { int AddRecord = 0; ErrorMsgLabel.Text = ""; #region 取得畫面元件的值 string v_Code = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim(); string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim(); DateTime processtime = DateTime.Now; //string v_Organizationcode = ((WUI.SLP.Organization)FormView1.FindControl("TextBoxOrganizationCode")).Text.Trim(); string v_Password = ((TextBox)FormView1.FindControl("TextBoxPassword")).Text.Trim(); string v_Memo = ((TextBox)FormView1.FindControl("TextBoxMemo")).Text.Trim(); if (v_Password.Length < 8) throw new Exception("密碼長度不足8碼!"); //密碼加密 SYSModel.CryptographyHelper Cry = new SYSModel.CryptographyHelper(); string CryPassword = Cry.Encrypt(v_Password); ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_Code); ParameterList.Add("SYS_USER"); ParameterList.Add("CODE"); ParameterList.Add(""); DataTable Dup = Uniq.QuerySwitch(SYSModel.MaintainProgram.QueryType.Duplicate, ParameterList ); if (Dup.Rows.Count > 0) { if (Dup.Rows[0]["ENABLE"].ToString() == "1") { throw new Exception("資料重覆!"); } } #endregion #region 加入輸入條件 ParameterList.Clear(); ParameterList.Add(v_Code); ParameterList.Add(v_Name); ParameterList.Add(processtime); //vCreateDate ParameterList.Add(Session["UID"].ToString()); //vCreateUID ParameterList.Add(processtime); //vUpdateDate ParameterList.Add(Session["UID"].ToString()); //vUpdateUID //ParameterList.Add(v_Organizationcode); ParameterList.Add(CryPassword); ParameterList.Add(v_Memo); #endregion SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); AddRecord = BCO.CreateUser(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("I");//2 ParameterList.Add(v_Code);//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); Response.Write("<script>alert('新增完成');location.replace('SYS042.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
private void Loaddata(string NewCode) { SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); ParameterList.Clear(); ParameterList.Add(NewCode); DataTable Dt = BCO.QueryUserByID(ParameterList); if (Dt != null) { if (Dt.Rows.Count == 0) { ArrayList AL = (ArrayList)Session["SYS04_SortKey" + Request.QueryString["SYS042_PageTimeStamp"]]; string strRemove = "id=" + NewCode; AL.Remove(strRemove); Session["SYS04_SortKey" + Request.QueryString["SYS042_PageTimeStamp"]] = AL; throw new Exception("此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!"); } } }
/// <summary> /// 繫結資料 /// </summary> /// <param name=VirtualDataID></param> private void databind(FormViewMode fvm) { try { SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); ParameterList.Clear(); if (Request["ID"] != null) ParameterList.Add(Request["ID"].ToString()); else ParameterList.Add("0"); dt_Result = BCO.QuerySwitch(SYSModel.MaintainUser.QueryType.ID, ParameterList ); if (dt_Result.Rows.Count > 0) { this.hiddenID.Value = dt_Result.Rows[0]["ID"].ToString(); FormView1.DataSource = dt_Result; FormView1.DataBind(); if (dt_Result.Rows[0]["ENABLE"].ToString() == "0") { ((Button)FormView1.FindControl("EditButton")).Visible = false; ((Button)FormView1.FindControl("DeleteButton")).Visible = false; } LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("Q");//2 ParameterList.Add(dt_Result.Rows[0]["CODE"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); } AuthorityControls(this); //ToolBarStatus switch (fvm) { case FormViewMode.Edit: ToolBarStatus("edit"); TextBox txtname = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); txtname.Visible = false; break; case FormViewMode.Insert: ToolBarStatus("insert"); break; case FormViewMode.ReadOnly: ToolBarStatus("readonly"); TextBox txtname1 = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); txtname1.Visible = false; break; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }//databind