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