public static List <DanhBaKhachQuen> GetKhachQuens_LastUpdate(DateTime LastUpdate) { try { List <DanhBaKhachQuen> lstKhachQuen = new List <DanhBaKhachQuen>(); DataTable dt = new DataTable(); dt = new Data.DanhBaKhachQuen().GetKhachQuens_LastUpdate(LastUpdate); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { lstKhachQuen.Add(GetKhachQuen_Row(dr)); } dt.Dispose(); dt = null; } return(lstKhachQuen); } catch (Exception ex) { LogError.WriteLogError("GetKhachQuens_LastUpdate", ex); return(new List <DanhBaKhachQuen>()); } }
/// <summary> /// Load danh sách xe hiện có trên hệ thống /// </summary> public static void LoadVehicles() { try { Vehicles_Active_LastUpdate = DateTime.Now; DicXe = new Dictionary <string, string>(); DicObjecXe = new Dictionary <string, Data.BanCo.Entity.DM.DMXe>(); ListXe = new Data.BanCo.Entity.DM.DMXe().GetListAll(); foreach (var item in ListXe) { if (!DicXe.ContainsKey(item.PK_SoHieuXe)) { DicXe.Add(item.PK_SoHieuXe, item.BienKiemSoat); } else { DicXe[item.PK_SoHieuXe] = item.BienKiemSoat; } if (!DicObjecXe.ContainsKey(item.PK_SoHieuXe)) { DicObjecXe.Add(item.PK_SoHieuXe, item); } else { DicObjecXe[item.PK_SoHieuXe] = item; } } } catch (Exception ex) { LogError.WriteLogError("Lỗi Load Danh sách xe hệ thống", ex); } }
public static List <DanhBaKhachQuen_Rank> GetDanhSachKhachQuen_Rank() { try { List <DanhBaKhachQuen_Rank> listKhachQuen_Rank = new List <DanhBaKhachQuen_Rank>(); DataTable dt = new DataTable(); dt = new Data.DanhBaKhachQuen().GetDanhBaKhachQuen_Rank_ID(""); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { listKhachQuen_Rank.Add(GetKhachQuen_Rank_Row(dr)); } } dt.Dispose(); dt = null; return(listKhachQuen_Rank); } catch (Exception ex) { LogError.WriteLogError("GetDanhSachKhachQuen_Rank: ", ex); return(new List <DanhBaKhachQuen_Rank>()); } }
public static DanhBaEx GetDanhBaEx_Row(DataRow dr) { try { DanhBaEx objKhachQuen = new DanhBaEx(); objKhachQuen.MaDoiTac = dr["MaKH"].ToString(); objKhachQuen.PhoneNumber = dr["Phones"].ToString(); objKhachQuen.Name = dr["Name"].ToString(); objKhachQuen.Address = dr["Address"].ToString(); objKhachQuen.IsActive = Convert.ToBoolean(dr["IsActive"]); objKhachQuen.GhiChuTiepNhan = dr["Notes"].ToString(); int Type = dr["Type"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Type"]); if (Type == 1) { objKhachQuen.KieuKHGoiDen = KieuKhachHangGoiDen.KhachHangVIP; } else if (Type == 2) { objKhachQuen.KieuKHGoiDen = KieuKhachHangGoiDen.KhachHangBinhThuong; } else if (Type == 3) { objKhachQuen.KieuKHGoiDen = KieuKhachHangGoiDen.KhachHangBinhThuong; } objKhachQuen.KieuDanhBa = KieuDanhBa.ThanThiet; objKhachQuen.GPS_KinhDo = dr["KinhDo"] == DBNull.Value ? 0 : (float)dr["KinhDo"]; objKhachQuen.GPS_ViDo = dr["ViDo"] == DBNull.Value ? 0 : (float)dr["ViDo"]; return(objKhachQuen); } catch (Exception ex) { LogError.WriteLogError("GetDanhBaEx_Row: ", ex); return(null); } }
public DataTable GetDataTable(DateTime start, DateTime end, string phoneNumber, string diaChi, string line, string vung, string IDCuoc, string pBookID) { try { DateTime from = start; DateTime to = end; DataTable dtAll = new DataTable(); int countMinute = (to - from).TotalMinutes.To <int>() / 10; for (int i = 1; i <= countMinute + 1; i++) { try { dtAll.Merge(this.ExeStore("sp_TaxiperationHistory_GetData", from, from.AddMinutes(10), phoneNumber, diaChi, line, vung, IDCuoc, pBookID)); } catch (Exception ex) { LogError.WriteLogError("GetDataTable: ", ex); } from = from.AddMinutes(10); Thread.Sleep(50); } return(dtAll); } catch (Exception ex) { LogError.WriteLogError("GetDataTable: ", ex); return(new DataTable()); } }
public static DanhBaKhachQuenEx GetKhachQuenEx_Row(DataRow dr) { try { DanhBaKhachQuenEx objKhachQuen = new DanhBaKhachQuenEx(); objKhachQuen.MaKH = dr["MaKH"].ToString(); objKhachQuen.Phones = dr["Phones"].ToString(); objKhachQuen.Name = dr["Name"].ToString(); objKhachQuen.Address = dr["Address"].ToString(); objKhachQuen.BirthDay = dr["BirthDay"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["BirthDay"]); objKhachQuen.Email = dr["Email"].ToString(); objKhachQuen.Fax = dr["Fax"].ToString(); objKhachQuen.IsActive = Convert.ToBoolean(dr["IsActive"]); objKhachQuen.Notes = dr["Notes"].ToString(); objKhachQuen.Rank = 0; // dr["Rank"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Rank"].ToString()); objKhachQuen.Type = 0; // dr["Type"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Type"]); objKhachQuen.RankName = string.Empty; //dr["RankName"] == DBNull.Value ? string.Empty : dr["RankName"].ToString(); objKhachQuen.TypeName = string.Empty; // dr["TypeName"] == DBNull.Value ? string.Empty : dr["TypeName"].ToString(); objKhachQuen.TrangThaiGoi = dr["TrangThaiGoi"] == DBNull.Value ? (byte)0 : byte.Parse(dr["TrangThaiGoi"].ToString()); objKhachQuen.ThoiDiemGoiGanDay = dr["ThoiDiemGoi"] == DBNull.Value ? new DateTime(2000, 1, 1, 0, 0, 0) : DateTime.Parse(dr["ThoiDiemGoi"].ToString()); objKhachQuen.GhiChuGoi = dr["GhiChu"] == DBNull.Value ? string.Empty : dr["GhiChu"].ToString(); objKhachQuen.ThangNam = dr["ThangNam"] == DBNull.Value ? string.Empty : dr["ThangNam"].ToString(); objKhachQuen.SoLanGoiTrongThang = dr["SoLanGoi"] == DBNull.Value ? 0 : int.Parse(dr["SoLanGoi"].ToString()); objKhachQuen.KinhDo = dr["KinhDo"] == DBNull.Value ? 0 : (float)dr["KinhDo"]; objKhachQuen.ViDo = dr["ViDo"] == DBNull.Value ? 0 : (float)dr["ViDo"]; return(objKhachQuen); } catch (Exception ex) { LogError.WriteLogError("GetKhachQuenEx_Row: ", ex); return(null); } }
public static List <DoiTac> GetDoiTacs(string strSQL) { try { List <DoiTac> lstDoiTac = new List <DoiTac>(); DataTable dt = new DataTable(); dt = new Data.DM.DoiTac().GetDoiTacs(strSQL); 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: ", ex); return(new List <DoiTac>()); } }
private void KhoiTaoDanhBaOnMEM_CongTy_GetLast(DateTime LastUpdate) { try { List <DanhBaEx> listDBCongTy = new List <DanhBaEx>(); listDBCongTy = DanhBaEx.GetDanhBaCONGTY_GetLast(LastUpdate); // thêm vào dic foreach (DanhBaEx dbcty in listDBCongTy) { // chưa tồn tài thì thêm vào ds if (!dicDanhBaCongTy.ContainsKey(dbcty.PhoneNumber)) { dicDanhBaCongTy.TryAdd(dbcty.PhoneNumber, dbcty); } else { dicDanhBaCongTy[dbcty.PhoneNumber] = dbcty; } if (Global.IsDebug) { LogError.WriteLogInfo("KhoiTaoDanhBaOnMEM_CongTy_GetLast:" + dbcty.PhoneNumber + "-" + dbcty.Address); } } } catch (Exception ex) { LogError.WriteLogError("KhoiTaoDanhBaOnMEM_CongTy_GetLast.", ex); } }
void timerCapture_Elapsed(object sender, System.Timers.ElapsedEventArgs e) { try { g_iCount_GetCuocGoi++; if (g_iCount_GetCuocGoi >= 60) { KhoiTaoCuocKhachOnlineLenMEM(); g_iCount_GetCuocGoi = 0; } g_iCount_GetDanhBa++; if (g_iCount_GetDanhBa >= 300) // 5phut { KhoiTaoDanhBaOnMEM_KhachHang_GetLast(g_ThoiDiemLayTruoc_KhachHang); KhoiTaoDanhBaOnMEM_DoiTac_GetLast(g_ThoiDiemLayTruoc_DoiTac); KhoiTaoDanhBaOnMEM_CongTy_GetLast(g_ThoiDiemLayTruoc_CongTy); g_iCount_GetDanhBa = 0; } } catch (Exception ex) { LogError.WriteLogError("Loi trong timer.", ex); } }
private void KhoiTaoDanhBaOnMEM_KhachHang_GetLast(DateTime LastUpdate) { try { List <DanhBaEx> lstKhachVip = DanhBaKhachQuen.GetKhachQuens_LastUpdate_V2(LastUpdate); if (lstKhachVip != null && lstKhachVip.Count > 0) { g_ThoiDiemLayTruoc_KhachHang = DateTime.Now; foreach (var item in lstKhachVip) { if (dicKhachQuen.ContainsKey(item.PhoneNumber)) { dicKhachQuen[item.PhoneNumber] = item; } else { dicKhachQuen.TryAdd(item.PhoneNumber, item); } if (Global.IsDebug) { LogError.WriteLogInfo("KhoiTaoDanhBaOnMEM_KhachHang_GetLast:" + item.PhoneNumber + "-" + item.Address); } } } } catch (Exception ex) { LogError.WriteLogError("KhoiTaoDanhBaOnMEM_KhachHang_GetLast.", ex); } }
/// <summary> /// Load danh bạ công ty, khách ảo /// </summary> private void KhoiTaoDanhBaOnMEM() { try { List <DanhBaEx> listDBMoiGioi = DanhBaEx.GetDanhBaMoiGioi(); if (dicMoiGioi == null) { dicMoiGioi = new ConcurrentDictionary <string, DanhBaEx>(); } foreach (DanhBaEx dbex in listDBMoiGioi) { if (!dicMoiGioi.ContainsKey(dbex.PhoneNumber)) { dicMoiGioi.TryAdd(dbex.PhoneNumber, dbex); } } List <DanhBaEx> listDBCongTy = new List <DanhBaEx>(); listDBCongTy = DanhBaEx.GetDanhBaCongTy(); foreach (DanhBaEx dbcty in listDBCongTy) { if (!dicDanhBaCongTy.ContainsKey(dbcty.PhoneNumber)) { dicDanhBaCongTy.TryAdd(dbcty.PhoneNumber, dbcty); } } } catch (Exception ex) { LogError.WriteLogError("KhoiTaoDanhBaOnMEM: ", ex); } }
private void bwSync_LoadDanhBaKhachQuen_DoWork(object sender, DoWorkEventArgs e) { try { List <DanhBaEx> lstKhachVip = DanhBaKhachQuen.GetAllKhachQuens_V2(); if (lstKhachVip != null && lstKhachVip.Count > 0) { DanhBaEx dicRet = new DanhBaEx(); foreach (DanhBaEx item in lstKhachVip) { if (dicKhachQuen.ContainsKey(dicRet.PhoneNumber)) { continue; } dicKhachQuen.TryAdd(dicRet.PhoneNumber, dicRet); if (Global.IsDebug) { LogError.WriteLogInfo("bwSync_LoadDanhBaKhachQuen_DoWork:" + dicRet.PhoneNumber + "-" + dicRet.Address); } } } } catch (Exception ex) { LogError.WriteLogError("bwSync_LoadDanhBaKhachQuen_DoWork.", ex); } }
public static DanhBaKhachQuen GetKhachQuen_Row(DataRow dr) { try { DanhBaKhachQuen objKhachQuen = new DanhBaKhachQuen(); objKhachQuen.MaKH = dr.Table.Columns.Contains("MaKH") && dr["MaKH"] != DBNull.Value ? dr["MaKH"].ToString() : string.Empty; objKhachQuen.Phones = dr.Table.Columns.Contains("Phones") && dr["Phones"] != DBNull.Value ? dr["Phones"].ToString() : string.Empty; //dr["Phones"].ToString(); objKhachQuen.Name = dr.Table.Columns.Contains("Name") && dr["Name"] != DBNull.Value ? dr["Name"].ToString() : string.Empty; //dr["Name"].ToString(); objKhachQuen.Address = dr.Table.Columns.Contains("Address") && dr["Address"] != DBNull.Value ? dr["Address"].ToString() : string.Empty; //dr["Address"].ToString(); objKhachQuen.BirthDay = !dr.Table.Columns.Contains("BirthDay") || dr["BirthDay"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["BirthDay"]); objKhachQuen.Email = dr.Table.Columns.Contains("Email") && dr["Email"] != DBNull.Value ? dr["Email"].ToString() : string.Empty; //dr["Email"].ToString(); objKhachQuen.Fax = dr.Table.Columns.Contains("Fax") && dr["Fax"] != DBNull.Value ? dr["Fax"].ToString() : string.Empty; //dr["Fax"].ToString(); objKhachQuen.IsActive = dr.Table.Columns.Contains("IsActive") && dr["IsActive"] != DBNull.Value && Convert.ToBoolean(dr["IsActive"]); objKhachQuen.Notes = dr.Table.Columns.Contains("Notes") && dr["Notes"] != DBNull.Value ? dr["Notes"].ToString() : string.Empty; //dr["Notes"].ToString(); objKhachQuen.Rank = !dr.Table.Columns.Contains("Rank") || dr["Rank"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Rank"].ToString()); objKhachQuen.Type = !dr.Table.Columns.Contains("Type") || dr["Type"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Type"]); objKhachQuen.RankName = dr.Table.Columns.Contains("RankName") && dr["RankName"] != DBNull.Value ? dr["RankName"].ToString() : string.Empty; // dr["RankName"] == DBNull.Value ? string.Empty : dr["RankName"].ToString(); objKhachQuen.TypeName = dr.Table.Columns.Contains("TypeName") && dr["TypeName"] != DBNull.Value ? dr["TypeName"].ToString() : string.Empty; // dr["TypeName"] == DBNull.Value ? string.Empty : dr["TypeName"].ToString(); objKhachQuen.KinhDo = !dr.Table.Columns.Contains("KinhDo") || dr["KinhDo"] == DBNull.Value ? 0 : float.Parse(dr["KinhDo"].ToString()); objKhachQuen.ViDo = !dr.Table.Columns.Contains("ViDo") || dr["ViDo"] == DBNull.Value ? 0 : float.Parse(dr["ViDo"].ToString()); return(objKhachQuen); } catch (Exception ex) { LogError.WriteLogError("GetKhachQuen_Row", ex); return(new DanhBaKhachQuen()); } }
/// <summary> /// hàm thực hiện lấy danh bạ công ty. /// </summary> public static List <DanhBaEx> GetDanhBaCongTy() { //Ds danh bạ mở rộng trả về List <DanhBaEx> listRet = new List <DanhBaEx>(); try { List <DanhBaCongTy> listDanhBa = DanhBaCongTy.GetDanhSachDanhBaCongTy(); foreach (DanhBaCongTy dbcty in listDanhBa) { string Name = dbcty.Name.Length > 0 ? "[" + dbcty.Name + "] " : ""; DanhBaEx dtx = new DanhBaEx() { PhoneNumber = dbcty.PhoneNumber, Address = Name + dbcty.Address, KieuDanhBa = KieuDanhBa.CongTy, KieuKHGoiDen = KieuKhachHangGoiDen.KhachHangBinhThuong, IsActive = true }; listRet.Add(dtx); } } catch (Exception ex) { LogError.WriteLogError("GetDanhBaCongTy: ", ex); } return(listRet); }
/// <summary> /// Get danh bạ đối tác có sự thay đổi /// </summary> public static List <DanhBaEx> GetDanhBaMoiGioi_LastUpdate(DateTime LastUpdate) { List <DanhBaEx> listRet = new List <DanhBaEx>(); try { DoiTac dt = new DoiTac(); List <DoiTac> listDT = dt.GetCacDoiTacs_LastUpdate(LastUpdate); foreach (DoiTac doiTac in listDT) { // tác số điện thoại string[] arrDienThoai = doiTac.Phones.Split(";".ToCharArray()); for (int i = 0; i < arrDienThoai.Length; i++) { DanhBaEx dtx = new DanhBaEx(arrDienThoai[i], doiTac.Name + " - " + doiTac.Address, KieuDanhBa.MoiGioi, doiTac.MaDoiTac, doiTac.Vung, "", doiTac.IsActive, "", doiTac.KinhDo, doiTac.ViDo, ""); listRet.Add(dtx); } } } catch (Exception ex) { LogError.WriteLogError("GetDanhBaMoiGioi_LastUpdate ", ex); } return(listRet); }
/// <summary> /// Check license /// </summary> public void CheckLicense() { //if (Debugger.IsAttached) return;//*sign if (ExceptionCompany()) { return; } try { string message = ""; LicenseEntity objLicense = new LicenseEntity(); string pCode = string.Empty; string pKey = string.Empty; DateTime pDate = CommonBL.GetTimeServer(); DataTable dtTemp = objLicense.GetAll(); if (dtTemp != null && dtTemp.Rows.Count > 0) { pCode = dtTemp.Rows[0]["LicenseCode"].ToString(); pKey = dtTemp.Rows[0]["LicenseKey"].ToString(); //pDate = dtTemp.Rows[0]["CreatedDate"].To<DateTime>(); string strCPUID = ""; string strMacAddress = objLicense.GetServerInformation(out strCPUID); var hasValid = BALicenseManager.CheckValidateLicense(pCode, pKey, pDate, strMacAddress, strCPUID); if (hasValid < 0) { message = string.Format("{0}:Mã xác thực License Key không hợp lệ. Vui lòng liên hệ nhà cung cấp", hasValid); new MessageBoxBA().Show(message, "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Error); Application.Exit(); } else if (hasValid > 1) { message = string.Format("Bản quyền còn {0} ngày nữa sẽ hết hạn. Vui lòng liên hệ nhà cung cấp", hasValid); new MessageBoxBA().Show(message, "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Warning); } else if (hasValid == 0) { message = string.Format("Phần mềm đã hết hạn sử dụng. Bạn không được sử dụng phần mềm này nữa"); new MessageBoxBA().Show(message, "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Error); Application.Exit(); } } else { message = "Phần mềm đang chưa có bản quyền."; new MessageBoxBA().Show(message, "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Error); Application.Exit(); } } catch (Exception ex) { LogError.WriteLogError("LicenseBL CheckLicense", ex); new MessageBoxBA().Show("Lỗi.Phần mềm đang chưa có bản quyền.", "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Error); Application.Exit(); } }
public static void LoadVehicles_Active_LastUpdate() { try { if ((Vehicles_Active_LastUpdate == DateTime.MinValue) && DicObjecXe != null && DicObjecXe.Count > 0) { Vehicles_Active_LastUpdate = DicObjecXe.Max(p => p.Value.LastUpdate); } if ((Vehicles_Active_LastUpdate == null || Vehicles_Active_LastUpdate == DateTime.MinValue)) { Vehicles_Active_LastUpdate = DieuHanhTaxi.GetTimeServer(); } if ((Vehicles_Active_LastUpdate == null || Vehicles_Active_LastUpdate == DateTime.MinValue)) { Vehicles_Active_LastUpdate = DateTime.Now; } var ListXeUpdate = Data.BanCo.Entity.DM.DMXe.Inst.GetLastUpdate(Vehicles_Active_LastUpdate); if (ListXeUpdate != null && ListXeUpdate.Count > 0) { foreach (var item in ListXeUpdate) { if (item.LastUpdate > Vehicles_Active_LastUpdate) { Vehicles_Active_LastUpdate = item.LastUpdate; } if (!DicXe.ContainsKey(item.PK_SoHieuXe)) { DicXe.Add(item.PK_SoHieuXe, item.BienKiemSoat); } else { DicXe[item.PK_SoHieuXe] = item.BienKiemSoat; } if (!DicObjecXe.ContainsKey(item.PK_SoHieuXe)) { DicObjecXe.Add(item.PK_SoHieuXe, item); } else { DicObjecXe[item.PK_SoHieuXe] = item; } } if (DicObjecXe != null) { ListXe = DicObjecXe.Select(p => p.Value).ToList(); } } } catch (Exception ex) { LogError.WriteLogError("LoadVehicles_Active_LastUpdate", ex); } }
public bool Update() { try { return(new Data.DanhBaKhachQuen().Update(this.MaKH, this.Phones, this.Name, this.Address, this.BirthDay, this.Email, this.Fax, this.IsActive, this.Notes, this.Rank, this.Type)); } catch (Exception ex) { LogError.WriteLogError("DanhBaKhachQuen.Insert", ex); return(false); } }
public bool Insert() { try { return(new Data.TinhTienTheoKm().Insert(this.KmMoCua, this.GiaMoCua, this.KmNguong1, this.GiaNguong1, this.KmNguong2, this.GiaNguong2, this.KmNguong3, this.GiaNguong3, this.N1_ChieuDiTu, this.N1_ChieuDiDen, this.N1_Giam, this.N2_ChieuDiTu, this.N2_Giam, this.IsAll, this.KmNguong2Chieu, this.TiLeGiamGia2Chieu, this.LoaiXe, this.ThongTinThueBao)); } catch (Exception ex) { LogError.WriteLogError("TinhTienTheoKm.Insert", ex); return(false); } }
public DataTable GetAllLoaiXe_Truck() { try { return(new Data.TinhTienTheoKm().GetAllLoaiXe_Truck()); } catch (Exception ex) { LogError.WriteLogError("TinhTienTheoKm.GetAllLoaiXe", ex); return(null); } }
public bool Delete(string maKhachHang) { try { return(new Data.DanhBaKhachQuen().Delete(maKhachHang)); } catch (Exception ex) { LogError.WriteLogError("DanhBaKhachQuen.Delete", ex); return(false); } }
public bool Update() { try { return(new Data.TinhTienTheoKm().Update(this.KmMoCua, this.GiaMoCua, this.KmNguong1, this.GiaNguong1, this.GiaNguong2, this.KmNguong2Chieu, this.TiLeGiamGia2Chieu, this.LoaiXe, this.ThongTinThueBao, this.LoaiCuoc)); } catch (Exception ex) { LogError.WriteLogError("TinhTienTheoKm.Update", ex); return(false); } }
/// <summary> /// Convert Từ số hiệu sang biển số /// </summary> /// <param name="soHieuXe">Số hiệu xe</param> /// <param name="soLan">Số lần</param> /// <returns>Biển số xe</returns> public static string ConvertSangBienSo(string soHieuXe, int soLan = 0) { try { if (DicXe != null && DicXe.Count > 0) { if (DicXe.ContainsKey(soHieuXe) && DicXe[soHieuXe].Trim().Length > 0) { return(DicXe[soHieuXe]); } } if (soLan < 2) { var xe = Data.BanCo.Entity.DM.DMXe.Inst.GetDMXeTheoSoXe(soHieuXe); if (xe != null) // return ConvertSangBienSo(soHieuXe, soLan++); //else { if (DicObjecXe != null) { if (DicObjecXe.ContainsKey(xe.PK_SoHieuXe)) { DicObjecXe[xe.PK_SoHieuXe] = xe; } else { DicObjecXe.Add(xe.PK_SoHieuXe, xe); } } if (DicXe != null) { if (DicXe.ContainsKey(xe.PK_SoHieuXe)) { DicXe[xe.PK_SoHieuXe] = xe.BienKiemSoat; } else { DicXe.Add(xe.PK_SoHieuXe, xe.BienKiemSoat); } return(xe.BienKiemSoat); } } } } catch (Exception ex) { LogError.WriteLogError(string.Format("ConvertSangBienSo:{0}-{1}", soHieuXe, soLan), ex); //return ConvertSangBienSo(soHieuXe, soLan++); } return(string.Empty); }
/// <summary> /// Lưu thông tin license vào DB /// </summary> public int AuthoriseLicenseKey(params object[] parInput)//5 tham số! { try { var temp = this.ExeStoreWithOutput("sp_AuthoriseLicenseKey", parInput); return(temp.Value["pResult"].To <int>()); } catch (Exception ex) { LogError.WriteLogError("AuthoriseLicenseKey: ", ex); return(-1);//Lỗi kết nối cơ sở dữ liệu! } }
public DataTable LayDanhSachNguoiNhan(params object[] pInput) { DataTable result = new DataTable(); try { result = Inst.ExeStore("sp_LayDanhSachNguoiNhan", pInput); } catch (Exception ex) { LogError.WriteLogError("LayDanhSachNguoiNhan: ", ex); } return(result); }
public static DanhBaKhachQuen_Type GetKhachQuen_Type_Row(DataRow dr) { try { DanhBaKhachQuen_Type objKhachQuen_Type = new DanhBaKhachQuen_Type(); objKhachQuen_Type.ID = Convert.ToInt16(dr["ID"]); objKhachQuen_Type.Notes = dr["Notes"].ToString(); objKhachQuen_Type.Type = dr["Type"].ToString(); return(objKhachQuen_Type); } catch (Exception ex) { LogError.WriteLogError("GetKhachQuen_Type_Row: ", ex); return(new DanhBaKhachQuen_Type()); } }
public static DanhBaKhachQuen_Rank GetKhachQuen_Rank_Row(DataRow dr) { try { DanhBaKhachQuen_Rank objKhachQuen_Rank = new DanhBaKhachQuen_Rank(); objKhachQuen_Rank.ID = Convert.ToInt16(dr["ID"]); objKhachQuen_Rank.Notes = dr["Notes"].ToString(); objKhachQuen_Rank.Rank = dr["Rank"].ToString(); return(objKhachQuen_Rank); } catch (Exception ex) { LogError.WriteLogError("GetKhachQuen_Rank_Row: ", ex); return(new DanhBaKhachQuen_Rank()); } }
/// <summary> /// Lưu thông tin sử dụng xe /// </summary> /// <returns></returns> public bool Save() { try { if (this.ID > 0) { return(new TinhTien_SuDung().Update(this.ID, this.LoaiXe, this.Km_Tu, this.Km_Den, this.Vtb, this.TG)); } else { return(new TinhTien_SuDung().Insert(this.LoaiXe, this.Km_Tu, this.Km_Den, this.Vtb, this.TG)); } } catch (Exception ex) { LogError.WriteLogError("TinhTien_SuDungXe.Save", ex); return(false); } }
public GlobalContacts() { try { bwSync_LoadDanhBaBuuDien.DoWork += bwSync_LoadDanhBaBuuDien_DoWork; bwSync_LoadDanhBaKhachQuen.DoWork += bwSync_LoadDanhBaKhachQuen_DoWork; g_ThoiDiemLayTruoc_KhachHang = DateTime.Now; g_ThoiDiemLayTruoc_DoiTac = DateTime.Now; g_ThoiDiemLayTruoc_CongTy = DateTime.Now; G_TimerCapture = new System.Timers.Timer(1000); G_TimerCapture.Elapsed += timerCapture_Elapsed; } catch (Exception ex) { LogError.WriteLogError("GlobalContacts Init:", ex); } }
/// <summary> /// Tra ve dia chi cua so dien thoai /// </summary> public static string GetAddress(string PhoneNumber) { try { DataTable dt = new DataTable(); dt = new Data.DanhBaKhachQuen().GetAddress_Phones(PhoneNumber); if (dt.Rows.Count > 0) { return(dt.Rows[0]["Address"].ToString()); } dt.Dispose(); dt = null; return(string.Empty); } catch (Exception ex) { LogError.WriteLogError("GetAddress: ", ex); return(string.Empty); } }