コード例 #1
0
ファイル: DefaultYXDRTransData.cs プロジェクト: ChainSong/WMS
        //new PreOrderService().ManualAllocationJson(new ManualAllocationRequest()
        //{ PodRequest = pod, ID = Convert.ToInt64(ID), CustomerId = CustomerId, Creator = base.UserInfo.Name, Criterion = Criterion });
        public override void CustomerDefinedSettledTransData(ref string message)
        {
            if (TransDataType == "PreOrder")
            {
                #region
                if (WareHouseID == 0)
                {
                    message = "用户没有分配仓库!!";
                    return;
                }
                WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseList().Where(m => m.ID == WareHouseID).FirstOrDefault();//customerid获取仓库
                IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);
                WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0];
                DataSet   dsResualt = new DataSet();
                DataTable dtpo      = new DataTable();
                dtpo.TableName = "预出库单主信息$";
                DataTable dtpodetail = new DataTable();
                dtpodetail.TableName = "预出库单明细信息$";

                DataTable dtNike = Transdata.Tables[0];
                //List<ProductSearch> searprolistfs = new List<ProductSearch>();
                //for (int i = 0; i < dtNike.Rows.Count; i++)
                //{
                //    ProductSearch psfs = new ProductSearch();
                //    psfs.Str10 = dtNike.Rows[i]["Style Color"].ToString();
                //    psfs.Str9 = dtNike.Rows[i]["Size"].ToString();
                //    psfs.Str8 = "01";
                //    searprolistfs.Add(psfs);
                //}
                //IEnumerable<ProductSearch> productListfs = ApplicationConfigHelper.GetSearchProduct(CustomerID, searprolistfs, "Acticle");

                dtpo.Columns.Add("外部单号");
                dtpo.Columns.Add("预出库单类型");
                dtpo.Columns.Add("仓库名称");
                dtpo.Columns.Add("订单日期");
                dtpo.Columns.Add("省");
                dtpo.Columns.Add("市");
                dtpo.Columns.Add("联系人");
                dtpo.Columns.Add("快递公司");
                dtpo.Columns.Add("备注");
                dtpo.Columns.Add("自定义字段2");
                dtpo.Columns.Add("自定义字段3");
                dtpo.Columns.Add("自定义字段4");
                dtpo.Columns.Add("地址");
                dtpo.Columns.Add("联系方式");
                dtpo.Columns.Add("自定义字段5");
                dtpo.Columns.Add("自定义字段6");
                dtpo.Columns.Add("自定义字段7");

                dtpodetail.Columns.Add("外部单号");
                dtpodetail.Columns.Add("仓库");
                dtpodetail.Columns.Add("SKU");
                dtpodetail.Columns.Add("UPC");
                dtpodetail.Columns.Add("产品等级");
                dtpodetail.Columns.Add("产品名称");
                dtpodetail.Columns.Add("批次号");
                dtpodetail.Columns.Add("托号");
                dtpodetail.Columns.Add("备注");
                dtpodetail.Columns.Add("期望数量");
                dtpodetail.Columns.Add("自定义字段4");
                dtpodetail.Columns.Add("自定义字段5");
                dtpodetail.Columns.Add("自定义字段6");
                dtpodetail.Columns.Add("自定义字段7");
                dtpodetail.Columns.Add("单位");
                dtpodetail.Columns.Add("规格");

                for (int i = 0; i < dtNike.Rows.Count; i++)
                {
                    if (dtpo.Select("外部单号='" + dtNike.Rows[i]["出库订单号"].ToString() + "'").Count() <= 0)
                    {
                        DataRow dr = dtpo.NewRow();
                        dr["外部单号"] = dtNike.Rows[i]["出库订单号"].ToString();
                        switch (dtNike.Rows[i]["订单类别"].ToString())
                        {
                        case "2":
                            dr["预出库单类型"] = "门店调拨出库";
                            break;

                        case "6":
                            dr["预出库单类型"] = "退仓出货";
                            break;

                        default:
                            dr["预出库单类型"] = dtNike.Rows[i]["订单类别"].ToString();
                            break;
                        }
                        //dr["预出库单类型"] = dtNike.Rows[i]["订单类别"].ToString() == "2" ? "门店调拨出库" : "退仓出货";//1大仓退货 2门店调拨
                        dr["仓库名称"]   = warehouse.WarehouseName;
                        dr["市"]      = "";
                        dr["省"]      = "";
                        dr["联系人"]    = "";
                        dr["订单日期"]   = dtNike.Rows[i]["订单日期"].ToString();
                        dr["备注"]     = "";
                        dr["自定义字段2"] = dtNike.Rows[i]["门店代码"].ToString();
                        dr["自定义字段3"] = dtNike.Rows[i]["预计发货日期"].ToString();
                        dr["自定义字段4"] = dtNike.Rows[i]["客户要求到货日期"].ToString();
                        dr["地址"]     = "";
                        dr["自定义字段5"] = dtNike.Rows[i]["箱号"].ToString();
                        dr["联系方式"]   = "";
                        dr["自定义字段6"] = "";
                        dr["自定义字段7"] = "";
                        dtpo.Rows.Add(dr);
                    }

                    DataRow drdetail = dtpodetail.NewRow();
                    drdetail["外部单号"] = dtNike.Rows[i]["出库订单号"].ToString();
                    drdetail["仓库"]   = warehouse.WarehouseName;
                    drdetail["SKU"]  = dtNike.Rows[i]["SKU"].ToString();
                    drdetail["UPC"]  = "";
                    try
                    {
                        drdetail["产品等级"] = dtNike.Rows[i]["产品等级"].ToString();
                    }
                    catch
                    {
                        drdetail["产品等级"] = "A品";
                    }
                    drdetail["产品名称"]   = dtNike.Rows[i]["SKU"].ToString();
                    drdetail["批次号"]    = "";
                    drdetail["托号"]     = "";
                    drdetail["规格"]     = "";
                    drdetail["备注"]     = "";
                    drdetail["期望数量"]   = dtNike.Rows[i]["数量"].ToString();
                    drdetail["自定义字段4"] = dtNike.Rows[i]["箱号"].ToString();
                    drdetail["自定义字段5"] = dtNike.Rows[i]["Article"].ToString();
                    drdetail["自定义字段6"] = dtNike.Rows[i]["Size"].ToString();
                    drdetail["自定义字段7"] = dtNike.Rows[i]["物品类型"].ToString();
                    drdetail["单位"]     = wmsunit.Unit;
                    dtpodetail.Rows.Add(drdetail);
                }
                dsResualt.Tables.Add(dtpo);
                dsResualt.Tables.Add(dtpodetail);
                this.AfterData = dsResualt;
                #endregion
            }
            else if (TransDataType == "Asn")
            {
                #region 矩阵导入
                DataTable  dtNew  = new DataTable();
                DataRow    rowNew = dtNew.NewRow();
                DataColumn dc     = null;
                //dc = dtNew.Columns.Add("ID", Type.GetType("System.Int32"));
                //dc.AutoIncrement = true;//自动增加
                //dc.AutoIncrementSeed = 1;//起始为1
                //dc.AutoIncrementStep = 1;//步长为1
                //dc.AllowDBNull = false;//
                dc = dtNew.Columns.Add("类型", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("行号", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("单号", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("日期", Type.GetType("System.DateTime"));
                dc = dtNew.Columns.Add("sold", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("ship", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("客户", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("Article", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("SKU", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("BoxQty", Type.GetType("System.Int32"));
                dc = dtNew.Columns.Add("BoxNumber", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("收货人", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("地址", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("联系方式", Type.GetType("System.String"));
                dc = dtNew.Columns.Add("邮编", Type.GetType("System.String"));
                if (!string.IsNullOrEmpty(Transdata.Tables[0].Rows[0].ToString().Trim()) && Transdata.Tables[0].Rows[0][3].ToString().Trim() == "Z001")
                {
                    #region NIKE装箱单
                    List <ProductSearch> searprolistfs = new List <ProductSearch>();
                    for (int i = 11; i < Transdata.Tables[0].Rows.Count; i++)
                    {
                        ProductSearch psfs = new ProductSearch();
                        if (!string.IsNullOrEmpty(Transdata.Tables[0].Rows[i]["UPC"].ToString().Trim()))
                        {
                            psfs.SKU = Transdata.Tables[0].Rows[i]["UPC"].ToString().Trim();
                            //psfs.Str9 = dtNike.Rows[i]["Size"].ToString();
                            //psfs.Str8 = "01";
                            if (!searprolistfs.Exists(a => a.SKU == psfs.SKU))
                            {
                                searprolistfs.Add(psfs);
                            }
                        }
                    }
                    IEnumerable <ProductSearch> productListfs = ApplicationConfigHelper.GetSearchProductYXDR(CustomerID, searprolistfs, "SKU");

                    for (int j = 0; j < Transdata.Tables[0].Rows.Count; j++)
                    {
                        DataRow rowValue = Transdata.Tables[0].Rows[j];
                        if (string.IsNullOrEmpty(rowValue[0].ToString().Trim()))
                        {
                            continue;
                        }
                        #region 处理数据
                        rowNew["类型"]        = rowValue["OrderType"].ToString().Trim();//NIKE
                        rowNew["行号"]        = "";
                        rowNew["单号"]        = rowValue["ExternOrderKey"].ToString().Trim();
                        rowNew["日期"]        = System.DateTime.Now;
                        rowNew["sold"]      = "";
                        rowNew["ship"]      = "";
                        rowNew["客户"]        = "HADDA";
                        rowNew["Article"]   = rowValue["Style"].ToString().Trim();
                        rowNew["SKU"]       = rowValue["UPC"].ToString().Trim();
                        rowNew["收货人"]       = "";
                        rowNew["地址"]        = "";
                        rowNew["联系方式"]      = "";
                        rowNew["邮编"]        = "";
                        rowNew["BoxQty"]    = rowValue["QtyShipped"].ToString().Trim();
                        rowNew["BoxNumber"] = rowValue["LabelNo"].ToString().Trim();
                        dtNew.Rows.Add(rowNew.ItemArray);
                        #endregion
                    }
                    #region 转换
                    if (ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray().Count() <= 0)
                    {
                        message = "用户没有分配仓库!!";
                        return;
                    }
                    WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray()[0];//
                    IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);
                    WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0];
                    DataSet   dsResualt = new DataSet();
                    DataTable dtasn     = new DataTable();
                    dtasn.TableName = "预入库单主信息$";
                    DataTable dtasndetail = new DataTable();
                    dtasndetail.TableName = "预入库单明细信息$";

                    DataTable dtNike = dtNew;//

                    dtasn.Columns.Add("外部入库单号");
                    dtasn.Columns.Add("预入库单类型");
                    dtasn.Columns.Add("预入库日期");
                    dtasn.Columns.Add("仓库名称");
                    dtasn.Columns.Add("备注");
                    dtasn.Columns.Add("客户");

                    dtasndetail.Columns.Add("外部入库单号");
                    dtasndetail.Columns.Add("SKU");
                    dtasndetail.Columns.Add("UPC");
                    dtasndetail.Columns.Add("预收数量");
                    dtasndetail.Columns.Add("单位");
                    dtasndetail.Columns.Add("规格");
                    dtasndetail.Columns.Add("批次号");
                    dtasndetail.Columns.Add("托号");

                    for (int i = 0; i < dtNike.Rows.Count; i++)
                    {
                        if (dtNike.Rows[i]["单号"].ToString().Trim() != "" || dtNike.Rows[i]["SKU"].ToString().Trim() != "")
                        {
                            if (dtasn.Select("外部入库单号='" + dtNike.Rows[i]["单号"].ToString().Trim() + "'").Count() <= 0)
                            {
                                DataRow dr = dtasn.NewRow();
                                dr["外部入库单号"] = dtNike.Rows[i]["单号"].ToString().Trim();
                                dr["预入库单类型"] = dtNike.Rows[i]["类型"].ToString().Trim() == "Z001" ? "门店调拨入库" : dtNike.Rows[i][0].ToString().Trim();//入库暂时只有一种类型NIKE入库
                                dr["预入库日期"]  = dtNike.Rows[i]["日期"].ToString().Trim();
                                dr["仓库名称"]   = warehouse.WarehouseName;
                                dr["备注"]     = "";
                                dr["客户"]     = dtNike.Rows[i]["客户"].ToString().Trim();
                                dtasn.Rows.Add(dr);
                            }

                            DataRow drdetail = dtasndetail.NewRow();
                            drdetail["外部入库单号"] = dtNike.Rows[i]["单号"].ToString().Trim();
                            drdetail["SKU"]    = dtNike.Rows[i]["SKU"].ToString().Trim();
                            drdetail["UPC"]    = "";
                            drdetail["预收数量"]   = dtNike.Rows[i]["BoxQty"].ToString().Trim();
                            drdetail["单位"]     = "";
                            drdetail["规格"]     = "";
                            drdetail["批次号"]    = "";
                            drdetail["托号"]     = dtNike.Rows[i]["BoxNumber"].ToString().Trim();
                            dtasndetail.Rows.Add(drdetail);
                        }
                    }
                    dsResualt.Tables.Add(dtasn);
                    dsResualt.Tables.Add(dtasndetail);
                    this.AfterData = dsResualt;
                    #endregion

                    #endregion
                }
                else
                {
                    #region 普通装箱单
                    for (int r = 11; r < Transdata.Tables[0].Rows.Count; r++)
                    {
                        if (!string.IsNullOrEmpty(Transdata.Tables[0].Rows[r][0].ToString()))
                        {
                            for (int c = 1; c < 6; c++)
                            {
                                if (string.IsNullOrEmpty(Transdata.Tables[0].Rows[r][c].ToString()))
                                {
                                    message = (r + 2) + "行" + (c + 1) + "列有空值!";
                                    return;
                                }
                            }
                        }
                    }
                    List <ProductSearch> searprolistfs = new List <ProductSearch>();
                    for (int i = 11; i < Transdata.Tables[0].Rows.Count; i++)
                    {
                        ProductSearch psfs = new ProductSearch();
                        if (!string.IsNullOrEmpty(Transdata.Tables[0].Rows[i][0].ToString().Trim()))
                        {
                            psfs.Str10 = Transdata.Tables[0].Rows[i][0].ToString().Trim();
                            //psfs.Str9 = dtNike.Rows[i]["Size"].ToString();
                            //psfs.Str8 = "01";
                            if (!searprolistfs.Exists(a => a.Str10 == psfs.Str10))
                            {
                                searprolistfs.Add(psfs);
                            }
                        }
                    }
                    IEnumerable <ProductSearch> productListfs = ApplicationConfigHelper.GetSearchProductYXDR(CustomerID, searprolistfs, "Acticle");

                    for (int j = 11; j < Transdata.Tables[0].Rows.Count; j++)
                    {
                        DataRow rowValue = Transdata.Tables[0].Rows[j];
                        if (string.IsNullOrEmpty(rowValue[0].ToString().Trim()))
                        {
                            continue;
                        }
                        #region 处理数据
                        if (rowValue[0].ToString().Trim().Length >= 3)
                        {
                            string receiptnumber  = Transdata.Tables[0].Rows[1][2].ToString().Trim() + "-";
                            string receipttype    = Transdata.Tables[0].Rows[1][1].ToString().Trim();
                            string Article        = rowValue[0].ToString().Trim();
                            string Color          = rowValue[5].ToString().Trim();
                            int    boxNumberStart = Int32.Parse(rowValue[1].ToString().Trim());
                            int    boxNumberEnd   = Int32.Parse(rowValue[3].ToString().Trim());
                            int    boxCount       = Int32.Parse(rowValue[4].ToString().Trim());
                            //if ( dtNew.Select("Article='"+Article+"'").Count()<=0 )
                            //{
                            //    rowNew["单号"]=ordernumber + rowValue[0].ToString().Trim().Substring(rowValue[0].ToString().Trim().Length-1,rowValue[0].ToString().Trim().Length-4);
                            //}
                            rowNew["类型"]      = receipttype;
                            rowNew["行号"]      = "";
                            rowNew["单号"]      = receiptnumber + rowValue[0].ToString().Trim().Substring(rowValue[0].ToString().Trim().Length - 3, 3);
                            rowNew["日期"]      = System.DateTime.Now;
                            rowNew["sold"]    = "";
                            rowNew["ship"]    = "";
                            rowNew["客户"]      = "HADDA";
                            rowNew["Article"] = "Article";
                            rowNew["收货人"]     = "";
                            rowNew["地址"]      = "";
                            rowNew["联系方式"]    = "";
                            rowNew["邮编"]      = "";

                            //string Size = rowValue[0].ToString().Trim().Substring(rowValue[0].ToString().Trim().Length - 3, 3);
                            for (int jc = 6; jc <= 16; jc++)
                            {
                                if (!string.IsNullOrEmpty(rowValue[jc].ToString().Trim()))
                                {
                                    string size = Transdata.Tables[0].Rows[9][jc].ToString().Trim();
                                    if (productListfs.Where(a => a.Str10 == Article & a.Str9 == size & a.Str8 == Color).OrderByDescending(a => a.Str10).Select(a => a.SKU).Count() <= 0)
                                    {
                                        message = "款号" + Article + " 尺码" + size + " 颜色" + Color + " 不存在!!";
                                    }
                                    string SKU = productListfs.Where(a => a.Str10 == Article & a.Str9 == size & a.Str8 == Color).OrderByDescending(a => a.Str10).Select(a => a.SKU).FirstOrDefault().ToString();
                                    rowNew["SKU"] = SKU;
                                    if (boxCount == 1)
                                    {
                                        rowNew["BoxQty"]    = Int32.Parse(rowValue[jc].ToString().Trim());
                                        rowNew["BoxNumber"] = boxNumberStart.ToString();
                                        dtNew.Rows.Add(rowNew.ItemArray);
                                    }
                                    else
                                    {
                                        for (int i = boxNumberStart; i <= boxNumberEnd; i++)
                                        {
                                            rowNew["BoxQty"]    = Int32.Parse(rowValue[jc].ToString().Trim());
                                            rowNew["BoxNumber"] = i.ToString();
                                            dtNew.Rows.Add(rowNew.ItemArray);
                                        }
                                    }
                                }
                            }
                        }
                        else
                        {
                            message = "行" + j + ",款号长度不足或款号有误!!";
                            return;
                        }
                        #endregion
                    }
                    #endregion
                    #region 转换
                    if (ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray().Count() <= 0)
                    {
                        message = "用户没有分配仓库!!";
                        return;
                    }
                    WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray()[0];//
                    IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);
                    WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0];
                    DataSet   dsResualt = new DataSet();
                    DataTable dtasn     = new DataTable();
                    dtasn.TableName = "预入库单主信息$";
                    DataTable dtasndetail = new DataTable();
                    dtasndetail.TableName = "预入库单明细信息$";

                    DataTable dtNike = dtNew;//

                    dtasn.Columns.Add("外部入库单号");
                    dtasn.Columns.Add("预入库单类型");
                    dtasn.Columns.Add("预入库日期");
                    dtasn.Columns.Add("仓库名称");
                    dtasn.Columns.Add("备注");
                    dtasn.Columns.Add("客户");

                    dtasndetail.Columns.Add("外部入库单号");
                    dtasndetail.Columns.Add("SKU");
                    dtasndetail.Columns.Add("UPC");
                    dtasndetail.Columns.Add("预收数量");
                    dtasndetail.Columns.Add("单位");
                    dtasndetail.Columns.Add("规格");
                    dtasndetail.Columns.Add("批次号");
                    dtasndetail.Columns.Add("托号");

                    for (int i = 0; i < dtNike.Rows.Count; i++)
                    {
                        if (dtNike.Rows[i]["单号"].ToString().Trim() != "" || dtNike.Rows[i]["SKU"].ToString().Trim() != "")
                        {
                            if (dtasn.Select("外部入库单号='" + dtNike.Rows[i][2].ToString().Trim() + "'").Count() <= 0)
                            {
                                DataRow dr = dtasn.NewRow();
                                dr["外部入库单号"] = dtNike.Rows[i][2].ToString().Trim();
                                dr["预入库单类型"] = dtNike.Rows[i][0].ToString().Trim() == "1" ? "大仓补货入库" : dtNike.Rows[i][0].ToString().Trim();//入库暂时只有一种类型
                                dr["预入库日期"]  = dtNike.Rows[i][3].ToString().Trim();
                                dr["仓库名称"]   = warehouse.WarehouseName;
                                dr["备注"]     = "";
                                dr["客户"]     = dtNike.Rows[i][6].ToString().Trim();
                                dtasn.Rows.Add(dr);
                            }

                            DataRow drdetail = dtasndetail.NewRow();
                            drdetail["外部入库单号"] = dtNike.Rows[i][2].ToString().Trim();
                            drdetail["SKU"]    = dtNike.Rows[i][8].ToString().Trim();
                            drdetail["UPC"]    = "";
                            drdetail["预收数量"]   = dtNike.Rows[i][9].ToString().Trim();
                            drdetail["单位"]     = "";
                            drdetail["规格"]     = "";
                            drdetail["批次号"]    = "";
                            drdetail["托号"]     = dtNike.Rows[i][10].ToString().Trim();
                            dtasndetail.Rows.Add(drdetail);
                        }
                    }
                    dsResualt.Tables.Add(dtasn);
                    dsResualt.Tables.Add(dtasndetail);
                    this.AfterData = dsResualt;

                    #endregion
                }
                #endregion
            }
            else
            {
                this.AfterData = Transdata;
            }
        }
コード例 #2
0
        //new PreOrderService().ManualAllocationJson(new ManualAllocationRequest()
        //{ PodRequest = pod, ID = Convert.ToInt64(ID), CustomerId = CustomerId, Creator = base.UserInfo.Name, Criterion = Criterion });
        public override void CustomerDefinedSettledTransData(ref string message)
        {
            if (TransDataType == "PreOrder")
            {
                List <ProductSearch>        productListS = new List <ProductSearch>();
                IEnumerable <ProductSearch> productList;
                if (WareHouseID == 0)
                {
                    message = "用户没有分配仓库!!";
                    return;
                }
                WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseList().Where(m => m.ID == WareHouseID).FirstOrDefault();//customerid获取仓库
                IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);
                WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0];
                DataSet   dsResualt = new DataSet();
                DataTable dtpo      = new DataTable();
                dtpo.TableName = "预出库单主信息$";
                DataTable dtpodetail = new DataTable();
                dtpodetail.TableName = "预出库单明细信息$";
                DataTable dtNike = Transdata.Tables[0];
                dtpo.Columns.Add("外部单号");
                dtpo.Columns.Add("预出库单类型");
                dtpo.Columns.Add("仓库名称");
                dtpo.Columns.Add("订单日期");
                dtpo.Columns.Add("省");
                dtpo.Columns.Add("市");
                dtpo.Columns.Add("联系人");
                dtpo.Columns.Add("快递公司");
                dtpo.Columns.Add("备注");
                dtpo.Columns.Add("自定义字段2");
                dtpo.Columns.Add("自定义字段3");
                dtpo.Columns.Add("自定义字段4");
                dtpo.Columns.Add("地址");
                dtpo.Columns.Add("联系方式");
                dtpo.Columns.Add("自定义字段5");
                dtpo.Columns.Add("自定义字段6");
                dtpo.Columns.Add("自定义字段7");
                dtpo.Columns.Add("自定义字段12");

                dtpodetail.Columns.Add("外部单号");
                dtpodetail.Columns.Add("仓库");
                dtpodetail.Columns.Add("SKU");
                dtpodetail.Columns.Add("UPC");
                dtpodetail.Columns.Add("产品名称");
                dtpodetail.Columns.Add("产品等级");
                dtpodetail.Columns.Add("批次号");
                dtpodetail.Columns.Add("托号");
                dtpodetail.Columns.Add("备注");
                dtpodetail.Columns.Add("期望数量");
                dtpodetail.Columns.Add("自定义字段4");
                dtpodetail.Columns.Add("自定义字段5");
                dtpodetail.Columns.Add("自定义字段6");
                dtpodetail.Columns.Add("自定义字段7");
                dtpodetail.Columns.Add("单位");
                dtpodetail.Columns.Add("规格");
                for (int i = 0; i < dtNike.Rows.Count; i++)
                {
                    if (dtpo.Select("外部单号='" + dtNike.Rows[i]["订单号"].ToString() + "'").Count() <= 0)
                    {
                        DataRow dr = dtpo.NewRow();
                        dr["外部单号"]   = dtNike.Rows[i]["订单号"].ToString();
                        dr["预出库单类型"] = dtNike.Rows[i]["订单类型"].ToString();
                        dr["仓库名称"]   = warehouse.WarehouseName;
                        dr["市"]      = "";
                        dr["省"]      = "";
                        dr["联系人"]    = "";
                        dr["订单日期"]   = dtNike.Rows[i]["日期"].ToString();
                        dr["备注"]     = dtNike.Rows[i]["备注1"].ToString();
                        dr["自定义字段2"] = dtNike.Rows[i]["备注2"].ToString();
                        dr["自定义字段3"] = dtNike.Rows[i]["备注3"].ToString();
                        dr["自定义字段4"] = dtNike.Rows[i]["客户代码"].ToString();
                        //客户代码不存在
                        if (CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray().Length <= 0)
                        {
                            message = dtNike.Rows[i]["客户代码"].ToString() + "客户代码不存在!";
                            return;
                        }
                        dr["地址"]     = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray()[0].AddressLine1 : "";
                        dr["自定义字段5"] = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray()[0].Company : "";
                        dr["联系方式"]   = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray()[0].PhoneNum1 : "";
                        dr["自定义字段6"] = dtNike.Rows[i]["备注4"].ToString();
                        dr["自定义字段7"] = dtNike.Rows[i]["备注5"].ToString();
                        if (dtNike.Rows[i]["订单类型"].ToString().Equals("退仓出货"))
                        {
                            string querykey  = "R" + System.DateTime.Now.Year.ToString().Substring(3, 1).ToString() + System.DateTime.Now.ToString("MMdd");
                            string Carrerkey = ApplicationConfigHelper.GetQueryDetail("pro_wms_getCarrierKey_select", querykey).ToString();
                            if (Carrerkey == "")
                            {
                                Carrerkey = "R" + System.DateTime.Now.Year.ToString().Substring(3, 1).ToString() + System.DateTime.Now.ToString("MMdd") + "01";
                            }
                            else
                            {
                                Carrerkey = "R" + (Convert.ToInt32(Carrerkey.Substring(1, Carrerkey.Length - 1)) + 1).ToString();
                            }
                            dr["自定义字段12"] = Carrerkey;
                        }
                        else
                        {
                            dr["自定义字段12"] = "";
                        }
                        dtpo.Rows.Add(dr);
                    }

                    DataRow drdetail = dtpodetail.NewRow();
                    drdetail["外部单号"] = dtNike.Rows[i]["订单号"].ToString();
                    drdetail["仓库"]   = warehouse.WarehouseName;
                    drdetail["SKU"]  = dtNike.Rows[i]["存货代码"].ToString();
                    ProductSearch ps = new ProductSearch();
                    //存货代码格式不正确
                    //for (int j = 0; j < drdetail["SKU"].ToString().Split('-').Length; j++)
                    //{
                    //    if (drdetail["SKU"].ToString().Split('-')[j].Equals(""))
                    //    {
                    //        message = drdetail["SKU"].ToString() + "存货代码格式不正确!";
                    //        return;
                    //    }
                    //}
                    if (drdetail["SKU"].ToString().Split('-').Length < 3)
                    {
                        message = drdetail["SKU"].ToString() + "存货代码格式不正确!";
                        return;
                    }
                    try
                    {
                        ps.Str10 = drdetail["SKU"].ToString().Split('-')[0] + "-" + drdetail["SKU"].ToString().Split('-')[1];
                        ps.Str8  = drdetail["SKU"].ToString().Substring(drdetail["SKU"].ToString().Length - 2, 2);
                        ps.Str9  = drdetail["SKU"].ToString().Substring(ps.Str10.Length + 1, drdetail["SKU"].ToString().Length - (ps.Str10.Length + 4));
                    }
                    catch
                    {
                        message = drdetail["SKU"].ToString() + "存货代码格式不正确!";
                        return;
                    }
                    //if (drdetail["SKU"].ToString().Split('-').Length <= 4)
                    //{
                    //    ps.Str9 = drdetail["SKU"].ToString().Split('-')[2];
                    //    ps.Str8 = drdetail["SKU"].ToString().Split('-')[3];
                    //}
                    //else if (drdetail["SKU"].ToString().Split('-').Length == 5)
                    //{
                    //    ps.Str9 = drdetail["SKU"].ToString().Split('-')[2] + "-" + drdetail["SKU"].ToString().Split('-')[3];
                    //    ps.Str8 = drdetail["SKU"].ToString().Split('-')[4];
                    //}
                    //else if (drdetail["SKU"].ToString().Split('-').Length == 6)
                    //{
                    //    ps.Str9 = drdetail["SKU"].ToString().Split('-')[2] + "-" + drdetail["SKU"].ToString().Split('-')[3] + drdetail["SKU"].ToString().Split('-')[4];
                    //    ps.Str8 = drdetail["SKU"].ToString().Split('-')[5];
                    //}
                    //获得SKU集合
                    productListS.Add(ps);

                    drdetail["UPC"] = "";
                    try
                    {
                        drdetail["产品等级"] = dtNike.Rows[i]["产品等级"].ToString();
                    }
                    catch
                    {
                        drdetail["产品等级"] = "A品";
                    }
                    drdetail["批次号"]    = "";
                    drdetail["托号"]     = "";
                    drdetail["规格"]     = "";
                    drdetail["备注"]     = "";
                    drdetail["期望数量"]   = dtNike.Rows[i]["数量"].ToString();
                    drdetail["自定义字段4"] = dtNike.Rows[i]["单位"].ToString();
                    drdetail["自定义字段5"] = dtNike.Rows[i]["存货名称及规格型号"].ToString();
                    drdetail["自定义字段6"] = dtNike.Rows[i]["存货代码"].ToString();
                    drdetail["自定义字段7"] = dtNike.Rows[i]["BU"].ToString();
                    drdetail["单位"]     = wmsunit.Unit;
                    dtpodetail.Rows.Add(drdetail);
                }

                productList = ApplicationConfigHelper.GetSearchProduct(CustomerID, productListS, "Acticle");
                for (int i = 0; i < dtpodetail.Rows.Count; i++)
                {
                    string SKU       = dtpodetail.Rows[i]["SKU"].ToString();
                    int    skulength = SKU.Split('-').Length;
                    string str10     = SKU.Split('-')[0] + "-" + SKU.Split('-')[1];
                    //string str8 = SKU.Split('-')[skulength - 1];
                    //string str9 = "";
                    string str8 = SKU.Substring(SKU.Length - 2, 2);
                    string str9 = SKU.ToString().Substring(str10.Length + 1, SKU.Length - (str10.Length + 4));
                    //for (int m = 2; m < skulength - 1; m++)
                    //{
                    //    str9 += SKU.Split('-')[m]+"-";
                    //}
                    //str9 = str9.Substring(0,str9.Length - 1);
                    //存货代码不存在
                    if (productList.Where(c => c.Str10 == str10 && c.Str8 == str8 && c.Str9 == str9).Select(m => m.SKU).ToArray().Length <= 0)
                    {
                        message = dtpodetail.Rows[i]["SKU"].ToString() + "存货代码不存在!";
                        return;
                    }
                    //Article不存在
                    if (productList.Where(c => c.Str10 == str10 && c.Str8 == str8 && c.Str9 == str9).Select(m => m.LongMaterial).ToArray().Length <= 0)
                    {
                        message = str10 + "不存在!";
                        return;
                    }
                    dtpodetail.Rows[i]["SKU"]  = productList.Where(c => c.Str10 == str10 && c.Str8 == str8 && c.Str9 == str9).Select(m => m.SKU).FirstOrDefault();
                    dtpodetail.Rows[i]["产品名称"] = productList.Where(c => c.SKU == dtpodetail.Rows[i]["SKU"]).ToArray().Length > 0 ? productList.Where(c => c.SKU == dtpodetail.Rows[i]["SKU"]).ToArray()[0].LongMaterial.ToString() : "";
                }
                dsResualt.Tables.Add(dtpo);
                dsResualt.Tables.Add(dtpodetail);

                this.AfterData = dsResualt;
            }
            else if (TransDataType == "Receiving")
            {
                DataTable dt = Transdata.Tables[0].Copy();
                if (!dt.Columns.Contains("生产日期"))
                {
                    dt.Columns.Add("生产日期");
                }
                if (!dt.Columns.Contains("UPC"))
                {
                    dt.Columns.Add("UPC");
                }
                if (!dt.Columns.Contains("箱内总数"))
                {
                    dt.Columns.Add("箱内总数");
                }
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    try
                    {
                        Convert.ToDateTime(dt.Rows[i]["生产日期"].ToString());
                    }
                    catch
                    {
                        dt.Rows[i]["生产日期"] = System.DateTime.Now.ToString();
                    }
                }
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);
                this.AfterData = ds;
            }
            else
            {
                this.AfterData = Transdata;
            }
        }
コード例 #3
0
        public override void CustomerDefinedSettledTransData(ref string message)
        {
            if (TransDataType == "PreOrder")
            {
                if (Transdata.Tables[0].Columns.Contains("订单类型"))
                {
                    if (Transdata.Tables[0].Rows[0]["订单类型"].ToString() == "退仓出货")
                    {
                        #region 退仓出货 不拆单
                        List <ProductSearch>        productListS = new List <ProductSearch>();
                        IEnumerable <ProductSearch> productList;
                        if (WareHouseID == 0)
                        {
                            message = "用户没有分配仓库!!";
                            return;
                        }
                        WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseList().Where(m => m.ID == WareHouseID).FirstOrDefault();//customerid获取仓库
                        IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);
                        WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0];
                        DataSet   dsResualt = new DataSet();
                        DataTable dtpo      = new DataTable();
                        dtpo.TableName = "预出库单主信息$";
                        DataTable dtpodetail = new DataTable();
                        dtpodetail.TableName = "预出库单明细信息$";
                        DataTable dtNike = Transdata.Tables[0];
                        dtpo.Columns.Add("外部单号");
                        dtpo.Columns.Add("预出库单类型");
                        dtpo.Columns.Add("仓库名称");
                        dtpo.Columns.Add("订单日期");
                        dtpo.Columns.Add("省");
                        dtpo.Columns.Add("市");
                        dtpo.Columns.Add("联系人");
                        dtpo.Columns.Add("快递公司");
                        dtpo.Columns.Add("备注");
                        dtpo.Columns.Add("自定义字段2");
                        dtpo.Columns.Add("自定义字段3");
                        dtpo.Columns.Add("自定义字段4");
                        dtpo.Columns.Add("地址");
                        dtpo.Columns.Add("联系方式");
                        dtpo.Columns.Add("自定义字段5");
                        dtpo.Columns.Add("自定义字段6");
                        dtpo.Columns.Add("自定义字段7");
                        dtpo.Columns.Add("自定义字段12");

                        dtpodetail.Columns.Add("外部单号");
                        dtpodetail.Columns.Add("仓库");
                        dtpodetail.Columns.Add("SKU");
                        dtpodetail.Columns.Add("UPC");
                        dtpodetail.Columns.Add("产品名称");
                        dtpodetail.Columns.Add("产品等级");
                        dtpodetail.Columns.Add("批次号");
                        dtpodetail.Columns.Add("托号");
                        dtpodetail.Columns.Add("备注");
                        dtpodetail.Columns.Add("期望数量");
                        dtpodetail.Columns.Add("自定义字段4");
                        dtpodetail.Columns.Add("自定义字段5");
                        dtpodetail.Columns.Add("自定义字段6");
                        dtpodetail.Columns.Add("自定义字段7");
                        dtpodetail.Columns.Add("单位");
                        dtpodetail.Columns.Add("规格");
                        for (int i = 0; i < dtNike.Rows.Count; i++)
                        {
                            if (dtpo.Select("外部单号='" + dtNike.Rows[i]["订单号"].ToString() + "'").Count() <= 0)
                            {
                                DataRow dr = dtpo.NewRow();
                                dr["外部单号"]   = dtNike.Rows[i]["订单号"].ToString();
                                dr["预出库单类型"] = dtNike.Rows[i]["订单类型"].ToString();
                                dr["仓库名称"]   = warehouse.WarehouseName;
                                dr["市"]      = "";
                                dr["省"]      = "";
                                dr["联系人"]    = "";
                                dr["订单日期"]   = dtNike.Rows[i]["日期"].ToString();
                                dr["备注"]     = dtNike.Rows[i]["备注1"].ToString();
                                dr["自定义字段2"] = dtNike.Rows[i]["备注2"].ToString();
                                dr["自定义字段3"] = dtNike.Rows[i]["备注3"].ToString();
                                dr["自定义字段4"] = dtNike.Rows[i]["客户代码"].ToString();
                                //客户代码不存在
                                if (CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray().Length <= 0)
                                {
                                    message = "第【" + (i + 2) + "】行," + "【客户代码】列的客户代码格式不对或 " + dtNike.Rows[i]["客户代码"].ToString() + "客户代码不存在!";
                                    return;
                                }
                                dr["地址"]     = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray()[0].AddressLine1 : "";
                                dr["自定义字段5"] = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray()[0].Company : "";
                                dr["联系方式"]   = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["客户代码"].ToString()).ToArray()[0].PhoneNum1 : "";
                                dr["自定义字段6"] = dtNike.Rows[i]["备注4"].ToString();
                                dr["自定义字段7"] = dtNike.Rows[i]["备注5"].ToString();
                                if (dtNike.Rows[i]["订单类型"].ToString().Equals("退仓出货"))
                                {
                                    string querykey  = "R" + System.DateTime.Now.Year.ToString().Substring(3, 1).ToString() + System.DateTime.Now.ToString("MMdd");
                                    string Carrerkey = ApplicationConfigHelper.GetQueryDetail("pro_wms_getCarrierKey_select", querykey).ToString();
                                    if (Carrerkey == "")
                                    {
                                        Carrerkey = "R" + System.DateTime.Now.Year.ToString().Substring(3, 1).ToString() + System.DateTime.Now.ToString("MMdd") + "01";
                                    }
                                    else
                                    {
                                        Carrerkey = "R" + (Convert.ToInt32(Carrerkey.Substring(1, Carrerkey.Length - 1)) + 1).ToString();
                                    }
                                    dr["自定义字段12"] = Carrerkey;
                                }
                                else
                                {
                                    dr["自定义字段12"] = "";
                                }
                                dtpo.Rows.Add(dr);
                            }

                            DataRow drdetail = dtpodetail.NewRow();
                            drdetail["外部单号"] = dtNike.Rows[i]["订单号"].ToString();
                            drdetail["仓库"]   = warehouse.WarehouseName;
                            drdetail["SKU"]  = dtNike.Rows[i]["存货代码"].ToString();
                            ProductSearch ps = new ProductSearch();
                            if (drdetail["SKU"].ToString().Split('-').Length < 3)
                            {
                                message = drdetail["SKU"].ToString() + "存货代码格式不正确!";
                                return;
                            }
                            try
                            {
                                ps.Str10 = drdetail["SKU"].ToString().Split('-')[0] + "-" + drdetail["SKU"].ToString().Split('-')[1];
                                ps.Str8  = drdetail["SKU"].ToString().Substring(drdetail["SKU"].ToString().Length - 2, 2);
                                ps.Str9  = drdetail["SKU"].ToString().Substring(ps.Str10.Length + 1, drdetail["SKU"].ToString().Length - (ps.Str10.Length + 4));
                            }
                            catch
                            {
                                message = drdetail["SKU"].ToString() + "存货代码格式不正确!";
                                return;
                            }
                            //获得SKU集合
                            productListS.Add(ps);

                            drdetail["UPC"] = "";
                            try
                            {
                                drdetail["产品等级"] = dtNike.Rows[i]["产品等级"].ToString();
                            }
                            catch
                            {
                                drdetail["产品等级"] = "A品";
                            }
                            if (dtNike.Columns.Contains("批次号"))
                            {
                                drdetail["批次号"] = dtNike.Rows[i]["批次号"].ToString();
                            }
                            else
                            {
                                drdetail["批次号"] = "";
                            }
                            drdetail["托号"]     = "";
                            drdetail["规格"]     = "";
                            drdetail["备注"]     = "";
                            drdetail["期望数量"]   = dtNike.Rows[i]["数量"].ToString();
                            drdetail["自定义字段4"] = dtNike.Rows[i]["单位"].ToString();
                            drdetail["自定义字段5"] = dtNike.Rows[i]["存货名称及规格型号"].ToString();
                            drdetail["自定义字段6"] = dtNike.Rows[i]["存货代码"].ToString();
                            drdetail["自定义字段7"] = dtNike.Rows[i]["BU"].ToString();
                            drdetail["单位"]     = wmsunit.Unit;
                            dtpodetail.Rows.Add(drdetail);
                        }

                        productList = ApplicationConfigHelper.GetSearchProduct(CustomerID, productListS, "Acticle");
                        for (int i = 0; i < dtpodetail.Rows.Count; i++)
                        {
                            string SKU       = dtpodetail.Rows[i]["SKU"].ToString();
                            int    skulength = SKU.Split('-').Length;
                            string str10     = SKU.Split('-')[0] + "-" + SKU.Split('-')[1];
                            string str8      = SKU.Substring(SKU.Length - 2, 2);
                            string str9      = SKU.ToString().Substring(str10.Length + 1, SKU.Length - (str10.Length + 4));
                            //存货代码不存在
                            if (productList.Where(c => c.Str10 == str10 && c.Str8 == str8 && c.Str9 == str9).Select(m => m.SKU).ToArray().Length <= 0)
                            {
                                message = "第【" + (i + 2) + "】行," + "【SKU】列的存货代码格式不对或 " + dtpodetail.Rows[i]["SKU"].ToString() + "存货代码不存在!";
                                return;
                            }
                            //Article不存在
                            if (productList.Where(c => c.Str10 == str10 && c.Str8 == str8 && c.Str9 == str9).Select(m => m.LongMaterial).ToArray().Length <= 0)
                            {
                                message = str10 + "不存在!";
                                return;
                            }
                            dtpodetail.Rows[i]["SKU"]  = productList.Where(c => c.Str10 == str10.Trim().ToUpper() && c.Str8 == str8 && c.Str9 == str9.Trim().ToUpper()).Select(m => m.SKU).FirstOrDefault();
                            dtpodetail.Rows[i]["产品名称"] = productList.Where(c => c.SKU == dtpodetail.Rows[i]["SKU"]).ToArray().Length > 0 ? productList.Where(c => c.SKU == dtpodetail.Rows[i]["SKU"]).ToArray()[0].LongMaterial.ToString() : "";
                        }
                        dsResualt.Tables.Add(dtpo);
                        dsResualt.Tables.Add(dtpodetail);

                        this.AfterData = dsResualt;
                        #endregion
                    }
                    else if (Transdata.Tables[0].Rows[0]["订单类型"].ToString() == "CRW退货")
                    {
                        #region CRW退货 不拆单
                        if (ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray().Count() <= 0)
                        {
                            message = "用户没有分配仓库!!";
                            return;
                        }
                        WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray()[0];//Bob
                        IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);
                        WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0];
                        DataSet   dsResualt = new DataSet();
                        DataTable dtpo      = new DataTable();
                        dtpo.TableName = "预出库单主信息$";
                        DataTable dtpodetail = new DataTable();
                        dtpodetail.TableName = "预出库单明细信息$";

                        DataTable            dtNike        = Transdata.Tables[0];
                        List <ProductSearch> searprolistfs = new List <ProductSearch>();
                        for (int i = 0; i < dtNike.Rows.Count; i++)
                        {
                            ProductSearch psfs = new ProductSearch();
                            //客户代码不存在
                            if (dtNike.Rows[i]["Style Color"].ToString().Equals("") || dtNike.Rows[i]["Style Color"].ToString().Length == 0)
                            {
                                message = "第【" + (i + 2) + "】行," + "【Style Color】列" + "有空值或格式不正确!";
                                return;
                            }
                            if (dtNike.Rows[i]["Size"].ToString().Equals("") || dtNike.Rows[i]["Style Color"].ToString().Length == 0)
                            {
                                message = "第【" + (i + 2) + "】行," + "【Size】列" + "有空值或格式不正确!";
                                return;
                            }
                            psfs.Str10 = dtNike.Rows[i]["Style Color"].ToString();
                            psfs.Str9  = dtNike.Rows[i]["Size"].ToString();
                            psfs.Str8  = "01";
                            searprolistfs.Add(psfs);
                        }
                        IEnumerable <ProductSearch> productListfs = ApplicationConfigHelper.GetSearchProduct(CustomerID, searprolistfs, "Acticle");
                        //先验证article存不存在再继续
                        for (int i = 0; i < dtNike.Rows.Count; i++)
                        {
                            if (productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length <= 0)
                            {
                                message = "第【" + (i + 2) + "】行," + "【Style Color】列的Article格式不对或Article " + dtNike.Rows[i]["Style Color"].ToString() + " 在系统中不存在!";
                                return;
                            }
                            else
                            {
                                if (productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString() && m.Str9 == dtNike.Rows[i]["Size"].ToString()).ToArray().Length <= 0)
                                {
                                    message = "第【" + (i + 2) + "】行," + "【Size】列的尺寸格式不对或 " + dtNike.Rows[i]["Style Color"].ToString() + "对应的尺寸" + dtNike.Rows[i]["Size"].ToString() + " 在系统中不存在!";
                                    return;
                                }
                            }
                        }

                        dtpo.Columns.Add("外部单号");
                        dtpo.Columns.Add("预出库单类型");
                        dtpo.Columns.Add("仓库名称");
                        dtpo.Columns.Add("订单日期");
                        dtpo.Columns.Add("省");
                        dtpo.Columns.Add("市");
                        dtpo.Columns.Add("联系人");
                        dtpo.Columns.Add("快递公司");
                        dtpo.Columns.Add("备注");
                        dtpo.Columns.Add("自定义字段2");
                        dtpo.Columns.Add("自定义字段3");
                        dtpo.Columns.Add("自定义字段4");
                        dtpo.Columns.Add("地址");
                        dtpo.Columns.Add("联系方式");
                        dtpo.Columns.Add("自定义字段5");
                        dtpo.Columns.Add("自定义字段6");
                        dtpo.Columns.Add("自定义字段7");
                        dtpo.Columns.Add("自定义字段8");

                        dtpodetail.Columns.Add("外部单号");
                        dtpodetail.Columns.Add("仓库");
                        dtpodetail.Columns.Add("SKU");
                        dtpodetail.Columns.Add("UPC");
                        dtpodetail.Columns.Add("产品等级");
                        dtpodetail.Columns.Add("产品名称");
                        dtpodetail.Columns.Add("批次号");
                        dtpodetail.Columns.Add("托号");
                        dtpodetail.Columns.Add("备注");
                        dtpodetail.Columns.Add("期望数量");
                        dtpodetail.Columns.Add("自定义字段4");
                        dtpodetail.Columns.Add("自定义字段5");
                        dtpodetail.Columns.Add("自定义字段6");
                        dtpodetail.Columns.Add("自定义字段7");
                        dtpodetail.Columns.Add("单位");
                        dtpodetail.Columns.Add("规格");

                        //判断是否是殊门店配置
                        IEnumerable <WMSConfig> wmslist = null;//NFS分单配置
                        string userdef3 = "";
                        if (CustomerList.Where(m => m.StorerKey == dtNike.Rows[0]["Store Code"].ToString()).Count() > 0)
                        {
                            userdef3 = CustomerList.Where(m => m.StorerKey == dtNike.Rows[0]["Store Code"].ToString()).FirstOrDefault().UserDef3;
                        }
                        else
                        {
                            message = "第【1】行," + "【Store Code】列的门店代码格式不对或门店代码 " + dtNike.Rows[0][0].ToString() + "在系统中不存在!";
                            return;
                        }
                        try
                        {
                            wmslist = ApplicationConfigHelper.GetWMS_Config(userdef3);
                        }
                        catch (Exception)
                        {
                        }

                        //特殊门店
                        if (wmslist != null && wmslist.Count() > 0)
                        {
                            for (int i = 0; i < dtNike.Rows.Count; i++)
                            {
                                string division = "", gender = "";
                                division = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].Division;
                                gender   = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].GenderAge;
                                if (division == "FTW" && gender == "YA")
                                {
                                }
                                string exterNo = DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + '-' + dtNike.Rows[0]["Store Code"].ToString() + wmslist.Where(m => m.Str1 == gender && m.Str2 == division).FirstOrDefault().Code;//年月日+门店代码+code
                                //if (dtpo.Select("外部单号='" + DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + dtNike.Rows[i]["Store Code"].ToString() + wmslist.Where(m => m.Str1 == gender && m.Str2 == division).FirstOrDefault().Code + "'").Count() <= 0)
                                if (dtpo.Select("外部单号='" + exterNo + "'").Count() <= 0)
                                {
                                    DataRow dr = dtpo.NewRow();
                                    if (productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length <= 0)
                                    {
                                        message = "第【" + (i + 2) + "】行," + "【Style Color】列的Article格式不对或Article " + dtNike.Rows[i]["Style Color"].ToString() + "在系统中不存在!";
                                        return;
                                    }
                                    dr["外部单号"]   = DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + '-' + dtNike.Rows[0]["Store Code"].ToString() + wmslist.Where(m => m.Str1 == gender && m.Str2 == division).FirstOrDefault().Code;//年月日+门店代码+code
                                    dr["预出库单类型"] = "门店调拨出库";
                                    dr["仓库名称"]   = warehouse.WarehouseName;
                                    dr["市"]      = "";
                                    dr["省"]      = "";
                                    dr["联系人"]    = "";
                                    dr["订单日期"]   = DateTime.Now.ToString();
                                    dr["备注"]     = "";
                                    dr["自定义字段2"] = dtNike.Rows[i]["Contract Code"].ToString();
                                    dr["自定义字段3"] = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].Division.ToString() : "";
                                    if (CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray().Length <= 0)
                                    {
                                        message = "第【" + (i + 2) + "】行," + "【Store Code】列的门店代码格式不对或门店代码 " + dtNike.Rows[i]["Store Code"].ToString() + "在系统中不存在!";//dtNike.Rows[i]["Store Code"].ToString() + "不存在!";
                                        return;
                                    }
                                    if (dtNike.Columns.Contains("LF"))
                                    {
                                        dr["自定义字段8"] = dtNike.Rows[i]["LF"].ToString();
                                    }
                                    dr["自定义字段4"] = dtNike.Rows[i]["Store Code"].ToString();
                                    dr["地址"]     = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray()[0].AddressLine1 : "";
                                    dr["自定义字段5"] = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray()[0].Company.ToString() : "";
                                    dr["联系方式"]   = "";
                                    dr["自定义字段6"] = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].GenderAge.ToString() : "";
                                    dr["自定义字段7"] = dtNike.Rows[i]["Store CRD"].ToString();
                                    dtpo.Rows.Add(dr);
                                }

                                DataRow drdetail = dtpodetail.NewRow();
                                drdetail["外部单号"] = DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + '-' + dtNike.Rows[0]["Store Code"].ToString() + wmslist.Where(m => m.Str1 == gender && m.Str2 == division).FirstOrDefault().Code;//年月日+门店代码+code
                                drdetail["仓库"]   = warehouse.WarehouseName;
                                drdetail["SKU"]  = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString().Trim().ToUpper() && m.Str9 == dtNike.Rows[i]["Size"].ToString().Trim().ToUpper() && m.Str8 == "01").ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString().Trim().ToUpper() && m.Str9 == dtNike.Rows[i]["Size"].ToString().Trim().ToUpper() && m.Str8 == "01").ToArray()[0].SKU : "";
                                drdetail["UPC"]  = "";
                                try
                                {
                                    drdetail["产品等级"] = dtNike.Rows[i]["产品等级"].ToString();
                                }
                                catch
                                {
                                    drdetail["产品等级"] = "A品";
                                }
                                drdetail["产品名称"] = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].LongMaterial.ToString() : "";//产品名称
                                if (dtNike.Columns.Contains("批次号"))
                                {
                                    drdetail["批次号"] = dtNike.Rows[i]["批次号"].ToString();
                                }
                                else
                                {
                                    drdetail["批次号"] = "";
                                }
                                drdetail["托号"]     = "";
                                drdetail["规格"]     = "";
                                drdetail["备注"]     = "";
                                drdetail["期望数量"]   = dtNike.Rows[i]["Sugg# Rep Qty"].ToString();
                                drdetail["自定义字段4"] = "";
                                drdetail["自定义字段5"] = "";
                                drdetail["自定义字段6"] = dtNike.Rows[i]["Style Color"].ToString() + "-" + dtNike.Rows[i]["Size"].ToString();
                                drdetail["自定义字段7"] = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].Division.ToString() : "";//BU
                                drdetail["单位"]     = wmsunit.Unit;
                                dtpodetail.Rows.Add(drdetail);
                            }
                        }
                        else
                        {
                            //string time = DateTime.Now.ToString("HHmmssfff");
                            //dtNike.DefaultView.Sort = "Store CRD ASC,BU ASC,Store Code ASC,Style Color ASC";
                            //dtNike = dtNike.DefaultView.ToTable();
                            for (int i = 0; i < dtNike.Rows.Count; i++)
                            {
                                //if (dtpo.Select("外部单号='" + DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].Division.Substring(0, 1).ToString() + '-' + dtNike.Rows[i]["Store Code"] + productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].GenderAge.Substring(0, 1).ToString() + "'").Count() <= 0)
                                //不拆单
                                if (dtpo.Select("外部单号='" + DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + '-' + dtNike.Rows[i]["Store Code"] + "'").Count() <= 0)
                                {
                                    //time = DateTime.Now.ToString("HHmmssfff");
                                    DataRow dr = dtpo.NewRow();
                                    if (productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length <= 0)
                                    {
                                        message = "第【" + (i + 2) + "】行," + "【Style Color】列的Article格式不对或Article " + dtNike.Rows[i]["Style Color"].ToString() + "在系统中不存在!";
                                        return;
                                    }
                                    //dr["外部单号"] = DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].Division.Substring(0, 1).ToString() + '-' + dtNike.Rows[i]["Store Code"] + productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].GenderAge.Substring(0, 1).ToString();
                                    //不拆单
                                    dr["外部单号"]   = DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + '-' + dtNike.Rows[i]["Store Code"].ToString();
                                    dr["预出库单类型"] = "门店调拨出库";
                                    dr["仓库名称"]   = warehouse.WarehouseName;
                                    dr["市"]      = "";
                                    dr["省"]      = "";
                                    dr["联系人"]    = "";
                                    dr["订单日期"]   = DateTime.Now.ToString();
                                    dr["备注"]     = "";
                                    dr["自定义字段2"] = dtNike.Rows[i]["Contract Code"].ToString();
                                    dr["自定义字段3"] = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].Division.ToString() : "";
                                    if (CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray().Length <= 0)
                                    {
                                        message = "第【" + (i + 2) + "】行," + "【Store Code】列的门店代码格式不对或门店代码 " + dtNike.Rows[i]["Store Code"].ToString() + "在系统中不存在!";//dtNike.Rows[i]["Store Code"].ToString() + "不存在!";
                                        return;
                                    }
                                    if (dtNike.Columns.Contains("LF"))
                                    {
                                        dr["自定义字段8"] = dtNike.Rows[i]["LF"].ToString();
                                    }
                                    dr["自定义字段4"] = dtNike.Rows[i]["Store Code"].ToString();
                                    dr["地址"]     = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray()[0].AddressLine1 : "";
                                    dr["自定义字段5"] = CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtNike.Rows[i]["Store Code"].ToString()).ToArray()[0].Company.ToString() : "";
                                    dr["联系方式"]   = "";
                                    dr["自定义字段6"] = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].GenderAge.ToString() : "";
                                    dr["自定义字段7"] = dtNike.Rows[i]["Store CRD"].ToString();
                                    dtpo.Rows.Add(dr);
                                }

                                DataRow drdetail = dtpodetail.NewRow();
                                //drdetail["外部单号"] = DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].Division.Substring(0, 1).ToString() + '-' + dtNike.Rows[i]["Store Code"] + productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].GenderAge.Substring(0, 1).ToString();
                                //不拆单
                                drdetail["外部单号"] = DateTime.Parse(dtNike.Rows[i]["Store CRD"].ToString()).ToString("yyyyMMdd") + '-' + dtNike.Rows[i]["Store Code"].ToString().ToString();
                                drdetail["仓库"]   = warehouse.WarehouseName;
                                drdetail["SKU"]  = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString().Trim().ToUpper() && m.Str9 == dtNike.Rows[i]["Size"].ToString().Trim().ToUpper() && m.Str8 == "01").ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString().Trim().ToUpper() && m.Str9 == dtNike.Rows[i]["Size"].ToString().Trim().ToUpper() && m.Str8 == "01").ToArray()[0].SKU : "";
                                drdetail["UPC"]  = "";
                                try
                                {
                                    drdetail["产品等级"] = dtNike.Rows[i]["产品等级"].ToString();
                                }
                                catch
                                {
                                    drdetail["产品等级"] = "A品";
                                }
                                drdetail["产品名称"] = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].LongMaterial.ToString() : "";//产品名称
                                if (dtNike.Columns.Contains("批次号"))
                                {
                                    drdetail["批次号"] = dtNike.Rows[i]["批次号"].ToString();
                                }
                                else
                                {
                                    drdetail["批次号"] = "";
                                }
                                drdetail["托号"]     = "";
                                drdetail["规格"]     = "";
                                drdetail["备注"]     = "";
                                drdetail["期望数量"]   = dtNike.Rows[i]["Sugg# Rep Qty"].ToString();
                                drdetail["自定义字段4"] = "";
                                drdetail["自定义字段5"] = "";
                                drdetail["自定义字段6"] = dtNike.Rows[i]["Style Color"].ToString() + "-" + dtNike.Rows[i]["Size"].ToString();
                                drdetail["自定义字段7"] = productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == dtNike.Rows[i]["Style Color"].ToString()).ToArray()[0].Division.ToString() : "";//BU
                                drdetail["单位"]     = wmsunit.Unit;
                                dtpodetail.Rows.Add(drdetail);
                            }
                        }
                        //datatable 外部单号升序排序,并依次添加序号
                        //ModifyForDataTable MFD = new ModifyForDataTable();
                        //dtpo = MFD.AddSerialNumberForNFS(dtpo);
                        //dtpodetail = MFD.AddSerialNumberForNFS(dtpodetail);

                        dsResualt.Tables.Add(dtpo);
                        dsResualt.Tables.Add(dtpodetail);
                        //datatable 外部单号升序排序,并依次添加序号
                        ModifyForDataTable MFD = new ModifyForDataTable();
                        dsResualt      = MFD.AddSerialNumberForNFS(dsResualt);
                        this.AfterData = dsResualt;
                        #endregion
                    }
                }
                else
                {
                    #region 正常出货 拆单
                    if (ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray().Count() <= 0)
                    {
                        message = "用户没有分配仓库!!";
                        return;
                    }
                    WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray()[0];
                    IEnumerable <ProjectCustomer> Customer = ApplicationConfigHelper.GetProjectCustomers(ProjectID).ToArray();
                    IEnumerable <WMS_UnitAndSpecifications_Config> wmsunit = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray();
                    #region 产品等级列表
                    IEnumerable <WMSConfig> ProductLevelList = null;
                    try
                    {
                        ProductLevelList = ApplicationConfigHelper.GetWMS_Config("ProductLevel_" + Customer.Select(s => s.Name).FirstOrDefault().ToString()).ToArray();
                    }
                    catch (Exception)
                    {
                        ProductLevelList = ApplicationConfigHelper.GetWMS_Config("ProductLevel").ToArray();
                    }
                    #endregion
                    #region 预出库单类型列表
                    IEnumerable <WMSConfig> ordertypes = null;
                    try
                    {
                        ordertypes = ApplicationConfigHelper.GetWMS_Config("OrderType_" + Customer.Select(s => s.Name).FirstOrDefault().ToString()).ToArray();
                    }
                    catch (Exception)
                    {
                        ordertypes = ApplicationConfigHelper.GetWMS_Config("OrderType").ToArray();
                    }
                    #endregion

                    DataSet   dsResualt = new DataSet();
                    DataTable dtpo      = new DataTable();
                    dtpo.TableName = "预出库单主信息$";
                    DataTable dtpodetail = new DataTable();
                    dtpodetail.TableName = "预出库单明细信息$";

                    DataTable            dtNike        = Transdata.Tables[0];
                    List <ProductSearch> searprolistfs = new List <ProductSearch>();
                    for (int i = 0; i < dtNike.Rows.Count; i++)
                    {
                        ProductSearch psfs = new ProductSearch();
                        #region 验证物料 验证包装单位 验证产品等级 验证预出库单类型 数量是否为空
                        if (dtNike.Rows[i]["物料"].ToString().Equals("") || dtNike.Rows[i]["物料"].ToString().Length == 0)
                        {
                            message = "第【" + (i + 1) + "】行," + "【物料】列" + "有空值或格式不正确!";
                            return;
                        }
                        if (dtNike.Rows[i]["包装单位"].ToString().Equals("") || dtNike.Rows[i]["包装单位"].ToString().Length == 0)
                        {
                            message = "第【" + (i + 1) + "】行," + "【包装单位】列" + "有空值或格式不正确!";
                            return;
                        }
                        if (dtNike.Columns.Contains("产品等级"))
                        {
                            if (dtNike.Rows[i]["产品等级"].ToString().Equals("") || dtNike.Rows[i]["产品等级"].ToString().Length == 0)
                            {
                                message = "第【" + (i + 1) + "】行," + "【产品等级】列" + "有空值或格式不正确!";
                                return;
                            }
                        }
                        if (dtNike.Columns.Contains("预出库单类型"))
                        {
                            if (dtNike.Rows[i]["预出库单类型"].ToString().Equals("") || dtNike.Rows[i]["预出库单类型"].ToString().Length == 0)
                            {
                                message = "第【" + (i + 1) + "】行," + "【预出库单类型】列" + "有空值或格式不正确!";
                                return;
                            }
                        }
                        if (dtNike.Rows[i]["出货数量"].ToString().Equals("") || dtNike.Rows[i]["出货数量"].ToString().Length == 0)
                        {
                            message = "第【" + (i + 1) + "】行," + "【出货数量】列" + "有空值或格式不正确!";
                            return;
                        }
                        #endregion
                        psfs.SKU = dtNike.Rows[i]["物料"].ToString();
                        searprolistfs.Add(psfs);
                    }
                    IEnumerable <ProductSearch> productListfs = ApplicationConfigHelper.GetSearchProduct(CustomerID, searprolistfs, "SKU");
                    for (int i = 0; i < dtNike.Rows.Count; i++)
                    {
                        #region 验证物料 验证单位 验证产品等级 验证出库单类型
                        if (productListfs.Where(m => m.SKU == dtNike.Rows[i]["物料"].ToString()).ToArray().Length <= 0)
                        {
                            message = "第【" + (i + 1) + "】行," + "【物料】列的格式不对或 " + dtNike.Rows[i]["物料"].ToString() + " 在系统中不存在!";
                            return;
                        }
                        if (wmsunit.Where(m => m.Unit == dtNike.Rows[i]["包装单位"].ToString()).ToArray().Length <= 0)
                        {
                            message = "第【" + (i + 1) + "】行," + "【包装单位】列的格式不对或 " + dtNike.Rows[i]["包装单位"].ToString() + " 在系统中不存在!";
                            return;
                        }
                        if (dtNike.Columns.Contains("产品等级"))
                        {
                            if (ProductLevelList.Where(m => m.Name == dtNike.Rows[i]["产品等级"].ToString()).ToArray().Length <= 0)
                            {
                                message = "第【" + (i + 1) + "】行," + "【产品等级】列的格式不对或 " + dtNike.Rows[i]["产品等级"].ToString() + " 在系统中不存在!";
                                return;
                            }
                        }
                        if (dtNike.Columns.Contains("预出库单类型"))
                        {
                            if (ordertypes.Where(m => m.Name == dtNike.Rows[i]["预出库单类型"].ToString()).ToArray().Length <= 0)
                            {
                                message = "第【" + (i + 1) + "】行," + "【预出库单类型】列的格式不对或 " + dtNike.Rows[i]["预出库单类型"].ToString() + " 在系统中不存在!";
                                return;
                            }
                        }
                        #endregion
                    }
                    #region
                    dtpo.Columns.Add("外部单号");
                    dtpo.Columns.Add("预出库单类型");
                    dtpo.Columns.Add("仓库名称");
                    dtpo.Columns.Add("订单日期");
                    dtpo.Columns.Add("省");
                    dtpo.Columns.Add("市");
                    dtpo.Columns.Add("地址");
                    dtpo.Columns.Add("联系人");
                    dtpo.Columns.Add("联系方式");
                    dtpo.Columns.Add("快递公司");
                    dtpo.Columns.Add("备注");
                    dtpo.Columns.Add("自定义字段4");
                    dtpo.Columns.Add("自定义字段5");
                    #endregion
                    #region
                    dtpodetail.Columns.Add("外部单号");
                    dtpodetail.Columns.Add("仓库");
                    dtpodetail.Columns.Add("SKU");
                    dtpodetail.Columns.Add("UPC");
                    dtpodetail.Columns.Add("产品等级");
                    dtpodetail.Columns.Add("产品名称");
                    dtpodetail.Columns.Add("批次号");
                    dtpodetail.Columns.Add("托号");
                    dtpodetail.Columns.Add("单位");
                    dtpodetail.Columns.Add("规格");
                    dtpodetail.Columns.Add("备注");
                    dtpodetail.Columns.Add("期望数量");
                    #endregion
                    for (int i = 0; i < dtNike.Rows.Count; i++)
                    {
                        if (dtpo.Select("外部单号='" + dtNike.Rows[i]["运单号"].ToString() + "'").Count() <= 0)
                        {
                            #region
                            DataRow dr = dtpo.NewRow();
                            dr["外部单号"] = dtNike.Rows[i]["运单号"].ToString();
                            try
                            {
                                dr["预出库单类型"] = dtNike.Rows[i]["预出库单类型"].ToString();
                            }
                            catch
                            {
                                dr["预出库单类型"] = "市内配送出库";
                            }
                            dr["仓库名称"]   = warehouse.WarehouseName;
                            dr["订单日期"]   = DateTime.Now.ToString();
                            dr["省"]      = "";
                            dr["市"]      = dtNike.Rows[i]["市"].ToString();
                            dr["地址"]     = dtNike.Rows[i]["客户地址"].ToString();
                            dr["联系人"]    = dtNike.Rows[i]["联系人"].ToString();
                            dr["联系方式"]   = dtNike.Rows[i]["电话"].ToString();
                            dr["快递公司"]   = dtNike.Rows[i]["承运商"].ToString();
                            dr["备注"]     = "";
                            dr["自定义字段4"] = dtNike.Rows[i]["客户编号"].ToString();
                            dr["自定义字段5"] = dtNike.Rows[i]["客户名称"].ToString();
                            dtpo.Rows.Add(dr);
                            #endregion
                        }
                        #region
                        DataRow drdetail = dtpodetail.NewRow();
                        drdetail["外部单号"] = dtNike.Rows[i]["运单号"].ToString();
                        drdetail["仓库"]   = warehouse.WarehouseName;
                        drdetail["SKU"]  = dtNike.Rows[i]["物料"].ToString().Trim().ToUpper();
                        drdetail["UPC"]  = "";
                        try
                        {
                            drdetail["产品等级"] = dtNike.Rows[i]["产品等级"].ToString();
                        }
                        catch
                        {
                            drdetail["产品等级"] = "A品";
                        }
                        drdetail["产品名称"] = dtNike.Rows[i]["物料描述"].ToString();
                        drdetail["批次号"]  = DateTime.Now.ToString("yyyyMMdd");
                        drdetail["托号"]   = "";
                        drdetail["单位"]   = dtNike.Rows[i]["包装单位"].ToString();
                        drdetail["规格"]   = "";
                        drdetail["备注"]   = dtNike.Rows[i]["发货备注"].ToString();
                        drdetail["期望数量"] = dtNike.Rows[i]["出货数量"].ToString();
                        dtpodetail.Rows.Add(drdetail);
                        #endregion
                    }
                    dsResualt.Tables.Add(dtpo);
                    dsResualt.Tables.Add(dtpodetail);
                    //datatable 外部单号升序排序,并依次添加序号
                    //ModifyForDataTable MFD = new ModifyForDataTable();
                    //dsResualt = MFD.AddSerialNumberForNFS(dsResualt);
                    this.AfterData = dsResualt;
                    #endregion
                }
            }
            else if (TransDataType == "Receiving")
            {
                #region  架
                DataTable dt = Transdata.Tables[0].Copy();
                if (!dt.Columns.Contains("生产日期"))
                {
                    dt.Columns.Add("生产日期");
                }
                if (!dt.Columns.Contains("UPC"))
                {
                    dt.Columns.Add("UPC");
                }
                if (!dt.Columns.Contains("箱内总数"))
                {
                    dt.Columns.Add("箱内总数");
                }
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    try
                    {
                        Convert.ToDateTime(dt.Rows[i]["生产日期"].ToString());
                    }
                    catch
                    {
                        dt.Rows[i]["生产日期"] = System.DateTime.Now.ToString();
                    }
                }
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);
                this.AfterData = ds;
                #endregion
            }
            else
            {
                this.AfterData = Transdata;
            }
        }
