/// <summary> /// 更新手术间 /// </summary> /// <param name="room"></param> /// <returns></returns> public int UpdateOpsRoom(Neusoft.HISFC.Models.Operation.OpsRoom room) { string strSql = string.Empty; string strValid = Neusoft.FrameWork.Function.NConvert.ToInt32(room.IsValid).ToString(); if (this.Sql.GetSql("Operator.OpsTableManage.UpdateOpsRoom.1", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, room.Name, room.InputCode, strValid, room.DeptID, room.OperCode, room.ID); } catch (Exception ex) { this.Err = ex.Message; this.ErrCode = ex.Message; return(-1); } if (strSql == null) { return(-1); } return(this.ExecNoQuery(strSql)); }
/// <summary> /// 根据科室获得科室下手术间 /// </summary> /// <param name="deptID"></param> /// <returns></returns> public ArrayList GetRoomsByDept(string deptID) { ArrayList rooms = new ArrayList(); string strSql = string.Empty; if (this.Sql.GetSql("Operator.OpsTableManage.GetRoomsByDept.1", ref strSql) == -1) { return(rooms); } try { strSql = string.Format(strSql, deptID); } catch (Exception ex) { this.Err = ex.Message; this.ErrCode = ex.Message; return(rooms); } if (strSql == null) { return(rooms); } if (this.ExecQuery(strSql) == -1) { return(rooms); } try { while (Reader.Read()) { Neusoft.HISFC.Models.Operation.OpsRoom room = new Neusoft.HISFC.Models.Operation.OpsRoom(); room.ID = Reader[2].ToString(); //代码 room.Name = Reader[3].ToString(); //名称 room.InputCode = Reader[4].ToString(); //助记码 room.DeptID = deptID; //所属科室 room.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(Reader[6].ToString()); room.OperCode = Reader[7].ToString(); room.OperDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[8].ToString()); rooms.Add(room); } } catch (Exception ex) { this.Err = ex.Message; this.ErrCode = ex.Message; if (this.Reader.IsClosed == false) { Reader.Close(); } return(rooms); } Reader.Close(); return(rooms); }
/// <summary> /// 删除手术间 /// </summary> /// <param name="room"></param> /// <returns></returns> public int DelOpsRoom(Neusoft.HISFC.Models.Operation.OpsRoom room) { string strSql = string.Empty; if (this.Sql.GetSql("Operator.OpsTableManage.DelOpsRoom.1", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, room.ID); } catch (Exception ex) { this.Err = ex.Message; this.ErrCode = ex.Message; return(-1); } if (this.ExecNoQuery(strSql) == -1) { return(-1); } //删除手术间下的手术台 if (this.Sql.GetSql("Operator.OpsTableManage.DelOpsRoom.2", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, room.ID); } catch (Exception ex) { this.Err = ex.Message; this.ErrCode = ex.Message; return(-1); } if (this.ExecNoQuery(strSql) == -1) { return(-1); } return(0); }
public new OpsRoom Clone() { OpsRoom newOpsRoom = base.Clone() as OpsRoom; return(newOpsRoom); }