private SqlParamInfo[] GetRoleInfoPars(RoleInfoData roleInfo) { return(new SqlParamInfo[] { new SqlParamInfo("角色ID", DbType.String, roleInfo.角色ID), new SqlParamInfo("科室ID", DbType.String, roleInfo.科室ID), new SqlParamInfo("角色名称", DbType.String, roleInfo.角色名称), new SqlParamInfo("分组标记", DbType.String, roleInfo.分组标记), new SqlParamInfo("角色信息", DbType.String, roleInfo.角色信息.ToString()) }); }
/// <summary> /// 更新角色 /// </summary> /// <param name="hisServerData"></param> public void UpdateRoleInfo(RoleInfoData roleInfo) { string sql = "Update 影像角色信息 " + " Set 角色名称=:角色名称, 分组标记=:分组标记, 角色信息=:角色信息 where 角色ID=:角色ID"; sql = SqlHelper.GetSqlBiz().GetSqlContext("更新科室角色信息", sql); SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("角色名称", DbType.String, roleInfo.角色名称), new SqlParamInfo("分组标记", DbType.String, roleInfo.分组标记), new SqlParamInfo("角色信息", DbType.String, roleInfo.角色信息.ToString()), new SqlParamInfo("角色ID", DbType.String, roleInfo.角色ID) }; _dbHelper.ExecuteSQL(sql, sqlPars); }
/// <summary> /// 新增角色 /// </summary> /// <param name="hisServerData"></param> /// <returns></returns> public bool NewRole(RoleInfoData roleInfo) { string sql = "insert into " + " 影像角色信息(角色ID,科室ID,角色名称, 分组标记, 角色信息) " + " values " + " (:角色ID,:科室ID,:角色名称, :分组标记, :角色信息)"; sql = SqlHelper.GetSqlBiz().GetSqlContext("插入科室角色信息", sql); SqlParamInfo[] sqlPars = GetRoleInfoPars(roleInfo); DataTable dtResult = _dbHelper.ExecuteSQL(sql, sqlPars); return(true); }