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