/// <summary>
/// 根據傳入參數取得商品庫存
/// </summary>
/// <param name="CHAN_NO"></param>
/// <param name="STORE"></param>
private void GetStock(string v_ROOT_NO, string v_Item, string v_Period)
{
//string SessionIDName = "CRM041_Stock" + PageTimeStamp.Value;
if ((v_Item == String.Empty) || (v_Period == String.Empty))
{
v_Item = this.slp_down_ITEM.Text;
v_Period = this.txt_down_PERIOD.Text;
}
ArrayList ParameterList = new ArrayList();//20091117
if (v_ROOT_NO == String.Empty)
{
#region 依照品號取得所屬[群分類]、[大分類]
ParameterList.Clear();
BCO_ITM.SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ITEM", v_Item, "=", "and");
BCO_ITM.MaintainSKU bco_itm = new BCO_ITM.MaintainSKU(ConntionDB);
DataTable dt_Return = bco_itm.QuerySKUByFind_1(ParameterList);
if (dt_Return != null && dt_Return.Rows.Count != 0)
{
s_PMA = dt_Return.Rows[0]["PMA"].ToString();//大分類
s_ROOT_NO = dt_Return.Rows[0]["ROOT_NO"].ToString();//群分類
v_ROOT_NO = s_ROOT_NO;
}
bco_itm = null;
dt_Return.Dispose();
#endregion
}
if (dtStock == null)
{
ParameterList.Clear();
ParameterList.Add(v_ROOT_NO);
ParameterList.Add(v_Item);
ParameterList.Add(v_Period);
ParameterList.Add(Session["UID"].ToString());
BCO.QueryCRMCommon bco_Common = new BCO.QueryCRMCommon(ConntionDB);
dtStock = bco_Common.QueryCRMItemPeriodStock(ParameterList);
//Session["SessionID"] = SessionIDName;
//Session[SessionIDName] = dtStock;
bco_Common = null;
}
}
/// <summary>
/// 根據傳入參數取得商品庫存 by PageMethod
/// </summary>
/// <param name="v_RootNo"></param>
/// <param name="v_Item"></param>
/// <param name="v_Period"></param>
/// <param name="strUserID"></param>
/// <param name="strPageTimeStamp"></param>
private void GetStockByPageMethod(string v_RootNo, string v_Item, string v_Period, string strUserID, string strPageTimeStamp)
{
#region
try
{
if (v_Item.Trim() == "" || v_Period.Trim() == "")
{
throw new Exception("輸入之品號、期別不完整");
}
ArrayList ParameterList = new ArrayList();
if (v_RootNo.Trim() == "")
{
#region 依照品號取得所屬[群分類]、[大分類]
ParameterList.Clear();
BCO_ITM.SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ITEM", v_Item, "=", "and");
BCO_ITM.MaintainSKU bco_itm = new BCO_ITM.MaintainSKU(ConntionDB);
DataTable dt_Return = bco_itm.QuerySKUByFind_1(ParameterList);
if (dt_Return != null && dt_Return.Rows.Count != 0)
{
Session[string.Format("CRM041_s_PMA_{0}", strPageTimeStamp)] = dt_Return.Rows[0]["PMA"].ToString();//大分類
Session[string.Format("CRM041_s_ROOT_NO_{0}", strPageTimeStamp)] = dt_Return.Rows[0]["ROOT_NO"].ToString();//群分類
v_RootNo = Session[string.Format("CRM041_s_ROOT_NO_{0}", strPageTimeStamp)].ToString();
}
bco_itm = null;
dt_Return.Dispose();
#endregion
}
if (Session[string.Format("CRM041_dtStock_{0}", strPageTimeStamp)] == null)
{
ParameterList.Clear();
ParameterList.Add(v_RootNo);
ParameterList.Add(v_Item);
ParameterList.Add(v_Period);
ParameterList.Add(strUserID);
BCO_CRM.QueryCRMCommon BCO = new BCO_CRM.QueryCRMCommon(ConntionDB);
Session[string.Format("CRM041_dtStock_{0}", strPageTimeStamp)] = BCO.QueryCRMItemPeriodStock(ParameterList);
BCO.CloseConnection();
}
}
catch (Exception ex)
{
throw ex;
}
#endregion
}