public static DataTable getAll() { var lst = DAL_HISTORY.GetAll(); var dt = new DataTable(); dt = BLL_ExtendList.ToDataTable(lst); DataColumn STT = new DataColumn(); STT.ColumnName = "STT"; dt.Columns.Add(STT); DataColumn NV = new DataColumn(); NV.ColumnName = "NV"; dt.Columns.Add(NV); DataColumn NGAY = new DataColumn(); NGAY.ColumnName = "NGAY"; dt.Columns.Add(NGAY); DataColumn TG = new DataColumn(); TG.ColumnName = "TG"; dt.Columns.Add(TG); DataColumn STATUS = new DataColumn(); STATUS.ColumnName = "STATUS"; dt.Columns.Add(STATUS); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["STT"] = i + 1; //PERSONAL per = DAL_PERSON.getPerByID(int.Parse(dt.Rows[i]["ID_PER"].ToString())); //if (per.TYPE_PS == 1) { dt.Rows[i]["NV"] = DAL_EMPLOYEE.GetFullName(int.Parse(dt.Rows[i]["ID_PER"].ToString())); } //else //{ // dt.Rows[i]["NV"] = "Khách"; //} DateTime time = (DateTime)dt.Rows[i]["TIME_UPDATE"]; dt.Rows[i]["NGAY"] = time.ToShortDateString(); dt.Rows[i]["TG"] = time.ToShortTimeString(); if (dt.Rows[i]["IN_OUT"] == "False") { dt.Rows[i]["STATUS"] = "Ra"; } else { dt.Rows[i]["STATUS"] = "Ra"; } } dt.Columns.Remove("TIME_UPDATE"); dt.Columns.Remove("IN_OUT"); return(dt); }
public static DataTable getAll() { try { var db = new DBEntities(); var lst = db.PERSONALs.ToList(); DataTable dt = BLL_ExtendList.ToDataTable(lst); return(dt); } catch (Exception exx) { return(null); } }
public static DataTable SearchEmp(string key) { var lst = DAL_EMPLOYEE.SearchEmp(key); var dt = new DataTable(); dt = BLL_ExtendList.ToDataTable(lst); DataColumn STT = new DataColumn(); STT.ColumnName = "STT"; dt.Columns.Add(STT); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["STT"] = i + 1; } dt.Columns.Remove("ATTENDANCEs"); dt.Columns.Remove("PERSONAL"); dt.Columns.Remove("ISDELETE"); return(dt); }
public static DataTable filterPage(DateTime s, DateTime e, int num) { var lst = DAL_HISTORY.filterPage(s, e, num); var dt = new DataTable(); dt = BLL_ExtendList.ToDataTable(lst); DataColumn STT = new DataColumn(); STT.ColumnName = "STT"; dt.Columns.Add(STT); DataColumn NV = new DataColumn(); NV.ColumnName = "NV"; dt.Columns.Add(NV); DataColumn NGAY = new DataColumn(); NGAY.ColumnName = "NGAY"; dt.Columns.Add(NGAY); DataColumn TG = new DataColumn(); TG.ColumnName = "TG"; dt.Columns.Add(TG); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["STT"] = (num - 1) * 5 + i + 1; //PERSONAL per = DAL_PERSON.getPerByID(int.Parse(dt.Rows[i]["ID_PER"].ToString())); //if (per.TYPE_PS == 1) { dt.Rows[i]["NV"] = DAL_EMPLOYEE.GetFullName(int.Parse(dt.Rows[i]["ID_PER"].ToString())); } DateTime time = (DateTime)dt.Rows[i]["TIME_UPDATE"]; dt.Rows[i]["NGAY"] = time.ToShortDateString(); dt.Rows[i]["TG"] = time.ToShortTimeString(); } dt.Columns.Remove("TIME_UPDATE"); dt.Columns.Remove("IN_OUT"); return(dt); }
public static DataTable getHisMonth(int id, int month, int year) { //EMPLOYEE emp = DAL_EMPLOYEE.SearchEmpByName(name); var lst = new List <ATTENDANCE>(); var dt = new DataTable(); //if (emp!=null) //{ //int id = emp.ID; lst = DAL_ATTENDANCE.getByMonthEmp(month, year, id); if (lst.Count > 0) { dt = BLL_ExtendList.ToDataTable(lst); DataColumn STT = new DataColumn(); STT.ColumnName = "STT"; dt.Columns.Add(STT); DataColumn NAME = new DataColumn(); NAME.ColumnName = "NAME"; dt.Columns.Add(NAME); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["STT"] = i + 1; dt.Rows[i]["NAME"] = DAL_EMPLOYEE.GetFullName(int.Parse(dt.Rows[i]["ID_EMP"].ToString())); var IN = (TimeSpan)dt.Rows[i]["TIME_IN"]; //string OUT = dt.Rows[i]["TIME_OUT"]; dt.Rows[i]["TIME_IN"] = IN.Hours + ":" + IN.Minutes + ":" + IN.Seconds; try { var OUT = (TimeSpan)dt.Rows[i]["TIME_OUT"]; dt.Rows[i]["TIME_OUT"] = OUT.Hours + ":" + OUT.Minutes + ":" + OUT.Seconds; } catch (Exception ex) { } //} } dt.Columns.Remove("EMPLOYEE"); } return(dt); }
public static DataTable getAll() { var lst = DAL_ATTENDANCE.getAll(); return(BLL_ExtendList.ToDataTable(lst)); }