}//ButtonNew_Click
protected void ButtonQuery_Click(object sender, EventArgs e)
{
this.ErrorMsgLabel.Text = "";
ParameterList.Clear();
//0.PROMOTE_ID
//1.VENDOR
//2.TAX_TYPE
//3.TAX_REMAIN_AMT_OP
//4.TAX_REMAIN_AMT
//5.UTAX_REMAIN_AMT_OP
//6.UTAX_REMAIN_AMT
//7.TAX_AMT_OP
//8.TAX_AMT
//9.UTAX_AMT_OP
//10.UTAX_AMT
//11.TAX_OP
//12.TAX
//13.TAX_AMT+UTAX_AMT_OP
//14.TAX_AMT+UTAX_AMT
if (CheckBoxLikeSearch.Checked == true)
{
ParameterList.Add("%" + SLP_PROMOTE.Text.Trim() + "%");
ParameterList.Add("%" + SLP_VendorBase1.Text.Trim() + "%");
}
else
{
ParameterList.Add(SLP_PROMOTE.Text.Trim());
ParameterList.Add(SLP_VendorBase1.Text.Trim());
}
ParameterList.Add(SLP_TAXTYPE.Text.Trim());
ParameterList.Add(SLP_NO_TAX_AMT.Operator);
ParameterList.Add(SLP_NO_TAX_AMT.Text.Trim());
ParameterList.Add(SLP_TAX.Operator);
ParameterList.Add(SLP_TAX.Text.Trim());
ParameterList.Add(SLP_SUM_AMT.Operator);
ParameterList.Add(SLP_SUM_AMT.Text.Trim());
BCO.VAM15_BCO bco = new BCO.VAM15_BCO(ConnectionDB);
DataTable dt = bco.QueryMain(ParameterList);
if (dt.Rows.Count == 0)
{
this.GridView1.Visible = false;
ErrorMsgLabel.Text = "查無資料！";
}
else
{
this.GridView1.Visible = true;
Session["VAM151_MST" + PageTimeStamp.Value] = dt;
Set_IDCollection(dt.DefaultView);
this.GridView1.DataSource = dt;
if (this.TextBoxPagesize.Text == "")
this.GridView1.PageSize = 10;
else
this.GridView1.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text);
this.GridView1.PageIndex = 0;
this.GridView1.DataBind();
ViewState["SortField"] = null;
ViewState["SortDirect"] = null;
}
UnSetClinetFocus();
}//ButtonQuery_Click
