/// <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;
}
