/// <summary>
/// 取得群分類、大分類、Pattern分類
/// </summary>
/// <param name="strItem"></param>
/// <param name="iIncludeNonEffChecked"></param>
/// <returns></returns>
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();//20091106
ParameterList.Clear();
ParameterList.Add(strItem);
DataTable dtTemp = BCO.QueryItemInfo(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
}
