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