public IActionResult PostIndent([FromBody] IndentDto indentDto)
{
if (indentDto == null)
{
return(BadRequest());
}
Indent model = new Indent();
model.Account = indentDto.Account;
model.Amount = indentDto.Amount;
model.CreatTIme = System.DateTime.Now;
model.Count = indentDto.Count;
model.Price = _productRepository.GetSeed(indentDto.SeedID).Price;
model.FinishedTime = System.DateTime.Now;
model.SeedID = _productRepository.GetSeed(indentDto.SeedID).SeedID;
model.Status = IndentStatus.创建;
{ var InventoryModel = _productRepository.GetInventory(model.SellerID, model.SeedID);
if (InventoryModel.Count - model.Count < 0)
{
return(BadRequest("库存不足"));
}
}
_productRepository.AddIndent(model);
if (!_productRepository.Save())
{
return(BadRequest("错误"));
}
return(Ok());
}
/// <summary>
///订单显示
/// </summary>
/// <param name="orderSite"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public List <IndentDto> GetIndentPageList(int userId, int OrderSite)
{
using (MySqlConnection conn = new MySqlConnection(connStr))
{
string sql1 = string.Format("select orders.*,address.detailaddress,address.AddressPerson from address join orders on address.Id = orders.addressId where orders.usersId = {0} and orders.OrderSite={1}", userId, OrderSite);
var orderlist = conn.Query <IndentDto>(sql1).ToList();
string sql2 = string.Format("select goods.goodsimg as img,goods.GoodsName,ordergoods.ordersid from ordergoods join goods on ordergoods.GoodsId=goods.Id where UsersId={0}", userId);
var goodslist = conn.Query <orderImg>(sql2).ToList();
List <IndentDto> indent = new List <IndentDto>();
foreach (var item in orderlist)
{
IndentDto indentDto = new IndentDto();
indentDto.ApplyMethod = item.ApplyMethod;
indentDto.Id = item.Id;
indentDto.AddressPerson = item.AddressPerson;
indentDto.PracticalMoney = item.PracticalMoney;
indentDto.OrderSite = item.OrderSite;
List <string> imgs = new List <string>();
foreach (var item1 in goodslist.Where(a => a.ordersid == item.Id))
{
imgs.Add(item1.img);
}
indentDto.imgs = imgs;
indent.Add(indentDto);
}
return(indent);
}
}
public async Task <JsonResult> AddIndent([FromBody] IndentDto IndentDto)
{
try
{
RepositoryWrapper.IndentDetails.AddIndent(IndentDto.IndentDetails, IndentDto.IndentProducts);
return(await base.FinalizStatusCodeeMessage("Indent Created Successfully", 200));
}
catch (Exception ex)
{
return(await base.FinalizStatusCodeeMessage("Error: Failure in Indent Create : " + ex, 500));
}
}
public IActionResult GetIndent(int indentid)
{
var model = _productRepository.GetIndentForId(indentid);
if (model == null)
{
return(BadRequest());
}
IndentDto result = new IndentDto
{
Account = model.Account,
Amount = model.Amount,
CreatTIme = model.CreatTIme,
Count = model.Count,
Price = model.Price,
FinishedTime = model.FinishedTime,
IndentID = model.IndentID,
SeedID = model.SeedID,
Status = model.Status
};
return(Ok(result));
}
public IActionResult PatchIndent(int indentID, [FromBody] JsonPatchDocument <IndentDto> jsonPatch)
{
if (jsonPatch == null)
{
return(BadRequest());
}
var model = _productRepository.GetIndentForId(indentID);
if (model == null)
{
return(NotFound());
}
IndentDto patch = new IndentDto
{
Account = model.Account,
Amount = model.Amount,
CreatTIme = model.CreatTIme,
Count = model.Count,
FinishedTime = System.DateTime.Now,
Status = model.Status,
SeedID = _productRepository.GetSeed(model.SeedID).SeedID,
Price = _productRepository.GetSeed(model.SeedID).Price
};
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
TryValidateModel(patch);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
model.Account = patch.Account;
model.Amount = patch.Amount;
model.CreatTIme = patch.CreatTIme;
model.FinishedTime = patch.FinishedTime;
model.SeedID = patch.SeedID;
model.Status = patch.Status;
if (!_productRepository.Save())
{
return(StatusCode(500, "更新出错"));
}
else
if (model.Status != IndentStatus.异常)
{
_productRepository.AddSellInformation(new SellInformation
{
Account = model.Account,
IndentID = model.IndentID,
SeedID = model.SeedID,
SellCount = model.Count,
SellerID = model.SellerID,
SellTime = model.FinishedTime
});
_productRepository.GetInventory(model.SellerID, model.SeedID).Count -= model.Count;
if (!_productRepository.Save())
{
return(StatusCode(500, "更新出错在向库存更新数目时出错"));
}
}
return(NoContent());
}
public IActionResult PutIndent(int indentid, [FromBody] IndentDto indentDto)
{
if (indentDto == null)
{
return(BadRequest());
}
Indent Put = new Indent
{
Account = indentDto.Account,
Amount = indentDto.Amount,
CreatTIme = indentDto.CreatTIme,
FinishedTime = indentDto.FinishedTime,
Count = indentDto.Count,
Price = _productRepository.GetSeed(indentDto.SeedID).Price,
SeedID = _productRepository.GetSeed(indentDto.SeedID).SeedID,
Status = indentDto.Status,
SellerID = _productRepository.GetSeller(indentDto.SellerID).SellerID,
};
var model = _productRepository.GetIndentForId(indentid);
if (model == null)
{
return(NotFound());
}
var InventoryModel = _productRepository.GetInventory(Put.SellerID, Put.SeedID);
if (InventoryModel == null)
{
return(BadRequest("无此库存"));
}
if (InventoryModel.Count - Put.Count < 0)
{
return(BadRequest("库存不足"));
}
model.Account = Put.Account;
model.Amount = Put.Amount;
model.CreatTIme = Put.CreatTIme;
model.FinishedTime = Put.FinishedTime;
model.SeedID = Put.SeedID;
model.Status = Put.Status;
model.SellerID = Put.SellerID;
if (model.Status == IndentStatus.完成)
{
_productRepository.AddSellInformation(new SellInformation
{
Account = model.Account,
IndentID = model.IndentID,
SeedID = model.SeedID,
SellCount = model.Count,
SellerID = model.SellerID,
SellTime = model.FinishedTime
});
}
if (!_productRepository.Save())
{
return(BadRequest());
}
return(NoContent());
}
