public static Personnel GetBy(string OALoginID) { string sql = "select hd.departmentname as Department,lastname as Name from [dbo].[HrmResource] left join HrmDepartment hd on departmentid = hd.id where loginid = '" + OALoginID + "'"; DataTable dt = Common.SQLHelper.ExecuteQueryToDataTable(Common.SQLHelper.OA_strConn, sql); if (dt == null) { return(null); } Personnel Personnel = Common.ConvertHelper.DataTableToList <Personnel>(dt).First(); return(Personnel); }
public static User GetUserByToken(string Token) { string UserID = User.GetUserIDBy(Token); User user = User.GetBy(UserID); if (user == null) { return(null); } Personnel personnel = Personnel.GetBy(UserID); if (personnel == null) { return(null); } user.UserID = UserID; user.Name = personnel.Name; user.Department = personnel.Department; return(user); }