/// <summary>
/// 根据Id显示用户列表
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public List <UserJoinDepJoinPosJoinproductJoinJurisdiction> GetUserJoinsById(int userId)
{
List <UserJoinDepJoinPosJoinproductJoinJurisdiction> userJoin = new List <UserJoinDepJoinPosJoinproductJoinJurisdiction>();
string sqlText = $"SELECT * FROM dbo.UserInfo u LEFT JOIN dbo.Department d ON u.U_DepartmentId = d.DepartmentId LEFT JOIN dbo.Position po ON u.U_PositionId = po.PositionId LEFT JOIN dbo.Jurisdiction j ON po.PositionId = j.J_PositionId LEFT JOIN dbo.product pr ON u.ProductTeam = pr.PId WHERE u.UserId = {userId}";
//DataTable data = new DataTable();
//data = SqlDbHelper.ExecuteDataTable(sqlText);
userJoin = JsonConvert.DeserializeObject <List <UserJoinDepJoinPosJoinproductJoinJurisdiction> >(JsonConvert.SerializeObject(SqlDbHelper.ExecuteDataTable(sqlText)));
//截取时间
foreach (var item in userJoin)
{
string dt = item.UserAddTime;
string date = dt.Substring(0, 10);
string time = dt.Substring(11, 5);
string datatime = $"{date} {time}";
item.UserAddTime = datatime;
}
return(userJoin);
}
/// <summary>
/// 根据ID获取职位表
/// </summary>
/// <returns></returns>
public List <Position> GetPositionsById(int positionId)
{
List <Position> positions = new List <Position>();
string sqlText = $"SELECT * FROM dbo.Position WHERE PositionId = '{positionId}'";
positions = JsonConvert.DeserializeObject <List <Position> >(JsonConvert.SerializeObject(SqlDbHelper.ExecuteDataTable(sqlText)));
//截取时间
foreach (var item in positions)
{
string dt = item.PositionAddTime;
string date = dt.Substring(0, 10);
string time = dt.Substring(11, 5);
string datatime = $"{date} {time}";
item.PositionAddTime = datatime;
}
return(positions);
}
/// <summary>
/// 获取职位和权限表
/// </summary>
/// <returns></returns>
public List <PositionJoinJurisdiction> GetPositionsJoinJurisdictionBypPosId(int positionId)
{
List <PositionJoinJurisdiction> posjoinjur = new List <PositionJoinJurisdiction>();
string sqlText = $"SELECT * FROM dbo.Position p LEFT JOIN dbo.Jurisdiction j ON p.PositionId = j.J_PositionId WHERE j.J_PositionId = '{positionId}'";
posjoinjur = JsonConvert.DeserializeObject <List <PositionJoinJurisdiction> >(JsonConvert.SerializeObject(SqlDbHelper.ExecuteDataTable(sqlText)));
return(posjoinjur);
}
/// <summary>
/// 获取部门表
/// </summary>
/// <returns></returns>
public List <Department> GetDepartments()
{
List <Department> departments = new List <Department>();
string sqlText = "SELECT * FROM dbo.Department";
departments = JsonConvert.DeserializeObject <List <Department> >(JsonConvert.SerializeObject(SqlDbHelper.ExecuteDataTable(sqlText)));
return(departments);
}
