/// <summary> /// Method to get MoBOMs via a specified model /// </summary> /// <param name="model">a valid model code</param> /// <returns>Interface to Model Collection Generic of MoBOMInfo</returns> public IList<MoBOMInfo> GetMoBOMByModel(string model) { IList<MoBOMInfo> result = dal.GetMoBOMByModel(model); int rows = (int)result.LongCount(); while (rows < MAX_SUB_COUNT) { MoBOMInfo info = new MoBOMInfo(); result.Add(info); rows++; } return result; }
/// <summary> /// Method to get MoBOMs via a specified model /// </summary> /// <param name="model">a valid model code</param> /// <returns>Interface to Model Collection Generic of MoBOMInfo</returns> public IList<MoBOMInfo> GetMoBOMByModel(string model) { IList<MoBOMInfo> result = new List<MoBOMInfo>(); string strSql = "SELECT distinct(MO), Qty, PrintQty as StartQty, Udt FROM MO where Model='" + model + "'"; using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql, null)) { while (rdr.Read()) { MoBOMInfo mo = new MoBOMInfo(); mo.Mo = rdr.GetString(0).Trim(); mo.Qty = "" + rdr.GetInt16(1); mo.StartQty = "" + rdr.GetInt16(2); mo.UpdateDate = rdr.GetDateTime(3).ToString("yyyy-MM-dd"); result.Add(mo); } } return result; }