public static void LoadDrivers_Active()
{
try
{
if (_listDriver_Active == null)
{
_listDriver_Active = new T_NHANVIEN().GetAllDriver_Active();
}
if (_dictDriver == null)
{
_dictDriver = new Dictionary <string, T_NHANVIEN>();
}
if (_dictDriver_MaNV == null)
{
_dictDriver_MaNV = new Dictionary <string, T_NHANVIEN>();
}
if (_listDriver_Active != null && _listDriver_Active.Count > 0)
{
foreach (var item in _listDriver_Active)
{
if (!_dictDriver.ContainsKey(item.FK_SoHieuXeLai))
{
_dictDriver.Add(item.FK_SoHieuXeLai, item);
}
if (!_dictDriver_MaNV.ContainsKey(item.PK_MaNhanVien))//*sign
{
_dictDriver_MaNV.Add(item.PK_MaNhanVien, item);
}
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("LoadDrivers_Active ", ex);
}
}
public static List <DoiTac> GetDoiTacs_V2(int KieuTimKiem, string ThongTinTimKiem)
{
try
{
List <DoiTac> lstDoiTac = new List <DoiTac>();
DataTable dt = new DataTable();
dt = new Data.DM.DoiTac().GetDoiTacs_V2(KieuTimKiem, ThongTinTimKiem);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
lstDoiTac.Add(DoiTac.GetDoiTacByRow(dr));
}
}
dt.Dispose();
dt = null;
return(lstDoiTac);
}
catch (Exception ex)
{
LogError.WriteLogError("GetDoiTacs_V2: ", ex);
return(new List <DoiTac>());
}
}
public List <DoiTac> GetListOfDoiTacs(bool isActive)
{
try
{
List <DoiTac> lstDoiTac = new List <DoiTac>();
DataTable dt = new DataTable();
dt = new Data.DM.DoiTac().GetDSDoiTacs(isActive);// lay ta ca
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
lstDoiTac.Add(DoiTac.GetDoiTacByRow(dr));
}
}
return(lstDoiTac);
}
catch (Exception ex)
{
LogError.WriteLogError("GetListOfDoiTacs: ", ex);
return(new List <DoiTac>());
}
}
/// <summary>
/// Load danh sách cuộc gọi gần đây
/// </summary>
private void KhoiTaoCuocKhachOnlineLenMEM()
{
try
{
dicCuocOnline.Clear();
DataTable dt = new Data.CuocGoi().GetCuocOnlines_v2();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
DanhBaEx dicRet = new DanhBaEx();
string soDienThoai = dr["PhoneNumber"] == DBNull.Value ? string.Empty : dr["PhoneNumber"].ToString();
string diaChi = dr["DiaChiDonKhach"] == DBNull.Value ? string.Empty : dr["DiaChiDonKhach"].ToString();
if (soDienThoai != string.Empty && diaChi != string.Empty)
{
if (dicCuocOnline.ContainsKey(soDienThoai))
{
continue;
}
string diaChiTra = dr["DiaChiTraKhach"] == DBNull.Value ? string.Empty : dr["DiaChiTraKhach"].ToString();
int vung = dr["Vung"] == DBNull.Value ? 0 : int.Parse(dr["Vung"].ToString());
string maDoiTac = dr["MaDoiTac"] == DBNull.Value ? string.Empty : dr["MaDoiTac"].ToString();
string loaiXe = dr["LoaiXe"] == DBNull.Value ? string.Empty : dr["LoaiXe"].ToString();
float kinhDo = dr["GPS_KinhDo"] == DBNull.Value ? 0 : float.Parse(dr["GPS_KinhDo"].ToString());
float viDo = dr["GPS_ViDo"] == DBNull.Value ? 0 : float.Parse(dr["GPS_ViDo"].ToString());
string lenhDienThoai = dr["LenhDienThoai"] == DBNull.Value ? string.Empty : dr["LenhDienThoai"].ToString();
string GhiChuDienThoai = dr["GhiChuDienThoai"] == DBNull.Value ? string.Empty : dr["GhiChuDienThoai"].ToString();
DateTime ThoiDiemGoi = dr["ThoiDiemGoi"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(dr["ThoiDiemGoi"].ToString());
long ID = dr["ID"] == DBNull.Value ? 0 : long.Parse(dr["ID"].ToString());
int SoLanGoi = dr["SoLanGoi"] == DBNull.Value ? 0 : int.Parse(dr["SoLanGoi"].ToString());
int KieuKHGoiDen = dr["KieuKhachHangGoiDen"] == DBNull.Value ? 0 : int.Parse(dr["KieuKhachHangGoiDen"].ToString());
dicRet.Address = diaChi;
dicRet.PhoneNumber = soDienThoai;
dicRet.Vung = vung;
dicRet.MaDoiTac = maDoiTac;
dicRet.LoaiXe = loaiXe;
dicRet.Address_Destination = diaChiTra;
dicRet.GPS_KinhDo = kinhDo;
dicRet.GPS_ViDo = viDo;
dicRet.LenhTiepNhan = lenhDienThoai;
dicRet.GhiChuTiepNhan = GhiChuDienThoai;
dicRet.SoLanGoi = SoLanGoi;
dicRet.IdCuocGoi = ID;
dicRet.ThoiDiemGoi = ThoiDiemGoi;
try
{
dicRet.KieuKHGoiDen = (KieuKhachHangGoiDen)KieuKHGoiDen;
}
catch
{
dicRet.KieuKHGoiDen = KieuKhachHangGoiDen.KhachHangBinhThuong;
}
dicCuocOnline.TryAdd(soDienThoai, dicRet);
if (Global.IsDebug)
{
LogError.WriteLogInfo("KhoiTaoCuocKhachOnlineLenMEM:" + soDienThoai + "-" + dicRet.Address);
}
}
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("KhoiTaoCuocKhachOnlineLenMEM.", ex);
}
}
public DanhBaEx GetGlobalContacsInfo(string phoneNumber)
{
DanhBaEx item = new DanhBaEx();
try
{
if (Global.IsDebug)
{
LogError.WriteLogInfo("GetGlobalContacsInfo:" + phoneNumber);
}
if (dicMoiGioi.ContainsKey(phoneNumber))
{
item = dicMoiGioi[phoneNumber];
if (Global.IsDebug)
{
LogError.WriteLogInfo("dicMoiGioi:" + phoneNumber + "-" + item.Address);
}
return(item);
}
// lấy từ cuốc online
//lock (dicCuocOnline)
//{
if (dicCuocOnline.ContainsKey(phoneNumber))
{
item = dicCuocOnline[phoneNumber];
if (Global.IsDebug)
{
LogError.WriteLogInfo("dicCuocOnline:" + dicCuocOnline.Count.ToString() + "-" + dicCuocOnline[phoneNumber].PhoneNumber + "-" + item.PhoneNumber + "-" + " - " + phoneNumber + item.Address);
}
return(dicCuocOnline[phoneNumber]);
}
//}
if (dicKhachQuen.ContainsKey(phoneNumber))
{
item = dicKhachQuen[phoneNumber];
if (Global.IsDebug)
{
LogError.WriteLogInfo("dicKhachQuen:" + phoneNumber + "-" + item.Address);
}
return(item);
}
// lấy theo danh bạ
if (dicDanhBaCongTy.ContainsKey(phoneNumber))
{
item = dicDanhBaCongTy[phoneNumber];
if (Global.IsDebug)
{
LogError.WriteLogInfo("dicDanhBaCongTy:" + phoneNumber + "-" + item.Address);
}
return(item);
}
//if (soDienThoai.StartsWith("04"))
//{
// //Nếu là số điện thoại bàn ở HN thì mới check trong danh mục Bưu Điện.
// if (dicDanhBa_BuuDien.ContainsKey(soDienThoai))
// {
// item = dicDanhBa_BuuDien[soDienThoai];
// diaChi = item.Address;
// if (item.Name != "")
// diaChi = string.Format("[{0}]{1}", item.Name, diaChi);
// kieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;
// }
//}
}
catch (Exception ex)
{
LogError.WriteLogError("GetGlobalContacsInfo.", ex);
return(item);
}
return(item);
}
public static void LayThongTinCauHinh()
{
if (_layThongTinCauHinh == false)
{
_layThongTinCauHinh = true;
}
else
{
return;
}
try
{
DataTable dt = QuanTriCauHinh.GetThongTinCauHinh();
if ((dt == null) || (dt.Rows.Count <= 0))
{
ThietLapMacDinh();
}
else
{
DataRow dr = dt.Rows[0];
mTenCongTy = dr["TenCongTy"].ToString();
mLogoPath = dr["LogoCongTy"].ToString();
mSoGiayGioiHanThoiGianChuyenTongDai = int.Parse(dr["SoGiayGioiHanThoiGianChuyenTongDai"].ToString().Length > 0 ? dr["SoGiayGioiHanThoiGianChuyenTongDai"].ToString() : "60");
mSoGiayGioiHanThoiGianDieuXe = int.Parse(dr["SoGiayGioiHanThoiGianDieuXe"].ToString().Length > 0 ? dr["SoGiayGioiHanThoiGianDieuXe"].ToString() : "120");
mSoGiayGioiHanThoiGianDonKhach = int.Parse(dr["SoGiayGioiHanThoiGianDonKhach"].ToString().Length > 0 ? dr["SoGiayGioiHanThoiGianDonKhach"].ToString() : "300");
mSoPhutGioiHanMatLienLac = int.Parse(dr["SoPhutGioiHanMatLienLac"].ToString().Length > 0 ? dr["SoPhutGioiHanMatLienLac"].ToString() : "120");
mSoPhutGioiHanMatLienLacBaoNghi = int.Parse(dr["SoPhutGioiHanMatLienLacBaoNghi"].ToString().Length > 0 ? dr["SoPhutGioiHanMatLienLacBaoNghi"].ToString() : "180");
mSoPhutGioiHanMatLienLacBaoDiSanBay = int.Parse(dr["SoPhutGioiHanMatLienLacBaoDiSanBay"].ToString().Length > 0 ? dr["SoPhutGioiHanMatLienLacBaoDiSanBay"].ToString() : "180");
mSoPhutGioiHanMatLienLacBaoDiDuongDai = int.Parse(dr["SoPhutGioiHanMatLienLacBaoDiDuongDai"].ToString().Length > 0 ? dr["SoPhutGioiHanMatLienLacBaoDiDuongDai"].ToString() : "180");
mSoDauCuaTongDai = dr["SoDauCuaTongDai"].ToString();
mThuMucDuLieuTanasonic = dr["ThuMucDuLieuTanasonic"].ToString();
mThuMucFileAmThanh = dr["ThuMucFileAmThanh"].ToString();
mTatCaLineCuaHeThong = dr["TatCaLineCuaHeThong"].ToString();
mCacLineCuaTaxiOperation = dr["CacLineCuaTaxiOperation"].ToString();
mSoDienThoaiCongTy = dr["SoDienThoaiCongTy"].ToString();
mHasTongDai = Convert.ToBoolean(dr["HasTongDai"].ToString());
mSoDongCuocGoiDaGiaiQuyet = Convert.ToInt16(dr["SoDongCuocGoiDaGiaiQuyet"].ToString());
mKiemTraXeDaRaHoatDong = dr["KiemTraXeDaRaHoatDong"] != DBNull.Value && bool.Parse(dr["KiemTraXeDaRaHoatDong"].ToString());
mCacVungTongDai = dr["CacVungTongDai"].ToString();
mTinhTienCuocHaiChieuKhongNgatCuoc = dr["TinhTienCuocHaiChieuKhongNgatCuoc"] != DBNull.Value && bool.Parse(dr["TinhTienCuocHaiChieuKhongNgatCuoc"].ToString());
KichHoachTaxiGroupDon = dr["KichHoachTaxiGroupDon"] != DBNull.Value && bool.Parse(dr["KichHoachTaxiGroupDon"].ToString());
SoPhutGiuKhachChuaCoXeNhan = Convert.ToByte(dr["SoPhutGiuKhachChuaCoXeNhan"].ToString());
SoPhutGiuKhachCoXeNhan = Convert.ToByte(dr["SoPhutGiuKhachCoXeNhan"].ToString());
SoPhutGiuKhachLai = Convert.ToByte(dr["SoPhutGiuKhachLai"].ToString());
GPS_MaCungXN = dr["GPS_MaXN"].ToString();
GPS_LoaiBanDo = dr["GPS_MAP_LoaiBanDo"].ToString();
GPS_MucZoom = Convert.ToInt32(dr["GPS_MAP_Zoom"].ToString());
GPS_KinhDo = float.Parse(dr["GPS_MAP_KinhDo"].ToString());
GPS_ViDo = float.Parse(dr["GPS_MAP_ViDo"].ToString());
GPS_TenTinh = dr["GPS_TenTinh"].ToString();
GPS_TrangThai = dr["GPS_Trangthai"] != DBNull.Value && bool.Parse(dr["GPS_Trangthai"].ToString());
GPS_BKGioiHan = Convert.ToInt32(dr["GPS_BKGioiHan"].ToString());
GPS_BKXeNhan = Convert.ToInt32(dr["GPS_BKXeNhan"].ToString());
GPS_KetNoiManHinh = dr["GPS_KetNoiManHinh"] != DBNull.Value && bool.Parse(dr["GPS_KetNoiManHinh"].ToString());
GopKenh_TrangThai = dr["GopKenh_TrangThai"] != DBNull.Value && bool.Parse(dr["GopKenh_TrangThai"].ToString());
GopKenh_GioBD = TimeSpan.Parse(dr["GopKenh_GioBD"].ToString());
GopKenh_GioKT = TimeSpan.Parse(dr["GopKenh_GioKT"].ToString());
var ft = false;
if (dr.Table.Columns["FT_ChieuVe_CoDuyet"] != null)
{
bool.TryParse(dr["FT_ChieuVe_CoDuyet"].ToString(), out ft);
FT_ChieuVe_CoDuyet = ft;
var ft_ChieuVe_CoDuyet = false;
bool.TryParse(dr["FT_ChieuVe_CoChotCo"].ToString(), out ft_ChieuVe_CoDuyet);
FT_ChieuVe_CoChotCo = ft_ChieuVe_CoDuyet;
}
else
{
FT_ChieuVe_CoChotCo = false;
}
if (dr.Table.Columns["FT_KM"] != null)
{
int FT_KM = 1;
if (dr["FT_KM"] != DBNull.Value)
{
int.TryParse(dr["FT_KM"].ToString(), out FT_KM);
}
FT_SoKM = FT_KM;
}
else
{
FT_SoKM = 5;
}
if (dr.Table.Columns["FT_KM"] != null)
{
try
{
FT_ServiceMap = (Utils.Enums.Enum_FT_ServiceMap)Enum.Parse(typeof(Utils.Enums.Enum_FT_ServiceMap), dr["FT_ServiceMap"].ToString());
}
catch
{
FT_ServiceMap = Utils.Enums.Enum_FT_ServiceMap.Google;
}
}
else
{
FT_ServiceMap = Utils.Enums.Enum_FT_ServiceMap.None;
}
if (dr.Table.Columns["FT_ChieuVe_Active"] != null)
{
FT_ChieuVe_Active = dr["FT_ChieuVe_Active"] != DBNull.Value && bool.Parse(dr["FT_ChieuVe_Active"].ToString());
}
if (dr.Table.Columns["FT_Active"] != null)
{
FT_Active = dr["FT_Active"] != DBNull.Value && bool.Parse(dr["FT_Active"].ToString());
}
if (dr.Table.Columns.Contains("FolderAmThanh") && dr["FolderAmThanh"] != null && !string.IsNullOrEmpty(dr["FolderAmThanh"].ToString()))
{
FolderAmThanh = dr["FolderAmThanh"].ToString();
}
else
{
FolderAmThanh = @"D:\Public\AmThanhEnVangVip";
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("Lấy T.tin cấu hình", ex);
}
}
/// <summary>
/// Load danh sách lái xe theo thời gian
/// </summary>
public static bool LoadDrivers_Active_LastUpdate()
{
bool hasUpdate = false;
try
{
if ((Driver_LastUpdate == DateTime.MinValue) && _listDriver_Active != null && _listDriver_Active.Count > 0)
{
Driver_LastUpdate = _listDriver_Active.Max(p => p.LastUpdate);
}
if (Driver_LastUpdate == null || Driver_LastUpdate == DateTime.MinValue)
{
Driver_LastUpdate = GetTimeServer();
}
if (_listDriver_Active == null)
{
_listDriver_Active = new T_NHANVIEN().GetAllDriver_Active();
}
else
{
_listDriver_Active = new T_NHANVIEN().GetAllDriver_Active_GetLast(Driver_LastUpdate);
}
if (_dictDriver == null)
{
_dictDriver = new Dictionary <string, T_NHANVIEN>();
}
if (_listDriver_Active != null && _listDriver_Active.Count > 0)
{
hasUpdate = true;
foreach (var item in _listDriver_Active)
{
if (item.LastUpdate > Driver_LastUpdate)
{
Driver_LastUpdate = item.LastUpdate;
}
if (!_dictDriver.ContainsKey(item.FK_SoHieuXeLai))
{
_dictDriver.Add(item.FK_SoHieuXeLai, item);
}
else
{
_dictDriver[item.FK_SoHieuXeLai] = item;
}
if (!_dictDriver_MaNV.ContainsKey(item.PK_MaNhanVien))
{
_dictDriver_MaNV.Add(item.PK_MaNhanVien, item);
}
else
{
_dictDriver_MaNV[item.PK_MaNhanVien] = item;
}
}
}
}
catch (Exception exx)
{
LogError.WriteLogError("LoadDrivers_Active_LastUpdate", exx);
}
return(hasUpdate);
}
/// <summary>
/// Ham thuc hien tra ve mot doi tac tu du lieu cua mot DataRow
/// </summary>
public static DoiTac GetDoiTacByRow(DataRow dr)
{
DoiTac objDoiTac = new DoiTac();
try
{
objDoiTac.MaDoiTac = StringTools.TrimSpace(dr["Ma_DoiTac"].ToString());
objDoiTac.Name = StringTools.TrimSpace(dr["Name"].ToString());
objDoiTac.Address = StringTools.TrimSpace(dr["Address"].ToString());
objDoiTac.Phones = StringTools.TrimSpace(dr["Phones"].ToString());
objDoiTac.Fax = StringTools.TrimSpace(dr["Fax"].ToString());
objDoiTac.Email = StringTools.TrimSpace(dr["Email"].ToString());
if (dr.Table.Columns.Contains("LoaiDoiTacID") && !string.IsNullOrEmpty(dr["LoaiDoiTacID"].ToString()))
{
objDoiTac.LoaiDoiTacID = int.Parse(dr["LoaiDoiTacID"].ToString());
if (dr.Table.Columns.Contains("TenLoaiDoiTac") && !string.IsNullOrEmpty(dr["TenLoaiDoiTac"].ToString()))
{
objDoiTac.TenLoaiDoiTac = StringTools.TrimSpace(dr["TenLoaiDoiTac"].ToString());
}
else
{
objDoiTac.TenLoaiDoiTac = "";
}
}
else
{
objDoiTac.LoaiDoiTacID = 0;
objDoiTac.TenLoaiDoiTac = "";
}
if (StringTools.TrimSpace(dr["TiLeHoaHongNoiTinh"].ToString()).Length > 0)
{
objDoiTac.TiLeHoaHongNoiTinh = float.Parse(StringTools.TrimSpace(dr["TiLeHoaHongNoiTinh"].ToString()));
}
else
{
objDoiTac.TiLeHoaHongNoiTinh = 0;
}
if (StringTools.TrimSpace(dr["TiLeHoaHongNgoaiTinh"].ToString()).Length > 0)
{
objDoiTac.TiLeHoaHongDuongDai = float.Parse(StringTools.TrimSpace(dr["TiLeHoaHongNgoaiTinh"].ToString()));
}
else
{
objDoiTac.TiLeHoaHongDuongDai = 0;
}
objDoiTac.Notes = dr["Notes"].ToString();
objDoiTac.IsActive = dr["IsActive"].ToString() == "1" ? true : false;
objDoiTac.MaNhanVien = dr["FK_MaNhanVien"].ToString();
objDoiTac.TenNhanVien = dr["TenNhanVien"].ToString();
if (dr["Vung"] != null)
{
objDoiTac.Vung = int.Parse(dr["Vung"].ToString().Length <= 0 ? "1" : dr["Vung"].ToString());
}
else
{
objDoiTac.Vung = 1;
}
objDoiTac.NgayKyKet = DateTime.Parse(dr["NgayKyKet"].ToString().Length <= 0 ? "01-01-1900 01:01:01" : dr["NgayKyKet"].ToString());
int step = 0;
if (dr["FK_Step"] != null)
{
int.TryParse(dr["FK_Step"].ToString(), out step);
}
objDoiTac.FK_Step = step;
objDoiTac.CongTyID = 0; // int.Parse(dr["CongTyID"].ToString());
objDoiTac.TenCongTy = ""; // dr["TenCongTy"].ToString();
float kinhdo = 0;
float vido = 0;
float.TryParse(dr["KinhDo"].ToString(), out kinhdo);
objDoiTac.KinhDo = kinhdo;//Convert.ToDecimal(dr["KinhDo"]);
float.TryParse(dr["ViDo"].ToString(), out vido);
objDoiTac.ViDo = vido;
try
{
objDoiTac.VietTat = dr["VietTat"].ToString();
}
catch
{
}
try
{
if (dr["NgayKetThuc"] == null)
{
objDoiTac.NgayKetThuc = new DateTime(1900, 1, 1);
}
else
{
objDoiTac.NgayKetThuc = DateTime.Parse(dr["NgayKetThuc"].ToString().Length <= 0 ? "01-01-1900 01:01:01" : dr["NgayKetThuc"].ToString());
}
}
catch (Exception ex)
{
objDoiTac.NgayKetThuc = new DateTime(1900, 1, 1);
}
//SoNha
try
{
objDoiTac.SoNha = dr["SoNha"].ToString();
}
catch (Exception ex)
{
objDoiTac.SoNha = "";
}
// TenDuong
try
{
objDoiTac.TenDuong = dr["TenDuong"].ToString();
}
catch (Exception ex) { objDoiTac.TenDuong = ""; }
// NguoiTao
try
{
objDoiTac.NguoiTao = dr["CreatedBy"].ToString();
}
catch (Exception ex) { objDoiTac.NguoiTao = ""; }
// NgayTao
try
{
objDoiTac.NgayTao = DateTime.Parse(dr["CreatedDate"].ToString());
}
catch (Exception ex) { objDoiTac.NgayTao = new DateTime(1900, 1, 1); }
// NguoiSua cuoi
try
{
objDoiTac.NguoiSua = dr["UpdatedBy"].ToString();
}
catch (Exception ex) { objDoiTac.NguoiSua = ""; }
// ngay sua cuoi cung
try
{
objDoiTac.NgaySua = DateTime.Parse(dr["UpdatedDate"].ToString());
}
catch (Exception ex) { objDoiTac.NgaySua = new DateTime(1900, 1, 1); }
}
catch (Exception ex)
{
LogError.WriteLogError("GetDoiTacByRow", ex);
}
return(objDoiTac);
}
