private void grvGiaoDich_DoubleClick(object sender, EventArgs e) { if (DuLieuTaoSan.Q.TienMatThemSua) { cTNgan = (GVCTTM.GetRow(GVCTTM.GetSelectedRows()[0]) as O_CTNGANHANG); int Ma = cTNgan.ID; if (cTNgan.LoaiGiaoDich == 23 || cTNgan.LoaiGiaoDich == 24) { List <O_CTNGANHANG> cTNganHangOs = _listCTNganHangO.Where(w => w.MaLienKet.Equals(cTNgan.MaLienKet)).ToList(); if (cTNganHangOs.Count == 2) { Ma = cTNgan.ID == cTNganHangOs[0].ID ? Ma : cTNganHangOs[0].ID; Ma = cTNgan.ID == cTNganHangOs[1].ID ? Ma : cTNganHangOs[1].ID; new frmNHCTThem(cTNgan, Ma).ShowDialog(ParentForm); } else { XuLyGiaoDien.Alert("Sai định dạng!", Form_Alert.enmType.Warning); } } else { new frmNHCTThem(cTNgan, 0).ShowDialog(ParentForm); } } }
private void btnFILE_Click(object sender, EventArgs e) { using (XtraOpenFileDialog xtraOpenFileDialog = new XtraOpenFileDialog()) { xtraOpenFileDialog.Multiselect = true; xtraOpenFileDialog.RestoreDirectory = true; if (xtraOpenFileDialog.ShowDialog() == DialogResult.OK) { txtFileDinhKem.Properties.Tokens.Clear(); var filenames = xtraOpenFileDialog.FileNames; foreach (var item in filenames) { string filename = Path.GetFileName(item); var token_item = new TokenEditToken(filename + $" [{GetFileSizeFromFileNameURL(item)}]", item); txtFileDinhKem.Properties.Tokens.Add(token_item); } try { txtFileDinhKem.EditValue = string.Join(",", filenames); txtFileDinhKem.Properties.PopupPanel = flyEmail; } catch (Exception ex) { XuLyGiaoDien.Alert(ex.Message, Form_Alert.enmType.Warning); } } } }
private void btnLuu_Click(object sender, EventArgs e) { List <KiemTra> kiemTras = new List <KiemTra>(); kiemTras.Add(new KiemTra() { _Control = iKhachSan, _Tu = 1, _Den = 50 }); kiemTras.Add(new KiemTra() { _Control = iMaCho, _Tu = 1, _Den = 50 }); kiemTras.Add(new KiemTra() { _Control = iIDKhachHang, _Tu = 1, _Den = 50 }); XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic = XuLyDuLieu.FormToDictionary(this, dic); XulyDuLieuTruocKhiThem(dic); }
private void btnLuu_Click(object sender, EventArgs e) { List <KiemTra> kiemTras = new List <KiemTra>() { new KiemTra() { _Control = iSignIn, _Tu = 2, _Den = 20, _ChoQua = !new D_SIGNIN().DaTonTai(string.Format("WHERE SignIn='{0}' AND ID <> {1}", iSignIn.Text, _SignInO.ID)), _ThongBao2 = "Đã tồn tại" } }; XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic = XuLyDuLieu.FormToDictionary(this, dic); long CapNhatNum = (_SignInO.ID > 0) ? (_SignInD.CapNhat(dic, _SignInO.ID) > 0 ? _SignInO.ID : 0) : _SignInD.ThemMoi(dic, true); if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0)) { if (Owner is frmSignIn) { (Owner as frmSignIn).TaiLaiSignIn(); } Close(); } }
private void btnDongY_Click(object sender, EventArgs e) { List <KiemTra> kiemTras = new List <KiemTra>() { new KiemTra() { _Control = txtMatKhauCu, _ChoQuaThang = TMD5.TMd5Hash(txtMatKhauCu.Text) == DuLieuTaoSan.NV.MatKhauCty, _ThongBao2 = "Mật khẩu sai" }, new KiemTra() { _Control = txtMatKhauMoi }, new KiemTra() { _Control = iMatKhauCty, _ChoQuaThang = iMatKhauCty.Text == txtMatKhauMoi.Text, _ThongBao2 = "Mật khẩu mới không khớp" } }; XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("MatKhauCty", TMD5.TMd5Hash(iMatKhauCty.Text)); if (XuLyGiaoDien.ThongBao(Text, new D_DAILY().CapNhat(dic, DuLieuTaoSan.NV.ID) > 0)) { Close(); } }
private void btnOK_Click(object sender, EventArgs e) { int n = lstDaiLyz.CheckedItems.Count; if (n == 0) { XuLyGiaoDien.Alert("Chưa chọn đại lý tìm!", Form_Alert.enmType.Info); } else { if (!XuLyGiaoDien.wait.IsSplashFormVisible) { XuLyGiaoDien.wait.ShowWaitForm(); } string daily = string.Format("{0}", lstDaiLyz.CheckedItems[0]); for (int i = 1; i < n; i++) { daily += string.Format(",{0}", lstDaiLyz.CheckedItems[i]); } lst = new D_HOADON().DuLieu(string.Format("CONVERT(date, NgayThucHien) BETWEEN '{0}' AND '{1}' AND MaHD <> '0' AND ((GiaYeuCau - GiaHeThong) * PhanTram / 100) > 0 AND IDKhachHang in ({2}) ORDER BY IDKhachHang,MaHD,MaCho,GiaHeThong Desc", bdtpTu.DateTime.ToString("yyyyMMdd"), bdtpDen.DateTime.ToString("yyyyMMdd"), daily)); hoaDonOBindingSource.DataSource = lst; if (XuLyGiaoDien.wait.IsSplashFormVisible) { XuLyGiaoDien.wait.CloseWaitForm(); } } }
private void btnAddServer_Click(object sender, EventArgs e) { List <Dictionary <string, object> > lstdic = new List <Dictionary <string, object> >(); for (int i = 0; i < _lstSIChinh.Count; i++) { if (lstSI.Where(w => w.SignIn.Equals(_lstSIChinh[i].SignIn)).Count() == 0) { Dictionary <string, object> keyValues = new Dictionary <string, object>(); keyValues.Add("DaiLy", _lstSIChinh[i].DaiLy); keyValues.Add("SignIn", _lstSIChinh[i].SignIn); keyValues.Add("HangBay", _lstSIChinh[i].HangBay); keyValues.Add("Chinh", _lstSIChinh[i].Chinh); keyValues.Add("Khoa", _lstSIChinh[i].Khoa); keyValues.Add("MatKhau", _lstSIChinh[i].MatKhau); lstdic.Add(keyValues); } else { XuLyGiaoDien.Alert("Đã tồn tại " + _lstSIChinh[i].SignIn, Form_Alert.enmType.Warning); } } if (lstdic.Count > 0) { if (new D_SIGNIN().ThemNhieu1Ban(lstdic) > 0) { XuLyGiaoDien.Alert("Thêm sign in thành công", Form_Alert.enmType.Success); } } }
private void btnLuu_Click(object sender, EventArgs e) { List <KiemTra> kiemTras = new List <KiemTra>(); kiemTras.Add(new KiemTra() { _Control = iTenHang, _Tu = 5, _Den = 30, }); kiemTras.Add(new KiemTra() { _Control = iTenTat, _Tu = 2, _Den = 5, _ChoQua = !_HangBayD.DaTonTai("TenTat", iTenTat.Text, _HangBay.ID), _ThongBao2 = "Đã tồn tại" }); XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic = XuLyDuLieu.FormToDictionary(this, dic); long a = (_HangBay.ID > 0) ? _HangBayD.CapNhat(dic, _HangBay.ID) : _HangBayD.ThemMoi(dic, true); if (XuLyGiaoDien.ThongBao(Text, a > 0)) { (Owner.ActiveMdiChild as frmHangBay).DuLieu(); Close(); } }
private void btnLuu2_Click(object sender, EventArgs e) { if (!checkEdit2.Checked && _TinhTrangO.ID < 1) { XtraMessageBox.Show("Nếu muốn thêm mới vui lòng chọn vào [Thêm]", "Thông báo"); return; } List <KiemTra> kiemTras = new List <KiemTra>(); kiemTras.Add(new KiemTra() { _Control = iTenTrangThai, _Tu = 3, _Den = 30, _ChoQua = !(_ListTinhTrangO.Where(w => w.TenTrangThai.Equals(iTenTrangThai.Text) && !w.ID.Equals(checkEdit2.Checked ? 0 : _TinhTrangO.ID)).Count() > 0), _ThongBao2 = "Giá trị này đã tồn tại" }); XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("TenTrangThai", iTenTrangThai.Text); dic.Add("LoaiKhachHang", _LoaiKhachHang); long a = !checkEdit2.Checked ? _TinhTrangD.CapNhat(dic, _TinhTrangO.ID) : _TinhTrangD.ThemMoi(dic, true); if (XuLyGiaoDien.ThongBao("Tình trạng " + (checkEdit1.Checked ? "thêm" : "sửa"), a > 0)) { _ListTinhTrangO = _TinhTrangD.DuLieu(_LoaiKhachHang, false); trangThaiOBindingSource.DataSource = _ListTinhTrangO; (Owner.ActiveMdiChild as frmDaiLy).DuLieu(); } }
void ChinhSua() { if (DuLieuTaoSan.Q.NganHangThemSua) { cTNgan = (GVCTNH.GetRow(GVCTNH.GetSelectedRows()[0]) as O_CTNGANHANG); int Ma = cTNgan.ID; if (cTNgan.LoaiGiaoDich == 23 || cTNgan.LoaiGiaoDich == 24) { List <O_CTNGANHANG> cTNganHangOs = _listCTNganHangO.Where(w => (w.MaLienKet ?? string.Empty).Equals(cTNgan.MaLienKet)).ToList(); if (cTNganHangOs.Count == 2) { Ma = cTNgan.ID == cTNganHangOs[0].ID ? Ma : cTNganHangOs[0].ID; Ma = cTNgan.ID == cTNganHangOs[1].ID ? Ma : cTNganHangOs[1].ID; new frmNHCTThem(cTNgan, Ma).ShowDialog(ParentForm); } else { XuLyGiaoDien.Alert("Sai định dạng", Form_Alert.enmType.Info); } } else { new frmNHCTThem(cTNgan, 0).ShowDialog(ParentForm); } } }
private void btnOK_Click(object sender, EventArgs e) { if (lstDaiLy.CheckedItems.Count == 0) { XuLyGiaoDien.Alert("Vui lòng nhập đầy đủ thông tin", Form_Alert.enmType.Info); } else { if (!XuLyGiaoDien.wait.IsSplashFormVisible) { XuLyGiaoDien.wait.ShowWaitForm(); } //simpleButton1.Text = "Cần chạy lại: " + daiLyD.DemNgayPhiSai().ToString(); D_GIAODICH gdb = new D_GIAODICH(); string daily = string.Format("{0}", lstDaiLy.CheckedItems[0]); int n = lstDaiLy.CheckedItems.Count; for (int i = 1; i < n; i++) { daily += string.Format(",{0}", lstDaiLy.CheckedItems[i]); } giaoDichOBindingSource.DataSource = gdb.LayDanhSachCN((DateTime)dtpTuNgay.EditValue, (DateTime)dtpDenNgay.EditValue, daily); if (giaoDichOBindingSource.DataSource != null) { btnGuiMail.Enabled = true; btnExcel.Enabled = true; } if (XuLyGiaoDien.wait.IsSplashFormVisible) { XuLyGiaoDien.wait.CloseWaitForm(); } } }
private void btnLuu_Click(object sender, EventArgs e) { string NCC = string.Empty; if (_DataHangBay.Rows.Count > 0) { foreach (DataRow row in _DataHangBay.Rows) { NCC += row["ID"].ToString() + "|"; } } List <KiemTra> kiemTras = new List <KiemTra>(); kiemTras.Add(new KiemTra() { _Control = iTenDayDu, _Tu = 2, _Den = 50 }); kiemTras.Add(new KiemTra() { _Control = iTen, _Tu = 2, _Den = 50, _ChoQua = !_NCCD.DaTonTai("Ten", iTen.Text, _NCCO.ID), _ThongBao2 = "Đã tồn tại" }); XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic = XuLyDuLieu.FormToDictionary(this, dic); dic.Add("HangBay", NCC); long CapNhatNum = (_NCCO.ID > 0) ? _NCCD.CapNhat(dic, _NCCO.ID) : _NCCD.ThemMoi(dic, true); if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0)) { if (_NCCO.ID < 1) { List <Dictionary <string, object> > lstDicS = new List <Dictionary <string, object> >(); for (int i = 0; i < 180; i++) { dic = new Dictionary <string, object>(); dic.Add("NCCID", CapNhatNum); dic.Add("SoDuCuoi", 0); dic.Add("SoDuThucTe", 0); dic.Add("Ngay", "getdate() - " + i); lstDicS.Add(dic); } new D_SODU_HANG().ThemNhieu1Ban(lstDicS); } (Owner.ActiveMdiChild as frmHangBay).DuLieu(); Close(); } }
private void btnSave_Click(Object sender, EventArgs e) { #region kiểm tra điều kiện List<KiemTra> kiemTras = new List<KiemTra>() { new KiemTra() { _Control = iTen } }; XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } #endregion D_NHOMQUYEN cvb = new D_NHOMQUYEN(); #region Kiểm tra tên tắt hãng bay if (cvb.KiemTraTonTai(iTen.Text, ID)) { XuLyGiaoDien.Alert("Tên nhóm quyền đã tồn tại", Form_Alert.enmType.Warning); return; } #endregion #region Lưu Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("Ten", iTen.Text); foreach (Control ctl in Controls) { if (ctl is GroupControl) { if ((ctl as GroupControl).CustomHeaderButtons.Count > 0) dic.Add(ctl.Name, (ctl as GroupControl).CustomHeaderButtons[0].Properties.Checked); foreach (Control ctl1 in (ctl as GroupControl).Controls) { if (ctl1 is CheckEdit) dic.Add(ctl1.Name, (ctl1 as CheckEdit).Checked); else if (ctl1 is GroupControl) { if ((ctl1 as GroupControl).CustomHeaderButtons.Count > 0) dic.Add(ctl1.Name, (ctl1 as GroupControl).CustomHeaderButtons[0].Properties.Checked); foreach (Control ctl2 in (ctl1 as GroupControl).Controls) { dic.Add(ctl2.Name, (ctl2 as CheckEdit).Checked); } } } } } if (XuLyGiaoDien.ThongBao(Text, (ID != 0) ? (cvb.CapNhat(dic, ID) > 0) : (cvb.ThemMoi(dic) > 0))) { (Owner.ActiveMdiChild as frmQuyenNhanVien).QuyenNhanVienOBindingSource.DataSource = new D_NHOMQUYEN().DuLieu(); Close(); } #endregion }
private void btnSV_Click(object sender, EventArgs e) { if (_GiaoDichD.KiemTraGiaoDich(txtSoVe.Text, true)) { XuLyGiaoDien.Alert("Số vé đã tồn tại", Form_Alert.enmType.Warning); return; } Xuli(_GiaoDichD.LayGiaoDichHoan(txtSoVe.Text, true)); iTheoDoi.Checked = !(Owner.ActiveMdiChild is frmVe); }
private void btnCode_Click(object sender, EventArgs e) { if (_GiaoDichD.KiemTraGiaoDich(iMaCho.Text, false)) { XuLyGiaoDien.Alert("Mã chỗ đã tồn tại", Form_Alert.enmType.Warning); return; } Xuli(_GiaoDichD.LayGiaoDichHoan(iMaCho.Text, false)); iTheoDoi.Checked = !(Owner.ActiveMdiChild is frmVe); }
private void simpleButton3_Click(object sender, EventArgs e) { List <KiemTra> kiemTras = new List <KiemTra>(); kiemTras.Add(new KiemTra() { _Control = iTenDangNhapCty, _Tu = 5, _Den = 30, _ChoQua = !_DaiLyD.DaTonTai("TenDangNhapCty", iTenDangNhapCty.Text, _KhachHangO.ID), _ThongBao2 = "Đã tồn tại" }); kiemTras.Add(new KiemTra() { _Control = txtMatKhauCty, _Tu = 5, _Den = 30, _ChoQuaThang = !txtMatKhauCty.Enabled }); XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic = XuLyDuLieu.FormToDictionary(this, dic); dic.Add("Ten", iTenDangNhapCty.Text); if (txtMatKhauCty.Enabled) { dic.Add("MatKhauCty", TMD5.TMd5Hash(txtMatKhauCty.Text)); } dic.Add("LoaiKhachHang", 0); NguoiThanKhach(false); dic.Add("ThongTinLienLac", _HoHang); long a = (_KhachHangO.ID > 0) ? _DaiLyD.CapNhat(dic, _KhachHangO.ID) : _DaiLyD.ThemMoi(dic, true); if (XuLyGiaoDien.ThongBao(Text, a > 0)) { if (_KhachHangO.ID < 1) { List <Dictionary <string, object> > lstDicS = new List <Dictionary <string, object> >(); for (int i = 0; i < 90; i++) { dic = new Dictionary <string, object>(); dic.Add("LoaiKhachHangSD", _KhachHangO.LoaiKhachHang); dic.Add("ChinhSachID", iChinhSach.EditValue); dic.Add("DaiLyID", a); dic.Add("Ngay", "getdate() - " + i); lstDicS.Add(dic); } new D_SODU_DAILY().ThemNhieu1Ban(lstDicS); } (Owner.ActiveMdiChild as frmNhanVien).DuLieu(); Close(); } }
private void btnSV_Click(object sender, EventArgs e) { txtSoVe.Text = txtSoVe.Text.Replace(" ", string.Empty); if (txtSoVe.Text.Length > 10) { if (_HoaDonD.KiemTraGiaoDich(txtSoVe.Text, true)) { XuLyGiaoDien.Alert("Số vé đã tồn tại", Form_Alert.enmType.Warning); return; } Xuli(Giao.LayGiaoDichHoan(txtSoVe.Text, true)); } }
private void btnCode_Click(object sender, EventArgs e) { txtMC.Text = txtMC.Text.Replace(" ", string.Empty); if (txtMC.Text.Length > 5) { if (_HoaDonD.KiemTraGiaoDich(txtMC.Text, false)) { XuLyGiaoDien.Alert("Mã chỗ đã tồn tại", Form_Alert.enmType.Warning); return; } Xuli(Giao.LayGiaoDichHoan(txtMC.Text, false)); } }
private void btnGuiMail_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("Bạn muốn gửi mail ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { List <string> vs = new List <string>(); if ((txtFileDinhKem.EditValue ?? string.Empty) != string.Empty) { vs = txtFileDinhKem.EditValue.ToString().Split(',').ToList(); } O_CAUHINHSMTP cauHinhSMTPO = new D_CAUHINHSMTP().DuLieu(); O_MAUEMAIL ma = new D_MAUEMAIL().DuLieu()[0]; SmtpClient client = new SmtpClient(); client.Port = cauHinhSMTPO.Port; client.Host = cauHinhSMTPO.Host; client.EnableSsl = cauHinhSMTPO.SSL; client.Timeout = 10000; client.DeliveryMethod = SmtpDeliveryMethod.Network; client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "time0326"); if (txtTen.Text.Length > 5) { MailMessage mm = new MailMessage(); mm.From = new MailAddress("*****@*****.**", "Thành Hoàng"); mm.BodyEncoding = UTF8Encoding.UTF8; mm.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure; mm.IsBodyHtml = true; RichEditMailMessageExporter exporter = new RichEditMailMessageExporter(txtMauEmail, mm); exporter.Export(); mm.To.Add(new MailAddress(txtTen.Text)); mm.Subject = txtTieuDe.Text; foreach (string g in vs) { if (g.Count() > 0) { mm.Attachments.Add(new Attachment(g)); } } try { client.Send(mm); XuLyGiaoDien.Alert("Gửi mail thành công", Form_Alert.enmType.Success); } catch (Exception ex) { XuLyGiaoDien.Alert(ex.Message, Form_Alert.enmType.Error); } } } }
private void btnExcel_Click(object sender, EventArgs e) { XtraFolderBrowserDialog fbd = new XtraFolderBrowserDialog(); if (fbd.ShowDialog() == DialogResult.OK) { D_GIAODICH gdb = new D_GIAODICH(); bool isok = false; int n = lstDaiLy.CheckedItems.Count; for (int i = 0; i < n; i++) { O_DAILY dl = lstDaiLy.GetItem(lstDaiLy.CheckedIndices[0]) as O_DAILY; string daily = string.Format("{0}", dl.ID); List <O_GIAODICH> lstCongNo = gdb.LayDanhSachCN((DateTime)dtpTuNgay.EditValue, (DateTime)dtpDenNgay.EditValue, daily, true); if (lstCongNo.Count > 1) { gridCTCongNo.Refresh(); isok = true; CTGiaoDichDindingSource.DataSource = lstCongNo; // Xuất excel string strFile = fbd.SelectedPath + @"\" + dl.Ten + " - " + ((DateTime)dtpTuNgay.EditValue).ToString("dd_MM_yyyy") + " - " + ((DateTime)dtpDenNgay.EditValue).ToString("dd_MM_yyyy") + ".xlsx"; XlsxExportOptionsEx opt = new XlsxExportOptionsEx(); opt.CustomizeCell += op_CustomizeCell; opt.SheetName = "Bản Công Nợ"; gridCTCongNo.ForceInitialize(); grvCTCongNo.Columns["LuyKe"].Width = 90; grvCTCongNo.Columns["GiaThu"].Width = 90; grvCTCongNo.Columns["GiaHeThong"].Width = 90; grvCTCongNo.Columns["TaiKhoanCo"].Width = 90; grvCTCongNo.Columns["TenKhach"].Width = 400; grvCTCongNo.OptionsPrint.AutoWidth = false; grvCTCongNo.OptionsView.ColumnAutoWidth = false; gridCTCongNo.ExportToXlsx(strFile, opt); int index = lstDaiLy.FindItem(0, true, delegate(ListBoxFindItemArgs ei) { ei.IsFound = object.Equals(dl.ID, ei.ItemValue); }); lstDaiLy.SetItemChecked(index, false); } } if (isok) { XuLyGiaoDien.Alert("Xuất file thành công!", Form_Alert.enmType.Success); } else { XuLyGiaoDien.Alert("Không có thông tin", Form_Alert.enmType.Info); } } }
private void btnLuu_Click(object sender, EventArgs e) { List <KiemTra> kiemTras = new List <KiemTra>(); kiemTras.Add(new KiemTra() { _Control = iTen, _Tu = 3, _Den = 30, }); kiemTras.Add(new KiemTra() { _Control = iNguoiDaiDienHD, _Tu = 3, _Den = 30, }); kiemTras.Add(new KiemTra() { _Control = iDiDong, _SDT = true, _ChoQua = !_DaiLyD.DaTonTai("DiDong", iDiDong.Text, _DaiLyO.ID, "AND LoaiKhachHang = 3"), _ThongBao2 = "Đã tồn tại" }); XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic = XuLyDuLieu.FormToDictionary(this, dic); dic.Add("LoaiKhachHang", 3); long a = (_DaiLyO.ID > 0) ? _DaiLyD.CapNhat(dic, _DaiLyO.ID) : _DaiLyD.ThemMoi(dic, true); if (XuLyGiaoDien.ThongBao(Text, a > 0)) { if (Owner.ActiveMdiChild is frmKhachLe) { (Owner.ActiveMdiChild as frmKhachLe).DuLieu(); } else if (Owner is frmVeThem) { (Owner as frmVeThem).DuLieuKhachLe(a); } else { (Owner as frmKhachSanThem).DuLieuKhachLe(a); } Close(); } }
private void btnLuu_Click(object sender, EventArgs e) { if (!checkEdit1.Checked && _NhomDaiLyO.ID < 1) { XtraMessageBox.Show("Nếu muốn thêm mới vui lòng chọn vào [Thêm]", "Thông báo"); return; } List <KiemTra> kiemTras = new List <KiemTra>(); kiemTras.Add(new KiemTra() { _Control = iTen, _Tu = 3, _Den = 30, }); kiemTras.Add(new KiemTra() { _Control = iTu, _Tu = 0, _Den = 30, _ChoQua = !(_ListNhomDaiLyO.Where(w => iTu.Value > w.Tu - 1 && w.Den + 1 > iTu.Value && !w.ID.Equals(checkEdit1.Checked ? 0 : _NhomDaiLyO.ID)).Count() > 0), _ThongBao2 = "Giá trị này đã tồn tại" }); kiemTras.Add(new KiemTra() { _Control = iDen, _Tu = 0, _Den = 30, _ChoQua = !(_ListNhomDaiLyO.Where(w => iDen.Value > w.Tu - 1 && w.Den + 1 > iDen.Value && !w.ID.Equals(checkEdit1.Checked ? 0 : _NhomDaiLyO.ID)).Count() > 0) && iDen.Value - 1000000 > iTu.Value, _ThongBao2 = "Giá trị này đã tồn tại" }); XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("LoaiKhachHang", _LoaiKhachHang); dic.Add("Den", iDen.Value); dic.Add("Tu", iTu.Value); dic.Add("Ten", iTen.EditValue); long a = !checkEdit1.Checked ? _NhomDaiLyD.CapNhat(dic, _NhomDaiLyO.ID) : _NhomDaiLyD.ThemMoi(dic, true); if (XuLyGiaoDien.ThongBao("Nhóm " + (checkEdit1.Checked ? "thêm" : "sửa"), a > 0)) { _ListNhomDaiLyO = _NhomDaiLyD.DuLieu(_LoaiKhachHang); nhomKhachHangOBindingSource.DataSource = _ListNhomDaiLyO; (Owner.ActiveMdiChild as frmDaiLy).DuLieu(); } }
private void btnLuu2_Click(object sender, EventArgs e) { List <KiemTra> kiemTras = new List <KiemTra>() { new KiemTra() { _Control = iKyHieuDi, _Tu = 3, _Den = 100, }, new KiemTra() { _Control = iKyHieuDen, _Tu = 3, _Den = 5, _ChoQua = !_TuyenBayD.DaTonTai("Ten", iKyHieuDi.Text + "-" + iKyHieuDen.Text, _TuyenBayO.ID), _ThongBao2 = "Tuyến bay đã tồn tại" } }; XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } List <Dictionary <string, object> > Lstdic = new List <Dictionary <string, object> >(); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("KyHieuDen", iKyHieuDi.EditValue); dic.Add("KyHieuDi", iKyHieuDen.EditValue); dic.Add("Ten", iKyHieuDen.Text + "-" + iKyHieuDi.Text); Dictionary <string, object> dic2 = new Dictionary <string, object>(); dic2.Add("KyHieuDen", iKyHieuDen.EditValue); dic2.Add("KyHieuDi", iKyHieuDi.EditValue); dic2.Add("Ten", iKyHieuDi.Text + "-" + iKyHieuDen.Text); Lstdic.Add(dic); Lstdic.Add(dic2); long a = _TuyenBayD.ThemNhieu1Ban(Lstdic); if (XuLyGiaoDien.ThongBao(Text, a > 0)) { (Owner.ActiveMdiChild as frmTuyenBay).DuLieuSanBay(); Close(); } }
private void btnLuu2_Click(object sender, EventArgs e) { List <KiemTra> kiemTras = new List <KiemTra>() { new KiemTra() { _Control = iTenDayDu, _Tu = 3, _Den = 100, _ChoQuaThang = !_SanBayD.DaTonTai("TenDayDu", iKyHieu.Text, _SanBayO.ID), _ThongBao2 = "Sân bay đã tồn tại" }, new KiemTra() { _Control = iKyHieu, _Tu = 3, _Den = 5, _ChoQuaThang = !_SanBayD.DaTonTai("KyHieu", iKyHieu.Text, _SanBayO.ID), _ThongBao2 = "Sân bay đã tồn tại" } }; XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("TenDayDu", iTenDayDu.Text); dic.Add("KyHieu", iKyHieu.Text); dic.Add("NoiDia", iNoiDia.Checked); dic.Add("KhuVuc", (Text.StartsWith("Khu vực"))); long CapNhatNum = (_SanBayO.ID > 0) ? (_SanBayD.CapNhat(dic, _SanBayO.ID) > 0 ? _SanBayO.ID : 0) : _SanBayD.ThemMoi(dic, true); if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0)) { if (Text.StartsWith("Khu vực")) { (Owner as frmNCCThem).KhuVuc(); } else { (Owner.ActiveMdiChild as frmTuyenBay).DuLieuSanBay(); } Close(); } }
private void frmCongNo_Load(object sender, EventArgs e) { //------------------------------------------------------------------------------------------------------------------------------------------------------------------------ try { Microsoft.Win32.RegistryKey key = Microsoft.Win32.Registry.CurrentUser.OpenSubKey(@"SOFTWARE\THCRM", true); if ((key.GetValue("TepDinhKem") ?? string.Empty) != string.Empty) { txtFileDinhKem.Properties.Tokens.Clear(); List <string> filenames = key.GetValue("TepDinhKem").ToString().Split(',').ToList(); foreach (var item in filenames) { string filename = Path.GetFileName(item); var token_item = new TokenEditToken(filename + $" [{GetFileSizeFromFileNameURL(item)}]", item); txtFileDinhKem.Properties.Tokens.Add(token_item); } try { txtFileDinhKem.EditValue = string.Join(",", filenames); txtFileDinhKem.Properties.PopupPanel = flyEmail; } catch (Exception ex) { XuLyGiaoDien.Alert(ex.Message, Form_Alert.enmType.Warning); } } key.Close(); } catch { } //------------------------------------------------------------------------------------------------------------------------------------------------------------------------ dtpTuNgay.EditValue = DateTime.ParseExact("01/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(), "d/M/yyyy", null); dtpDenNgay.EditValue = (DateTime.Today.Day == 1) ? DateTime.Today : DateTime.Today.AddDays(-1); dateEdit1.EditValue = DateTime.ParseExact("01/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(), "d/M/yyyy", null).AddDays(-3); dateEdit2.EditValue = DateTime.Today; loaiGiaoDichOBindingSource.DataSource = new D_LOAIGIAODICH().DuLieu_CongNo_TheoLoai(chk.Checked ? 1 : 2); tuyenBayOBindingSource.DataSource = new D_TUYENBAY().DuLieu(); //------------------------------------------------------------------------------------------------------------------------------------------------------------------------ btnExcel.Enabled = DuLieuTaoSan.Q.Lv2Excel; btnGuiMail.Enabled = DuLieuTaoSan.Q.Lv2GuiMail; btnFILE.Enabled = DuLieuTaoSan.Q.Lv2ThemTep; }
private void frmCapSignIn_Load(object sender, EventArgs e) { ma = new D_MAUEMAIL().DuLieu()[5]; _lstDL = new D_DAILY().All(false).Where(w => w.LoaiKhachHang.Equals(1)).ToList(); for (int i = 0; i < _lstDL.Count; i++) { _lstDL[i].TenTam = (_lstDL[i].Ten + "_" + _lstDL[i].MaAGS).ToUpper(); } daiLyOBindingSource.DataSource = _lstDL; _lstHB = new D_HANGBAY().DuLieu().Where(w => w.SapXep).ToList();; hangBayOBindingSource.DataSource = _lstHB; List <O_NHACUNGCAP> nc = new D_NHACUNGCAP().DuLieu(); lstSI = new D_SIGNIN().DuLieu(); Microsoft.Win32.RegistryKey key = Microsoft.Win32.Registry.CurrentUser.OpenSubKey(@"SOFTWARE\THCRM", true); if ((key.GetValue("TepDinhKemSignIn") ?? string.Empty) != string.Empty) { txtFileDinhKem.Properties.Tokens.Clear(); List <string> filenames = key.GetValue("TepDinhKemSignIn").ToString().Split(',').ToList(); try { foreach (var item in filenames) { string filename = Path.GetFileName(item); var token_item = new TokenEditToken(filename + $" [{GetFileSizeFromFileNameURL(item)}]", item); txtFileDinhKem.Properties.Tokens.Add(token_item); } txtFileDinhKem.EditValue = string.Join(",", filenames); txtFileDinhKem.Properties.PopupPanel = flyEmail; } catch (Exception ex) { XuLyGiaoDien.Alert(ex.Message, Form_Alert.enmType.Warning); } } }
private void btnXDC_ItemClick(object sender, ItemClickEventArgs e) { O_GIAODICH GD = (GVDC.GetRow(GVDC.GetSelectedRows()[0]) as O_GIAODICH); switch (GD.LoaiGiaoDich) { case 1: case 0: if (!DuLieuTaoSan.Q.KhacXoa) { return; } break; default: if (!DuLieuTaoSan.Q.KhacAdminXoa) { return; } break; } if (XuLyGiaoDien.ThongBao("giao dịch", new D_GIAODICH().Xoa(GD.ID) > 0, true)) { string NoiDung = string.Format("Xóa GD ", GD.GhiChu); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("FormName", Text); dic.Add("MaCho", GD.MaCho); dic.Add("NoiDung", NoiDung); dic.Add("NVGiaoDich", DuLieuTaoSan.NV.ID); dic.Add("LoaiKhachHang", GD.LoaiKhachHang); dic.Add("Ma", GD.IDKhachHang); new D_LS_GIAODICH().ThemMoi(dic); NapDatCho(); } else { XuLyGiaoDien.Alert("Xóa không thành công", Form_Alert.enmType.Error); } }
private void btnLuu_Click(object sender, EventArgs e) { if (_lstSIChinh.Where(w => w.SignIn.Equals(iSignIn.Text) && iSignIn.Text.Length > 0).Count() == 0) { GCSI.DataSource = null; List <KiemTra> kiemTras = new List <KiemTra>(); kiemTras.Add(new KiemTra() { _Control = icmb, _Tu = 1, _Den = 50 }); kiemTras.Add(new KiemTra() { _Control = iHangBay, _Tu = 1, _Den = 50 }); kiemTras.Add(new KiemTra() { _Control = iSignIn, _Tu = 1, _Den = 50, _ChoQuaThang = icmb.SelectedIndex == 0 }); XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } O_SIGNIN si = new O_SIGNIN(); si.CanLam = icmb.SelectedIndex; si.DaiLy = (int)iIDKhachHang.EditValue; si.HangBay = (int)iHangBay.EditValue; si.SignIn = iSignIn.Text; si.MatKhau = iMatKhau.Text; si.Chinh = iChinh.Checked; _lstSIChinh.Add(si); GCSI.DataSource = _lstSIChinh; GVSI.ExpandAllGroups(); XulyDulieuKhiThem(); iMatKhau.Text = RandomPassword(); iSignIn.Text = ""; } }
private void btnLuu_Click(object sender, EventArgs e) { List <KiemTra> kiemTras = new List <KiemTra>() { new KiemTra() { _Control = iNCC, _Tu = 2, _Den = 50 }, new KiemTra() { _Control = iLoaiGiaoDich, _Tu = 2, _Den = 50 }, new KiemTra() { _Control = iGhiChu, _Tu = 2, _Den = 50 }, new KiemTra() { _Control = iSoTien, _Tu = 2, _Den = 5000 } }; XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1); if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } Dictionary <string, object> dic = new Dictionary <string, object>(); dic = XuLyDuLieu.FormToDictionary(this, dic); if (XuLyGiaoDien.ThongBao(Text, _nCCGDO.ID != 0 ? (_nCCGDD.CapNhat(dic, _nCCGDO.ID) > 0) : (_nCCGDD.ThemMoi(dic) > 0))) { (Owner.ActiveMdiChild as frmHangBay).DuLieu(); Close(); } }
private void btnLuu_Click(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) { XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning); return; } D_NGANHANG nhb = new D_NGANHANG(); Dictionary <string, object> dic = new Dictionary <string, object>(); dic = XuLyDuLieu.FormToDictionary(this, dic); long CapNhatNum = nho.ID > 0 ? nhb.CapNhat(dic, nho.ID) : nhb.ThemMoi(dic, true); if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0)) { if (nho.ID < 1) { List <Dictionary <string, object> > lstDicS = new List <Dictionary <string, object> >(); for (int i = 0; i < 30; i++) { dic = new Dictionary <string, object>(); dic.Add("NganHangID", CapNhatNum); dic.Add("SoDuCuoi", 0); dic.Add("Ngay", "getdate() - " + i); lstDicS.Add(dic); } new D_SODU_NGANHANG().ThemNhieu1Ban(lstDicS); } (Owner.ActiveMdiChild as frmNganHang).LayDLNganHang(); (Owner.ActiveMdiChild as frmNganHang).TaiLaiDuLieu(); (Owner.ActiveMdiChild as frmNganHang).LayDLKhac(); GhiChuCmt(nho.ID); Close(); } }