public int UpdMaterial(string obj)
{
MaterialTableModel m = JsonConvert.DeserializeObject <MaterialTableModel>(obj);
var s = m.Material_Image;
if (Request.Form.Files.Count > 0)
{
//获取物理路径 webtootpath
string path = _hostEnvironment.ContentRootPath + "\\wwwroot\\img";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
var file = Request.Form.Files[0];
string fileExt = file.FileName.Split('.')[file.FileName.Split('.').Length - 1];
string filename = Guid.NewGuid().ToString() + "." + fileExt;
string fileFullName = path + "\\" + filename;
using (FileStream fs = System.IO.File.Create(fileFullName))
{
file.CopyTo(fs);
fs.Flush();
}
m.Material_Image = "/img/" + filename;
}
return(_bll.UpdMaterial(m));
}
/// <summary>
/// 添加物料
/// </summary>
/// <param name="mod"></param>
/// <returns></returns>
public int AddMaterial(MaterialTableModel mod)
{
return(_dal.AddMaterial(mod));
}
/// <summary>
/// 修改物料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int UpdMaterial(MaterialTableModel model)
{
return(_dal.UpdMaterial(model));
}
/// <summary>
/// 修改物料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int UpdMaterial(MaterialTableModel model)
{
string sql = $"update MaterialTable set Material_TypeId = {model.Material_TypeId},Material_PlaceName='{model.Material_PlaceName}',Material_Id = '{model.Material_Id}',Material_Name = '{model.Material_Name}',Material_Desc = '{model.Material_Desc}',Material_Image = '{model.Material_Image}',Material_Price = {model.Material_Price},Material_Number = {model.Material_Number},Material_State = {model.Material_State} where Id = {model.Id}";
return(dapper.Execute(sql));
}
/// <summary>
/// 添加物料
/// </summary>
/// <param name="mod"></param>
/// <returns></returns>
public int AddMaterial(MaterialTableModel mod)
{
var sql = $"insert into MaterialTable values('{mod.Material_Id}','{mod.Material_Name}',{mod.Material_TypeId},{mod.Material_Price},{mod.Material_Number},{mod.Material_LastNumber},'{mod.Material_Desc}','{mod.Material_Image}',{mod.Material_State},2,1,'2020-05-06',0,2,'{mod.Material_PlaceName}')";
return(dapper.Execute(sql));
}
