/// <summary>
/// 新增ㄧ筆出貨紀錄
/// </summary>
/// <param name="item"></param>
public static long Create(ShipmentItemModel item)
{
long number = -1;
using (SQLiteConnection conn = new SQLiteConnection(AppSettings.ConnectString))
{
conn.Open();
using (SQLiteCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"INSERT INTO ShipmentRecord (CustomerCode, ProductCode, Price, ShipQty, ShipDate, ColorCode, ColorName, IsSample, UpdatedTime) VALUES (@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9)";
cmd.Parameters.Add(new SQLiteParameter("@p1", item.CustomerCode));
cmd.Parameters.Add(new SQLiteParameter("@p2", item.ProductCode));
cmd.Parameters.Add(new SQLiteParameter("@p3", item.UnitPrice));
cmd.Parameters.Add(new SQLiteParameter("@p4", item.ShipQty));
cmd.Parameters.AddWithValue("@p5", item.ShipDate);
cmd.Parameters.Add(new SQLiteParameter("@p6", item.ColorCode));
cmd.Parameters.Add(new SQLiteParameter("@p7", item.ColorName));
cmd.Parameters.Add(new SQLiteParameter("@p8", item.IsSample));
cmd.Parameters.Add(new SQLiteParameter("@p9", DateTime.Now));
cmd.ExecuteNonQuery();
number = conn.LastInsertRowId;
}
}
return(number);
}
public async Task <BaseResult> CreateOrUpdate(ShipmentItemModel model)
{
ShipmentItem shipmentItem = model.ToShipmentItem();
if (shipmentItem.Id > 0)
{
return(await Update(shipmentItem.Id, shipmentItem));
}
else
{
return(await Create(shipmentItem));
}
}
public ShipmentItemModel Create(ShipmentItem entity)
{
var shipmentItemModel = new ShipmentItemModel()
{
ProductName = entity.OrderItem.Product.Name,
OrderedQuantity = entity.OrderItem.Quantity,
ShippedQuantity = entity.Quantity,
OrderItemId = entity.OrderItemId,
AttributeText = _formatterService.FormatProductAttributes(entity.OrderItem.AttributeJson),
ImageUrl = _mediaAccountant.GetPictureUrl(entity.OrderItem.Product.MediaItems?.FirstOrDefault(), returnDefaultIfNotFound: true),
Price = _taxSettings.DisplayProductPricesWithoutTax
? entity.OrderItem.Price
: entity.OrderItem.Price + entity.OrderItem.Tax / entity.OrderItem.Quantity,
SeName = entity.OrderItem.Product.SeoMeta.Slug
};
return(shipmentItemModel);
}
public static void Update(ShipmentItemModel item)
{
using (SQLiteConnection conn = new SQLiteConnection(AppSettings.ConnectString))
{
conn.Open();
using (SQLiteCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"Update ShipmentRecord SET ProductCode=@p0, Price=@p1, ShipQty=@p2, ShipDate=@p3, ColorCode=@p4, ColorName=@p5, UpdatedTime=@p6 WHERE SerialNumber=@p7";
cmd.Parameters.AddWithValue("@p0", item.ProductCode);
cmd.Parameters.AddWithValue("@p1", item.UnitPrice);
cmd.Parameters.AddWithValue("@p2", item.ShipQty);
cmd.Parameters.AddWithValue("@p3", item.ShipDate);
cmd.Parameters.AddWithValue("@p4", item.ColorCode);
cmd.Parameters.AddWithValue("@p5", item.ColorName);
cmd.Parameters.AddWithValue("@p6", DateTime.Now);
cmd.Parameters.AddWithValue("@p7", item.SerialNumber);
cmd.ExecuteNonQuery();
}
}
}
public async Task <IActionResult> CreateOrUpdate([FromBody] ShipmentItemModel model)
{
var res = await _shipmentItemService.CreateOrUpdate(model);
return(Ok(res));
}
public static ShipmentItem ToShipmentItem(this ShipmentItemModel model)
{
return(model.MapTo <ShipmentItemModel, ShipmentItem>());
}
