public static IEnumerable<BillOfMaterial> GetBillOfMaterialByID(int ID) { Dictionary<string, object> param = new Dictionary<string, object>(); param.Add("@ID", ID); DataTable dt = DBHelper.GetDataTable("GetBillOfMaterialByID", param, true); if (dt != null && dt.Rows.Count > 0) { var boms = DBHelper.ConvertToList<BillOfMaterial>(dt); if (boms != null) { foreach (var bom in boms) { bom.details = BillOfMaterialDetailLogic.GetRawMaterialDetails(bom.ProductID, bom.ShadeID, ""); bom.labParameters = BillOfMaterialLabParametersLogic.GetLabParamaters(bom.ID); } } return boms; } else return null; }
public static BillOfMaterial GetBillOfMaterialByPSR(int ProductID, int ShadeID, string RevisionNo) { Dictionary<string, object> param = new Dictionary<string, object>(); param.Add("@ProductID", ProductID); param.Add("@ShadeID", ShadeID); param.Add("@RevisionNo", RevisionNo); DataTable dt = DBHelper.GetDataTable("GetBillOfMaterialByPSR", param, true); if (dt != null && dt.Rows.Count > 0) { var boms = DBHelper.ConvertToList<BillOfMaterial>(dt); if (boms != null) { foreach (var bom in boms) { //bom.details = BillOfMaterialDetailLogic.GetRawMaterialDetails(bom.ProductID, bom.ShadeID, ""); bom.labParameters = BillOfMaterialLabParametersLogic.GetLabParamaters(bom.ID); } } return boms.FirstOrDefault(); } else return null; }