Esempio n. 1
0
        public string InventorySync(List <SALES_ORDER_DATAMODEL> salesOrderDatas, List <SALESOUT_DATAMODEL> salesoutDatas, List <TP_INVENTORYMODEL> inventorys)
        {
            try
            {
                foreach (var model in salesOrderDatas)
                {
                    sales_order_dataModel newmodel = new sales_order_dataModel();
                    newmodel.fid                  = PublicMethod.GetInt(model.FID);
                    newmodel.Part_name            = PublicMethod.GetString(model.PART_NAME);
                    newmodel.PRIME_COMMODITY_NAME = PublicMethod.GetString(model.PRIME_COMMODITY_NAME);
                    newmodel.fqty                 = PublicMethod.GetDecimal(model.FQTY);
                    newmodel.ftime                = PublicMethod.GetDateTime(model.FTIME);
                    newmodel.funit                = PublicMethod.GetString(model.FUNIT);
                    //LogHelper.WriteLog(JsonHelper.ToJson(newmodel));
                    sales_order_dataDal.Instance.InsertEx(newmodel);
                }

                foreach (var model in salesoutDatas)
                {
                    salesout_dataModel newmodel = new salesout_dataModel();
                    newmodel.fid                  = PublicMethod.GetInt(model.FID);
                    newmodel.fdate                = PublicMethod.GetDateTime(model.FDATE);
                    newmodel.Part_name            = model.PART_NAME;
                    newmodel.PRIME_COMMODITY_NAME = model.PRIME_COMMODITY_NAME;
                    newmodel.fqty                 = PublicMethod.GetDecimal(model.FQTY);
                    newmodel.Shipping_date        = PublicMethod.GetDateTime(model.SHIPPING_DATE);
                    newmodel.funit                = model.FUNIT;
                    newmodel.COLOR_NO             = model.COLOR_NO;
                    // LogHelper.WriteLog(JsonHelper.ToJson(newmodel));
                    salesout_dataDal.Instance.InsertEx(newmodel);
                }

                foreach (var model in inventorys)
                {
                    TP_inventoryModel newmodel = new TP_inventoryModel();
                    newmodel.fid                  = PublicMethod.GetInt(model.FID);
                    newmodel.Part_name            = model.PART_NAME;
                    newmodel.PRIME_COMMODITY_NAME = model.PRIME_COMMODITY_NAME;
                    newmodel.fqty                 = PublicMethod.GetDecimal(model.FQTY);
                    newmodel.ftime                = PublicMethod.GetDateTime(model.FTIME);
                    newmodel.funit                = model.FUNIT;
                    //LogHelper.WriteLog(JsonHelper.ToJson(newmodel));
                    TP_inventoryDal.Instance.InsertEx(newmodel);
                }

                LogHelper.WriteLog("123123");

                return(JsonHelper.ToJson(new { errCode = 0, errMsg = "上传成功!" }));
            }
            catch (Exception ex)
            {
                LogHelper.WriteLog(ex);
                throw ex;
            }
        }