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