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);
}
}
