private void btnRefresh_Click(object sender, EventArgs e) { if (TimKiem_BaoCao.CheckTuNgayDenNgay(calTuNgay.Value, calDenNgay.Value)) { DieuHanhTaxi objDHTaxi = new DieuHanhTaxi(); g_lstCuocGoiKetThuc = new List <DieuHanhTaxi>(); string sLine = StringTools.TrimSpace(txtLine.Text); string SQLCondition = string.Empty; string strTuNgay = string.Format("{0:yyyy-MM-dd HH:mm:ss}", calTuNgay.Value); string strDenNgay = string.Format("{0:yyyy-MM-dd HH:mm:ss}", calDenNgay.Value); SQLCondition = " AND ((ThoiDiemGoi >= cast('" + strTuNgay + "' as datetime)) AND (ThoiDiemGoi <= cast('" + strDenNgay + "' as datetime))) "; // Cuoi goi nho SQLCondition += " AND (GhiChuDienThoai LIKE N'%nhỡ%') "; string soDienThoai = StringTools.TrimSpace(txtDienThoai.Text); if (soDienThoai.Length > 0) { SQLCondition += " AND (PhoneNumber LIKE '%" + soDienThoai + "%')"; } string idNhanVien = StringTools.TrimSpace(txtNhanVien.Text); if (idNhanVien.Length > 0) { SQLCondition += " AND (MaNhanVienDienThoai = '" + idNhanVien + "')"; } if (sLine.Length > 0) { SQLCondition += " AND (Line = '" + sLine + "')"; } string NRecords = ""; g_lstCuocGoiKetThuc = objDHTaxi.Get_CuocGoi_KetThuc(NRecords, SQLCondition); // tim cuoc thuc hien lai cho khach if (g_lstCuocGoiKetThuc != null && g_lstCuocGoiKetThuc.Count > 0) { List <string> danhsachThoiDiemGoiLai = new List <string>(); foreach (DieuHanhTaxi item in g_lstCuocGoiKetThuc) { danhsachThoiDiemGoiLai.Add(DieuHanhTaxi.GetThoiDiemGoiLaiCuocGioNho(item.ThoiDiemGoi, item.PhoneNumber)); } // dong nhat vao ghi chú for (int i = 0; i < g_lstCuocGoiKetThuc.Count; i++) { g_lstCuocGoiKetThuc[i].GhiChuDienThoai = danhsachThoiDiemGoiLai[i]; } } gridDienThoai.DataMember = "lstCuocGoiKetThuc"; gridDienThoai.SetDataBinding(g_lstCuocGoiKetThuc, "lstCuocGoiKetThuc"); btnRefresh.Enabled = false; btnExportExcel.Enabled = !btnRefresh.Enabled; } else { MessageBox.MessageBoxBA msgDialog = new Taxi.MessageBox.MessageBoxBA(); msgDialog.Show(this, "Bạn phải nhập [Từ ngày] nhỏ hơn hoặc bằng [Đến ngày].", "Thông báo", Taxi.MessageBox.MessageBoxButtonsBA.OK, Taxi.MessageBox.MessageBoxIconBA.Warning); return; } }