private SqlParamInfo[] GetRoomInfoPars(DepRoomData roominfo) { return(new SqlParamInfo[] { new SqlParamInfo("房间ID", DbType.String, roominfo.房间ID), new SqlParamInfo("科室ID", DbType.String, roominfo.科室ID), new SqlParamInfo("房间名称", DbType.String, roominfo.房间名称), new SqlParamInfo("房间信息", DbType.String, roominfo.房间信息.ToString()) }); }
/// <summary> /// 更新房间 /// </summary> /// <param name="hisServerData"></param> public void UpdateRoomInfo(DepRoomData roomInfo) { string sql = "Update 影像房间信息 " + " Set 房间名称=:房间名称, 房间信息=:房间信息 where 房间ID=:房间ID"; sql = SqlHelper.GetSqlBiz().GetSqlContext("更新科室角色信息", sql); SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("房间名称", DbType.String, roomInfo.房间名称), new SqlParamInfo("房间信息", DbType.String, roomInfo.房间信息.ToString()), new SqlParamInfo("房间ID", DbType.String, roomInfo.房间ID) }; _dbHelper.ExecuteSQL(sql, sqlPars); }
/// <summary> /// 新增房间 /// </summary> /// <returns></returns> public bool NewRoom(DepRoomData roominfo) { string sql = "insert into " + " 影像房间信息(房间ID,科室ID,房间名称, 房间信息) " + " values " + " (:房间ID,:科室ID,:房间名称, :房间信息)"; sql = SqlHelper.GetSqlBiz().GetSqlContext("插入房间信息", sql); SqlParamInfo[] sqlPars = GetRoomInfoPars(roominfo); DataTable dtResult = _dbHelper.ExecuteSQL(sql, sqlPars); return(true); }