/// <summary>
/// 查詢鈕
/// </summary>
protected void btnQuery_Click(object sender, EventArgs e)
{
if (VerifyFormData() == true)
{
try
{
ErrorMsgLabel.Text = "";
int intP_Qty_S = 0;
int intP_Qty_E = 0;
//如果刷讀數量起迄都沒輸入,預設為 0 ~ 9999
if (txt_P_Qty_S.Text.Length == 0 && txt_P_Qty_E.Text.Length == 0)
{
intP_Qty_S = 0;
intP_Qty_E = 9999;
}
//如果只輸入迄,未輸入起,則起設為和迄相等
if (txt_P_Qty_S.Text.Length == 0 && txt_P_Qty_E.Text.Length != 0)
{
intP_Qty_E = int.Parse(txt_P_Qty_E.Text);
intP_Qty_S = intP_Qty_E;
}
//如果只輸入起,未輸入迄,則迄設為和起相等
if (txt_P_Qty_S.Text.Length != 0 && txt_P_Qty_E.Text.Length == 0)
{
intP_Qty_S = int.Parse(txt_P_Qty_S.Text);
intP_Qty_E = intP_Qty_S;
}
if (txt_P_Qty_S.Text.Length != 0 && txt_P_Qty_E.Text.Length != 0)
{
intP_Qty_S = int.Parse(txt_P_Qty_S.Text);
intP_Qty_E = int.Parse(txt_P_Qty_E.Text);
}
//抓取本頁初次登記的時間
string SessionIDName = "CGR011_" + PageTimeStamp.Value;
CGRModel.MaintainSorterData BCO = new PIC.VDS2G.LGT.CGR.MaintainSorterData(ConntionDB);
DataTable Dt;
ParameterList.Clear();
ParameterList.Add(SLP_StoreChain.Text);//通路
ParameterList.Add(SLP_Store.Text);//門市
ParameterList.Add(SLP_P_Date.Text);//處理日
ParameterList.Add(txtChan_Source_No.Text);//通路單號
ParameterList.Add(SLP_T_Date.Text);//模板日
ParameterList.Add(SLP_Sign_Date.Text);//簽收日
ParameterList.Add(txtBatch_No.Text);//批次序號
ParameterList.Add(SLP_SKU1.Text);//品號/品名
ParameterList.Add(SLP_ItemPeriod.Text);//期別
ParameterList.Add(intP_Qty_S);//刷讀數量_起
ParameterList.Add(intP_Qty_E);//刷讀數量_迄
ParameterList.Add(Int16.Parse(TextBoxRowCountLimit.Text));
Dt = BCO.QueryDetlByFind(ParameterList);
if (Dt.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGR011.aspx", "alert(' 查無資料 ');", true);
}
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
//為求總品項數的欄位
string[] fileds ={ "ITEM", "PERIOD" };
DataTable newdt = this.SelectDistinct(Dt, fileds);
lblDistinct.Text = newdt.Rows.Count.ToString();
Label1.Visible = true;
Label2.Visible = true;
lblSumPQty.Visible = true;
lblDistinct.Visible = true;
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
}
private void BindGrid(ArrayList AL_Rule)
{
//抓取本頁初次登記的時間
string SessionIDName = "CGR011_" + PageTimeStamp.Value;
CGRModel.MaintainSorterData BCO = new PIC.VDS2G.LGT.CGR.MaintainSorterData(ConntionDB);
DataTable Dt;
Dt = BCO.QueryDetlByFind(AL_Rule);
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
//為求總品項數的欄位
string[] fileds ={ "ITEM", "PERIOD" };
DataTable newdt = this.SelectDistinct(Dt, fileds);
lblDistinct.Text = newdt.Rows.Count.ToString();
Label1.Visible = true;
Label2.Visible = true;
lblSumPQty.Visible = true;
lblDistinct.Visible = true;
}
