/// <summary>
/// 删除用户
/// </summary>
/// <param name="id"></param>
/// <param name="isdelete"></param>
/// <returns></returns>
public ActionResult DeleUser(int id)
{
T_CLINIC user = roomService.GetRoomByKey(Convert.ToInt32(id));
user.IS_USE = 0;
user.CREATE_TIME = DateTime.Now;
roomService.DeleRoom(user);
/// usersService.DeleUser(key);
return(RedirectToAction("Index"));
}
/// <summary>
/// 删除用户（更改诊室是否停用的状态）
/// </summary>
/// <param name="newRoom"></param>
public void DeleRoom(T_CLINIC newRoom)
{
T_CLINIC user = db.T_CLINIC.Find(newRoom.CLINIC_ID);
if (user != null)
{
db.T_CLINIC.Attach(newRoom);
db.Entry(newRoom).State = EntityState.Modified; //直接修改数据库上下文
db.SaveChanges();
//删除多条数据参照查找
}
}
public ActionResult ChangeUser(string roomId, string userName, string nickName, decimal Floor, string ip, string position, string sex)
{
T_CLINIC room = roomService.GetRoomByKey(Convert.ToInt32(roomId));
room.CLINIC_NAME = userName;
room.DEPT_CODE = nickName;
room.FLOOR = Floor;
room.IP_ADDR = ip;
room.POSITION = position;
room.SEX_CODE = sex;
room.IS_USE = 0;
room.CREATE_TIME = DateTime.Now;
roomService.ChangeRoom(room);
return(RedirectToAction("Index"));
}
public ActionResult AddRoom(string userName, string nickName, decimal Floor, string ip, string position, string sex)
{
//实例一个文件
T_CLINIC room = new T_CLINIC();
room.CLINIC_NAME = userName;
room.DEPT_CODE = nickName;
room.FLOOR = Floor;
room.IP_ADDR = ip;
room.POSITION = position;
room.SEX_CODE = sex;
room.IS_USE = 0;
room.CREATE_TIME = DateTime.Now;
roomService.AddRoom(room);
return(RedirectToAction("Index")); //重定向
}
/// <summary>
/// 删除诊室
/// </summary>
/// <param name="key">被删除诊室的主键</param>
public void DeleRoom(T_CLINIC newRoom)
{
roomManageDao.DeleRoom(newRoom);
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="newuser">新用户对象</param>
public void ChangeRoom(T_CLINIC newRoom)
{
roomManageDao.ChangeRoom(newRoom);
}
/// <summary>
/// 添加诊室
/// </summary>
/// <param name="user">新诊室对象</param>
public void AddRoom(T_CLINIC newRoom)
{
roomManageDao.AddRoom(newRoom);
}
/// <summary>
/// 更改诊室信息
/// </summary>
/// <param name="newuser"></param>
public void ChangeRoom(T_CLINIC newRoom)
{
db.T_CLINIC.Attach(newRoom);
db.Entry(newRoom).State = EntityState.Modified; //直接修改数据库上下文
db.SaveChanges();
}
/// <summary>
/// 增加诊室
/// </summary>
/// <param name="user"></param>
public void AddRoom(T_CLINIC room)
{
db.T_CLINIC.Add(room); //直接在数据库上下文的表添加数据
db.SaveChanges(); //可以同时添加多条数据，直接在最后SaveChanges保存就行,返回值为影响的行数
}
