/// <summary> /// 根据商品id获取商品详情 /// </summary> /// <param name="productId"></param> /// <returns></returns> public ProductModel GetProductById(int productId) { var productModel = new ProductModel(); using (var cmd = DataCommandManager.GetDataCommand("GetProductById")) { cmd.SetParameterValue("@Id", productId); using (var dr = cmd.ExecuteDataReader()) { while (dr.Read()) { productModel = DataReaderToProductModel(dr); } } } return productModel; }
private ProductModel DataRowToProductModel(DataRow dr) { var productModel = new ProductModel(); productModel.Id = !Convert.IsDBNull(dr["Id"]) ? Convert.ToInt32(dr["Id"]) : 0; productModel.Name = !Convert.IsDBNull(dr["ProductName"]) ? dr["ProductName"].ToString() : string.Empty; productModel.Stock = !Convert.IsDBNull(dr["Stock"]) ? Convert.ToInt32(dr["Stock"]) : 0; productModel.VirtualSaledCount = !Convert.IsDBNull(dr["VirtualSaledCount"]) ? Convert.ToInt32(dr["VirtualSaledCount"]) : 0; productModel.RealSaledCount = !Convert.IsDBNull(dr["SaledCount"]) ? Convert.ToInt32(dr["SaledCount"]) : 0; productModel.Price = !Convert.IsDBNull(dr["Price"]) ? Convert.ToDecimal(dr["Price"]) : 0; productModel.SheepPrice = !Convert.IsDBNull(dr["SheepPrice"]) ? Convert.ToDecimal(dr["SheepPrice"]) : 0; productModel.FeedPrice = !Convert.IsDBNull(dr["FeedPrice"]) ? Convert.ToDecimal(dr["FeedPrice"]) : 0; productModel.WorkPrice = !Convert.IsDBNull(dr["WorkPrice"]) ? Convert.ToDecimal(dr["WorkPrice"]) : 0; productModel.YearEarningRate = !Convert.IsDBNull(dr["YearEarningRate"]) ? Convert.ToDecimal(dr["YearEarningRate"]) : 0; productModel.EarningRate = !Convert.IsDBNull(dr["EarningRate"]) ? Convert.ToDecimal(dr["EarningRate"]) : 0; productModel.Earning = !Convert.IsDBNull(dr["Earning"]) ? Convert.ToDecimal(dr["Earning"]) : 0; productModel.StartTime = !Convert.IsDBNull(dr["StartTime"]) ? Convert.ToDateTime(dr["StartTime"]) : DateTime.MinValue; productModel.EndTime = !Convert.IsDBNull(dr["EndTime"]) ? Convert.ToDateTime(dr["EndTime"]) : DateTime.MinValue; productModel.CreateTime = !Convert.IsDBNull(dr["CreateTime"]) ? Convert.ToDateTime(dr["CreateTime"]) : DateTime.MinValue; productModel.Status = !Convert.IsDBNull(dr["Status"]) ? Convert.ToInt32(dr["Status"]) : 0; productModel.CreatorId = !Convert.IsDBNull(dr["CreatorId"]) ? Convert.ToInt32(dr["CreatorId"]) : 0; productModel.EarningDay = !Convert.IsDBNull(dr["EarningDay"]) ? Convert.ToInt32(dr["EarningDay"]) : 0; productModel.SheepType = !Convert.IsDBNull(dr["SheepType"]) ? dr["SheepType"].ToString() : string.Empty; productModel.SheepFactory = !Convert.IsDBNull(dr["SheepFactory"]) ? dr["SheepFactory"].ToString() : string.Empty; productModel.ImgUrl = !Convert.IsDBNull(dr["ImgUrl"]) ? dr["ImgUrl"].ToString() : string.Empty; return productModel; }
/// <summary> /// 插入 /// </summary> /// <param name="product"></param> /// <returns></returns> public int InserProduct(ProductModel product) { using (var cmd = DataCommandManager.GetDataCommand("InsertProduct")) { cmd.SetParameterValue("@CreateTime", product.CreateTime); cmd.SetParameterValue("@CreatorId", product.CreatorId); cmd.SetParameterValue("@Earning", product.Earning); cmd.SetParameterValue("@EarningDay", product.EarningDay); cmd.SetParameterValue("@EarningRate", product.EarningRate); cmd.SetParameterValue("@EndTime", product.EndTime); cmd.SetParameterValue("@FeedPrice", product.FeedPrice); cmd.SetParameterValue("@ImgUrl", product.ImgUrl); cmd.SetParameterValue("@ProductName", product.Name); cmd.SetParameterValue("@Price", product.Price); cmd.SetParameterValue("@SaledCount", product.SaledCount); cmd.SetParameterValue("@SheepFactory", product.SheepFactory); cmd.SetParameterValue("@SheepPrice", product.SheepPrice); cmd.SetParameterValue("@SheepType", product.SheepType); cmd.SetParameterValue("@StartTime", product.StartTime); cmd.SetParameterValue("@Status", product.Status); cmd.SetParameterValue("@Stock", product.Stock); cmd.SetParameterValue("@WorkPrice", product.WorkPrice); cmd.SetParameterValue("@YearEarningRate", product.YearEarningRate); var result = cmd.ExecuteScalar(); if (result != null) { return Convert.ToInt32(result); } return 0; } }
/// <summary> /// 更新product /// </summary> /// <param name="product"></param> public void UpdateProduct(ProductModel product) { using (var cmd = DataCommandManager.GetDataCommand("UpdateProductById")) { cmd.SetParameterValue("@Id", product.Id); cmd.SetParameterValue("@CreateTime", product.CreateTime); cmd.SetParameterValue("@CreatorId", product.CreatorId); cmd.SetParameterValue("@Earning", product.Earning); cmd.SetParameterValue("@EarningDay", product.EarningDay); cmd.SetParameterValue("@EarningRate", product.EarningRate); cmd.SetParameterValue("@EndTime", product.EndTime); cmd.SetParameterValue("@FeedPrice", product.FeedPrice); cmd.SetParameterValue("@ImgUrl", product.ImgUrl); cmd.SetParameterValue("@ProductName", product.Name); cmd.SetParameterValue("@Price", product.Price); cmd.SetParameterValue("@SaledCount", product.SaledCount); cmd.SetParameterValue("@SheepFactory", product.SheepFactory); cmd.SetParameterValue("@SheepPrice", product.SheepPrice); cmd.SetParameterValue("@SheepType", product.SheepType); cmd.SetParameterValue("@StartTime", product.StartTime); cmd.SetParameterValue("@Status", product.Status); cmd.SetParameterValue("@Stock", product.Stock); cmd.SetParameterValue("@WorkPrice", product.WorkPrice); cmd.SetParameterValue("@YearEarningRate", product.YearEarningRate); cmd.ExecuteScalar(); } }
private OrderViewModel OrderModelToOrderViewModel(OrderModel orderModel,ProductModel productModel) { var orderViewModel = new OrderViewModel(); if (orderModel != null) { orderViewModel.OrderId = orderModel.OrderId; orderViewModel.UserId = orderModel.UserId; orderViewModel.CreateTime = orderModel.CreateTime; orderViewModel.ProductId = orderModel.ProductId; orderViewModel.ProductCount = orderModel.ProductCount; orderViewModel.Price = orderModel.Price; orderViewModel.Status = orderModel.Status; orderViewModel.PayType = orderModel.PayType; orderViewModel.TotalMoney = orderModel.Price*orderModel.ProductCount; } if (productModel != null) { orderViewModel.ProductName = productModel.Name; } return orderViewModel; }
public ActionResult ProductAddOrEdit(ProductModel product) { product.CreateTime = DateTime.Now; product.CreatorId = Admin.Id; if (Request.Files.Count > 0 && Request.Files[0].ContentLength > 0) { var file = Request.Files[0]; var urlPath = string.Format("/images/upload/{0}/", DateTime.Now.ToString("yyyyMMdd")); var imgFilePath = Server.MapPath(urlPath); var imgName = string.Format("{0}.jpg", Guid.NewGuid()); if (!Directory.Exists(imgFilePath)) { Directory.CreateDirectory(imgFilePath); } file.SaveAs(Path.Combine(imgFilePath, imgName)); product.ImgUrl = string.Format("{0}{1}", urlPath, imgName); } else { if (string.IsNullOrEmpty(product.ImgUrl)) { product.ImgUrl = "/images/no_pic.jpg"; } } if (product.Id == 0) { //insert ProductService.InsertProduct(product); } else if (product.Id > 0) { //update ProductService.UpdateProduct(product); } return RedirectToAction("Product"); }
public void UpdateProduct(ProductModel product) { productDataAccess.UpdateProduct(product); }
public int InsertProduct(ProductModel product) { return productDataAccess.InserProduct(product); }
/// <summary> /// 根据条件获取单个产品 /// </summary> /// <param name="condition"></param> /// <returns></returns> public ProductModel GetProductByCondition(string condition) { var productModel = new ProductModel(); using (var cmd = DataCommandManager.GetDataCommand("GetSingleProductByCondition")) { cmd.CommandText = string.Format("{0} where 1=1 and {1}",cmd.CommandText,condition); using (var dr = cmd.ExecuteDataReader()) { while (dr.Read()) { productModel = DataReaderToProductModel(dr); } } } return productModel; }