/// <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); } }
/// <summary> /// /// </summary> /// <param name="dt"></param> /// <returns></returns> private bool CheckData_XC(DataTable dt) { bool retVal = true; foreach (DataRow dr in dt.Rows) { //检查产品代码 Huali.EDI2.DAL.T_ICItem dICItem = new EDI2.DAL.T_ICItem(); string rowNum = dr["序号"].ToString(); string sku = dr["SKU"].ToString(); int productId = dICItem.GetItemIDBySKU(sku); if (productId == 0) { CustomDesktopAlert.H2("第" + rowNum + "行产品编号不能识别!"); retVal = false; } else { dr["SKU"] = productId.ToString(); } //检查门店ID string storeNumber = dr["门店代码"].ToString(); int storeId = dICItem.GetCustIDByFnumber(storeNumber); if (storeId == 0) { CustomDesktopAlert.H2("第" + rowNum + "行门店代码不能识别!"); //总店编号检查 storeNumber = storeNumber.Substring(0, storeNumber.Length - 3) + "001"; storeId = dICItem.GetCustIDByFnumber(storeNumber); if (storeId == 0) { CustomDesktopAlert.H2("第" + rowNum + "行总店编号不能识别!"); return(false); } else { dr["门店代码"] = storeId.ToString(); } } else { dr["门店代码"] = storeId.ToString(); } //检查客户ID string customNumber = dr["购货单位代码"].ToString(); int customId = dICItem.GetCustIDByFnumber(customNumber); if (customId == 0) { CustomDesktopAlert.H2("第" + rowNum + "行客户编号不能识别!"); return(false); } else { dr["购货单位代码"] = customId.ToString(); } //仓库编号 string stockName = dr["仓库"].ToString(); int stockId = dICItem.GetStockIDByFName(stockName); if (stockId == 0) { CustomDesktopAlert.H2("第" + rowNum + "行仓库编号不能识别!"); return(false); } else { dr["仓库"] = stockId.ToString(); } //促销类别 string cuxiaoType = dr["促销类别"].ToString(); Huali.EDI2.DAL.SEOutStockEntry dEntry = new EDI2.DAL.SEOutStockEntry(); int cxType = dEntry.GetInterIDByFName(cuxiaoType); dr["促销类别"] = cxType.ToString(); } return(retVal); }
/// <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); } }