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