コード例 #4
0
        public override void CustomerDefinedSettledTransData(ref string message)
        {
            if (TransDataType == "PreOrder")
            {
                if (ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray().Count() <= 0)
                {
                    message = "用户没有分配仓库!!";
                    return;
                }
                //正常出货 拆单
                WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray()[0];
                IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);
                WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0];
                DataSet   dsResualt  = new DataSet();
                DataTable dtpo       = new DataTable();
                DataTable dtpodetail = new DataTable();
                dtpo.TableName       = "预出库单主信息$";
                dtpodetail.TableName = "预出库单明细信息$";
                DataTable dtpodetailCount = Transdata.Tables[0]; //获取第一张表
                DataTable dtpoloadkey     = Transdata.Tables[1]; //获取第二张表

                #region 验证空值
                List <ProductSearch> searprolistfs = new List <ProductSearch>();
                string aa      = "";
                string bb      = "";
                string Size    = "";
                string Article = "";
                for (int i = 0; i < dtpodetailCount.Rows.Count; i++)
                {
                    ProductSearch psfs = new ProductSearch();
                    if (dtpodetailCount.Rows[i]["Sku"].ToString().Equals("") || dtpodetailCount.Rows[i]["Sku"].ToString().Length == 0)
                    {
                        message = "第【" + (i + 2) + "】行," + "【Sku】列" + "有空值或格式不正确(应为文本格式)!";
                        return;
                    }
                    aa   = dtpodetailCount.Rows[i]["sku"].ToString();
                    bb   = aa.Substring(6, 3);
                    Size = aa.Substring(9);
                    aa   = aa.Substring(0, 6);

                    psfs.Str10 = aa + "-" + bb;
                    psfs.Str9  = Size;
                    psfs.Str8  = "01";
                    searprolistfs.Add(psfs);
                }
                #endregion

                #region 获得SKU集合
                IEnumerable <ProductSearch> productListfs;
                productListfs = ApplicationConfigHelper.GetSearchProduct(CustomerID, searprolistfs, "Acticle");
                #endregion

                #region 先验证article存不存在再继续
                for (int i = 0; i < dtpodetailCount.Rows.Count; i++)
                {
                    aa      = dtpodetailCount.Rows[i]["sku"].ToString();
                    bb      = aa.Substring(6, 3);
                    Size    = aa.Substring(9);
                    aa      = aa.Substring(0, 6);
                    Article = aa + '-' + bb;
                    if (productListfs.Where(m => m.Str10 == Article).ToArray().Length <= 0)
                    {
                        message = "第【" + (i + 2) + "】行," + "【sku】列的Article格式不对或Article " + dtpodetailCount.Rows[i]["sku"].ToString() + " 在系统中不存在!";
                        return;
                    }
                    else
                    {
                        if (productListfs.Where(m => m.Str10 == Article && m.Str9 == Size).ToArray().Length <= 0)
                        {
                            message = "第【" + (i + 2) + "】行," + "【sku】列的尺寸格式不对或 " + dtpodetailCount.Rows[i]["sku"].ToString() + "对应的尺寸" + dtpodetailCount.Rows[i]["sku"].ToString() + " 在系统中不存在!";
                            return;
                        }
                    }
                    //判断是否为单仓订单
                    if (dtpoloadkey.Select("Loadkey='" + dtpodetailCount.Rows[i]["LOAD KEY"].ToString() + "'").Count() <= 0)
                    {
                        dtpodetailCount.Rows[i]["LF出库单号行号"] = "否";
                    }
                    else
                    {
                        dtpodetailCount.Rows[i]["LF出库单号行号"] = "是";
                    }

                    //判断 Division Code
                    if (dtpodetailCount.Rows[i]["Division Code"].ToString() == "10")
                    {
                        dtpodetailCount.Rows[i]["Division Code"] = "APP";
                    }
                    else if (dtpodetailCount.Rows[i]["Division Code"].ToString() == "20" || dtpodetailCount.Rows[i]["Division Code"].ToString() == "40")
                    {
                        dtpodetailCount.Rows[i]["Division Code"] = "FTW";
                    }
                    else
                    {
                        dtpodetailCount.Rows[i]["Division Code"] = "EQP";
                    }
                }
                #endregion

                #region  建列
                dtpo.Columns.Add("外部单号");
                dtpo.Columns.Add("预出库单类型");
                dtpo.Columns.Add("仓库名称");
                dtpo.Columns.Add("订单日期");
                dtpo.Columns.Add("省");
                dtpo.Columns.Add("市");  //城市
                dtpo.Columns.Add("联系人");
                dtpo.Columns.Add("快递公司");
                dtpo.Columns.Add("备注");
                dtpo.Columns.Add("自定义字段2");  //运输时效
                dtpo.Columns.Add("自定义字段3");  //Division Code
                dtpo.Columns.Add("自定义字段4");  //NFS店铺编码
                dtpo.Columns.Add("地址");      //地址1+地址2+地址3+地址4
                dtpo.Columns.Add("联系方式");
                dtpo.Columns.Add("自定义字段5");  //公司名
                dtpo.Columns.Add("自定义字段6");
                dtpo.Columns.Add("自定义字段7");  //计划发货时间
                dtpo.Columns.Add("自定义字段8");  //VAS Code
                dtpo.Columns.Add("自定义字段9");  //LOAD KEY
                dtpo.Columns.Add("自定义字段10"); //Nike PO
                dtpo.Columns.Add("自定义字段11"); //PACK SLIP NO
                dtpo.Columns.Add("自定义字段12"); //LF出库单号行号 (是否单仓)
                dtpo.Columns.Add("自定义字段13"); //BU
                dtpo.Columns.Add("自定义字段14"); //RP LI
                dtpo.Columns.Add("自定义字段15"); //CRD
                dtpo.Columns.Add("自定义字段16"); //预计卸货时间

                dtpodetail.Columns.Add("外部单号");
                dtpodetail.Columns.Add("仓库");
                dtpodetail.Columns.Add("SKU");  //Sku
                dtpodetail.Columns.Add("UPC");  //UPC
                dtpodetail.Columns.Add("产品等级");
                dtpodetail.Columns.Add("产品名称");
                dtpodetail.Columns.Add("批次号");
                dtpodetail.Columns.Add("托号");
                dtpodetail.Columns.Add("备注");
                dtpodetail.Columns.Add("期望数量");  //数量
                dtpodetail.Columns.Add("自定义字段2");
                dtpodetail.Columns.Add("自定义字段3");
                dtpodetail.Columns.Add("自定义字段4"); //Sku
                dtpodetail.Columns.Add("自定义字段5"); //VAS
                dtpodetail.Columns.Add("自定义字段6"); //Article
                dtpodetail.Columns.Add("自定义字段7"); //Division Code  BU
                dtpodetail.Columns.Add("自定义字段8"); //LF出库单号
                dtpodetail.Columns.Add("自定义字段9"); ////NIke单据编码

                dtpodetail.Columns.Add("单位");
                dtpodetail.Columns.Add("规格");
                #endregion

                #region 拆单 收货日期+BU+门店代码+Loadkey   计划发货时间+Loadkey+运输方式
                for (int i = 0; i < dtpodetailCount.Rows.Count; i++)
                {
                    aa      = dtpodetailCount.Rows[i]["sku"].ToString();
                    bb      = aa.Substring(6, 3);
                    Size    = aa.Substring(9);
                    aa      = aa.Substring(0, 6);
                    Article = aa + '-' + bb;

                    //生成外部单号
                    //string exterNo = dtpodetailCount.Rows[i]["Division Code"].ToString().Substring(0, 1) + '-'
                    //+ dtpodetailCount.Rows[i]["NFS店铺编码"].ToString() + '-' + dtpodetailCount.Rows[i]["LOAD KEY"].ToString();
                    string exterNo = dtpodetailCount.Rows[i]["计划发货时间"].ToString().Replace("-", "") + '-' + dtpodetailCount.Rows[i]["LOAD KEY"].ToString() + '-' + dtpodetailCount.Rows[i]["运输方式"].ToString();

                    //判断外部单号是否存在
                    if (dtpo.Select("外部单号='" + exterNo + "'").Count() <= 0)
                    {
                        DataRow dr = dtpo.NewRow();
                        if (productListfs.Where(m => m.Str10 == Article).ToArray().Length <= 0)
                        {
                            message = "第【" + (i + 2) + "】行," + "【sku】列的Article格式不对或Article " + dtpodetailCount.Rows[i]["sku"].ToString() + "在系统中不存在!";
                            return;
                        }
                        dr["外部单号"]   = exterNo;
                        dr["预出库单类型"] = dtpodetailCount.Rows[i]["订单类型"].ToString();//正常出库AB,残次出库C
                        dr["仓库名称"]   = warehouse.WarehouseName;
                        dr["市"]      = dtpodetailCount.Rows[i]["城市"].ToString();
                        dr["省"]      = "";
                        dr["联系人"]    = "";
                        dr["订单日期"]   = DateTime.Now.ToString();
                        dr["备注"]     = "";
                        dr["自定义字段2"] = dtpodetailCount.Rows[i]["运输时效"].ToString();
                        dr["自定义字段3"] = dtpodetailCount.Rows[i]["运输方式"].ToString();
                        //if (CustomerList.Where(m => m.StorerKey == dtpodetailCount.Rows[i]["NFS店铺编码"].ToString()).ToArray().Length <= 0)
                        //{
                        //    message = "第【" + (i + 2) + "】行," + "【NFS店铺编码】列的店铺编码格式不对或店铺编码 " + dtpodetailCount.Rows[i]["NFS店铺编码"].ToString() + "在系统中不存在!";//dtNike.Rows[i]["Store Code"].ToString() + "不存在!";
                        //    return;
                        //}
                        dr["自定义字段4"]  = dtpodetailCount.Rows[i]["NFS店铺编码"].ToString();
                        dr["地址"]      = dtpodetailCount.Rows[i]["地址3"].ToString() + '&' + dtpodetailCount.Rows[i]["地址4"].ToString() + '&' + dtpodetailCount.Rows[i]["地址2"].ToString() + '&' + dtpodetailCount.Rows[i]["地址1"].ToString();
                        dr["自定义字段5"]  = dtpodetailCount.Rows[i]["公司名"].ToString();
                        dr["联系方式"]    = "";
                        dr["自定义字段6"]  = productListfs.Where(m => m.Str10 == Article).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == Article).ToArray()[0].GenderAge.ToString() : "";
                        dr["自定义字段7"]  = dtpodetailCount.Rows[i]["计划发货时间"].ToString();
                        dr["自定义字段8"]  = dtpodetailCount.Rows[i]["VAS Code"].ToString();
                        dr["自定义字段9"]  = dtpodetailCount.Rows[i]["LOAD KEY"].ToString();
                        dr["自定义字段10"] = dtpodetailCount.Rows[i]["Nike PO"].ToString();
                        dr["自定义字段11"] = dtpodetailCount.Rows[i]["PACK SLIP NO"].ToString();
                        dr["自定义字段12"] = dtpodetailCount.Rows[i]["LF出库单号行号"].ToString();
                        dr["自定义字段13"] = dtpodetailCount.Rows[i]["Division Code"].ToString();//BU
                        //判断 Nike PO 长度是否大于9
                        if (dtpodetailCount.Rows[i]["Nike PO"].ToString().Length >= 9)
                        {
                            if (dtpodetailCount.Rows[i]["Nike PO"].ToString().Substring(8, 1).Equals("L"))
                            {                         //1.S列的第9位为L时,显示为LI,为S时,为RP。
                                dr["自定义字段14"] = "LI"; //LI
                            }
                            else if (dtpodetailCount.Rows[i]["Nike PO"].ToString().Substring(8, 1).Equals("S"))
                            {
                                dr["自定义字段14"] = "RP";//RP
                            }
                            else
                            {// 2.当非L或S时,用T列判断,RP为RP,LI为LI,NIKECN为空值。
                                if (dtpodetailCount.Rows[i]["VAS Code"].ToString().Equals("NIKECN"))
                                {
                                    dr["自定义字段14"] = "";
                                }
                                else
                                {
                                    dr["自定义字段14"] = dtpodetailCount.Rows[i]["VAS Code"].ToString();//RP为RP,LI为LI
                                }
                            }
                        }
                        else
                        {
                            // 2.当非L或S时,用T列判断,RP为RP,LI为LI,NIKECN为空值。
                            if (dtpodetailCount.Rows[i]["VAS Code"].ToString().Equals("NIKECN"))
                            {
                                dr["自定义字段14"] = "";
                            }
                            else
                            {
                                dr["自定义字段14"] = dtpodetailCount.Rows[i]["VAS Code"].ToString();    //RP为RP,LI为LI
                            }
                        }
                        //string.Format("{0:d}", dt)
                        //dr["自定义字段15"] = string.Format("{0:d}", DateTime.Parse(dtpodetailCount.Rows[i]["计划发货时间"].ToString())
                        //   .AddDays(int.Parse(dtpodetailCount.Rows[i]["运输时效"].ToString())));
                        dr["自定义字段15"] = (DateTime.Parse(dtpodetailCount.Rows[i]["计划发货时间"].ToString())
                                         .AddDays(int.Parse(dtpodetailCount.Rows[i]["运输时效"].ToString()))).ToString("yyyy-MM-dd");
                        try
                        {
                            DateTime time = DateTime.Parse(dtpodetailCount.Rows[i]["Nike PO"].ToString().Substring(0, 8).Insert(4, "-").Insert(7, "-"));

                            if (DateTime.Parse(dtpodetailCount.Rows[i]["计划发货时间"].ToString())
                                .AddDays(int.Parse(dtpodetailCount.Rows[i]["运输时效"].ToString())) >= DateTime.Parse(dtpodetailCount.Rows[i]["Nike PO"].ToString().Substring(0, 8).Insert(4, "-").Insert(7, "-"))
                                )
                            {                       //1.当H + I》S时,不显示CRD 2.当H + I < S时,显示CRD为S列前8位 运输时效 Nike PO
                                dr["自定义字段15"] = ""; //CRD
                            }
                            else
                            {
                                dr["自定义字段15"] = dtpodetailCount.Rows[i]["Nike PO"].ToString().Substring(0, 8).Insert(4, "-").Insert(7, "-");
                            }
                        }
                        catch (Exception e)
                        { }

                        //预计卸货时间
                        dr["自定义字段16"] = (DateTime.Parse(dtpodetailCount.Rows[i]["计划发货时间"].ToString())
                                         .AddDays(int.Parse(dtpodetailCount.Rows[i]["运输时效"].ToString()))).ToString("yyyy-MM-dd");
                        try
                        {
                            DateTime time = DateTime.Parse(dtpodetailCount.Rows[i]["Nike PO"].ToString().Substring(0, 8).Insert(4, "-").Insert(7, "-"));
                            dr["自定义字段16"] = dtpodetailCount.Rows[i]["Nike PO"].ToString().Substring(0, 8).Insert(4, "-").Insert(7, "-");
                        }
                        catch (Exception)
                        { }

                        dtpo.Rows.Add(dr);
                    }
                    DataRow drdetail = dtpodetail.NewRow();
                    drdetail["外部单号"] = exterNo;
                    drdetail["仓库"]   = warehouse.WarehouseName;
                    drdetail["SKU"]  = productListfs.Where(m => m.Str10 == Article.Trim().ToUpper() && m.Str9 == Size.Trim().ToUpper() && m.Str8 == "01").ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == Article.Trim().ToUpper() && m.Str9 == Size.Trim().ToUpper() && m.Str8 == "01").ToArray()[0].SKU : "";
                    drdetail["UPC"]  = "";

                    if (dtpodetailCount.Rows[i]["订单类型"].ToString() == "正常出库")
                    {
                        drdetail["产品等级"] = "A品";
                    }
                    else
                    {
                        drdetail["产品等级"] = "C品";
                    }

                    drdetail["产品名称"] = productListfs.Where(m => m.Str10 == Article).ToArray().Length > 0 ? productListfs.Where(m => m.Str10 == Article).ToArray()[0].LongMaterial.ToString() : "";//产品名称

                    drdetail["批次号"]    = "";
                    drdetail["托号"]     = "";
                    drdetail["规格"]     = "";
                    drdetail["备注"]     = "";
                    drdetail["期望数量"]   = dtpodetailCount.Rows[i]["数量"].ToString();
                    drdetail["自定义字段2"] = productListfs.Where(m => m.Str10 == Article.Trim().ToUpper() && m.Str9 == Size.Trim().ToUpper() && m.Str8 == "01").ToArray()[0].Price;    //价格
                    drdetail["自定义字段3"] = productListfs.Where(m => m.Str10 == Article.Trim().ToUpper() && m.Str9 == Size.Trim().ToUpper() && m.Str8 == "01").ToArray()[0].SafeLock; //安全扣
                    drdetail["自定义字段4"] = productListfs.Where(m => m.Str10 == Article.Trim().ToUpper() && m.Str9 == Size.Trim().ToUpper() && m.Str8 == "01").ToArray()[0].Hanger;   //衣架
                    drdetail["自定义字段5"] = dtpodetailCount.Rows[i]["VAS"].ToString();
                    drdetail["自定义字段6"] = Article + '-' + Size;
                    drdetail["自定义字段7"] = dtpodetailCount.Rows[i]["Division Code"];//BU
                    drdetail["自定义字段8"] = dtpodetailCount.Rows[i]["LF出库单号"].ToString();
                    drdetail["自定义字段9"] = dtpodetailCount.Rows[i]["NIke单据编码"].ToString();
                    drdetail["单位"]     = wmsunit.Unit;

                    dtpodetail.Rows.Add(drdetail);
                }
                #endregion

                dsResualt.Tables.Add(dtpo);
                dsResualt.Tables.Add(dtpodetail);

                //ModifyForDataTable MFD = new ModifyForDataTable();
                //dsResualt = MFD.AddSerialNumberForNFS(dsResualt);

                this.AfterData = dsResualt;
            }
            else if (TransDataType == "Receiving")
            {
                #region   架
                DataTable dt = Transdata.Tables[0].Copy();
                foreach (DataRow item in dt.Rows)
                {
                    if (!item["托号"].ToString().Equals(""))
                    {
                        message = "托号列不能有值,请清除后再导入!";
                        return;
                    }
                }

                if (!dt.Columns.Contains("生产日期"))
                {
                    dt.Columns.Add("生产日期");
                }
                if (!dt.Columns.Contains("UPC"))
                {
                    dt.Columns.Add("UPC");
                }
                if (!dt.Columns.Contains("箱内总数"))
                {
                    dt.Columns.Add("箱内总数");
                }
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    try
                    {
                        Convert.ToDateTime(dt.Rows[i]["生产日期"].ToString());
                    }
                    catch
                    {
                        dt.Rows[i]["生产日期"] = System.DateTime.Now.ToString();
                    }
                }
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);

                this.AfterData = ds;
                #endregion
            }
            else if (TransDataType == "Asn")
            {
                try
                {
                    if (ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray().Count() <= 0)
                    {
                        message = "用户没有分配仓库!!";
                        return;
                    }
                    //Asn
                    WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray()[0];
                    IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);
                    WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0];
                    DataTable dtpodetailCount = Transdata.Tables[0]; //获取第1张表
                    DataTable dtpoloadkey     = Transdata.Tables[1]; //获取第2张表


                    #region 验证空值
                    List <ProductSearch> searprolistfs = new List <ProductSearch>();
                    for (int i = 0; i < dtpoloadkey.Rows.Count; i++)
                    {
                        ProductSearch psfs = new ProductSearch();
                        if (dtpoloadkey.Rows[i]["SKU"].ToString().Equals("") || dtpoloadkey.Rows[i]["SKU"].ToString().Length == 0)
                        {
                            message = "第【" + (i + 2) + "】行," + "【SKU】列" + "有空值或格式不正确(应为文本格式)!";
                            return;
                        }
                        if (dtpoloadkey.Rows[i]["UPC"].ToString().Equals("") || dtpoloadkey.Rows[i]["UPC"].ToString().Length == 0)
                        {
                            message = "第【" + (i + 2) + "】行," + "【UPC】列" + "有空值或格式不正确(应为文本格式)!";
                            return;
                        }
                        psfs.Str10 = dtpoloadkey.Rows[i]["SKU"].ToString();
                        psfs.Str9  = dtpoloadkey.Rows[i]["UPC"].ToString();
                        psfs.Str8  = "01";
                        searprolistfs.Add(psfs);
                    }
                    #endregion

                    #region 获得SKU集合
                    IEnumerable <ProductSearch> productListfs;
                    productListfs = ApplicationConfigHelper.GetSearchProduct(CustomerID, searprolistfs, "Acticle");
                    #endregion

                    //退货仓填写默认门店代码
                    for (int i = 0; i < dtpodetailCount.Rows.Count; i++)
                    {
                        dtpodetailCount.Rows[i]["门店代码"] = "QQQQQQ";
                    }


                    for (int i = 0; i < dtpoloadkey.Rows.Count; i++)
                    {
                        string Article = dtpoloadkey.Rows[i]["SKU"].ToString();
                        string Sz      = dtpoloadkey.Rows[i]["UPC"].ToString();
                        try
                        {
                            dtpoloadkey.Rows[i]["SKU"] = productListfs.Where(m => m.Str10 == Article && m.Str9 == Sz && m.Str8 == "01").ToArray()[0].SKU.ToString();
                            dtpoloadkey.Rows[i]["UPC"] = DBNull.Value;
                        }
                        catch (Exception e)
                        {
                            message = "第" + (i + 1) + "行Article【" + Article + "】,Sz【" + Sz + "】在系统中不存在!";
                            return;
                        }
                    }
                    this.AfterData = Transdata;
                }
                catch (Exception e)
                {
                    throw;
                }
            }
            else
            {
                this.AfterData = Transdata;
            }
        }
