/// <summary>
/// 修改角色记录
/// </summary>
/// <returns>DataTable</returns>
public static bool UpdateUserRole(UserRoleModel model, string loginUserID)
{
//SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE dbo.UserRole ");
sql.AppendLine("SET ");
sql.AppendLine(" RoleID = @RoleID ");
sql.AppendLine(" ,ModifiedDate = getdate() ");
sql.AppendLine(" ,ModifiedUserID = '" + loginUserID + "' ");
sql.AppendLine("WHERE ");
sql.AppendLine(" UserID = @UserID ");
sql.AppendLine(" AND CompanyCD = @CompanyCD ");
//设置参数
SqlParameter[] param = new SqlParameter[3];
param[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
param[1] = SqlHelper.GetParameter("@UserID", model.UserID);
param[2] = SqlHelper.GetParameter("@RoleID", model.RoleID);
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 角色与用户关联信息修改
/// </summary>
/// <param name="model">角色与用户关联信息</param>
/// <returns>更新成功与否</returns>
public static bool UpdateUserRole(UserRoleModel model)
{
//获取登陆用户ID
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
return UserRoleDBHelper.UpdateUserRole(model, loginUserID);
}
/// <summary>
/// 添加角色记录
/// </summary>
/// <returns>DataTable</returns>
public static bool InsertUserRole(UserRoleModel model, string loginUserID)
{
//SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO dbo.UserRole");
sql.AppendLine(" (CompanyCD ");
sql.AppendLine(" ,UserID ");
sql.AppendLine(" ,RoleID ");
sql.AppendLine(" ,ModifiedDate ");
sql.AppendLine(" ,ModifiedUserID) ");
sql.AppendLine("VALUES ");
sql.AppendLine(" (@CompanyCD ");
sql.AppendLine(" ,@UserID ");
sql.AppendLine(" ,@RoleID ");
sql.AppendLine(" ,getdate() ");
sql.AppendLine(" ,'" + loginUserID + "') ");
//设置参数
SqlParameter[] param = new SqlParameter[3];
param[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
param[1] = SqlHelper.GetParameter("@UserID", model.UserID);
param[2] = SqlHelper.GetParameter("@RoleID", model.RoleID);
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
