Example #1
0
    protected void btnDel_Click(object sender, EventArgs e)
    {
        try
        {

            string SessionIDName = "VAM241_" + PageTimeStamp.Value;
            DataTable dtA = new DataTable();
            dtA = (DataTable)Session[SessionIDName];
            LinkButton btn = sender as LinkButton;
            GridViewRow gr = (btn.BindingContainer as GridViewRow);
            int i = gr.RowIndex;
            DataRow drA = null;
            if (dtA.Rows[i]["ITEM"].ToString().Trim()=="")
            {
                drA = dtA.Select("VENDOR='" + dtA.Rows[i]["VENDOR"].ToString() + "'")[0];    
            }
            else
            {
                drA = dtA.Select("VENDOR='" + dtA.Rows[i]["VENDOR"].ToString() + "' And ITEM ='" + dtA.Rows[i]["ITEM"].ToString() + "'")[0]; 
            }

            CAMCommon CAMCommonBCO = new CAMCommon();
            ArrayList ParameterDel = new ArrayList();
            ParameterDel.Add(CAMCommonBCO.GetValueSetParameter(drA["VENDOR"].ToString(), "string", false));
            ParameterDel.Add(CAMCommonBCO.GetValueSetParameter(drA["ITEM"].ToString(), "string", false));
            ParameterDel.Add(CAMCommonBCO.GetValueSetParameter(Session["UID"].ToString(), "string", false));

            VAM24_BCO BCO = new VAM24_BCO(ConntionDB);
            string sMsg = BCO.DeleteTranShipItem(ParameterDel, null);
            if (sMsg == "刪除成功")
            {
                drA.Delete();
                dtA.AcceptChanges();
                Session[SessionIDName] = dtA;
                this.GridView1.DataSource = dtA;
                this.GridView1.DataBind();

                if (dtA.Rows.Count > 0)
                {
                    StringCollection sc = new StringCollection();
                    foreach (DataRow dr in dtA.Rows)
                    {
                        sc.Add(dr["VENDOR"].ToString());
                    }

                    Session["VAM24CodeCollection"] = sc;
                }
            }

            ErrorMsgLabel.Text = sMsg;
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
    }