Example #1
0
        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                if (e.CommandName.Equals("cmdEdit"))
                {
                    string strUrl = ResolveUrl(string.Format("~/PermitEdit.aspx?cmd={0}&ID={1}", "edit", e.CommandArgument.ToString()));
                    Response.Redirect(strUrl);
                }

                if (e.CommandName.Equals("cmdDel"))
                {
                    if (1 == 1)
                    {
                        string     strSql = "Update [Account] Set Rec_Status='R' Where ID=@ID";
                        SqlCommand cmd    = new SqlCommand(strSql);
                        cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = new Guid(e.CommandArgument.ToString());
                        conn = new MyConnection();
                        conn.ExecuteQuery(cmd);
                    }

                    querySql();
                }
            }
            catch (Exception ex)
            {
                PublicLib.handleError("", this.GetType().Name, ex.Message);
            }
        }
Example #2
0
        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                if (e.CommandName.Equals("cmdEdit"))
                {
                    string strUrl = ResolveUrl(string.Format("~/PkgAddEdit.aspx?cmd={0}&PkgId={1}", "edit", e.CommandArgument.ToString()));
                    Response.Redirect(strUrl);
                }
                if (e.CommandName.Equals("cmdEditR"))
                {
                    string strUrl = ResolveUrl(string.Format("~/PkgRunDownSet.aspx?PkgId={0}", e.CommandArgument.ToString()));
                    Response.Redirect(strUrl);
                }
                if (e.CommandName.Equals("cmdDel"))
                {
                    string strPkgid   = e.CommandArgument.ToString().Split(',')[0].Trim();
                    string strPkgCode = e.CommandArgument.ToString().Split(',')[1].Trim();

                    //刪除套餐....
                    string     strcmd = "DELETE FROM [HMC_PkgM] Where Id=@Id";
                    SqlCommand cmd    = new SqlCommand(strcmd);
                    cmd.Parameters.Add("@Id", SqlDbType.Int).Value = int.Parse(strPkgid);
                    conn = new MyConnection();
                    conn.ExecuteQuery(cmd);

                    //刪除關聯階層...
                    strcmd = "DELETE FROM [HMC_Relative] Where Pkg_Id=@Pkg_Id";
                    cmd    = new SqlCommand(strcmd);
                    cmd.Parameters.Add("@Pkg_Id", SqlDbType.Int).Value = int.Parse(strPkgid);
                    conn = new MyConnection();
                    conn.ExecuteQuery(cmd);

                    //刪除細項...
                    strcmd = "DELETE FROM [HMC_PkgD] Where PkgCode=@PkgCode";
                    cmd    = new SqlCommand(strcmd);
                    cmd.Parameters.Add("@PkgCode", SqlDbType.VarChar).Value = strPkgCode;
                    conn = new MyConnection();
                    conn.ExecuteQuery(cmd);

                    //刪除流程...
                    strcmd = "DELETE FROM [HMC_PkgRunDown] Where Pkg_Id=@Pkg_Id";
                    cmd    = new SqlCommand(strcmd);
                    cmd.Parameters.Add("@Pkg_Id", SqlDbType.Int).Value = int.Parse(strPkgid);
                    conn = new MyConnection();
                    conn.ExecuteQuery(cmd);

                    Response.Redirect("~/PkgIndex.aspx");
                }
            }
            catch (Exception ex)
            {
                PublicLib.handleError("", this.GetType().Name, ex.Message);
            }
        }
Example #3
0
        protected void Insert_Rundown() //新增
        {
            conn = new MyConnection();
            string     strSql = "Insert Into [HMC_Rundown] (Name, Cre_Date, Cre_User) Values (@Name, @Cre_Date, @Cre_user)";
            SqlCommand cmd    = new SqlCommand(strSql);

            cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value     = txtName.Text;
            cmd.Parameters.Add("@Cre_Date", SqlDbType.DateTime).Value = DateTime.Now;
            cmd.Parameters.Add("@Cre_User", SqlDbType.VarChar).Value  = "05890";
            conn.ExecuteQuery(cmd);
        }
Example #4
0
        protected void deleteData(string argId)
        {
            conn = new MyConnection();
            string     strSql = "Update [HMC_Rundown] Set Mod_Date=@Mod_Date, Mod_User=@Mod_USER, Rec_Status=@Rec_Status Where Id=@Id";
            SqlCommand cmd    = new SqlCommand(strSql);

            cmd.Parameters.Add("@Id", SqlDbType.Int).Value             = argId;
            cmd.Parameters.Add("@Mod_Date", SqlDbType.DateTime).Value  = DateTime.Now;
            cmd.Parameters.Add("@Mod_User", SqlDbType.VarChar).Value   = "05890";
            cmd.Parameters.Add("@Rec_Status", SqlDbType.VarChar).Value = "R";
            conn.ExecuteQuery(cmd);
        }
Example #5
0
        protected void Update_Rundown() //編輯
        {
            conn = new MyConnection();
            string     strSql = "Update [HMC_Rundown] Set Name=@Name, Mod_Date=@Mod_Date, Mod_User=@Mod_USER Where Id=@Id";
            SqlCommand cmd    = new SqlCommand(strSql);

            cmd.Parameters.Add("@Id", SqlDbType.Int).Value            = strQueID;
            cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value     = txtName.Text;
            cmd.Parameters.Add("@Mod_Date", SqlDbType.DateTime).Value = DateTime.Now;
            cmd.Parameters.Add("@Mod_User", SqlDbType.VarChar).Value  = "05890";
            conn.ExecuteQuery(cmd);
        }
Example #6
0
 private void delete_Relative(string ID)
 {
     try
     {
         conn = new MyConnection();
         string     strcmd = "Delete From [HMC_Relative] Where Id=@Id";
         SqlCommand cmd    = new SqlCommand(strcmd);
         cmd.Parameters.Add("@Id", SqlDbType.Int).Value = int.Parse(ID);
         conn.ExecuteQuery(cmd);
     }
     catch (Exception ex)
     {
         PublicLib.handleError("", this.GetType().Name, ex.Message);
     }
 }
Example #7
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            try
            {
                conn = new MyConnection();
                string     strSql = "Insert Into [HMC_Relative] (Type,Pkg_Id,Parent_Id, Cre_Date, Cre_User) Values (@Type,@Pkg_Id, @Parent_Id, @Cre_Date, @Cre_user)";
                SqlCommand cmd    = new SqlCommand(strSql);
                cmd.Parameters.Add("@Type", SqlDbType.Int).Value          = 1;
                cmd.Parameters.Add("@Pkg_Id", SqlDbType.Int).Value        = ddlPkgCode.SelectedValue;
                cmd.Parameters.Add("@Parent_Id", SqlDbType.Int).Value     = strQuePID;
                cmd.Parameters.Add("@Cre_Date", SqlDbType.DateTime).Value = DateTime.Now;
                cmd.Parameters.Add("@Cre_User", SqlDbType.VarChar).Value  = "05890";
                conn.ExecuteQuery(cmd);
            }
            catch (Exception ex)
            {
                PublicLib.handleError("", this.GetType().Name, ex.Message);
            }
            string strUrl = ResolveUrl(string.Format("~/PkgRelative.aspx?PID={0}", strQuePID));

            Response.Redirect(strUrl);
        }
 private void button1_Click(object sender, EventArgs e)
 {
     dataGridView1.DataSource = myConn.ExecuteQuery(txtString.Text.Trim());
 }