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();
}
