private bool GetRootPmaPatternByItem(string strItem,out Int32 iIncludeNonEffChecked)
{
#region
bool bResult = false;
iIncludeNonEffChecked = 0;
try
{
//20090514 modified:this method is out of order
//ParameterList.Clear();
//ITMModel.SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ITEM", strItem, "=", "and");
//ITMModel.MaintainSKU BCO = new ITMModel.MaintainSKU(ConnectionDB);
//DataTable dtTemp = BCO.QuerySKUByFind_1(ParameterList);
ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(strItem);
ParameterList.Add(SLP_SLPDate2.Text);
DataTable dtTemp = BCO.QueryItemInfo2(ParameterList);
s_PMA = "";
s_ROOT_NO = "";
s_PATTERN = "";
if (dtTemp != null && dtTemp.Rows.Count != 0)
{
s_ROOT_NO = dtTemp.Rows[0]["ROOT_NO"].ToString().Trim();//群分類
s_PMA = dtTemp.Rows[0]["PMA"].ToString().Trim();//大分類
s_PATTERN = dtTemp.Rows[0]["PATTERN_NO"].ToString().Trim();//Pattern分類
if (s_ROOT_NO == "1" && !(s_PMA == "13" || s_PMA == "14" || s_PMA == "15" || s_PMA == "16"))
iIncludeNonEffChecked = 1;
else
iIncludeNonEffChecked = 0;
bResult = true;//有資料
}
else
{
iIncludeNonEffChecked = 0;
bResult = false;//無資料
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
return bResult;
#endregion
}
public static ALOModel.ALOCommon.SKUITEM GetITEMInfo(ALOModel.ALOCommon.SKUITEM ItemObject,
string StAcceptDate)
{
try
{
ALOModel.QueryALOCommon SKUProc = new ALOModel.QueryALOCommon(ConnectionDB);
#region 輸入變數
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
//品號
ParameterList.Add(ItemObject.Item);
// 2009-10-08 cyhsu add 門市進貨日
ParameterList.Add(StAcceptDate);
#endregion
DataTable Dt = SKUProc.QueryItemInfo2(ParameterList);
if (Dt.Rows.Count > 0)
{
ItemObject.RootNo = Dt.Rows[0]["ROOT_NO"].ToString();
ItemObject.PMA = Dt.Rows[0]["PMA"].ToString();
ItemObject.PatternNo = Dt.Rows[0]["PATTERN_NO"].ToString();
}
return ItemObject;
}
catch (Exception ex)
{
throw ex;
}
}
