private void gvTamUng_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { if (_GridView.FocusedRowHandle < 0) { return; } VnsCtNganSach tmp = (VnsCtNganSach)_GridView.GetRow(_GridView.FocusedRowHandle); switch (e.Column.Name) { case "colKhoanChiId": VnsDmKhoanChi tmpkc = (VnsDmKhoanChi)grlKhoanChi.GetRowByKeyValue(tmp.KhoanChiId); if (tmpkc == null) { return; } tmp.ObjDmKhoanChi = tmpkc; tmp.DienGiai = tmpkc.TenKhoanChi; break; case "colLoaiKhoanId": tmp.ObjVnsMaLoaiKhoan = (VnsMaLoaiKhoan)grlLoaiKhoan.GetRowByKeyValue(tmp.LoaiKhoanId); break; } _GridControl.RefreshDataSource(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void DeleteRow() { if (_GridView.FocusedRowHandle < 0) { return; } VnsCtNganSach gd = (VnsCtNganSach)_GridView.GetRow(_GridView.FocusedRowHandle); if (lstDelGiaoDich == null) { lstDelGiaoDich = new List <VnsCtNganSach>(); } lstDelGiaoDich.Add(gd); _GridView.DeleteSelectedRows(); _GridView.RefreshData(); }
private int SetFocusAfterAdd(GridView _GridView, DateTime beforeAdd) { for (int i = 0; i < _GridView.RowCount - 1; i++) { if (!_GridView.IsValidRowHandle(i)) { continue; } VnsCtNganSach tmp = (VnsCtNganSach)_GridView.GetRow(i); if (tmp != null) { if (tmp.GioThemMoi >= beforeAdd) { return(i); } } } return(0); }
private void AddRow() { DateTime beforeAdd = DateTime.Now; System.Threading.Thread.Sleep(1); if (lstGiaoDich == null) { lstGiaoDich = new List <VnsCtNganSach>(); } VnsCtNganSach tmp = new VnsCtNganSach(); int count = _GridView.RowCount; if (_GridView.FocusedRowHandle >= 0) { tmp = (VnsCtNganSach)_GridView.GetRow(_GridView.FocusedRowHandle); } if (tmp == null) { lstGiaoDich.Add(new VnsCtNganSach()); } else { VnsCtNganSach tmpAddRow = new VnsCtNganSach(); tmpAddRow.KhoanChiId = tmp.KhoanChiId; tmpAddRow.ObjDmKhoanChi = tmp.ObjDmKhoanChi; tmpAddRow.DienGiai = tmp.DienGiai; tmpAddRow.NoiDungCapPhat = txtNoiDung.Text; lstGiaoDich.Add(tmpAddRow); } //_GridControl.DataSource = lstGiaoDich; _GridView.RefreshData(); SetFocusAfterAdd(_GridView, beforeAdd); }
public IList <RpNganSachTongHop> GetKeHoachCapPhat(DateTime TuNgay, DateTime DenNgay, VnsLoaiChungTu objLCT) { VnsKhNganSachDao.DeleteBy(objLCT.MaLoaiChungTu, TuNgay.AddYears(1), DenNgay.AddYears(1), true); IList <RpNganSachTongHop> lstKh = VnsKhNganSachDao.GetKeHoachTrongNam("", TuNgay, DenNgay); IList <RpNganSachTongHop> lstCp = VnsChungTuDao.GetCapPhatTrongNam("", TuNgay, DenNgay); List <RpNganSachTongHop> lstKeHoachNamSau = new List <RpNganSachTongHop>(); List <RpNganSachTongHop> lstDuPhong = new List <RpNganSachTongHop>(); IList <VnsDmDonVi> lstDonvi = new List <VnsDmDonVi>(); IList <VnsMaLoaiKhoan> lstMaLoaiKhoan = new List <VnsMaLoaiKhoan>(); IList <VnsDmKhoanChi> lstKhoanChi = new List <VnsDmKhoanChi>(); lstDonvi = VnsDmDonViDao.GetAll(); lstMaLoaiKhoan = VnsMaLoaiKhoanDao.GetAll(); lstKhoanChi = VnsDmKhoanChiDao.GetAll(); foreach (RpNganSachTongHop objKh in lstKh) { lstKeHoachNamSau.Add(objKh); } foreach (RpNganSachTongHop objCp in lstCp) { Boolean flg = false; foreach (RpNganSachTongHop objKhNamSau in lstKeHoachNamSau) { if (objKhNamSau.DonViId == objCp.DonViId && objKhNamSau.KhoanChiId == objCp.KhoanChiId && objKhNamSau.LoaiKhoanId == objCp.LoaiKhoanId) { flg = true; objKhNamSau.SoTien = objKhNamSau.SoTien - objCp.SoTien; continue; } } if (!flg) { objCp.SoTien = objCp.SoTien * -1; lstDuPhong.Add(objCp); } } if (lstDuPhong.Count > 0) { foreach (RpNganSachTongHop rp in lstDuPhong) { lstKeHoachNamSau.Add(rp); } } lstKeHoachNamSau.Sort(CompareReport); Guid DonViId = new Guid(); VnsKhNganSach objKhNganSach = new VnsKhNganSach(); List <VnsKhNganSach> lstKhNganSach = new List <VnsKhNganSach>(); int sochungtumax = 0; for (int i = 0; i < lstKeHoachNamSau.Count; i++) { if (DonViId != lstKeHoachNamSau[i].DonViId) { sochungtumax++; DonViId = lstKeHoachNamSau[i].DonViId; objKhNganSach = new VnsKhNganSach(); List <String> lstCt = GetSoCT_prefix(objLCT, sochungtumax, 1, DenNgay.Year + 1); objKhNganSach.SoChungTu = lstCt[0] + lstCt[1]; objKhNganSach.DonViId = DonViId; objKhNganSach.ObjDmDonVi = GetDonVi(DonViId, lstDonvi); objKhNganSach.LoaiCt = objLCT.Id; objKhNganSach.MaCt = objLCT.MaLoaiChungTu; objKhNganSach.NgayCt = DenNgay.AddDays(1); objKhNganSach.NgayKeHoach = DenNgay.AddDays(1); objKhNganSach.NoiDung = "Chuyen so du nam truoc"; objKhNganSach.TuDong = true; lstKhNganSach.Add(objKhNganSach); } VnsCtNganSach objns = new VnsCtNganSach(); objns.KhoanChiId = lstKeHoachNamSau[i].KhoanChiId; objns.ObjDmKhoanChi = GetDmKhoanChi(objns.KhoanChiId, lstKhoanChi); objns.LoaiKhoanId = lstKeHoachNamSau[i].LoaiKhoanId; objns.ObjVnsMaLoaiKhoan = GetMaLoaiKhoan(objns.LoaiKhoanId, lstMaLoaiKhoan); objns.SoTien = lstKeHoachNamSau[i].SoTien; objns.DienGiai = objns.ObjDmKhoanChi.TenKhoanChi; objns.NoiDungCapPhat = "Số dư năm trước chuyển sang"; if (objns.SoTien > 0) { objKhNganSach.LstNganSach.Add(objns); } } VnsHtSoCtMaxDao.SetSoChungTuMaxByThangNamEtc(objLCT.Id, sochungtumax, 1, DenNgay.Year + 1); for (int i = 0; i < lstKhNganSach.Count; i++) { if (lstKhNganSach[i].LstNganSach.Count > 0) { VnsKhNganSachDao.SaveOrUpdate(lstKhNganSach[i]); } } return(lstKeHoachNamSau); }