public IEnumerable <HrDepartment> GetHrDepartments() { List <HrDepartment> hrDepartments = new List <HrDepartment>(); var connectionString = @"Server=localhost\SQLEXPRESS;Database=SynetecMvcDb;Trusted_Connection=True;"; SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM [dbo].[HrDepartment]"; DataTable dt = new DataTable(); dt.Load(cmd.ExecuteReader()); SqlDataAdapter da = new SqlDataAdapter(cmd); foreach (DataRow row in dt.Rows) { var hrDepartment = new HrDepartment(); hrDepartment.ID = Convert.ToInt32(row[0]); hrDepartment.Title = Convert.ToString(row[1]); hrDepartment.Description = Convert.ToString(row[2]); hrDepartment.BonusPoolAllocationPerc = Convert.ToInt32(row[3]); hrDepartments.Add(hrDepartment); } conn.Close(); return(hrDepartments); }
public HrDepartmentVM MapTo(HrDepartment model) { return(new HrDepartmentVM { Id = model.Id, Code_1C = model.Code_1C, TitleRu = model.TitleRu, TitleUz = model.TitleUz, TitleEn = model.TitleEn }); }
private static void Main(string[] args) { // Взаимодействие отделов предприятия. // Класс отдела кадров. var hrSystem = new HrDepartment(); // Класс бухгалтерской системы. var client = new AccountingDepartment(new EmployeeAdapter(hrSystem)); client.ShowEmployeeList(); Console.ReadKey(); }
/// <summary> /// 根据部门ID得到部门信息 /// </summary> /// <param name="connection"></param> /// <param name="hrGroupID"></param> /// <returns></returns> public static HrDepartment SelectHrGroupByHrGroupID(SqlConnection connection, int hrGroupID) { var model = new HrDepartment(); const string sql = "SELECT HG.Name,HG.Parent,HG.PKID FROM dbo.HrGroup AS HG WITH(NOLOCK) WHERE PKID = @hrGroupID"; var sqlParameter = new SqlParameter("@hrGroupID", hrGroupID); using (var reader = SqlHelper.ExecuteReader(connection, CommandType.Text, sql, sqlParameter)) { if (reader.Read()) { model.Name = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); model.Parent = reader.IsDBNull(1) ? 0 : reader.GetInt32(1); model.PKID = reader.IsDBNull(2) ? 0 : reader.GetInt32(2); } } return(model); }
public void Create(HrDepartment department) { _entitiesContext.HrDepartments.Add(department); _entitiesContext.SaveChanges(); }
public static void Init(AAA.EntityFramework.AAADbContext context) { var userAdministratorId = new Guid("00000000-0000-0000-0000-000000000001"); #region 用户 var userAdministrator = new User() { Id = userAdministratorId, UserAccount = "administrator", PassWord = Zeje.Utils.Encrypt_.SHA256("AAA123"), UserName = "******", UserStatus = UserStatus.启用, LoginIp = "", LoginTime = Clock.Now, LoginCount = 0, LoginFailedTimes = null, RegisterIp = "", RegisterTime = Clock.Now, PasswordSetTime = Clock.Now, UserRoles = null, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId, }; var userAdmin = new User() { Id = new Guid("00000000-0000-0000-0000-000000000002"), UserAccount = "admin", PassWord = Zeje.Utils.Encrypt_.SHA256("AAA123"), UserName = "******", UserStatus = UserStatus.启用, LoginIp = "", LoginTime = Clock.Now, LoginCount = 0, LoginFailedTimes = null, RegisterIp = "", RegisterTime = Clock.Now, PasswordSetTime = Clock.Now, UserRoles = null, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId, }; var userTest = new User() { Id = new Guid("00000000-0000-0000-0000-000000000003"), UserAccount = "test", PassWord = Zeje.Utils.Encrypt_.SHA256("123456"), UserName = "******", UserStatus = UserStatus.启用, LoginIp = "", LoginTime = Clock.Now, LoginCount = 0, LoginFailedTimes = null, RegisterIp = "", RegisterTime = Clock.Now, PasswordSetTime = Clock.Now, UserRoles = null, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId, }; context.Users.AddOrUpdate(userAdministrator); context.Users.AddOrUpdate(userAdmin); context.Users.AddOrUpdate(userTest); #endregion context.SaveChanges(); #region 部门 var department = new HrDepartment() { Id = new Guid("00000000-0000-0000-0000-000000000001"), ParentId = null, Name = "3A集团总部", Description = "3A集团是一个虚拟的集团", CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId, }; context.HrDepartments.AddOrUpdate(department); #endregion context.SaveChanges(); #region 角色 var roleAdmin = new Role() { Id = new Guid("00000000-0000-0000-0000-000000000001"), Name = "管理员", RoleStatus = RoleStatus.启用, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId, }; context.Roles.AddOrUpdate(roleAdmin); var roleCommon = new Role() { Id = new Guid("00000000-0000-0000-0000-000000000002"), Name = "普通用户", RoleStatus = RoleStatus.启用, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId, }; context.Roles.AddOrUpdate(roleCommon); #endregion context.SaveChanges(); #region 用户角色 context.UserRoles.AddOrUpdate(p => new { p.UserId, p.RoleId }, new UserRole() { UserId = userAdministrator.Id, RoleId = roleAdmin.Id, }, new UserRole() { UserId = userAdmin.Id, RoleId = roleAdmin.Id, }, new UserRole() { UserId = userTest.Id, RoleId = roleCommon.Id }); #endregion context.SaveChanges(); #region 页面 var pagePlatform = new Page() { Id = new Guid("00000000-0000-0000-0000-000000000001"), Name = "平台管理", Description = "平台管理", ParentId = null, Sort = 0, PageIconClass = "fa fa-link", PageUrl = "", PageIsMenu = true, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId }; var pageSystem = new Page() { Id = new Guid("00000000-0000-0000-0001-000000000001"), Name = "系统管理", Description = "系统管理", ParentId = pagePlatform.Id, Sort = 0, PageIconClass = "fa fa-link", PageUrl = "", PageIsMenu = true, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId }; var subPage = new Page[] { new Page() { Name = "组织机构管理", Description = "组织机构管理", ParentId = pageSystem.Id, Sort = 0, PageIconClass = "fa fa-link", PageUrl = "", PageIsMenu = true, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId }, new Page() { Name = "角色管理", Description = "角色管理", ParentId = pageSystem.Id, Sort = 0, PageIconClass = "fa fa-link", PageUrl = "", PageIsMenu = true, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId }, new Page() { Name = "用户管理", Description = "用户管理", ParentId = pageSystem.Id, Sort = 0, PageIconClass = "fa fa-link", PageUrl = "", PageIsMenu = true, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId }, new Page() { Name = "功能管理", Description = "功能管理", ParentId = pageSystem.Id, Sort = 0, PageIconClass = "fa fa-link", PageUrl = "", PageIsMenu = true, CreatorUserId = userAdministratorId, LastModifierUserId = userAdministratorId } }; context.Pages.AddOrUpdate(pagePlatform); context.Pages.AddOrUpdate(pageSystem); context.Pages.AddOrUpdate(p => new { p.Name }, subPage.ToArray()); #endregion context.SaveChanges(); }