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