public ActionResult Create(SysProductEntity model)
{
try
{
if (ModelState.IsValid)
{
model.ProductId = Convert.ToInt32(Request.Form["ProductId"]);
if (logic.GetProductInfo(model.ProductId) == null)
{
model.ProductName = Request.Form["ProductName"];
model.ProductEName = Request.Form["ProductEName"];
model.Remark = Request.Form["Remark"];
logic.AddProduct(model);
return(this.RefreshParent());
}
else
{
return(this.Back("重复的产品线编号：" + model.ProductId));
}
}
return(RedirectToAction("Create"));
}
catch (Exception ex)
{
return(this.Back("新增产品线该模块发生异常。" + ex.Message));
}
}
public int AddProduct(SysProductEntity model)
{
string sql = "INSERT INTO SysProduct(ProductId,ProductName,ProductEName,Remark) VALUES(@ProductId,@ProductName,@ProductEName,@Remark)";
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
return(conn.Execute(sql, model));
}
}
public int UpdateProduct(SysProductEntity model)
{
string sql = "UPDATE SysProduct SET ProductName=@ProductName,ProductEName=@ProductEName,Remark=@Remark WHERE ProductId=@ProductId";
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
return(conn.Execute(sql, model));
}
}
public int AddProduct(SysProductEntity model)
{
return(sysProductDal.AddProduct(model));
}
public int UpdateProduct(SysProductEntity model)
{
return(sysProductDal.UpdateProduct(model));
}
