using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.Text;
using siemensSapService.orm;
using siemensSapService.aspEntity;

using logtxtWrite;
using Newtonsoft.Json;
using System.Diagnostics;
using System.IO;

namespace siemensSapService.wcf
{
    // 注意: 使用“重构”菜单上的“重命名”命令，可以同时更改代码和配置文件中的类名“sapWcf”。
    public class sapWcf : IsapWcf
    {
        /// <summary>
        /// 添加出库单,被 张展的iWareSAP服务调用
        /// </summary>
        /// <param name="sale">要添加的plckList</param>
        /// <returns></returns>
        public string pickList(SaleOrder sale)
        {
            string result = "";
            #region 验证传入参数/合并相同物料
            if (sale.saleChild.Count == 0)
            {
                result = "出库明细数量为0!";
                logtxt.txtWrite("类名：sapWcf，函数名： pickList：收到数量是0", 2);
                return result;
            }
            #region 合并相同物料编号的数据
            //PICKlist child临时变量
            List<SaleOrderList> convertPickLIST = new List<SaleOrderList>();
            //按物料编号分组
            var PickList = sale.saleChild.GroupBy(x => x.materialCode);
            foreach (var convertItem in PickList)
            {
                for (int i = 1; i < convertItem.ToList().Count; i++)
                {
                    //数量合并到第一个
                    convertItem.ToList()[0].exitQty += convertItem.ToList()[i].exitQty;
                }
                convertPickLIST.Add(convertItem.ToList()[0]);
            }
            sale.saleChild = convertPickLIST;
            #endregion

            #endregion
            logtxt.txtWrite("类名：sapWcf，函数名： pickList：收到" + sale.saleChild.Count + "条数据", 0);
            try
            {

                using (dbModel mod = new dbModel())
                {
                    //出库单号/生成订单号
                    string orderCode = sale.orderNumber;
                    Sale_Order checkList = mod.Sale_Order.FirstOrDefault(x => x.OrderCode == orderCode);
                    List<string> rstPo = sale.saleChild.Select(x => x.materialCode).ToList();
                    //查找物料基础数据  找到po明细物料编号在数据库里有的集合
                    var checkMateria1s = (from p in mod.Base_ProductInfo
                                          where
                                              (from f in rstPo select f).Contains(p.ProductCode)
                                          select p).ToList();
                    //有就修改没有就新建
                    string trackingNum = "";
                    if (checkList != null)
                    {
                        //检查明细有就修改没有就新建
                        List<Sale_OrderList> checkLists = mod.Sale_OrderList.Where(x => x.Order_Id == checkList.Order_Id).ToList();
                        //if (checkLists.Count < 1)
                        //{
                        //    logtxt.txtWrite("类名：sapWcf，函数名： pickList：更新出库单明细为" + sale.saleChild.Count + "条数据", 2);
                        //}

                        checkList.MaterialCount = sale.orderQuantity;//出库套数
                        //int unb = 0;//计数
                        foreach (var item in sale.saleChild)
                        {
                            string materialCode = item.materialCode;
                            //unb++;
                            Sale_OrderList isHave = checkLists.FirstOrDefault(x => x.ProductCode == item.materialCode);

                            if (isHave != null)
                            {
                                //if (item.materialCode=="A7EQD-5170027509")
                                //{
                                //    decimal aa=item.exitQty;
                                //}
                                #region 修改出库单数据
                                //  isHave.ExtendField06 = item.saleItem;//销售项号
                                isHave.ProductCode = materialCode;//物料编号
                                isHave.SmallUnit = item.stockUnit;//库存单位
                                isHave.ValidQuantity = item.exitQty - isHave.QuantityShipped + isHave.ValidQuantity;//未出库数量 extendField03
                                isHave.QuantityShipped = item.exitQty;//预出库数量 extendField03
                                isHave.ModifyDate = DateTime.Now;
                                isHave.ExtendField09 = item.storageLocation;//G028 库区
                                continue;
                                #endregion
                            }
                            else
                            {
                                #region 新增出库单
                                string materialName = "sapPickList物料";

                                long productId = 0;
                                //查询物料找物料ID 没有就新建一个物料
                                Base_ProductInfo checkMateria = checkMateria1s.FirstOrDefault(x => x.ProductCode == materialCode);
                                if (checkMateria != null)
                                {
                                    productId = checkMateria.Product_Id;
                                    materialName = checkMateria.ProductName;
                                }
                                else
                                {
                                    #region 检查物料基础信息里是否有这个物料没有就新建
                                    Base_ProductInfo newMateria = new Base_ProductInfo();
                                    newMateria.ProductCode = materialCode;//物料编号
                                    newMateria.ProductName = materialName;//物料名称
                                    newMateria.SmallUnit = item.stockUnit;//库存单位
                                    newMateria.UnitConvert = 1M;
                                    newMateria.BigUnit = item.stockUnit;//采购单位
                                    newMateria.Enable = 1;//设置为可用
                                    ///////////////
                                    newMateria.Brand_Id = 0;//库存预警量
                                    newMateria.ProductModel = materialCode;
                                    newMateria.Provider_Id = 926;
                                    newMateria.ProviderCode = "PV201940371";
                                    newMateria.ProviderShortName = "默认供应商";
                                    newMateria.Consignor_Id = 30;
                                    newMateria.ConsignorCode = "GX30";
                                    newMateria.ConsignorName = "广州西门子";
                                    newMateria.UserProduct_Id = 1007;
                                    newMateria.UserProductCode = "100000001";
                                    mod.Base_ProductInfo.Add(newMateria);
                                    mod.SaveChanges();
                                    //通过新建获取产品ID
                                    productId = newMateria.Product_Id;
                                    #endregion
                                }
                                if (productId == 0)
                                {
                                    continue;//没这个物料到循环尾
                                }
                                if (trackingNum == "")//一个出库单只有一个跟踪号,只需要匹配一次 
                                {
                                    Purchase_OrderList saleList = mod.Purchase_OrderList.FirstOrDefault(x => x.ExtendField07 == sale.saleCode && x.SpecAlias == item.saleItem);
                                    trackingNum = saleList == null ? "" : saleList.ExtendField04;
                                }
                                int saleItem = 0;
                                bool saleitemis0 = Int32.TryParse(item.saleItem, out saleItem);
                                Sale_OrderList orderList = new Sale_OrderList();
                                orderList.Order_Id = checkList.Order_Id;
                                orderList.ExtendField06 = item.saleItem;//销售项号
                                orderList.ProductCode = materialCode;//物料编号
                                orderList.ProductName = materialName;//物料名称
                                orderList.SmallUnit = item.stockUnit;//库存单位
                                orderList.QuantityShipped = item.exitQty;//预出库数量 extendField03
                                orderList.ValidQuantity = item.exitQty;//未出库数量 extendField03
                                orderList.ExtendField03 = "新建";
                                orderList.ExtendField01 = "261";//移动类型
                                orderList.ExtendField09 = item.storageLocation;//G028 库区
                                orderList.CreateDate = DateTime.Now;
                                orderList.TrackingNumber = saleItem > 0 ? trackingNum : "";//跟踪号
                                orderList.SaleCode = sale.saleCode;//销售单
                                orderList.ExtendField10 = item.batch;//保留项号
                                //不为空的垃圾字段
                                orderList.Product_Id = productId;
                                orderList.ProductModel = materialCode;
                                mod.Sale_OrderList.Add(orderList);
                                #endregion
                            }
                        }
                        int numList = mod.SaveChanges();
                    }
                    else
                    {
                        string productCode = sale.productNumber;
                        Base_ProductInfo findProduct = mod.Base_ProductInfo.FirstOrDefault(x => x.ProductCode == productCode);
                        string productName = "未找到产品名称";
                        if (findProduct != null)
                        {
                            productName = findProduct.ProductName;
                        }
                        Sale_Order saleOrder = new Sale_Order();
                        #region pickList主表
                        saleOrder.OrderCode = orderCode;//出库单号 =生产订单号=提料单号 800开头的号
                        saleOrder.MaterialCount = sale.orderQuantity;//订单出库套数
                        saleOrder.SaleCode = sale.saleCode;//销售单号
                        saleOrder.StoreName = sale.ReservationNumber;//保留号
                        saleOrder.DeptName = productName;//(产品名称)物料描述
                        saleOrder.PriorityNo = 0;//优先级
                        saleOrder.OrderType = "SAP生产订单";//单据类型
                        saleOrder.StorageName = "立体库";
                        saleOrder.StatusID = 1;//状态ID
                        saleOrder.StatusText = "新建";
                        saleOrder.Client_Id = 0;//已出库套数
                        //不可为空垃圾字段
                        saleOrder.Storage_Id = 87;
                        saleOrder.Consignor_Id = 30;
                        saleOrder.ConsignorCode = "HZ20180002";
                        saleOrder.ConsignorName = "默认货主";
                        saleOrder.UserProduct_Id = 1007;
                        saleOrder.CreateID = 1;
                        saleOrder.Creator = "超级管理员";
                        saleOrder.CreateDate = DateTime.Now;
                        #endregion
                        #region 添加明细

                        foreach (var item in sale.saleChild)
                        {
                            #region 检查物料基础信息里是否有这个物料没有就新建
                            long productId = 0;
                            string materialCode = item.materialCode;
                            string materialName = "sapPickList物料";
                            //查询物料找物料ID 没有就新建一个物料
                            Base_ProductInfo checkMateria = checkMateria1s.FirstOrDefault(x => x.ProductCode == materialCode);
                            if (checkMateria != null)
                            {
                                productId = checkMateria.Product_Id;
                                materialName = checkMateria.ProductName;
                            }
                            else
                            {
                                #region 新建
                                Base_ProductInfo newMateria = new Base_ProductInfo();
                                newMateria.ProductCode = materialCode;//物料编号
                                newMateria.ProductName = materialName;//物料名称
                                newMateria.SmallUnit = item.stockUnit;//库存单位
                                newMateria.UnitConvert = 1M;
                                newMateria.BigUnit = item.stockUnit;//采购单位
                                newMateria.Enable = 1;//设置为可用
                                ///////////////
                                newMateria.Brand_Id = 0;//库存预警量
                                newMateria.ProductModel = materialCode;
                                newMateria.Provider_Id = 926;
                                newMateria.ProviderCode = "PV201940371";
                                newMateria.ProviderShortName = "默认供应商";
                                newMateria.Consignor_Id = 30;
                                newMateria.ConsignorCode = "GX30";
                                newMateria.ConsignorName = "广州西门子";
                                newMateria.UserProduct_Id = 1007;
                                newMateria.UserProductCode = "100000001";
                                mod.Base_ProductInfo.Add(newMateria);
                                mod.SaveChanges();
                                //通过新建获取产品ID
                                productId = newMateria.Product_Id;
                                #endregion
                            }
                            if (productId == 0)
                            {
                                continue;//没这个物料到循环尾
                            }
                            //查找跟踪号 
                            if (trackingNum == "")//一个出库单只有一个跟踪号只需要匹配一次
                            {
                                Purchase_OrderList saleList = mod.Purchase_OrderList.FirstOrDefault(x => x.ExtendField07 == sale.saleCode && x.SpecAlias == item.saleItem);
                                trackingNum = saleList == null ? "" : saleList.ExtendField04;
                            }

                            if (trackingNum != "")
                            {
                                saleOrder.TrackingNumber = trackingNum;
                            }
                            #endregion
                            int saleItem = 0;
                            bool saleitemis0 = Int32.TryParse(item.saleItem, out saleItem);
                            Sale_OrderList orderList = new Sale_OrderList();
                            orderList.ExtendField06 = item.saleItem;//销售项号
                            orderList.ProductCode = materialCode;//物料编号
                            orderList.ProductName = materialName;//物料名称
                            orderList.SmallUnit = item.stockUnit;//库存单位
                            orderList.QuantityShipped = item.exitQty;//预出库数量 extendField03
                            orderList.ValidQuantity = item.exitQty;//未出库数量 extendField03
                            orderList.ExtendField03 = "新建";
                            orderList.ExtendField01 = "261";//移动类型
                            orderList.ExtendField09 = item.storageLocation;//G028 库区
                            orderList.TrackingNumber = saleItem > 0 ? trackingNum : "";//跟踪号 

                            orderList.SaleCode = sale.saleCode;//销售单
                            orderList.ExtendField10 = item.batch;//保留项号
                            orderList.CreateDate = DateTime.Now;
                            //不为空的垃圾字段
                            orderList.Product_Id = productId;
                            orderList.ProductModel = materialCode;
                            saleOrder.Sale_OrderList.Add(orderList);
                        }
                        #endregion
                        mod.Sale_Order.Add(saleOrder);
                        int numList = mod.SaveChanges();
                    }


                }
            }
            catch (Exception ex)
            {
                //logtxt.txtWrite("类名：sapWcf，函数名： pickList：发生异常" + JsonConvert.SerializeObject(sale) + ex.ToString(), 2);
                //logtxt.txtWrite("类名：sapWcf，函数名： pickList：发生异常" + JsonConvert.SerializeObject(sale) + ex.ToString(), 2);
                //logtxt.txtWrite("类名：sapWcf，函数名： pickList：收到" + sale.saleChild.Count + "条数据,出现异常:" + ex.Message + ",堆栈:" + ex.StackTrace, 0);
                logtxt.txtWrite("类名：sapWcf，函数名： pickList：收到" + sale.saleChild.Count + "条数据,出现异常:" + ex.Message, 0);
                result = DateTime.Now.ToString() + "导入出库单异常" + ex.Message;
            }
            logtxt.txtWrite("类名：sapWcf，函数名： pickList：收到" + sale.saleChild.Count + "条数据,执行完毕:" + result, 0);
            return result;
        }
        /// <summary>
        /// 添加物料
        /// </summary>
        /// <param name="material">要添加的物料集合</param>
        /// <returns></returns>
        public string addMaterial(List<Material> materials)
        {
            string result = "";
            try
            {
                if (materials.Count == 0)
                {
                    //return result = "没有传入数据";
                    return result = "";//返回成功 【EditBy shaocx,2022-06-17】
                }
                //记录次数
                using (dbModel mod = new dbModel())
                {
                    int num = 0;
                    foreach (var item in materials)
                    {
                        num++;
                        if (item.materialCode == null)
                        {
                            result += "第" + num + "条数据:物料编号为空\r\n";
                            continue;
                        }
                        string materialCode = item.materialCode;

                        Base_ProductInfo checkMateria = mod.Base_ProductInfo.Where(x => x.ProductCode == materialCode).FirstOrDefault();
                        //已存在物料就修改 ,没有就新建
                        if (checkMateria != null)
                        {
                            checkMateria.ProductName = item.materialName;//物料名称
                            checkMateria.Weight = item.weight;//重量
                            checkMateria.BigUnit = item.purchaseUnit;//采购单位
                            checkMateria.SmallUnit = item.stockUnit;//库存单位
                            checkMateria.TypeName = item.Category;//物料类别;
                            checkMateria.Creator = item.creator;//创建人
                            continue;
                        }
                        Base_ProductInfo material = new Base_ProductInfo();
                        material.ProductCode = item.materialCode;//物料编号
                        material.ProductName = item.materialName;//物料名称
                        material.Weight = item.weight;//重量
                        material.TypeName = item.Category;//物料类别;
                        material.Brand_Id = 0;//库存预警量
                        material.BigUnit = item.purchaseUnit;//采购单位
                        material.SmallUnit = item.stockUnit;//库存单位
                        material.Creator = item.creator;//创建人
                        material.CreateDate = DateTime.Now;
                        material.Enable = 1;//启用
                        material.UnitConvert = 1;//单位转换
                        //不为空的垃圾字段
                        material.Provider_Id = 926;
                        material.ProviderCode = "PV201940371";
                        material.ProviderShortName = "默认供应商";
                        material.UserProduct_Id = 1007;
                        material.ProductModel = item.materialCode;
                        material.Consignor_Id = 30;
                        material.ConsignorCode = "GX30";
                        material.ConsignorName = "广州西门子";
                        mod.Base_ProductInfo.Add(material);
                    }
                    mod.SaveChanges();
                }

                //writeTxt.writeInfo("addMaterial", INFO);
            }
            catch (Exception ex)
            {
                result += "\r\n" + ex.Message;
            }
            return result;
        }
        /// <summary>
        /// 库存盘点,此接口被张展的iWareSAP所调用
        /// </summary>
        /// <param name="stockQuantity">要核对的数据</param>
        /// <returns>成功返回"",否则返回错误信息</returns>
        public string takeStock(List<ProductStock> stockQuantity)
        {
            //logtxt.txtWrite("类名：sapWcf，函数名： takeStock：收到盘点数据", 0);
            Log4NetHelper.WriteInfoLog(LogType.TakeStock, "收到盘点数据:" + JsonConvert.SerializeObject(stockQuantity));

            Stopwatch deviceSw = new Stopwatch();
            deviceSw.Start();//运行计算器开始记时
            List<ProductStock> sapInfo = new List<ProductStock>();
            #region 读取本地SA[库存盘点txt
            //var files = Directory.GetFiles("D:\\log_ShuYing");
            //注意：是按照创建时间降序排列
            var files = Directory.GetFiles("D:\\log_takeStock").OrderByDescending(x => new FileInfo(x).CreationTime).ToList();//盘点存放文件改为 log_takeStock 【EditBy shaocx,2022-10-12】
            if (files.Count < 1)
            {
                //logtxt.txtWrite("类名：sapWcf，函数名： takeStock：收到数据为空 条", 2);
                Log4NetHelper.WriteInfoLog(LogType.TakeStock, "收到数据为空");
                return "";
            }

            var filePath = files[0];
            var fileName = Path.GetFileName(filePath);
            using (var reader = new StreamReader(filePath))
            {
                var line = reader.ReadLine();
                if (line.StartsWith("MATNR"))
                {
                    while (!string.IsNullOrEmpty(line))
                    {
                        if (!line.StartsWith("MATNR"))
                        {
                            var spliterChar = Encoding.UTF8.GetString(new byte[] { 9 });
                            var args = line.Split(spliterChar.ToCharArray());
                            if (args[7] == "3TG1" && args[8] == "G021")
                            {
                                try
                                {
                                    ProductStock stock = new ProductStock();
                                    stock.SaleCode = args[11];
                                    if (args[12] == "")
                                    {
                                        stock.SaleItem = args[12];
                                    }
                                    else
                                    {
                                        stock.SaleItem = Convert.ToInt32(args[12]) < 1 ? "" : args[12];
                                    }
                                    stock.materialCode = args[0];
                                    stock.materialName = args[1];
                                    stock.stockUnit = args[6];
                                    stock.stockQuantity = decimal.Parse(args[19]);
                                    sapInfo.Add(stock);
                                }
                                catch (Exception)
                                {

                                }

                            }
                        }
                        line = reader.ReadLine();
                    }
                }
                else
                {
                    return "";
                }
            }
            #endregion

            if (sapInfo.Count < 1)
            {
                //logtxt.txtWrite("类名：sapWcf，函数名： sapInfo：转换数据为空 条", 2);
                Log4NetHelper.WriteInfoLog(LogType.TakeStock, "sapInfo：转换数据为空");
                return "";
            }
            string result = "";
            try
            {
                using (dbModel mod = new dbModel())//productCode
                {

                    // DateTime todayTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));//今天凌晨时间
                    //删除之前的 盘点数据
                    string sql = "truncate table TakeStock ";
                    mod.Database.ExecuteSqlCommand(sql);

                    //立库库存数据
                    List<vvBase_ProductPosition> stockInfo = mod.vvBase_ProductPosition.Where(x => x.PositionType == 1 && x.ProductStorage > 0).ToList();
                    #region 合并相同项
                    List<vvBase_ProductPosition> stockInfoMerge = new List<vvBase_ProductPosition>();
                    var merge = stockInfo.GroupBy(x => new { x.SaleCode, x.ExtendField08, x.ProductCode });
                    foreach (var item in merge)
                    {
                        vvBase_ProductPosition temporaryStock = new vvBase_ProductPosition();
                        if (item.ToList().Count > 1)
                        {

                            for (int k = 1; k < item.ToList().Count; k++)
                            {
                                temporaryStock.ProductStorage = item.ToList()[0].ProductStorage + item.ToList()[k].ProductStorage;
                            }
                        }
                        else
                        {
                            temporaryStock.ProductStorage = item.ToList()[0].ProductStorage;
                        }
                        temporaryStock.SmallUnit = item.ToList()[0].SmallUnit;
                        temporaryStock.ProductCode = item.ToList()[0].ProductCode;
                        temporaryStock.ProductName = item.ToList()[0].ProductName;
                        temporaryStock.SaleCode = item.ToList()[0].SaleCode;
                        temporaryStock.ExtendField08 = item.ToList()[0].ExtendField08;
                        stockInfoMerge.Add(temporaryStock);
                    }
                    int aa = mod.SaveChanges();
                    #endregion

                    //SAP传过来的 销售单下数据

                    //立库库存里和sap数据对应的项
                    List<vvBase_ProductPosition> stockInfoIdentical = stockInfoMerge.Where(p => sapInfo.Any(x => x.SaleCode == p.SaleCode &&
                        x.SaleItem == p.ExtendField08 && x.stockQuantity == p.ProductStorage && x.materialCode == p.ProductCode)).ToList();
                    //SAP库存和立库库存里数据对应的项
                    List<ProductStock> sapInfoIdentical = sapInfo.Where(p => stockInfoMerge.Any(x => x.SaleCode == p.SaleCode && x.ExtendField08 == p.SaleItem &&
                        x.ProductStorage == p.stockQuantity && x.ProductCode == p.materialCode)).ToList();

                    #region 移除相同项
                    if (stockInfoIdentical.Count > 0)//移除立库库存相同项
                    {
                        logtxt.txtWrite("类名：sapWcf，函数名： takeStock：盘点库存都相同的数据有:" + stockInfoIdentical.Count + "条", 0);
                        foreach (var itemRE in stockInfoIdentical)
                        {
                            stockInfoMerge.Remove(itemRE);
                        }
                    }
                    if (sapInfoIdentical.Count > 0)//移除SAP库存相同项
                    {
                        foreach (var itemRE in sapInfoIdentical)
                        {
                            sapInfo.Remove(itemRE);
                        }

                    }
                    #endregion
                    //----------------------------------------------------------------------------------------------------------  
                    //立库库存里和sap跟踪号和物料号对应且数量不对应的项
                    List<vvBase_ProductPosition> stockInfoIdentical2 = stockInfoMerge.Where(p => sapInfo.Any(x => x.SaleCode == p.SaleCode &&
                     x.SaleItem == p.ExtendField08 && x.materialCode == p.ProductCode)).ToList();
                    //SAP库存和立库库存里跟踪号和物料号对应且数量不对应的项
                    List<ProductStock> sapInfoIdentical2 = sapInfo.Where(p => stockInfoMerge.Any(x => x.SaleCode == p.SaleCode &&
                        x.ExtendField08 == p.SaleItem && x.ProductCode == p.materialCode)).ToList();
                    int matching = 0;//记录匹配失败的数量
                    aa = mod.SaveChanges();
                    TakeStock checkStatistics = new TakeStock();
                    checkStatistics.MateralName = "排除相同数据:" + stockInfoIdentical.Count + "条，数量差异数据:" + stockInfoIdentical2.Count + "条, " + "仅立库数据:" + stockInfoMerge.Count +
                        "条, " + "仅SAP数据：" + sapInfo.Count + "条。";
                    checkStatistics.CreateDate = DateTime.Now;//创建时间
                    mod.TakeStock.Add(checkStatistics);
                    int a = mod.SaveChanges();
                    if (sapInfoIdentical2.Count > 0)
                    {
                        #region 移除跟踪号和物料号对应且数量不对应的项
                        if (stockInfoIdentical2.Count > 0)//移除立库库存里和sap跟踪号和物料号对应且数量不对应的项
                        {
                            logtxt.txtWrite("类名：sapWcf，函数名： takeStock：盘点库存都相同的数据有:" + stockInfoIdentical2.Count + "条", 0);
                            foreach (var itemRE in stockInfoIdentical2)
                            {
                                stockInfoMerge.Remove(itemRE);
                            }
                        }
                        if (sapInfoIdentical2.Count > 0)//移除SAP库存和立库库存里跟踪号和物料号对应且数量不对应的项
                        {
                            foreach (var itemRE in sapInfoIdentical2)
                            {
                                sapInfo.Remove(itemRE);
                            }

                        }
                        #endregion
                        #region 写入匹配到的物料


                        for (int j = 0; j < sapInfoIdentical2.Count; j++)
                        {
                            //找出对应的立库库存数量
                            vvBase_ProductPosition stockInfoIdentical22 = stockInfoIdentical2.FirstOrDefault(x => x.ProductCode == sapInfoIdentical2[j].materialCode &&
                                x.SaleCode == sapInfoIdentical2[j].SaleCode && x.ExtendField08 == sapInfoIdentical2[j].SaleItem);
                            if (sapInfoIdentical2 != null)
                            {
                                TakeStock check = new TakeStock();
                                check.ProcureCode = sapInfoIdentical2[j].SaleCode;//采购单号
                                check.ProcureItem = sapInfoIdentical2[j].SaleItem;//采购项号
                                check.MateralCode = sapInfoIdentical2[j].materialCode;//物料编号
                                check.MateralName = sapInfoIdentical2[j].materialName;//物料名称
                                check.Unit = stockInfoIdentical22.SmallUnit;//库存单位
                                check.SapQuantity = sapInfoIdentical2[j].stockQuantity;//SAP数量
                                check.Ex1 = stockInfoIdentical22.SmallUnit;//SAP单位
                                check.StockQuantity = stockInfoIdentical22.ProductStorage;//库存数量
                                // check.Ex2 = sapInfo[j].isStock == 1 ? "常规货位" : "暂存区";//库存单位
                                check.CreateDate = DateTime.Now;//创建时间
                                mod.TakeStock.Add(check);
                            }
                            else
                            {
                                matching++;
                            }

                        }
                        if (matching > 0)
                        {
                            logtxt.txtWrite("类名：sapWcf，函数名： takeStock：相同项数量不同写入库存 匹配失败数量：" + matching + "条", 2);
                        }
                        #endregion
                    }
                    mod.SaveChanges();
                    #region 判断库存里有的,sap里没有的物料,如果有就写入到盘点表里
                    //
                    if (stockInfoMerge.Count > 0)
                    {
                        foreach (var stock in stockInfoMerge)
                        {
                            TakeStock check = new TakeStock();
                            check.ProcureCode = stock.SaleCode;//销售单号
                            check.ProcureItem = stock.ExtendField08;//销售项号
                            check.MateralCode = stock.ProductCode;//物料编号
                            check.MateralName = stock.ProductName;//物料名称
                            check.Unit = "";//SAP单位
                            check.SapQuantity = 0;//SAP数量
                            check.Ex1 = stock.SmallUnit;//库存单位
                            check.StockQuantity = stock.ProductStorage;//库存数量
                            check.CreateDate = DateTime.Now;//创建时间
                            mod.TakeStock.Add(check);
                        }
                    }

                    mod.SaveChanges();
                    #endregion

                    #region 写入SAP有的库存没有的数据总和

                    //判断有没有库存里有的,sap里没有的物料,如果有就写入到盘点表里
                    if (sapInfo.Count > 0)
                    {
                        foreach (var sapStock in sapInfo)
                        {
                            TakeStock check = new TakeStock();
                            check.ProcureCode = sapStock.SaleCode;//销售单号
                            check.ProcureItem = sapStock.SaleItem;//销售项
                            check.MateralCode = sapStock.materialCode;//物料编号
                            check.MateralName = sapStock.materialName;//物料名称
                            check.Unit = sapStock.stockUnit;//SAP单位
                            check.SapQuantity = sapStock.stockQuantity;//SAP数量
                            check.Ex1 = "";//库存单位
                            check.StockQuantity = 0;//库存数量
                            check.CreateDate = DateTime.Now;//创建时间
                            mod.TakeStock.Add(check);
                        }
                    }
                    #endregion
                    int resultNum = mod.SaveChanges();
                    if (resultNum < 1)
                    {
                        result = "保存失败";
                    }
                    //logtxt.txtWrite("类名：sapWcf，函数名： takeStock：盘点库存计算时间:" + deviceSw.Elapsed.ToString(), 0);
                    Log4NetHelper.WriteInfoLog(LogType.TakeStock, "类名：sapWcf，函数名： takeStock：盘点库存计算时间:" + deviceSw.Elapsed.ToString());
                    deviceSw.Stop();


                    //处理成功后，将所有文件删除
                    var remove_files = Directory.GetFiles("D:\\log_takeStock");
                    foreach (var item in remove_files)
                    {
                        File.Delete(item);//文件删除
                    }
                }
            }
            catch (Exception ex)
            {
                //logtxt.txtWrite("类名：sapWcf，函数名： takeStock：异常" + ex.ToString() + ex.StackTrace.ToString(), 2);
                Log4NetHelper.WriteErrorLog(LogType.TakeStock, "类名：sapWcf，函数名： takeStock：异常:" + ex.Message, ex);
                result += "\r\n" + ex.Message;
            }

            return result;

        }
    }
}