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