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