public static EmployeeViewModel getEmployeeInfo(string sys_empid)
{
DataSet dtSet = new DataSet();
HRInfoAccess _access = new HRInfoAccess();
dtSet = _access.HRInfo_QueryAll(sys_empid, "", "", "en", "");
DataTable dtHr = dtSet.Tables[0];
EmployeeViewModel result = new EmployeeViewModel();
result.EMPID = dtHr.Rows[0]["EMPID"].ToString();
result.EMPNAME = dtHr.Rows[0]["EMPNAME"].ToString();
result.EMPNAMEEN = dtHr.Rows[0]["EMPNAMEEN"].ToString();
result.SYS_EMPID = dtHr.Rows[0]["SYS_EMPID"].ToString();
result.SEX = dtHr.Rows[0]["SEX"].ToString();
result.GENDERNAME = dtHr.Rows[0]["GENDERNAME"].ToString();
result.BIRTHDAY = dtHr.Rows[0]["BIRTHDAY"].ToString();
result.EMPIDOLD = dtHr.Rows[0]["EMPIDOLD"].ToString();
result.RFID = dtHr.Rows[0]["RFID"].ToString();
result.FULLNAME = dtHr.Rows[0]["FULLNAME"].ToString();
result.FULLCD = dtHr.Rows[0]["FULLCD"].ToString();
result.ISLEAF = dtHr.Rows[0]["ISLEAF"].ToString();
result.DEPTCODE = dtHr.Rows[0]["DEPTCODE"].ToString();
result.IMAGEURL = dtHr.Rows[0]["IMAGEURL"].ToString();
return(result);
}
public static List <EmployeeItemViewModel> GetAllEmpoyee(string pDeptCode, string pStatus)
{
List <EmployeeItemViewModel> res = new List <EmployeeItemViewModel>();
if (string.IsNullOrEmpty(pDeptCode))
{
return(res);
}
DataTable dtRes = new DataTable();
HRInfoAccess _access = new HRInfoAccess();
dtRes = _access.HRInfo_Query("Q", "", pDeptCode, pStatus, "en");
foreach (DataRow dtr in dtRes.Rows)
{
EmployeeItemViewModel item = new EmployeeItemViewModel
{
EMPID = dtr["EMPID"].ToString(),
SYS_EMPID = dtr["SYS_EMPID"].ToString(),
FULLNAME = dtr["FULLNAME"].ToString(),
EMPNAME = dtr["EMPNAME"].ToString(),
DEPARTMENT = dtr["DEPARTMENT"].ToString(),
STATUS = dtr["STATUS"].ToString(),
IDENTITYCARD = dtr["UID_FOR_MES"].ToString(),
RFID = dtr["RFID"].ToString(),
DATEJOIN = dtr["DATEJOIN"].ToString()
};
res.Add(item);
}
return(res);
}
