protected void ButtonQuery_Click(object sender, EventArgs e)
{
MaintainGoodsInTransit BCO = new MaintainGoodsInTransit(ConntionDB);
ParameterList.Clear();
//0
if (chkLike.Checked == true)
ParameterList.Add("%" + txtONWAY_NO.Text.Trim() + "%");
else
ParameterList.Add(txtONWAY_NO.Text.Trim());
//1
if (chkLike.Checked == true)
ParameterList.Add("%" + txtPURCHASE_NO.Text.Trim() + "%");
else
ParameterList.Add(txtPURCHASE_NO.Text.Trim());
ParameterList.Add(EmptyPara(SLP_SLPDateRange1.StartDate.Trim(), SLP_SLPDateRange1.EndDate.Trim())); //2
ParameterList.Add(EmptyPara(SLP_SLPDateRange1.EndDate.Trim(), SLP_SLPDateRange1.StartDate.Trim())); //3
ParameterList.Add(this.SLP_EnumBase1.Text.Trim()); //4
ParameterList.Add(SLP_VendorBase1.Text.Trim()); //5
ParameterList.Add(EmptyPara(SLP_SLPDateRange2.StartDate.Trim(), SLP_SLPDateRange2.EndDate.Trim())); //6
ParameterList.Add(EmptyPara(SLP_SLPDateRange2.EndDate.Trim(), SLP_SLPDateRange2.StartDate.Trim())); //7
ParameterList.Add(SLP_User1.Text.Trim()); //8
ParameterList.Add(EmptyPara(SLP_SLPDateRange3.StartDate.Trim(), SLP_SLPDateRange3.EndDate.Trim())); //9
ParameterList.Add(EmptyPara(SLP_SLPDateRange3.EndDate.Trim(), SLP_SLPDateRange3.StartDate.Trim())); //10
ParameterList.Add(SLP_User2.Text.Trim()); //11
ParameterList.Add(SLP_SKU1.Text.Trim()); //12
ParameterList.Add(SLP_ItemPeriod1.Text.Trim()); //13
ParameterList.Add(EmptyPara(SLP_SLPDateRange4.StartDate.Trim(), SLP_SLPDateRange4.EndDate.Trim())); //9
ParameterList.Add(EmptyPara(SLP_SLPDateRange4.EndDate.Trim(), SLP_SLPDateRange4.StartDate.Trim())); //10
ParameterList.Add(SLP_CodeFile1.Text.Trim()); //16
ParameterList.Add(TextBoxRowCountLimit.Text.Trim()); //17
DataTable dt = BCO.QueryByFind(ParameterList);
ViewState[PageTimeStamp.Value] = dt;
ErrorMsgLabel.Text = "";
if (dt.Rows.Count > 0)
{
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 20 : (int.Parse(TextBoxPagesize.Text) < 0) ? 20 : int.Parse(TextBoxPagesize.Text);
BindData();
}
else
{
ErrorMsgLabel.Text = "查無資料";
GridView1.DataSource = null;
GridView1.DataBind();
}
}
