/// <summary> /// Method to get all sub modelboms of specific code /// </summary> /// <param name="code">Unique identifier for a ModelBOM</param> /// <returns>Interface to Model Collection Generic of ModelBOMInfo</returns> public IList<ModelBOMInfo> GetSubModelBOMByCode(string code) { IList<ModelBOMInfo> result = dal.GetSubModelBOMByCode(code); int rows = (int)result.LongCount(); while (rows < MAX_SUB_COUNT) { ModelBOMInfo info = new ModelBOMInfo(); result.Add(info); rows++; } return result; }
/// <summary> /// Method to get all alternative items /// </summary> /// <param name="code">Unique identifier for a ModelBOM</param> /// <param name="alternativeItemGroup">alternative item group</param> /// <returns>Interface to Model Collection Generic of string</returns> public IList<ModelBOMInfo> GetAlternativeItems(string code, string alternativeItemGroup) { IList<ModelBOMInfo> result = dal.GetAlternativeItems(code, alternativeItemGroup); ModelBOMInfo info; /*foreach (ModelBOMInfo item in result) { result.Add(item); }*/ int rows = (int)result.LongCount(); while (rows < MAX_SUB_COUNT - 1) { info = new ModelBOMInfo(); result.Add(info); rows++; } return result; }
/// <summary> /// Get information on a specific ModelBOM /// </summary> /// <param name="modelBOMId">Unique identifier for a ModelBOM</param> /// <returns>Business Entity representing a ModelBOM</returns> public ModelBOMInfo GetModelBOM(long modelBOMId) { ModelBOMInfo info = new ModelBOMInfo(); return info; }
/// <summary> /// Method to get specified ModelBOM's alternative items. /// <param name="code">Unique identifier for a ModelBOM</param> /// <param name="alternativeItemGroup">Alternative item group for a ModelBOM</param> /// </summary> /// <returns>Interface to Model Collection Generic of ModelBOMInfo</returns> public IList<ModelBOMInfo> GetAlternativeItems(string code, string alternativeItemGroup) { IList<ModelBOMInfo> result = new List<ModelBOMInfo>(); //if (debug) //{ // //模拟数据,以后变为从ModelBOM表中取得 // ModelBOMInfo info = new ModelBOMInfo(); // info.Material = "TC0000000002"; // result.Add(info); // info = new ModelBOMInfo(); // info.Material = "TC0000000003"; // result.Add(info); //} string strSql = "SELECT distinct Component as Material from ModelBOM where Material='" + code + "'"; strSql += " and Alternative_item_group='" + alternativeItemGroup + "'"; using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql, null)) { while (rdr.Read()) { ModelBOMInfo info = new ModelBOMInfo(); info.Material = rdr.GetString(0).Trim(); result.Add(info); } } return result; }
/// <summary> /// Method to get specified ModelBOM's children. /// </summary> /// <param name="code">Unique identifier for a ModelBOM</param> /// <returns>Interface to Model Collection Generic of vs</returns> public IList<ModelBOMInfo> GetSubModelBOMByCode(string code) { IList<ModelBOMInfo> result = new List<ModelBOMInfo>(); string strSql = "SELECT Component as Material, Material_group, Quantity, Alternative_item_group FROM ModelBOM where Material='" + code + "'"; using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql, null)) { while (rdr.Read()) { ModelBOMInfo info = new ModelBOMInfo(); if (!rdr.IsDBNull(0)) { info.Material = rdr.GetString(0).Trim(); } if (!rdr.IsDBNull(1)) { info.Material_group = rdr.GetString(1).Trim(); } if (!rdr.IsDBNull(2)) { info.Quantity = rdr.GetString(2).Trim(); } if (!rdr.IsDBNull(3)) { info.Alternative_item_group = rdr.GetString(3).Trim(); } result.Add(info); } } return result; }
/// <summary> /// Method to get specified ModelBOM's children. /// </summary> /// <param name="code">Unique identifier for a ModelBOM</param> /// <returns>Interface to Model Collection Generic of vs</returns> public IList<ModelBOMInfo> GetParentModelBOMByCode(string code) { IList<ModelBOMInfo> boms = new List<ModelBOMInfo>(); string strSql = "SELECT distinct(Material), Material_group, Component FROM ModelBOM where Component='" + code + "'"; using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql, null)) { while (rdr.Read()) { ModelBOMInfo info = new ModelBOMInfo(); info.Material = rdr.GetString(0).Trim(); info.Material_group = rdr.GetString(1).Trim(); info.Quantity = rdr.GetString(2).Trim(); boms.Add(info); } } return boms; }