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 = "查無資料";
}
}
