Ejemplo n.º 1
0
    /// <summary>
    /// 查詢配本門市資料
    /// </summary>
    /// <param name="dis_no">配本序號</param>
    /// <param name="item">配本商品品號</param>
    /// <param name="period">配本商品期別</param>
    private void getStore(string dis_no, string item, string period)
    {
        string SessionIDName = "ALO122_dt5" + PageTimeStamp.Value;
        DataTable dt = new DataTable();
        try
        {
            ArrayList ParameterList = new ArrayList();//20091113

            ParameterList.Clear();
            ParameterList.Add(dis_no); //配本序號
            ParameterList.Add(item); //配本商品品號
            ParameterList.Add(period); //配本商品期別
            ParameterList.Add(PageTimeStamp.Value + Session["UID"].ToString());
            BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
            dt = bco.QueryDisStoreFor122(ParameterList);
            if (dt.Rows.Count == 0) { btnBatchTune.Enabled = false; btnConditionQuery.Enabled = false; btnNewStoreQuery.Enabled = false; btnReturnedPerchase.Enabled = false; }
        }
        catch (Exception ex)
        {
            lblErrorQ1.Text = ex.Message;
        }
        finally
        {
            txtQueryTotRec.Text = dt.Rows.Count.ToString();
            ComputeTotQty(dt); //計算查詢總配量

            Session[SessionIDName] = dt;
            if (dt.Rows.Count == 0)
                GridView2.DataSource = null;
            else
                GridView2.DataSource = CopyTable(dt);//產生Rx_ITEM及Rx_PERIOD都不為空值的DataTable;
            GridView2.DataBind();
            Resize_Div(GridView2.Rows.Count);
            UpdatePanel1.Update();
        }
    }