public int UpdateEmp(string procName, Base_Emp_Information model)
{
string qian = "'";
string hou = "'";
model.Emp_Dept = qian + model.Emp_Dept + hou;
model.Emp_Post = qian + model.Emp_Post + hou;
model.Health = qian + model.Health + hou;
model.Phone = qian + model.Phone + hou;
string id = qian + model.Emp_ID + hou;
int code = 0;
using (IDbConnection conn = new SqlConnection()
{
ConnectionString = connectionString
})
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@updateFile1", model.Emp_Dept);
parameters.Add("@updateFile2", model.Emp_Post);
parameters.Add("@updateFile3", model.Phone);
parameters.Add("@updateFile4", model.Health);
parameters.Add("@id", id);
code = conn.Execute(procName, parameters, commandType: CommandType.StoredProcedure);
}
return(code);
}
public int UpdateEmp([FromForm] Base_Emp_Information model)
{
if (model.Emp_ID == null)
{
return(0);
}
return(bll.Upemp(model));
}
public Base_Emp_Information GetEmpModel(Guid id)
{
Base_Emp_Information model = bll.GetFirstData(id);
if (model != null)
{
return(model);
}
return(null);
}
public int AddEmp(string obj)
{
Base_Emp_Information model = JsonConvert.DeserializeObject <Base_Emp_Information>(obj);
model.Emp_ID = Guid.NewGuid();
model.Political_Outlook = "团员";
model.Entry_Time = model.Entry_Time.ToString();
model.Health = "健康";
model.Emp_Post = "部门员工";
if (Request.Form.Files.Count > 0)
{
//http://localhost:49233+/Files/%E6%96%B0%E5%BB%BA%E6%96%87%E6%9C%AC%E6%96%87%E6%A1%A3.html
//获取物理路径 webtootpath
string path = _hostEnvironment.ContentRootPath + "\\wwwroot\\Files";
//判断是否已经有该文件夹,如果没有,则进行创建
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
//获取到后台传递过来的图片
var file = Request.Form.Files[0];
//判读图片格式是Jpg,Png还是其他
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();
}
model.Emp_Picture = "/Files/" + filename;
}
return(bll.AddEmp(model));
}
public int Upemp(Base_Emp_Information model)
{
return(dal.Upemp(model));
}
public int AddEmp(Base_Emp_Information model)
{
return(dal.AddEmp(model));
}
/// <summary>
/// 修改存储过程 四个字段
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Upemp(Base_Emp_Information model)
{
return(dapper.UpdateEmp("Emp_Update", model));
}
/// <summary>
/// 添加员工信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddEmp(Base_Emp_Information model)
{
return(dapper.AddData(model));
}
