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