/// <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 }