예제 #1
0
        ///// <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(','));
        }
예제 #2
0
        /// <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(','));
        }