/// <summary> /// 新增商品 /// </summary> /// <param name="param"></param> public void InsertProduct(ProductInsertParam param) { using (var conn = new MySqlConnection(_configuration["ConnectString"])) { if (!_category.ExistCategory(param.CategoryID.Value)) { throw new Exception("CategoryID不存在"); } var result = conn.Insert("MALL.PRODUCT", param); if (result == 0) { throw new Exception("商品不存在"); } } }
public ActionResult Post(ProductInsertParam objProductInsertParam) { try { if (objAutorized.ValidateTokenResult == null) { return(Ok(new CommonResponse() { error_code = Convert.ToInt32(ErrorCode.Failure), message = "Invalid access." })); } if (objAutorized.ValidateTokenResult.isValid == false) { return(Ok(new CommonResponse() { error_code = Convert.ToInt32(ErrorCode.Failure), message = objAutorized.ValidateTokenResult.error_message })); } ProductTable objProduct = new ProductTable(); objProduct.ProdCatId = objProductInsertParam.ProdCatId; objProduct.ProdName = objProductInsertParam.ProdName; objProduct.ProdDescription = objProductInsertParam.ProdDescription; ValidationContext vc = new ValidationContext(objProduct); var validationsResults = new List <ValidationResult>(); bool correct = Validator.TryValidateObject(objProduct, vc, validationsResults, true); if (!correct) { string errorMessage = ""; foreach (var item in validationsResults.Select(ov => ov.ErrorMessage)) { errorMessage = string.Concat(errorMessage, item); } return(Ok(new CommonResponse() { error_code = Convert.ToInt32(ErrorCode.Failure), message = errorMessage })); } ProductDBAccess obj = ProductDBAccess.getInstance; List <ProductResponse.InsertData> objListData = obj.InsertProduct(objProduct); if (objListData.Count == 0) { return(Ok(new CommonResponse() { error_code = Convert.ToInt32(ErrorCode.Failure), message = "No data insert." })); } if (objListData[0].RowEffect == 0) { return(Ok(new CommonResponse() { error_code = Convert.ToInt32(ErrorCode.Failure), message = objListData[0].message })); } return(Ok(new ProductResponse.InsertData() { error_code = Convert.ToInt32(ErrorCode.Success), message = objListData[0].message, RowEffect = objListData[0].RowEffect, ProductId = objListData[0].ProductId })); } catch (Exception ex) { return(Ok(new CommonResponse() { error_code = Convert.ToInt32(ErrorCode.Failure), message = ex.Message })); } }
public Response CreateProduct(ProductInsertParam param) { _product.InsertProduct(param); return(new Response("操作成功")); }