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