/// <summary> /// 修改医生账户方法 /// </summary> /// <param name="m"></param> /// <returns></returns> public int GetUpdDoctorLog(DoctorLog_Model m) { string sql = $"update DoctorLog set Name='{m.Name}',_password='******',cellPhone='{m.cellPhone}',hospital_Id={m.hospital_Id},Department_Id={m.Department_Id},Grade_Id={m.Grade_Id},_certificate='{m._certificate}',identity_img='{m.identity_img}',Practice_img='{m.Practice_img}' where id={m.id}"; int h = helper.ExceuteNonQuery(sql); return(h); }
/// <summary> /// 注册方法 /// </summary> /// <param name="m">数据</param> /// <returns></returns> public int GetDoctorAdd(DoctorLog_Model m) { string sql = GetHelper.GetAddSql(m, "id"); int h = helper.ExceuteNonQuery(sql); return(h); }
/// <summary> /// 账号管理医生修改 /// </summary> /// <param name="m"></param> /// <returns></returns> public int GetupdDoctors(DoctorLog_Model d) { string sql = $"update DoctorLog set userName='******',hospital_Id={d.hospital_Id},Grade_Id={d.Grade_Id},_password='******',cellPhone='{d.cellPhone}' where id={d.id}"; int h = helper.ExceuteNonQuery(sql); return(h); }
/// <summary> /// 添加医生账户 /// </summary> /// <param name="m"></param> /// <returns></returns> public int GetAddDoctorLog(DoctorLog_Model m) { string sql = $"insert into DoctorLog(Name,_password,cellPhone,hospital_Id,Department_Id,Grade_Id,_certificate,identity_img,Practice_img,userName) values('{m.Name}', '{m._password}', '{m.cellPhone}', {m.hospital_Id}, {m.Department_Id}, {m.Grade_Id}, '{m._certificate}', '{m.identity_img}', '{m.Practice_img}','{m.userName}')"; int h = helper.ExceuteNonQuery(sql); return(h); }
/// <summary> /// 账号管理医生添加 /// </summary> /// <param name="m"></param> /// <returns></returns> public int GetAddDoctors(DoctorLog_Model d) { string sql = $"insert into DoctorLog(userName,hospital_Id,Grade_Id,_password,cellPhone) values('{d.userName}',{d.hospital_Id},{d.Grade_Id},'{d._password}','{d.cellPhone}')"; int h = helper.ExceuteNonQuery(sql); return(h); }
/// <summary> /// 医生端注册页面 注册方法 /// </summary> /// <param name="m"></param> /// <returns></returns> public int GetDoctLog_Zhuci(DoctorLog_Model m) { string sql = $"insert into DoctorLog(userName,_password,cellPhone) values('{m.userName}','{m._password}','{m.cellPhone}')"; int h = helper.ExceuteNonQuery(sql); return(h); }
public IActionResult GetAddDoctor(DoctorLog_Model m) { if (m.id == 0) { int h = doctorLog_BLL.GetAddDoctors(m); return(Ok(new { msg = h > 0 ? true : false, mrg = h > 0 ? "添加成功!" : "添加失败!" })); } else { int h = doctorLog_BLL.GetupdDoctors(m); return(Ok(new { msg = h > 0 ? true : false, mrg = h > 0 ? "修改成功!" : "修改失败!" })); } }
public IActionResult GetFanDoctorLog(int id) { List <DoctorLog_Model> models = doctorLog_BLL.GetDoctorLogList(); DoctorLog_Model m = models.Where(p => p.id.Equals(id)).FirstOrDefault(); return(Ok(new { code = 0, msg = "", data = m, count = models.Count })); }
public IActionResult GetAddDoctorLog() { var www = webHost.ContentRootPath; //获取更目录 var phat = $"{www}/wwwroot/imgs/"; //保存文件夹所在的位置 if (!System.IO.Directory.Exists(phat)) //判断文件夹是否存在 { System.IO.Directory.CreateDirectory(phat); //创建一个文件夹 } //创建一个MOdel DoctorLog_Model m = new DoctorLog_Model(); m.id = Convert.ToInt32(Request.Form["id"]); m.userName = Request.Form["userName"]; m.Name = Request.Form["Name"]; m.cellPhone = Request.Form["cellPhone"]; m.Grade_Id = Convert.ToInt32(Request.Form["Grade_Id"]); m.Department_Id = Convert.ToInt32(Request.Form["Department_Id"]); m.hospital_Id = Convert.ToInt32(Request.Form["hospital_Id"]); m._password = Request.Form["_password"]; m._certificate = Request.Form["_certificate2"]; m.identity_img = Request.Form["identity_img2"]; m.Practice_img = Request.Form["Practice_img2"]; //文件 var files = Request.Form.Files; if (m.id != 0) { //删除文件夹中图片 //修改方法 //遍历 foreach (var item in files) { //名字 var fileName = item.FileName; if (item.Name.Equals("_certificate")) { if (m._certificate != null && !System.IO.Directory.Exists($"{www}/wwwroot/" + m._certificate)) { var pat = $"{www}/wwwroot/" + m._certificate; System.IO.File.Delete(pat); } m._certificate = "imgs/zhen" + item.FileName; fileName = "zhen" + fileName; } if (item.Name.Equals("identity_img")) { if (m.identity_img != null && !System.IO.Directory.Exists($"{www}/wwwroot/" + m.identity_img)) { var pat = $"{www}/wwwroot/" + m.identity_img; System.IO.File.Delete(pat); } m.identity_img = "imgs/sheng" + item.FileName; fileName = "sheng" + fileName; } if (item.Name.Equals("Practice_img")) { if (m.Practice_img != null && !System.IO.Directory.Exists($"{www}/wwwroot/" + m.Practice_img)) { var pat = $"{www}/wwwroot/" + m.Practice_img; System.IO.File.Delete(pat); } m.Practice_img = "imgs/zhi" + item.FileName; fileName = "zhi" + fileName; } //数据流上传 using (System.IO.Stream sr = System.IO.File.Create($"{phat}{fileName}")) { item.CopyTo(sr); } } int h = doctorLog_BLL.GetUpdDoctorLog(m); return(Ok(new { state = h >= 1 ? true : false, msg = h >= 1 ? "修改成功!" : "修改失败!" })); } else { //添加方法 //遍历 foreach (var item in files) { //名字 var fileName = item.FileName; if (item.Name.Equals("_certificate")) { m._certificate = "imgs/zhen" + item.FileName; fileName = "zhen" + fileName; } if (item.Name.Equals("identity_img")) { m.identity_img = "imgs/sheng" + item.FileName; fileName = "sheng" + fileName; } if (item.Name.Equals("Practice_img")) { m.Practice_img = "imgs/zhi" + item.FileName; fileName = "zhi" + fileName; } //数据流上传 using (System.IO.Stream sr = System.IO.File.Create($"{phat}{fileName}")) { item.CopyTo(sr); } } int h = doctorLog_BLL.GetAddDoctorLog(m); return(Ok(new { state = h >= 1 ? true : false, msg = h >= 1?"添加成功!":"添加失败!" })); } }
public IActionResult GetUpdDoctor(DoctorLog_Model m) { int h = doctorLog_BLL.GetUpdateTable(m, "id"); return(Ok(new { msg = h })); }
public IActionResult GetDoctLog_Zhuci(DoctorLog_Model m) { int h = doctorLog_BLL.GetDoctLog_Zhuci(m); return(Ok(new { seate = h })); }