/// <summary> /// 新增userPrivilege /// </summary> /// <param name="model"></param> public void AddUserPrivilege(UserUpdateModule model) { List <string> sql = new List <string>(); List <SqlParameter[]> param = new List <SqlParameter[]>(); for (int i = 0; i < model.UserPrivilegeList.Count; i++) { StringBuilder str_insert = new StringBuilder(); str_insert.AppendLine("INSERT INTO User_Menu"); str_insert.AppendLine("(UserID, MenuID, IsSelected)"); str_insert.AppendLine(" VALUES "); str_insert.AppendLine(" (@UserID, @MenuID, @IsSelected)"); SqlParameter[] paras2 = new SqlParameter[3]; paras2[0] = new SqlParameter("@UserID", model.UserNameSearch.UserID); paras2[1] = new SqlParameter("@MenuID", model.UserPrivilegeList[i].MenuID); paras2[2] = new SqlParameter("@IsSelected", model.UserPrivilegeList[i].IsSelected); sql.Add(str_insert.ToString()); param.Add(paras2); } SqlAccess mySqlAccess_insert = new SqlAccess(); mySqlAccess_insert.ExecuteNonQuerys(sql, param); }
public async Task UpdateAsync_Test() { // Arrange var user = new UserUpdateModule { Id = 1021, Name = "Admin 21", ChangedFields = new[] { "name" } }; // Act var(result, data) = await repo.QuickUpdateAsync(user, new(new[] { "Name" })); // Assert Assert.IsTrue(result.Ok); Assert.IsNotNull(data); Assert.AreEqual(1, data?.RowsAffected); }
/// <summary> /// 获取User管理详细页面数据 /// </summary> /// <param name="userID"></param> /// <returns></returns> public UserUpdateModule GetUserByID(string userID) { StringBuilder str = new StringBuilder(); str.AppendLine(" SELECT "); str.AppendLine(" UserID, Username, Password, IsDelete "); str.AppendLine(" FROM LoginUser with(Nolock)"); str.AppendLine(" WHERE UserID = @UserID"); SqlParameter[] paras = new SqlParameter[1]; paras[0] = new SqlParameter("@UserID", userID); SqlAccess mySqlAccess = new SqlAccess(); DataSet ds = mySqlAccess.ExecuteAdapter(str.ToString(), paras); UserUpdateModule user = new UserUpdateModule(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { user = DataMappingHelper <UserUpdateModule> .DataTableToEntity(ds.Tables[0]); } return(user); }