Пример #1
0
        /// <summary>
        /// 星创销售订单导入
        /// </summary>
        /// <param name="dt"></param>
        private bool InsertSaleBill_XC(DataTable dt)
        {
            DataTable tmpdt = FilterData(dt, "数量 > 0");

            //CustomDesktopAlert.H2(tmpdt.Rows.Count.ToString());

            if (tmpdt.Rows.Count > 0)
            {
                Huali.EDI2.DAL.SEOutStock dSale = new EDI2.DAL.SEOutStock();
                int    interId      = dSale.GetMaxFInterID();
                string billNo       = dSale.GetMaxFBillNo();
                string sourceBillNo = tmpdt.Rows[0]["订单号"].ToString();
                //已经翻译到名店编号列
                int    custId      = int.Parse(tmpdt.Rows[0]["购货单位代码"].ToString());
                int    storeId     = int.Parse(tmpdt.Rows[0]["门店代码"].ToString());
                string productName = tmpdt.Rows[0]["收货方部门"].ToString();
                //string explanation = string.Format("补货 {0}", productName);
                string explanation = string.Format("{0}", productName);
                int    empId       = dSale.GetEmpIDByStoreID(storeId);
                Huali.EDI2.Models.SEOutStock mSale = BuildSaleModel(interId, billNo, storeId, explanation, sourceBillNo, custId, 20302, null, 15322, empId);
                try
                {
                    if (dSale.InsertBill(mSale) == true)
                    {
                        //CustomDesktopAlert.H2("写主表成功!");

                        //写子表
                        int succ = 0;
                        for (int i = 0; i < tmpdt.Rows.Count; i++)
                        {
                            Huali.EDI2.DAL.SEOutStockEntry dSaleEnrty = new EDI2.DAL.SEOutStockEntry();
                            int itemId  = int.Parse(tmpdt.Rows[i]["SKU"].ToString());
                            int entryId = i + 1;
                            int stockId = int.Parse(tmpdt.Rows[i]["仓库"].ToString());
                            int qty     = int.Parse(tmpdt.Rows[i]["数量"].ToString());
                            //int cxType = int.Parse(tmpdt.Rows[i]["促销类别"].ToString());
                            Huali.EDI2.DAL.T_ICItem dicitem = new EDI2.DAL.T_ICItem();
                            //decimal price = dicitem.GetSalePriceByFItemID(itemId);
                            decimal price  = 0;
                            int     unitid = dicitem.GetUnitIDByitemID(itemId);

                            Huali.EDI2.Models.SEOutStockEntry mSaleEntry = BuildSaleEntryModel(interId, entryId, itemId, stockId, qty, price, 0, 0, 0, 0, 0, 0, 40384, 40470, unitid);

                            if (dSaleEnrty.InsertBillEntry(mSaleEntry))
                            {
                                succ += 1;
                            }
                        }
                        if (succ == tmpdt.Rows.Count)
                        {
                            CustomDesktopAlert.H2("单据号 " + billNo + " :" + succ + " 条记录导入成功!</h2>");
                            return(true);
                        }
                        else
                        {
                            CustomDesktopAlert.H2(billNo + "写子表失败!");
                            return(false);
                        }
                    }
                    else
                    {
                        CustomDesktopAlert.H2("写主数据表失败");
                        return(false);
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return(false);
                }
            }
            else
            {
                CustomDesktopAlert.H2("没有可用的数据!");
                return(false);
            }
        }
Пример #2
0
        /// <summary>
        /// 将一张订单的数据写入数据库
        /// </summary>
        /// <param name="dt">一张订单的数据</param>
        private bool InsertSaleBill_RL(DataTable dt)
        {
            Huali.EDI2.DAL.SEOutStock dSale = new EDI2.DAL.SEOutStock();
            int    interId      = dSale.GetMaxFInterID();
            string billNo       = dSale.GetMaxFBillNo();
            string sourceBillNo = dt.Rows[0]["订单号"].ToString();
            //已经翻译到名店编号列
            int    custId      = int.Parse(dt.Rows[0]["客户编号"].ToString());
            int    storeId     = int.Parse(dt.Rows[0]["门店编号"].ToString());
            string productName = dt.Rows[0]["补货产品名称"].ToString();
            string explanation = string.Format("免费品 {0} 2+1+1", productName);
            int    empId       = dSale.GetEmpIDByStoreID(storeId);

            Huali.EDI2.Models.SEOutStock mSale = BuildSaleModel(interId, billNo, storeId, explanation, sourceBillNo, custId, 20303, 40394, 15326, empId);
            try
            {
                if (dSale.InsertBill(mSale) == true)
                {
                    //CustomDesktopAlert.H2("写主表成功!");

                    //写子表
                    int succ = 0;
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        Huali.EDI2.DAL.SEOutStockEntry dSaleEnrty = new EDI2.DAL.SEOutStockEntry();
                        int itemId  = int.Parse(dt.Rows[i]["补货产品编号"].ToString());
                        int entryId = i + 1;
                        int stockId = 526;//CSW
                        int qty     = int.Parse(dt.Rows[i]["补货数量"].ToString());
                        Huali.EDI2.DAL.T_ICItem dicitem = new EDI2.DAL.T_ICItem();
                        decimal price = dicitem.GetSalePriceByFItemID(itemId);

                        //Huali.EDI2.Models.SEOutStockEntry mSaleEntry = BuildSaleEntryModel(interId, entryId, itemId, stockId, qty, price, 0, 0, qty, qty, 0, 0,40311,40635, 255);
                        Huali.EDI2.Models.SEOutStockEntry mSaleEntry = BuildSaleEntryModel(interId, entryId, itemId, stockId, qty, price, 0, 0, 0, 0, 0, 0, 40311, 40635, 255);

                        if (dSaleEnrty.InsertBillEntry(mSaleEntry))
                        {
                            succ += 1;
                        }
                    }
                    if (succ == dt.Rows.Count)
                    {
                        CustomDesktopAlert.H2("单据号 " + billNo + " :" + succ + " 条记录导入成功!");
                        return(true);
                    }
                    else
                    {
                        CustomDesktopAlert.H2(billNo + "写子表失败!");
                        return(false);
                    }
                }
                else
                {
                    CustomDesktopAlert.H2("写主数据表失败");
                    return(false);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return(false);
            }
        }