protected void btnDel_Click(object sender, EventArgs e) { try { string SessionIDName = "VAM281_" + PageTimeStamp.Value; DataTable dtA = (DataTable)Session[SessionIDName]; LinkButton btn = sender as LinkButton; GridViewRow gr = (btn.BindingContainer as GridViewRow); int i = gr.RowIndex; ArrayList ParameterDel = new ArrayList(); ParameterDel.Add(dtA.Rows[i]["ID"].ToString()); ParameterDel.Add(Session["UID"].ToString()); ParameterDel.Add(dtA.Rows[i]["UPDATEDATE"].ToString()); ParameterDel.Add(dtA.Rows[i]["UPDATEUID"].ToString()); VAM28_BCO BCO = new VAM28_BCO(ConntionDB); BCO.DeleteOilSubsidyRecord(ParameterDel, null); DataRow drA = null; drA = dtA.Select("ID=" + dtA.Rows[i]["ID"].ToString())[0]; 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["ID"].ToString()); } Session["VAM28CodeCollection" + PageTimeStamp.Value] = sc; } ErrorMsgLabel.Text = "刪除成功"; } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
private void BindData() { ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(SLP_VENDOR_S.Text); ParameterList.Add(SLP_VENDOR_E.Text); ParameterList.Add(SLP_ITEM_S.Text); ParameterList.Add(SLP_ITEM_E.Text); ParameterList.Add(SLP_CREATEDATE.StartDate); ParameterList.Add(SLP_CREATEDATE.EndDate); ParameterList.Add(SLP_CREATEUID.Text); ParameterList.Add(SLP_UPDATEDATE.StartDate); ParameterList.Add(SLP_UPDATEDATE.EndDate); ParameterList.Add(SLP_UPDATEUID.Text); ParameterList.Add(TextBoxRowCountLimit.Text); VAM28_BCO BCO = new VAM28_BCO(ConntionDB); DataTable dt = BCO.QueryOilSubsidyByFind(ParameterList); string SessionIDName = "VAM281_" + PageTimeStamp.Value; Session[SessionIDName] = dt; GridView1.DataSource = dt; GridView1.PageSize = (TextBoxPagesize.Text == "") ? 20 : (int.Parse(TextBoxPagesize.Text) < 0) ? 20 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); if (dt.Rows.Count > 0) { StringCollection sc = new StringCollection(); foreach (DataRow dr in dt.Rows) { sc.Add(dr["ID"].ToString()); } Session["VAM28CodeCollection" + PageTimeStamp.Value] = sc; } else { ErrorMsgLabel.Text = "查無資料"; } }