///// <summary> ///// 获取该商品对应的母件的商品型号(如果同一笔订单里面多个母件都引用该子件,计算物料需求时该子件用量将合并为一笔,因此要带出所有母件的型号) ///// </summary> ///// <param name="pronoteHeaderId">加工单号</param> ///// <param name="productId">商品编号</param> ///// <returns></returns> //internal string GetCustomerProductNameByPronoteHeaderId(string pronoteHeaderId, string productId, string handbookProductId) //{ // List<string> invoiceProductIds = invoiceXODetailManager.SelectProductIDs(pronoteHeaderId, handbookProductId).ToList(); // List<string> parentProductIds = new List<string>(); // GetParentProductInfo("'" + productId + "'", parentProductIds); // IEnumerable<string> productIds = invoiceProductIds.Intersect(parentProductIds); // string pIds = ""; // foreach (var p in productIds) // { // pIds += "'" + p + "',"; // } // pIds = pIds.TrimEnd(','); // if (string.IsNullOrEmpty(pIds)) //有些商品是通过 + 上去的,没有对应订单里面的商品 // return null; // return productManager.SelectCustomerProductNameByProductIds(pIds).TrimEnd(','); //} #endregion /// <summary> /// 获取该商品对应的母件的商品型号(如果同一笔订单里面多个母件都引用该子件,计算物料需求时该子件用量将合并为一笔,因此要带出所有母件的型号) /// </summary> /// <param name="pronoteHeaderId">加工单</param> /// <param name="productId">商品编号</param> /// <param name="handbookProductId">手册项号</param> /// <returns></returns> internal static string GetCustomerProductNameByPronoteHeaderId(Model.PronoteHeader pronoteHeader, string productId, string handbookProductId) { List <string> invoiceProductIds = mRSHeaderManager.SelectAllProductIdByMRSHeaderId(pronoteHeader.MRSHeaderId, handbookProductId).ToList(); List <string> parentProductIds = new List <string>(); GetParentProductInfo("'" + productId + "'", parentProductIds); IEnumerable <string> productIds = invoiceProductIds.Intersect(parentProductIds); string pIds = ""; foreach (var p in productIds) { pIds += "'" + p + "',"; } pIds = pIds.TrimEnd(','); if (string.IsNullOrEmpty(pIds)) //有些商品是通过 + 上去的,没有对应订单里面的商品 { return(null); } return(productManager.SelectCustomerProductNameByProductIds(pIds).TrimEnd(',')); }
/// <summary> /// 获取该商品对应的母件的商品型号(如果同一笔订单里面多个母件都引用该子件,计算物料需求时该子件用量将合并为一笔,因此要带出所有母件的型号) /// </summary> /// <param name="pronoteHeaderId">加工单号</param> /// <param name="productId">商品编号</param> /// <returns></returns> internal string GetCustomerProductNameByPronoteHeaderId(string pronoteHeaderId, string productId) { List <string> invoiceProductIds = invoiceXODetailManager.SelectProductIDs(pronoteHeaderId).ToList(); List <string> parentProductIds = new List <string>(); GetParentProductInfo("'" + productId + "'", parentProductIds); IEnumerable <string> productIds = invoiceProductIds.Intersect(parentProductIds); string pIds = ""; foreach (var p in productIds) { pIds += "'" + p + "',"; } pIds = pIds.TrimEnd(','); if (string.IsNullOrEmpty(pIds)) { return(null); } return(productManager.SelectCustomerProductNameByProductIds(pIds).TrimEnd(',')); }