public void FindSpecialRule() { listAudit = new List <auditItem>(); DataControl dataControl = new DataControl(); DataTable dataIDName = new DataTable(); dataControl.GetListIDSpecial(ref dataIDName); for (int i = 0; i < dataIDName.Rows.Count; i++) { string ID = dataIDName.Rows[i][0].ToString().Trim(); string Depart = dataIDName.Rows[i][1].ToString().Trim(); DateTime dateFrom = (dataIDName.Rows[i][2].ToString().Trim() != "") ? (DateTime.ParseExact(dataIDName.Rows[i][2].ToString().Trim().Substring(0, 10), "dd/MM/yyyy", CultureInfo.InvariantCulture)) : DateTime.MinValue; DateTime dateTo = (dataIDName.Rows[i][3].ToString().Trim() != "") ? (DateTime.ParseExact(dataIDName.Rows[i][3].ToString().Trim().Substring(0, 10), "dd/MM/yyyy", CultureInfo.InvariantCulture)) : DateTime.MinValue; if (ID != "") { DataTable dt = new DataTable(); List <m_workingData> m_WorkingDatas = dataControl.GetWorkingData(ID, ref dt, numericUpDown1.Value.ToString()); List <FingerData> GetFingerDatas = new List <FingerData>(); GetFingerDatas = dataControl.GetFingerDatas(ID, numericUpDown1.Value.ToString()); if (m_WorkingDatas != null) { List <auditItem> auditItems = ListSpecialwrongruleFingerData(GetFingerDatas, Depart, dateFrom, dateTo); if (auditItems != null) { foreach (var item in auditItems) { listAudit.Add(item); } } } } } dtgv_bau.DataSource = listAudit; }
public void FindListNG() { DicListNG = new Dictionary <string, List <auditItem> >(); listThieuFingerData = new List <string>(); listwrongWorkingHours = new List <auditItem>(); DataControl dataControl = new DataControl(); DataTable dataIDName = new DataTable(); dataControl.GetListIDName(ref dataIDName, numericUpDown1.Value.ToString()); for (int i = 0; i < dataIDName.Rows.Count; i++) { string ID = dataIDName.Rows[i][0].ToString().Trim(); DataTable dt = new DataTable(); List <m_workingData> m_WorkingDatas = dataControl.GetWorkingData(ID, ref dt, numericUpDown1.Value.ToString()); List <FingerData> GetFingerDatas = dataControl.GetFingerDatas(ID, numericUpDown1.Value.ToString()); if (GetFingerDatas == null || GetFingerDatas.Count == 0) { listThieuFingerData.Add(ID); } else { List <auditItem> auditItems = GetAuditItems(dt, GetFingerDatas); if (auditItems != null && auditItems.Count > 0 && DicListNG.ContainsKey(ID) == false) { DicListNG.Add(ID, auditItems); foreach (var item in auditItems) { listwrongWorkingHours.Add(item); } } } } dtgv_inout.DataSource = listThieuFingerData.Select(x => new { Value = x }).ToList(); dtgv_workingtime.DataSource = listwrongWorkingHours; }