コード例 #5
0
        public override void CustomerDefinedSettledTransData(ref string message)
        {
            if (this.TransDataType == "PreOrder")
            {
                List <ProductSearch>        productListS = new List <ProductSearch>();//产品
                IEnumerable <ProductSearch> productList;


                if (WareHouseID == 0)
                {
                    message = "用户没有分配仓库!!";
                    return;
                }
                WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseList().Where(m => m.ID == WareHouseID).FirstOrDefault();//customerid获取仓库

                IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);
                WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0];
                DataSet   dsResualt  = new DataSet();
                DataTable dtpo       = new DataTable();
                DataTable dtpodetail = new DataTable();
                dtpo.TableName       = "预出库单主信息$";
                dtpodetail.TableName = "预出库单明细信息$";
                DataTable dtYXDRBJ = Transdata.Tables[0];//获取转换之后的excel数据

                //主表
                dtpo.Columns.Add("外部单号");
                dtpo.Columns.Add("预出库单类型");
                dtpo.Columns.Add("仓库名称");
                dtpo.Columns.Add("订单日期");
                dtpo.Columns.Add("收货公司");
                dtpo.Columns.Add("省");
                dtpo.Columns.Add("市");
                dtpo.Columns.Add("联系人");
                dtpo.Columns.Add("备注");
                dtpo.Columns.Add("地址");
                dtpo.Columns.Add("联系方式");
                dtpo.Columns.Add("自定义字段4");
                dtpo.Columns.Add("自定义字段2");
                dtpo.Columns.Add("自定义字段3");


                //子表
                dtpodetail.Columns.Add("外部单号");
                dtpodetail.Columns.Add("仓库");
                dtpodetail.Columns.Add("SKU");
                dtpodetail.Columns.Add("UPC");
                dtpodetail.Columns.Add("产品名称");
                dtpodetail.Columns.Add("产品等级");
                dtpodetail.Columns.Add("批次号");
                dtpodetail.Columns.Add("托号");
                dtpodetail.Columns.Add("备注");
                dtpodetail.Columns.Add("期望数量");
                dtpodetail.Columns.Add("单位");
                dtpodetail.Columns.Add("规格");
                dtpodetail.Columns.Add("自定义字段4");
                dtpodetail.Columns.Add("自定义字段5");
                dtpodetail.Columns.Add("自定义字段6");


                for (int i = 0; i < dtYXDRBJ.Rows.Count; i++)
                {
                    if (dtpo.Select("外部单号='" + dtYXDRBJ.Rows[i]["订单号"].ToString() + "'").Count() <= 0)//判断excel中是否有相同的外部单号
                    {
                        DataRow dr = dtpo.NewRow();
                        dr["外部单号"]   = dtYXDRBJ.Rows[i]["订单号"].ToString();
                        dr["预出库单类型"] = dtYXDRBJ.Rows[i]["订单类型"].ToString();
                        dr["仓库名称"]   = warehouse.WarehouseName;
                        dr["市"]      = CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray()[0].City : "";
                        dr["省"]      = "";
                        dr["联系人"]    = CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray()[0].Contact1 : "";


                        dr["订单日期"]   = dtYXDRBJ.Rows[i]["订单日期"].ToString();
                        dr["备注"]     = dtYXDRBJ.Rows[i]["备注1"].ToString();
                        dr["自定义字段4"] = dtYXDRBJ.Rows[i]["货主"].ToString();
                        dr["自定义字段2"] = dtYXDRBJ.Rows[i]["备注2"].ToString();
                        dr["自定义字段3"] = dtYXDRBJ.Rows[i]["备注3"].ToString();
                        if (CustomerList.Where(a => a.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray().Length <= 0)
                        {
                            message = dtYXDRBJ.Rows[i]["货主"].ToString() + "货主不存在!!";
                            return;
                        }
                        dr["地址"]   = CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray()[0].AddressLine1 : ""; //地址从wms_customer获取
                        dr["联系方式"] = CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray()[0].PhoneNum1 : "";    //联系方式从wms_customer获取
                        dr["收货公司"] = CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray().Length > 0 ? CustomerList.Where(m => m.StorerKey == dtYXDRBJ.Rows[i]["货主"].ToString()).ToArray()[0].Company : "";      //门店的名称从wms_customer获取


                        dtpo.Rows.Add(dr);//主表添加一行
                    }

                    DataRow drdetail = dtpodetail.NewRow();
                    drdetail["外部单号"] = dtYXDRBJ.Rows[i]["订单号"].ToString();
                    drdetail["仓库"]   = warehouse.WarehouseName;

                    ProductSearch ps = new ProductSearch();
                    ps.Str10 = dtYXDRBJ.Rows[i]["存货Article"].ToString();
                    ps.Str9  = dtYXDRBJ.Rows[i]["存货Size"].ToString();
                    productListS.Add(ps);//先获取Article+size集合,然后一起校验sku

                    drdetail["UPC"] = "";
                    try
                    {
                        drdetail["产品等级"] = dtYXDRBJ.Rows[i]["产品等级"].ToString();
                    }
                    catch
                    {
                        drdetail["产品等级"] = "A品";
                    }
                    drdetail["批次号"]    = "";
                    drdetail["托号"]     = "";
                    drdetail["规格"]     = "";
                    drdetail["备注"]     = "";
                    drdetail["期望数量"]   = dtYXDRBJ.Rows[i]["数量"].ToString();
                    drdetail["自定义字段4"] = dtYXDRBJ.Rows[i]["备注4"].ToString();
                    drdetail["自定义字段5"] = dtYXDRBJ.Rows[i]["备注5"].ToString();
                    drdetail["自定义字段6"] = dtYXDRBJ.Rows[i]["备注6"].ToString();
                    drdetail["单位"]     = dtYXDRBJ.Rows[i]["单位"].ToString();
                    dtpodetail.Rows.Add(drdetail);
                }
                productList = ApplicationConfigHelper.GetSearchProductYXDR(CustomerID, productListS, "ArticleSize");
                for (int i = 0; i < dtpodetail.Rows.Count; i++)
                {
                    if (productList.ToArray().Length <= 0)
                    {
                        message = "excel中的Article+Size未匹配到任何SKU,请检查excel数据!";
                        return;
                    }
                    string sku = productList.Where(p => p.Str10 == productListS[i].Str10 && p.Str9 == productListS[i].Str9).ToArray().Length > 0 ? productList.Where(p => p.Str10 == productListS[i].Str10 && p.Str9 == productListS[i].Str9).ToArray()[0].SKU : "";
                    if (string.IsNullOrEmpty(sku))
                    {
                        int x = i + 1;
                        message = "excel中第" + x + "行的Article=" + productListS[i].Str10 + "和Size=" + productListS[i].Str9 + "未匹配到SKU";
                        return;
                    }
                    dtpodetail.Rows[i]["SKU"]  = sku;
                    dtpodetail.Rows[i]["产品名称"] = productList.Where(p => p.Str10 == productListS[i].Str10 && p.Str9 == productListS[i].Str9).ToArray().Length > 0 ? productList.Where(p => p.Str10 == productListS[i].Str10 && p.Str9 == productListS[i].Str9).ToArray()[0].GoodsName : "";
                }
                //验证同一外部单号是否存在相同的SKU
                //var dd = from t in dtpodetail.AsEnumerable()
                //         group t by new { t1 = t.Field<string>("外部单号"), t2 = t.Field<string>("SKU") } into m
                //         select new
                //         {
                //             外部单号 = m.Select(p => p.Field<string>("外部单号")).First(),
                //             SKU = m.Select(p => p.Field<string>("SKU")).First(),
                //             count = m.Count(),
                //         };
                //var dr1 = dd.Where(c => c.count > 1);
                //if (dr1.Count() > 0)
                //{
                //    foreach (var item in dr1)
                //    {
                //        message += "<p><font color='#FF0000'>外部单号" + item.外部单号 + "中的SKU" + item.SKU + "存在重复值!" + "</font></p>";
                //        return;
                //    }
                //}

                dsResualt.Tables.Add(dtpo);
                dsResualt.Tables.Add(dtpodetail);

                this.AfterData = dsResualt;
            }
            else if (TransDataType == "Asn")//入库单
            {
                if (ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray().Count() <= 0)
                {
                    message = "用户没有分配仓库!!";
                    return;
                }

                List <ProductSearch>        productListS = new List <ProductSearch>();//产品
                IEnumerable <ProductSearch> productList;

                WarehouseInfo warehouse = ApplicationConfigHelper.GetWarehouseListByCustomer(CustomerID).Where(p => p.ID == WareHouseID).ToArray()[0];                         //查询仓库
                IEnumerable <WMS_Customer>       CustomerList = ApplicationConfigHelper.GetAllCustomerByID(CustomerID);                                                        //查询wms_customer
                WMS_UnitAndSpecifications_Config wmsunit      = ApplicationConfigHelper.GetWMS_UnitAndSpecifications_Config(ProjectID, CustomerID, warehouse.ID).ToArray()[0]; //查询单位等信息

                DataSet   dsresult   = new DataSet();
                DataTable dtas       = new DataTable();
                DataTable dtasdetail = new DataTable();
                DataTable dtYXDRBJas = Transdata.Tables[0];

                dtas.TableName       = "预入库单主信息$";
                dtasdetail.TableName = "预入库单明细信息$";

                //主表
                dtas.Columns.Add("外部入库单号");
                dtas.Columns.Add("预入库单类型");
                dtas.Columns.Add("预入库日期");
                dtas.Columns.Add("仓库名称");
                dtas.Columns.Add("客户");
                dtas.Columns.Add("备注");
                dtas.Columns.Add("自定义字段1");
                dtas.Columns.Add("自定义字段2");
                dtas.Columns.Add("自定义字段3");

                //子表
                dtasdetail.Columns.Add("外部入库单号");
                dtasdetail.Columns.Add("仓库");
                dtasdetail.Columns.Add("SKU");
                dtasdetail.Columns.Add("产品名称");
                dtasdetail.Columns.Add("UPC");
                dtasdetail.Columns.Add("规格");
                dtasdetail.Columns.Add("预收数量");
                dtasdetail.Columns.Add("单位");
                dtasdetail.Columns.Add("产品等级");
                dtasdetail.Columns.Add("箱号");
                dtasdetail.Columns.Add("备注");
                dtasdetail.Columns.Add("自定义字段4");
                dtasdetail.Columns.Add("自定义字段5");
                dtasdetail.Columns.Add("自定义字段6");

                for (int i = 0; i < dtYXDRBJas.Rows.Count; i++)
                {
                    if (dtas.Select("外部入库单号='" + dtYXDRBJas.Rows[i]["订单号"].ToString() + "'").Count() <= 0)
                    {
                        DataRow dr = dtas.NewRow();
                        dr["外部入库单号"] = dtYXDRBJas.Rows[i]["订单号"].ToString();
                        dr["预入库单类型"] = dtYXDRBJas.Rows[i]["预入库单类型"].ToString();
                        dr["预入库日期"]  = dtYXDRBJas.Rows[i]["预入库日期"].ToString();
                        dr["仓库名称"]   = warehouse.WarehouseName;
                        dr["客户"]     = dtYXDRBJas.Rows[i]["客户"].ToString();
                        dr["备注"]     = dtYXDRBJas.Rows[i]["备注1"].ToString();
                        dr["自定义字段1"] = dtYXDRBJas.Rows[i]["备注1"].ToString();
                        dr["自定义字段2"] = dtYXDRBJas.Rows[i]["备注2"].ToString();
                        dr["自定义字段3"] = dtYXDRBJas.Rows[i]["备注3"].ToString();
                        dtas.Rows.Add(dr);
                    }

                    //子表
                    DataRow drdetail = dtasdetail.NewRow();
                    drdetail["外部入库单号"] = dtYXDRBJas.Rows[i]["订单号"].ToString();
                    drdetail["仓库"]     = warehouse.WarehouseName;

                    ProductSearch ps = new ProductSearch();
                    ps.SKU = dtYXDRBJas.Rows[i]["SKU"].ToString();
                    productListS.Add(ps);

                    drdetail["UPC"]  = "";
                    drdetail["规格"]   = "";
                    drdetail["预收数量"] = dtYXDRBJas.Rows[i]["预收数量"].ToString();
                    drdetail["箱号"]   = dtYXDRBJas.Rows[i]["箱号"].ToString();
                    drdetail["单位"]   = dtYXDRBJas.Rows[i]["单位"].ToString();
                    try
                    {
                        drdetail["产品等级"] = dtYXDRBJas.Rows[i]["产品等级"].ToString();
                    }
                    catch (Exception)
                    {
                        drdetail["产品等级"] = "A品";//默认A
                    }
                    drdetail["备注"]     = dtYXDRBJas.Rows[i]["备注4"].ToString();
                    drdetail["自定义字段4"] = dtYXDRBJas.Rows[i]["备注4"].ToString();
                    drdetail["自定义字段5"] = dtYXDRBJas.Rows[i]["备注5"].ToString();
                    drdetail["自定义字段6"] = dtYXDRBJas.Rows[i]["备注6"].ToString();
                    dtasdetail.Rows.Add(drdetail);
                }

                productList = ApplicationConfigHelper.GetSearchProductYXDR(CustomerID, productListS, "SKU");

                for (int i = 0; i < dtYXDRBJas.Rows.Count; i++)
                {
                    if (productList.ToArray().Length <= 0)
                    {
                        message = "excel中的SKU在系统中不存在,请检查excel数据!";
                        return;
                    }
                    string sku = productList.Where(p => p.SKU == productListS[i].SKU).ToArray().Length > 0 ? productList.Where(p => p.SKU == productListS[i].SKU).ToArray()[0].SKU : "";
                    if (string.IsNullOrEmpty(sku))
                    {
                        message = "excel中的SKU=" + dtYXDRBJas.Rows[i]["SKU"].ToString() + "在系统中不存在,请检查数据!";
                        return;
                    }
                    dtasdetail.Rows[i]["SKU"]  = sku;
                    dtasdetail.Rows[i]["产品名称"] = productList.Where(p => p.SKU == sku).Select(p => p.GoodsName).FirstOrDefault();
                }

                //验证同一外部单号是否存在相同的SKU
                //var dd = from t in dtasdetail.AsEnumerable()
                //         group t by new { t1 = t.Field<string>("外部入库单号"), t2 = t.Field<string>("SKU") } into m
                //         select new
                //         {
                //             外部单号 = m.Select(p => p.Field<string>("外部入库单号")).First(),
                //             SKU = m.Select(p => p.Field<string>("SKU")).First(),
                //             count = m.Count(),
                //         };
                //var dr1 = dd.Where(c => c.count > 1);
                //if (dr1.Count() > 0)
                //{
                //    foreach (var item in dr1)
                //    {
                //        message += "<p><font color='#FF0000'>外部入库单号" + item.外部单号 + "中的SKU" + item.SKU + "存在重复值!" + "</font></p>";
                //        return;
                //    }
                //}


                dsresult.Tables.Add(dtas);
                dsresult.Tables.Add(dtasdetail);
                this.AfterData = dsresult;
            }
            else if (TransDataType == "Receiving")//上架单
            {
                DataTable dt = new DataTable();
                dt = this.Transdata.Tables[0].Copy();
                if (!dt.Columns.Contains("生产日期"))
                {
                    dt.Columns.Add("生产日期");
                }
                if (!dt.Columns.Contains("UPC"))
                {
                    dt.Columns.Add("UPC");
                }
                if (!dt.Columns.Contains("箱内总数"))
                {
                    dt.Columns.Add("箱内总数");
                }
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    try
                    {
                        Convert.ToDateTime(dt.Rows[i]["生产日期"].ToString());
                    }
                    catch
                    {
                        dt.Rows[i]["生产日期"] = System.DateTime.Now.ToString();
                    }
                }
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);
                this.AfterData = ds;
            }
            else
            {
                this.AfterData = Transdata;
            }
        }