/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(ProductBuy model, SqlTransaction tran = null)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ProductBuy(");
strSql.Append(" ProductID,BuyUserID,LinkName,LinkTel,CreateTime,IsDelete )");
strSql.Append(" values (");
strSql.Append("@ProductID,@BuyUserID,@LinkName,@LinkTel,@CreateTime,@IsDelete);select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProductID", model.ProductID),
new SqlParameter("@BuyUserID", model.BuyUserID),
new SqlParameter("@LinkName", model.LinkName),
new SqlParameter("@LinkTel", model.LinkTel),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@IsDelete", model.IsDelete),
};
object obj;
if (tran == null)
{
obj = SqlHelper.GetSingle(strSql.ToString(), CommandType.Text, parameters);
}
else
{
obj = SqlHelper.GetSingle(tran, CommandType.Text, strSql.ToString(), parameters);
}
return(obj == null ? 0 : Convert.ToInt32(obj));
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(ProductBuy model, SqlTransaction tran = null)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ProductBuy set ");
strSql.Append("ProductID=@ProductID,BuyUserID=@BuyUserID,LinkName=@LinkName,LinkTel=@LinkTel,CreateTime=@CreateTime,IsDelete=@IsDelete");
strSql.Append(" where ProductBuyId=@ProductBuyId");
SqlParameter[] parameters =
{
new SqlParameter("@ProductID", model.ProductID),
new SqlParameter("@BuyUserID", model.BuyUserID),
new SqlParameter("@LinkName", model.LinkName),
new SqlParameter("@LinkTel", model.LinkTel),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@IsDelete", model.IsDelete),
new SqlParameter("@ProductBuyId", model.ProductBuyId)
};
if (tran == null)
{
return(SqlHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters) > 0);
}
else
{
return(SqlHelper.ExecuteSql(tran, CommandType.Text, strSql.ToString(), parameters) > 0);
}
}
public async Task <ActionResult <ProductBuyDto> > AddProduct([FromBody] ProductBuy productBuy)
{
await _repository.AddProductAsync(productBuy);
await _repository.CommitAsync();
return(CreatedAtAction(nameof(GetProduct),
new { productId = productBuy.ProductId },
productBuy.Adapt <ProductBuyDto> ()));
}
/// <summary>
/// 修改 (可能有其他业务逻辑检查)
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ResultInfo Update(ProductBuy model, SqlTransaction tran = null)
{
ResultInfo ri = new ResultInfo();
if (Edit(model, tran))
{
ri.Ok = true;
ri.Msg = "修改成功";
}
return(ri);
}
public async Task <ActionResult <ProductBuyDto> > UpdateProduct([FromBody] ProductBuy productBuy)
{
var product = await _repository.UpdateProductAsync(productBuy);
if (product == null)
{
return(NotFound());
}
await _repository.CommitAsync();
return(product);
}
public async Task <ProductBuyDto> UpdateProductAsync(ProductBuy productBuy)
{
var product = await _context.Set <ProductBuy> ()
.FirstOrDefaultAsync(p => p.ProductId == productBuy.ProductId);
if (product != null)
{
product.ProductName = productBuy.ProductName;
product.Specification = productBuy.Specification;
product.CategoryId = productBuy.CategoryId;
}
return(product.Adapt <ProductBuyDto> ());
}
public ActionResult OrderBuy(long id = 0)
{
ResultInfo ri = new ResultInfo();
if (id > 0)
{
var model = ProductBLL.Instance.GetModel(id);
if (model != null)
{
if (model.IsDelete == 0)
{
ProductBuy buymodel = new ProductBuy()
{
BuyUserID = UserID,
IsDelete = 0,
CreateTime = DateTime.Now,
//LinkName=string.Empty,
//LinkTel
ProductID = model.ProductID
};
if (ProductBuyBLL.Instance.Add(buymodel) > 0)
{
ri.Ok = true;
//通知商家
var salerInfo = UserBaseBLL.Instance.GetUserInfo(model.CreateUser.ToInt64());
NoticeBLL.Instance.OnOrderBuyProduct_Notice_Saler(salerInfo, model.ProductID.ToString(), model.PTitle, UserInfo.UserName, UserID, GetDomainName, NoticeTypeEnum.OrderBuyProduct);
}
}
else
{
ri.Msg = "产品信息已被删除，不能预约！";
}
}
else
{
ri.Msg = "产品信息不存在！";
}
}
else
{
ri.Msg = "预约信息源错误！";
}
return(Result(ri));
}
/// <summary>
/// 保存 (可能有其他业务逻辑检查)
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public ResultInfo Create(ProductBuy model, SqlTransaction tran = null)
{
ResultInfo ri = new ResultInfo();
if (model == null)
{
return(ri);
}
int result = Add(model, tran);
if (result > 0)
{
ri.Ok = true;
ri.Msg = "添加成功";
}
return(ri);
}
public async Task <IActionResult> Create([Bind("Id,ProductTypeId,ProductName,ProductQualityId,Price,AmountSignId,NumberOfProduct,NumberSignId,TotalPrice,PaymentMethodId,Condition,ManagerSignature,EntryDate")] ProductBuy productBuy)
{
if (ModelState.IsValid)
{
productBuy.TotalPrice = productBuy.Price * productBuy.NumberOfProduct;
productBuy.ManagerSignature = HttpContext.Session.GetString("username");
productBuy.EntryDate = DateTime.Now;
_context.Add(productBuy);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["AmountSignId"] = new SelectList(_context.AmountSign, "AmountSignId", "AmountSignName", productBuy.AmountSignId);
ViewData["NumberSignId"] = new SelectList(_context.NumberSign, "NumberSignId", "NumberSignName", productBuy.NumberSignId);
ViewData["PaymentMethodId"] = new SelectList(_context.PaymentMethod, "PaymentMethodId", "PaymentMethodName", productBuy.PaymentMethodId);
ViewData["ProductQualityId"] = new SelectList(_context.Set <ProductQuality>(), "ProductQualityId", "ProductQualityName", productBuy.ProductQualityId);
ViewData["ProductTypeId"] = new SelectList(_context.Set <ProductType>(), "ProductTypeId", "ProductTypeName", productBuy.ProductTypeId);
return(View(productBuy));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,ProductTypeId,ProductName,ProductQualityId,Price,AmountSignId,NumberOfProduct,NumberSignId,TotalPrice,PaymentMethodId,Condition,ManagerSignature,EntryDate")] ProductBuy productBuy)
{
if (id != productBuy.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
productBuy.TotalPrice = productBuy.Price * productBuy.NumberOfProduct;
productBuy.ManagerSignature = HttpContext.Session.GetString("username");
_context.Update(productBuy);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductBuyExists(productBuy.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["AmountSignId"] = new SelectList(_context.AmountSign, "AmountSignId", "AmountSignName", productBuy.AmountSignId);
ViewData["NumberSignId"] = new SelectList(_context.NumberSign, "NumberSignId", "NumberSignName", productBuy.NumberSignId);
ViewData["PaymentMethodId"] = new SelectList(_context.PaymentMethod, "PaymentMethodId", "PaymentMethodName", productBuy.PaymentMethodId);
ViewData["ProductQualityId"] = new SelectList(_context.Set <ProductQuality>(), "ProductQualityId", "ProductQualityName", productBuy.ProductQualityId);
ViewData["ProductTypeId"] = new SelectList(_context.Set <ProductType>(), "ProductTypeId", "ProductTypeName", productBuy.ProductTypeId);
return(View(productBuy));
}
/// <summary>
/// 修改一条记录
/// </summary>
/// <param name="model">实体对象</param>
/// <returns></returns>
public bool Edit(ProductBuy model, SqlTransaction tran = null)
{
return(dal.Update(model, tran));
}
/// <summary>
/// 添加一条记录，没有任何逻辑
/// </summary>
/// <param name="model">实体对象</param>
/// <returns></returns>
public int Add(ProductBuy model, SqlTransaction tran = null)
{
return(dal.Add(model, tran));
}
public async Task AddProductAsync(ProductBuy productBuy)
{
await _context.Set <ProductBuy> ().AddAsync(productBuy);
}
