/// <summary>
/// 插入产品尺寸记录
/// </summary>
/// <param name="productSize">产品尺寸模型</param>
/// <returns>返回插入产品尺寸记录所影响的行数</returns>
public static int AddProductSize(ProductSizeModel productSize)
{
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@productSizeName", SqlDbType.VarChar, 50),
new SqlParameter("@productSizeDescr", SqlDbType.VarChar, 50)
};
sparams[0].Value = productSize.ProductSizeName;
sparams[1].Value = productSize.ProductSizeDescr;
return(DBHelper.ExecuteNonQuery("AddProductSize", sparams, CommandType.StoredProcedure));
}
public ActionResult ProductSizeIndex()
{
var model = new ProductSizeModel
{
Id = GetParams <int>("id"),
ProductId = GetParams <int>("productid"),
Size = GetParams <string>("size"),
Unitprice = GetParams <decimal>("unitprice"),
Status = GetParams <int>("status"),
Createtime = GetParams <DateTime>("createtime"),
Updatetime = GetParams <DateTime>("updatetime"),
};
return(View(model));
}
public static ProductSizePO ToPO(this ProductSizeModel item)
{
if (item == null)
{
return(null);
}
return(new ProductSizePO
{
Id = item.Id,
ProductId = item.ProductId,
Size = item.Size,
Unitprice = item.Unitprice,
Status = item.Status,
Createtime = item.Createtime,
Updatetime = item.Updatetime,
});
}
/// <summary>
/// 查询产品尺寸
/// </summary>
/// <param name="productSizeID"></param>
/// <returns></returns>
public static ProductSizeModel GetProductSizeItem(int productSizeID)
{
string cmd = "select ProductSizeID,ProductSizeName,ProductSizeDescr from ProductSize where ProductSizeID=@ProductSizeID";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ProductSizeID", productSizeID)
};
SqlDataReader dr = DBHelper.ExecuteReader(cmd, param, CommandType.Text);
dr.Read();
ProductSizeModel psm = new ProductSizeModel();
psm.ProductSizeID = Convert.ToInt32(dr["ProductSizeID"]);
psm.ProductSizeName = dr["ProductSizeName"].ToString();
psm.ProductSizeDescr = dr["ProductSizeDescr"].ToString();
dr.Close();
return(psm);
}
/// <summary>
/// 插入产品尺寸记录
/// </summary>
/// <param name="productSize">产品尺寸模型</param>
/// <returns>返回插入产品尺寸记录所影响的行数</returns>
public static int AddProductSize(ProductSizeModel productSize)
{
return(ProductSizeDAL.AddProductSize(productSize));
}
/// <summary>
/// 更新指定产品尺寸
/// </summary>
/// <param name="productSize">产品尺寸模型</param>
/// <returns>返回更新指定产品尺寸</returns>
public static int UpdProductSizeByID(ProductSizeModel productSize)
{
return(ProductSizeDAL.UpdProductSizeByID(productSize));
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Save(ProductSizeModel model)
{
return(ProductSizeRepository.Save(model.ToPO()));
}
public ProductSizePresenter(IProductSizeView view, ProductSizeModel model)
{
_view = view;
_model = model;
}
public bool Save(ProductSizeModel model)
{
return(new ProductSizeService().Save(model));
}
