public IList<string> WhereUsedComponent(string component) { try { IList<string> ret = new List<string>(); MethodBase mthObj = MethodBase.GetCurrentMethod(); int tk = mthObj.MetadataToken; mtns::SQLContextNew sqlCtx = null; lock (mthObj) { if (!SQLCache.PeerTheSQL(tk, out sqlCtx)) { mtns::ModelBOM_NEW cond = new mtns::ModelBOM_NEW(); cond.component = component; cond.flag = 1; sqlCtx = mtns::FuncNew.GetConditionedSelect<mtns::ModelBOM_NEW>(tk, null, new string[] { mtns::ModelBOM_NEW.fn_material }, new mtns::ConditionCollection<mtns::ModelBOM_NEW>(new mtns::EqualCondition<mtns::ModelBOM_NEW>(cond)), mtns::ModelBOM_NEW.fn_cdt); } } sqlCtx.Param(ModelBOM_NEW.fn_component).Value = component; sqlCtx.Param(ModelBOM_NEW.fn_flag).Value = 1; using (SqlDataReader sqlR = _Schema.SqlHelper.ExecuteReader(_Schema.SqlHelper.ConnectionString_BOM, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params)) { if (sqlR != null) { while (sqlR.Read()) { ret.Add(g.GetValue_Str(sqlR, 0)); } } } return ret; } catch (Exception) { throw; } }
public IList<MoBOMInfo> GetModelBomListByComponents(string[] pnList) { try { IList<MoBOMInfo> ret = null; MethodBase mthObj = MethodBase.GetCurrentMethod(); int tk = mthObj.MetadataToken; mtns::SQLContextNew sqlCtx = null; lock (mthObj) { if (!SQLCache.PeerTheSQL(tk, out sqlCtx)) { mtns::ModelBOM_NEW cond = new mtns::ModelBOM_NEW(); cond.component = "[INSET]"; mtns::ModelBOM_NEW cond1 = new mtns::ModelBOM_NEW(); cond1.flag = 1; sqlCtx = mtns::FuncNew.GetConditionedSelect<mtns::ModelBOM_NEW>(tk, null, null, new mtns::ConditionCollection<mtns::ModelBOM_NEW>(new mtns::InSetCondition<mtns::ModelBOM_NEW>(cond), new EqualCondition<mtns::ModelBOM_NEW>(cond1)), mtns::ModelBOM_NEW.fn_material, mtns::ModelBOM_NEW.fn_component); sqlCtx.Param(ModelBOM_NEW.fn_flag).Value = cond1.flag; } } string Sentence = sqlCtx.Sentence.Replace(g.DecInSet(mtns::ModelBOM_NEW.fn_component), g.ConvertInSet(new List<string>(pnList))); using (SqlDataReader sqlR = _Schema.SqlHelper.ExecuteReader(_Schema.SqlHelper.ConnectionString_BOM, CommandType.Text, Sentence, sqlCtx.Params)) { ret = mtns::FuncNew.SetFieldFromColumn<mtns::ModelBOM_NEW, MoBOMInfo, MoBOMInfo>(ret, sqlR, sqlCtx); } return ret; } catch (Exception) { throw; } }