private void FrmTongHopKinhPhi_Load(object sender, EventArgs e)
{
txtNam.Text = DateTime.Now.Year.ToString();
String MaLoaiChungTu = this.AccessibleDescription;
objLoaiChungTu = VnsLoaiChungTuService.GetByMa(MaLoaiChungTu);
}
private void BindCombo()
{
objLoaiChungTu = VnsLoaiChungTuService.GetByMa(MaLoaiChungTu);
if (objLoaiChungTu != null)
{
this.Text = objLoaiChungTu.Ten;
}
}
private void BindCombo()
{
MaLoaiChungTu = this.AccessibleDescription;
objLoaiChungTu = VnsLoaiChungTuService.GetByMa(MaLoaiChungTu);
if (objLoaiChungTu != null)
{
this.Text = objLoaiChungTu.Ten;
}
}
public List <string> GetSoCT_prefix(VnsLoaiChungTu objLct, int SoChungtuMax, int THANG, int NAM)
{
List <string> lst_str = new List <string>();
string Prefix = "";
string So_CT = "";
decimal m_SoCT_old = SoChungtuMax;
VnsLoaiChungTu obj = objLct;
if (!string.IsNullOrEmpty(obj.MauSoCt))
{
string m_prefix_old = obj.MauSoCt;
Prefix = GetPrefix(m_prefix_old, NAM, THANG);
}
So_CT = GetSoCT(m_SoCT_old, 6);
lst_str.Add(Prefix);
lst_str.Add(So_CT);
return(lst_str);
}
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);
}
private void btnIn_Click(object sender, EventArgs e)
{
VnsLoaiChungTu objct = (VnsLoaiChungTu)ComboHelper.GetSelectData(cboLoaiCt);
IList <RpChiTietNganSach> lst = new List <RpChiTietNganSach>();
string mact = objct == null ? "" : objct.MaLoaiChungTu;
lst = ReportCapPhatService.GetBangKeChiTiet(ucDate.StartDate, ucDate.EndDate, mact, new Guid());
IList <Info> TempLstThamSo = General.lstThamSo;
Info objThamSo = new Info();
objThamSo.Ma = "p_DateInput";
objThamSo.GiaTri = ucDate.Value_info.Ten;
TempLstThamSo.Add(objThamSo);
objThamSo = new Info();
objThamSo.Ma = "p_DonVi";
objThamSo.GiaTri = cboLoaiCt.Text;
TempLstThamSo.Add(objThamSo);
objThamSo = new Info();
objThamSo.Ma = "p_NgayBaoCao";
objThamSo.GiaTri = "Hà Nội, ngày " + DateTime.Now.Day.ToString() + " tháng " + DateTime.Now.Month.ToString() + " năm " + DateTime.Now.Year.ToString();
TempLstThamSo.Add(objThamSo);
objThamSo = new Info();
objThamSo.Ma = "p_TieuDe";
string TieuDe = cboLoaiCt.Text;
objThamSo.GiaTri = TieuDe.ToUpper();
TempLstThamSo.Add(objThamSo);
ReportHelper.getParamValue(General.lstThamSo);
List <RpChiTietNganSach> tmplst = new List <RpChiTietNganSach>(lst);
XtraReport rp;
switch (this.AccessibleDescription)
{
case "BangKe_01":
rp = new Report.BangKe_01();
ReportHelper.SetParamValue(TempLstThamSo, rp.Parameters);
tmplst = new List <RpChiTietNganSach>(lst);
tmplst.Sort(RpChiTietNganSach.ComparePhieuByNgay_SoCt);
tmplst = SortList(tmplst);
rp.DataSource = tmplst;
rp.ShowPreviewDialog();
break;
case "BangKe_02":
tmplst = new List <RpChiTietNganSach>(lst);
tmplst.Sort(RpChiTietNganSach.ComparePhieuByNgay_SoCt);
rp = new Report.BangKe_02(tmplst);
ReportHelper.SetParamValue(TempLstThamSo, rp.Parameters);
rp.DataSource = tmplst;
rp.ShowPreviewDialog();
break;
}
}
