private void btnLuu_Click(object sender, EventArgs e) { if (gridView2.RowCount > 0 && gridView2.Columns["SoTien"].SummaryItem.SummaryValue.ToString() != (iSoTien.Value * (iLoaiKhachHang.EditValue.ToString() == "8" ? -1 : 1)).ToString()) { XuLyGiaoDien.Alert("Tổng tiền chi tiết không bằng giao dịch", Form_Alert.enmType.Warning); return; } List <KiemTra> kiemTras = new List <KiemTra>() { new KiemTra() { _Control = iNganHangID, _Tu = 2, _Den = 50 }, new KiemTra() { _Control = iLoaiGiaoDich, _Tu = 2, _Den = 50 }, new KiemTra() { _Control = iMaDL, _Tu = 2, _Den = 50, _ChoQuaThang = new List <int>() { 6, 9 }.Contains((int)iLoaiKhachHang.EditValue) }, new KiemTra() { _Control = iLoaiKhachHang, _Tu = 2, _Den = 50 } }; 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 = XuLyDuLieu.FormToDictionary(this, dic); bool ThanhCong = false; if (int.Parse(iLoaiKhachHang.EditValue.ToString()) == 7) { Dictionary <string, object> dicnh = new Dictionary <string, object>(); dicnh.Add("NgayGD", iNgayGD.DateTime); dicnh.Add("NganHangID", iMaDL.EditValue); dicnh.Add("MaDL", iNganHangID.EditValue); dicnh.Add("SoTien", 0 - iSoTien.Value); dicnh.Add("GhiChu", iGhiChu.Text); dicnh.Add("TrangThaiID", iTrangThaiID.EditValue); dicnh.Add("NgayHT", iNgayHT.DateTime); dicnh.Add("LoaiGiaoDich", ((int)iLoaiGiaoDich.EditValue % 2 == 0) ? int.Parse(iLoaiGiaoDich.EditValue.ToString()) - 1 : int.Parse(iLoaiGiaoDich.EditValue.ToString()) + 1); dicnh.Add("LoaiKhachHang", iLoaiKhachHang.EditValue); dicnh.Add("NVGiaoDich", iNVGiaoDich.EditValue); dicnh.Add("GhiChuNV", iGhiChuNV.Text); if (CTM.ID == 0) { string Ma = ct.LayGioServer().ToString("yyyyMMddhhmmssttt"); dicnh.Add("MaLienKet", Ma); dic.Add("MaLienKet", Ma); lstDic.Add(dic); lstDic.Add(dicnh); ThanhCong = ct.ThemNhieu1Ban(lstDic) > 1; } else { List <string> lstCTV = new List <string>() { string.Format("WHERE ID = {0}", CTM.ID), string.Format("WHERE MaLienKet = '{1}' and ID <> {0}", CTM.ID, CTM.MaLienKet) }; lstDic.Add(dic); lstDic.Add(dicnh); if ((int)iLoaiGiaoDich.EditValue != CTM.LoaiGiaoDich) { string Ma = ct.LayGioServer().ToString("yyyyMMddhhmmssttt"); dicnh.Add("MaLienKet", Ma); dic.Add("MaLienKet", Ma); List <string> lstTb = new List <string>(); List <string> lstThem = new List <string>(); lstThem.Add("S"); lstThem.Add("T"); lstTb.Add("CTNGANHANG"); lstTb.Add("CTNGANHANG"); ThanhCong = ct.CapNhat_ThemNhieu(lstDic, lstTb, lstCTV, lstThem) > 1; } else { ThanhCong = ct.SuaNhieu1Ban(lstDic, lstCTV) > 1; } } } else { ThanhCong = ((CTM.ID == 0) ? ct.ThemMoi(dic) : ct.CapNhat(dic, CTM.ID)) > 0; } if (XuLyGiaoDien.ThongBao(iLoaiGiaoDich.Text + (CTM.ID != 0 ? " sửa" : " thêm"), ThanhCong)) { if (_GiaoDichOLD.Count > 0 || _GiaoDich.Count > 0) { List <Dictionary <string, object> > lstDicT = new List <Dictionary <string, object> >(); List <string> lstTb = new List <string>(); List <string> lstThem = new List <string>(); List <string> lstCTV = new List <string>(); foreach (O_BAOCAOCTNH d in _GiaoDich) { if (_GiaoDichOLD.Contains(d)) { lstDicT.Add(XuLyDuLieu.ConvertClassToDic(d)); lstThem.Add("S"); } else { lstDicT.Add(XuLyDuLieu.ConvertClassToDic(d)); lstThem.Add("T"); } lstCTV.Add(string.Format("WHERE ID = {0}", d.ID)); lstTb.Add("BAOCAOCTNH"); } new D_BAOCAOCTNH().CapNhat_ThemNhieu(lstDicT, lstTb, lstCTV, lstThem); List <object> lstCTVBC = new List <object>(); foreach (O_BAOCAOCTNH d in _GiaoDichOLD) { if (!_GiaoDich.Contains(d)) { lstCTVBC.Add(d.ID); } } if (lstCTVBC.Count > 0) { new D_BAOCAOCTNH().XoaNhieu1Ban(lstCTVBC, "BAOCAOCTNH"); } } new D_NGANHANG().ChayLaiSD(); O_LOAIGIAODICH _NCCO = iLoaiGiaoDich.GetSelectedDataRow() as O_LOAIGIAODICH; if (CTM.NganHangID == 1) { (Owner.ActiveMdiChild as frmTienMat).TaiLaiDuLieu(); } else { (Owner.ActiveMdiChild as frmNganHang).LayDLNganHang(); (Owner.ActiveMdiChild as frmNganHang).TaiLaiDuLieu(); } GhiChuCmt(CTM.ID); Close(); } }
private void btnTHu_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("Bạn muốn thêm phí ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { 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(); } List <long> a = new List <long>(); string daily = string.Format("{0}", lstDaiLyz.CheckedItems[0]); a.Add(long.Parse(lstDaiLyz.CheckedItems[0].ToString())); for (int i = 1; i < n; i++) { a.Add(long.Parse(lstDaiLyz.CheckedItems[i].ToString())); 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)); O_GIAODICH gdo; O_KHOANGAY kn = new D_KHOANGAY().KiemTraNgayKhoa(bdtpTu.DateTime); if (kn.KhoaAdmin) { return; } D_GIAODICH giaoDichD = new D_GIAODICH(); foreach (int b in a) { O_DAILY dl = lstDaiLy.Where(w => w.ID.Equals(b)).ToList()[0]; XuLyGiaoDien.wait.SetWaitFormDescription("Thu phí: " + dl.Ten); gdo = new O_GIAODICH(); gdo.LoaiKhachHang = dl.LoaiKhachHang; gdo.IDKhachHang = dl.ID; gdo.MaCho = "HD"; gdo.NVGiaoDich = DuLieuTaoSan.NV.ID; gdo.GiaThu = gdo.GiaHeThong = long.Parse(lst.Where(w => w.IDKhachHang.Equals(b)).Sum(w => w.CL2).ToString()); gdo.TenKhach = "Phí hóa đơn tháng " + bdtpTu.DateTime.Month; gdo.CoDinh = true; gdo.HTTT = 1; gdo.LoaiGiaoDich = 5; if (gdo.GiaHeThong > 0) { giaoDichD.ThemMoi(XuLyDuLieu.ConvertClassToDic(gdo)); } } if (XuLyGiaoDien.wait.IsSplashFormVisible) { XuLyGiaoDien.wait.CloseWaitForm(); } XuLyGiaoDien.Alert("Thêm giao dịch thành công!", Form_Alert.enmType.Success); } } }