/// <summary>
/// 查詢通路及路線的配本門市數量
/// </summary>
/// <param name="dis_no">配本序號</param>
/// <param name="date">門市進貨日</param>
/// <param name="item">配本商品品號</param>
/// <param name="period">配本商品期別</param>
/// <param name="route_s">配本路線起</param>
/// <param name="route_e">配本路線迄</param>
private void getTotal_Chan(string dis_no, string date, string item, string period, string chan_no, string route_s, string route_e)
{
try
{
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(PageTimeStamp.Value + Session["UID"].ToString());
ParameterList.Add(dis_no); //配本序號
ParameterList.Add(date); //門市進貨日
ParameterList.Add(item); //配本商品品號
ParameterList.Add(period); //配本商品期別
ParameterList.Add(chan_no); //通路
ParameterList.Add(route_s); //路線起
ParameterList.Add(route_e); //路線迄
DataTable dt = new DataTable();
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
dt = bco.QueryChanAndRouteSumFor122(ParameterList);
if (dt.Rows.Count > 0)
{
//txtDIS_STO_CQTY.Text = dt.Rows[0]["N_CHAN_TOT_QTY"].ToString() == "" ? "0" : dt.Rows[0]["N_CHAN_TOT_QTY"].ToString();
//txtN_DIS_TOT_OQTY.Text = dt.Rows[0]["N_ROUTE_TOT_QTY"].ToString() == "" ? "0" : dt.Rows[0]["N_ROUTE_TOT_QTY"].ToString();
//txtDiff.Text = Convert.ToString(int.Parse(txtN_DIS_TOT_OQTY.Text) - int.Parse(txtN_DIS_TOT_QTY.Text));
//因為有可能修改多筆後的資料，結果差異數仍為0
////if (txtDiff.Text != "0") btnDis_Update.Enabled = true; else btnDis_Update.Enabled = false;
//2010-05-18 cyhsu add
txtDisSumQty_New.Text = dt.Rows[0]["N_NEW_DISTOTQTY"].ToString() == "" ? "0" : dt.Rows[0]["N_NEW_DISTOTQTY"].ToString();
txtPageDisQty_New.Text = dt.Rows[0]["N_NEW_PAGETOTQTY"].ToString() == "" ? "0" : dt.Rows[0]["N_NEW_PAGETOTQTY"].ToString();
txtDiff.Text = Convert.ToString(int.Parse(txtDisSumQty_New.Text) - int.Parse(txtDisSumQty.Text));
}
}
catch (Exception ex) { this.lblErrorQ1.Text = ex.Message; }
}
