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