public ActionResult AddDeliveryDetail(DeliveryDetailModel model)
{
var productModel = _productService.GetProductByCode(model.ProductCode);
if (productModel == null)
{
return(Json(new
{
IsProductSkusNotFound = true
}));
}
if (_deliveryService.CheckProductExistedInDelivery(model.DeliveryId, productModel.Id))
{
return(Json(new
{
IsDupp = true
}));
}
model.ProductId = productModel.Id;
model.Quantity = model.Quantity;
_deliveryService.InsertDeliveryDetail(model);
return(Json(new { }));
}
public ActionResult ProductAddPopup(string btnId, string formId, int deliveryId, ProductListSelected request)
{
if (request.ProductIds != null)
{
if (!string.IsNullOrEmpty(request.ProductIds))
{
var productIds = request.ProductIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var productId in productIds)
{
var id = Int32.Parse(productId);
var isExisted = _deliveryService.CheckProductExistedInDelivery(deliveryId, id);
if (isExisted)
{
continue;
}
var deliveryDetailModel = new DeliveryDetailModel()
{
Quantity = 1,
VatRate = 0,
DiscountRate = 0,
ProductId = id,
DeliveryId = deliveryId,
UnitPrice = 0
};
_deliveryService.InsertDeliveryDetail(deliveryDetailModel);
}
}
}
return(RedirectToAction("Edit", new { id = deliveryId }));
}
private void CalculateAmount(DeliveryDetailModel deliveryDetailModel)
{
deliveryDetailModel.SubAmount = deliveryDetailModel.UnitPrice * deliveryDetailModel.Quantity;
deliveryDetailModel.DiscountAmount = deliveryDetailModel.SubAmount * deliveryDetailModel.DiscountRate / 100;
deliveryDetailModel.VatAmount = (deliveryDetailModel.SubAmount - deliveryDetailModel.DiscountAmount) *
deliveryDetailModel.VatRate / 100;
deliveryDetailModel.Amount = deliveryDetailModel.SubAmount - deliveryDetailModel.DiscountAmount +
deliveryDetailModel.VatAmount;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DeliveryDetailModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update DeliveryDetail set ");
strSql.Append(" DeliveryDetailId = @DeliveryDetailId , ");
strSql.Append(" DeliveryId = @DeliveryId , ");
strSql.Append(" StockId = @StockId , ");
strSql.Append(" ActualPrice = @ActualPrice , ");
strSql.Append(" DeliveryDetailMemo = @DeliveryDetailMemo ");
strSql.Append(" where DeliveryDetailId=@DeliveryDetailId ");
SqlParameter[] parameters =
{
new SqlParameter("@DeliveryDetailId", SqlDbType.VarChar, 50),
new SqlParameter("@DeliveryId", SqlDbType.VarChar, 50),
new SqlParameter("@StockId", SqlDbType.Decimal, 9),
new SqlParameter("@ActualPrice", SqlDbType.Decimal, 9),
new SqlParameter("@DeliveryDetailMemo", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.DeliveryDetailId;
parameters[1].Value = model.DeliveryId;
parameters[2].Value = model.StockId;
parameters[3].Value = model.ActualPrice;
parameters[4].Value = model.DeliveryDetailMemo; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(DeliveryDetailModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DeliveryDetail(");
strSql.Append("DeliveryDetailId,DeliveryId,StockId,ActualPrice,DeliveryDetailMemo");
strSql.Append(") values (");
strSql.Append("@DeliveryDetailId,@DeliveryId,@StockId,@ActualPrice,@DeliveryDetailMemo");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@DeliveryDetailId", SqlDbType.VarChar, 50),
new SqlParameter("@DeliveryId", SqlDbType.VarChar, 50),
new SqlParameter("@StockId", SqlDbType.Decimal, 9),
new SqlParameter("@ActualPrice", SqlDbType.Decimal, 9),
new SqlParameter("@DeliveryDetailMemo", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.DeliveryDetailId;
parameters[1].Value = model.DeliveryId;
parameters[2].Value = model.StockId;
parameters[3].Value = model.ActualPrice;
parameters[4].Value = model.DeliveryDetailMemo;
bool result = false;
try
{
helper.ExecSqlReInt(strSql.ToString(), parameters);
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
public ActionResult DeliveryDetailEdit(DeliveryDetailModel model)
{
var detail = _deliveryService.GetDeliveryDetailById(model.Id);
if (detail == null)
{
return(Json(new DataSourceResult {
Errors = "Sản phẩm không tồn tại"
}));
}
if (!ModelState.IsValid)
{
return(Json(new DataSourceResult {
Errors = ModelState.SerializeErrors()
}));
}
_deliveryService.UpdateDeliveryDetail(model);
return(new NullJsonResult());
}
