Пример #1
0
    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;            
        }

    }
Пример #2
0
    /// <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 = "查無資料"; }
    }
Пример #3
0
    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;
        }
    }
Пример #4
0
    /// <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;
        }
    }
Пример #5
0
 public User()
 {
     co_main = new BCO.MaintainUser(ConntionDB);
 }
Пример #6
0
        /// <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;
        }
Пример #7
0
    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;
        }
    }
Пример #8
0
        }//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
Пример #9
0
    }//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;
        }

    }
Пример #10
0
    /// <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");
            }
        }
    }
Пример #11
0
    /// <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;
        }
    }
Пример #12
0
    }//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;
        }
    }
Пример #13
0
    }//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;
        }

    }
Пример #14
0
    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("此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!");
            }
        }
    }
Пример #15
0
    /// <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