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