public async Task Can_Update_Organization() { var org = new Organization { ParentId = 0, Name = "变更前" }; var orgId = await Db.InsertAsync(org, true); org.Id = orgId; org.Name = "变更后"; await OrgManage.SaveOrganization(org); var newOrg = await Db.SingleByIdAsync <Organization>(orgId); Assert.AreEqual(newOrg.Name, "变更后"); //同组织下名称不能重复 var oneChild = new Organization { ParentId = orgId, Name = "子组织1" }; var wrongChild = new Organization { ParentId = orgId, Name = "子组织1" }; await Db.InsertAsync(oneChild); Assert.ThrowsAsync <UserFriendlyException>(async() => await OrgManage.SaveOrganization(wrongChild)); }
public async Task Can_Read_ParentName() { var oneChild = await Db.SingleAsync <Organization>(x => x.ParentId > 0); var parentOrg = await Db.SingleByIdAsync <Organization>(oneChild.ParentId); var org = await OrgManage.GetOrganizationById(oneChild.Id); Assert.AreEqual(oneChild.Id, org.Id); Assert.AreEqual(oneChild.ParentId, org.ParentId); Assert.AreEqual(parentOrg.Name, org.ParentName); }
public async Task Can_Delete_Organization() { var org = new Organization { ParentId = 0, Name = "待删除" }; var orgId = await Db.InsertAsync(org, true); Assert.IsTrue(orgId > 0); await OrgManage.DeleteOrganization(orgId); var exist = await Db.ExistsAsync <Organization>(x => x.Id == orgId); Assert.IsFalse(exist); }
public async Task Can_Save_Organization() { var org = new Organization { ParentId = 0, Name = "水利厅" }; var orgId = await OrgManage.SaveOrganization(org); Assert.True(org.Id > 0); var dbOrg = await Db.SingleByIdAsync <Organization>(orgId); Assert.AreEqual(orgId, dbOrg.Id); Assert.AreEqual(org.Name, dbOrg.Name); Assert.AreEqual(org.ParentId, dbOrg.ParentId); }
public async Task Query_Root_Org_Test() { var rootOrgs = await Db.SelectAsync <Organization>(x => x.ParentId == 0); var orgs = await OrgManage.GetRootOrganizations(); Assert.AreEqual(rootOrgs.Count, orgs.Count); rootOrgs.ForEach(org => { var dbOrg = orgs.FirstOrDefault(x => x.Id == org.Id); Assert.NotNull(dbOrg); Assert.AreEqual(org.Name, dbOrg.Name); Assert.AreEqual(org.ParentId, dbOrg.ParentId); }); }
public async Task Can_Query_Organization() { var parentId = await Db.ScalarAsync <long>( Db.From <Organization>().Where(x => x.ParentId == 0).Select(x => Sql.Max(x.Id))); var childCount = await Db.CountAsync <Organization>(x => x.ParentId == parentId); var queryResults = await OrgManage.GetOrganizations( new OrgQuery { PageIndex = 1, PageSize = 10, ParentId = parentId }); Assert.AreEqual(queryResults.Total, childCount); var searchCount = await Db.CountAsync <Organization>(x => x.Name.Contains("组织3")); queryResults = await OrgManage.GetOrganizations( new OrgQuery { PageIndex = 1, PageSize = 10, SearchName = "组织3" }); Assert.AreEqual(queryResults.Total, searchCount); }