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