public bool AddItem(PhuraseDetailModel detail) { try { var products = Mapper.Map <List <PhuraseProductEntity> >(detail.Products); ProteinDbContext.PhuraseDetails.Add( new PhuraseDetailEntity() { Account = detail.Account, DeliveryNumber = detail.DeliveryNumber, OrderNumber = detail.OrderNumber, Plat = (int)detail.Plat, Products = products, TotalMoney = detail.TotalMoney, TotalTax = detail.TotalTax, TransferMoney = detail.TransferMoney, TransferMoneyWithoutTax = detail.TransferMoneyWithoutTax, Remark = detail.Remark, ReceiptNumber = detail.ReceiptNumber, IsWriteOffMoney = detail.IsWriteOffMoney, Manager = detail.Manager, OrderCreateTime = detail.OrderCreateTime, CompanyInvoiceNumber = detail.CompanyInvoiceNumber, CompanyName = detail.CompanyName } ); ProteinDbContext.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); return(false); } return(true); }
public bool UpdateItem(PhuraseDetailModel detail) { try { var entity = ProteinDbContext.PhuraseDetails.FirstOrDefault(i => detail.Key == i.Key); if (entity == null) { return(false); } entity.Account = detail.Account; entity.DeliveryNumber = detail.DeliveryNumber; entity.OrderNumber = detail.OrderNumber; entity.Plat = (int)detail.Plat; entity.Products = Mapper.Map <ICollection <PhuraseProductEntity> >(detail.Products).ToList(); entity.TotalMoney = detail.TotalMoney; entity.TotalTax = detail.TotalTax; entity.TransferMoney = detail.TransferMoney; entity.TransferMoneyWithoutTax = detail.TransferMoneyWithoutTax; entity.Remark = detail.Remark; entity.ReceiptNumber = detail.ReceiptNumber; entity.IsWriteOffMoney = detail.IsWriteOffMoney; entity.Manager = detail.Manager; entity.OrderCreateTime = detail.OrderCreateTime; entity.CompanyInvoiceNumber = detail.CompanyInvoiceNumber; entity.CompanyName = detail.CompanyName; return(ProteinDbContext.SaveChanges() > 0); } catch (Exception e) { Console.WriteLine(e); return(false); } }
/// <summary> /// 更新需出貨excel /// </summary> /// <param name="filePath"></param> public List <PhuraseDetailModel> AnalyzeShipData(string filePath) { var result = new Dictionary <string, PhuraseDetailModel>(); //载入xls文档 Workbook workbook = new Workbook(); workbook.LoadFromFile(filePath); //获取第一张工作表 Worksheet sheet = workbook.Worksheets[0]; for (int i = 1; i < sheet.Rows.Count(); i++) { var cells = sheet.Rows[i].Cells; if (string.IsNullOrEmpty(cells[0].DisplayedText)) { break; } var data = new PhuraseDetailModel(); data.OrderNumber = cells[0].DisplayedText; //[現貨] 英國官方授權經銷 MYPROTEIN 濃縮乳清蛋白 2.5 KG 開立發票、紙箱包裝 台肌店-口味:藍莓起司蛋糕 var name = string.IsNullOrEmpty(cells[19].DisplayedText) ? cells[18].DisplayedText + "-口味:無口味" : cells[18].DisplayedText + "-口味:" + cells[19].DisplayedText; if (!result.TryGetValue(data.OrderNumber, out var currenData)) { data.Account = cells[3].DisplayedText; Double.TryParse(cells[6].DisplayedText, out Double money); data.TransferMoney = (int)money; data.TotalMoney = Convert.ToInt32(Convert.ToDouble(cells[7].DisplayedText)); data.TotalTax = Convert.ToInt32(Convert.ToDouble(cells[7].DisplayedText) * 0.05); data.TransferMoneyWithoutTax = Convert.ToInt32(Convert.ToDouble(cells[6].DisplayedText) / 1.05); data.Products = new List <PhuraseProductModel>() { new PhuraseProductModel() { ProductName = name, // 需要再蝦皮編輯商品貨號 Count = Convert.ToInt32(cells[24].DisplayedText), ProductMoney = Convert.ToInt32(Convert.ToDouble(cells[5].DisplayedText)), ProductMoneyWithoutTax = Convert.ToInt32(Convert.ToDouble(cells[5].DisplayedText) / 1.05), } }; data.DeliveryNumber = cells[40].DisplayedText; data.Remark = "買家備註:" + cells[44].DisplayedText + "單備註" + cells[45].DisplayedText; result.Add(data.OrderNumber, data); } else { currenData.Products.Add(new PhuraseProductModel() { ProductName = name, // 需要再蝦皮編輯商品貨號 Count = Convert.ToInt32(Convert.ToDouble(cells[24].DisplayedText)), ProductMoney = Convert.ToInt32(Convert.ToDouble(cells[5].DisplayedText)), ProductMoneyWithoutTax = Convert.ToInt32(Convert.ToDouble(cells[5].DisplayedText) / 1.05), //ItemCode=cells[22].ToString()+cells[23].ToString() }); } } return(result.Values.ToList()); }
/// <summary> /// /// </summary> /// <param name="shoppeeFee"></param> /// <param name="receiptnumber"></param> /// <param name="saleWay"></param> /// <returns></returns> public PhuraseDetailModel CreateSale(int shoppeeFee, string receiptnumber, PlatEnum saleWay) { var model = new PhuraseDetailModel(); var a = new List <PhuraseProductModel>(); a = _phurases; model.Products = a; model.TotalMoney = _phurases.Sum(x => x.ProductMoney * x.Count) + shoppeeFee; model.TransferMoney = shoppeeFee; model.TotalTax = Convert.ToInt32((_phurases.Sum(x => x.ProductMoneyWithoutTax * x.Count) + shoppeeFee) * 0.05); model.ReceiptNumber = receiptnumber; model.Plat = saleWay; _phurases.Clear(); return(model); }
public bool DeleteItem(PhuraseDetailModel detail) { try { var entity = ProteinDbContext.PhuraseDetails.FirstOrDefault(i => detail.Key == i.Key); if (entity == null) { return(false); } ProteinDbContext.PhuraseDetails.Remove(entity); return(ProteinDbContext.SaveChanges() > 0); } catch (Exception e) { Console.WriteLine(e); return(false); } }