public void genGrid(decimal ip_dc_id_don_vi, int ip_i_nam) { List<GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN> lst_pl02; List<QuyetToan.PL02_kinh_phi_su_dung_quyet_toan.ItemCLKM> lst_clkm; List<string> lst_NDC; lst_NDC = new List<string>(); lst_NDC.Add("I. Kinh phí năm quyết toán năm nay:"); lst_NDC.Add("II. KP năm trước chưa QT, quyết toán năm nay"); BKI_QLDTEntities db = new BKI_QLDTEntities(); //load list Chuong loai khoan muc tieu muc lst_clkm = db .DM_CHUONG_LOAI_KHOAN_MUC .Select(x => new QuanLyDuToan.QuyetToan.PL02_kinh_phi_su_dung_quyet_toan.ItemCLKM { MaSo = x.MA_SO , Ten = x.TEN , IdLoai = x.ID_LOAI , MaSoParent = x.DM_CHUONG_LOAI_KHOAN_MUC_PARENT.MA_SO }) .ToList(); //Sao chep du lieu Muc, Tieu muc tu GD_GIAO_KH sang DateTime v_dat_dau_nam = new DateTime(ip_i_nam, 1, 1); DateTime v_dat_cuoi_nam = new DateTime(ip_i_nam + 1, 1, 1); var lst_gd_giao_kh = db.GD_CHI_TIET_GIAO_KH .Where(x => x.ID_DON_VI == ip_dc_id_don_vi && x.DM_QUYET_DINH.NGAY_THANG >= v_dat_dau_nam && x.DM_QUYET_DINH.NGAY_THANG <= v_dat_cuoi_nam && x.ID_CHUONG != null) .ToList(); lst_pl02 = db.GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN .Where(x => x.ID_DON_VI == ip_dc_id_don_vi && x.NAM == ip_i_nam) .ToList(); //Sao chep muc, tieu muc KHONG co trong PL02 foreach (var kh in lst_gd_giao_kh) { if (!lst_pl02.Exists(x=>x.MA_KHOAN==kh.DM_CHUONG_LOAI_KHOAN_MUC_KHOAN.MA_SO &&x.MA_MUC==kh.DM_CHUONG_LOAI_KHOAN_MUC_MUC.MA_SO &&x.MA_TIEU_MUC==kh.DM_CHUONG_LOAI_KHOAN_MUC_TIEU_MUC.MA_SO)) { GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN gd = new GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN(); gd.ID_DON_VI = ip_dc_id_don_vi; gd.LOAI = lst_NDC[0]; gd.MA_KHOAN = kh.DM_CHUONG_LOAI_KHOAN_MUC_KHOAN.MA_SO; gd.MA_LOAI = kh.DM_CHUONG_LOAI_KHOAN_MUC_KHOAN.DM_CHUONG_LOAI_KHOAN_MUC_PARENT.MA_SO; gd.MA_MUC = kh.DM_CHUONG_LOAI_KHOAN_MUC_MUC.MA_SO; gd.MA_TIEU_MUC = kh.DM_CHUONG_LOAI_KHOAN_MUC_TIEU_MUC.MA_SO; gd.NAM = ip_i_nam; gd.SO_BAO_CAO = 0; gd.SO_XET_DUYET = 0; db.GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN.Add(gd); db.SaveChanges(); //reload list PL02 lst_pl02 = db.GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN .Where(x => x.ID_DON_VI == ip_dc_id_don_vi && x.NAM == ip_i_nam) .ToList(); } } //Xoa nhung muc, tieu muc KHONG co trong GD_GIAO_KH foreach (var pl02 in lst_pl02.Where(x => x.LOAI.Contains("I. Kinh phí năm quyết toán năm nay")).ToList()) { if (!lst_gd_giao_kh.Exists(x=>x.DM_CHUONG_LOAI_KHOAN_MUC_KHOAN.MA_SO==pl02.MA_KHOAN &&x.DM_CHUONG_LOAI_KHOAN_MUC_MUC.MA_SO==pl02.MA_MUC &&x.DM_CHUONG_LOAI_KHOAN_MUC_TIEU_MUC.MA_SO==pl02.MA_TIEU_MUC)) { db.GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN.Remove(pl02); db.SaveChanges(); } } //reload list PL02 lst_pl02 = db.GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN .Where(x => x.ID_DON_VI == ip_dc_id_don_vi && x.NAM == ip_i_nam) .ToList(); string v_str_grid = ""; v_str_grid = UserControls.QT_QBT_GRID_PL02.RenderToString(lst_pl02, lst_NDC, lst_clkm); Context.Response.Output.Write(v_str_grid); }
public void UpdateGiaoDich( decimal ip_dc_id_giao_dich , string ip_str_ma_loai , string ip_str_ma_khoan , string ip_str_ma_muc , string ip_str_ma_tieu_muc , string ip_str_so_bao_cao , string ip_str_so_xet_duyet , string ip_str_noi_dung_chi , string ip_str_loai , decimal ip_dc_id_don_vi , decimal ip_dc_nam) { try { using (BKI_QLDTEntities db = new BKI_QLDTEntities()) { GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN gd; if (ip_dc_id_giao_dich < 0) { gd = new GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN(); } else { gd = db.GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN.Where(x => x.ID == ip_dc_id_giao_dich).FirstOrDefault(); } gd.MA_LOAI = ip_str_ma_loai; gd.MA_KHOAN = ip_str_ma_khoan; gd.MA_MUC = ip_str_ma_muc; gd.MA_TIEU_MUC = ip_str_ma_tieu_muc; gd.NOI_DUNG_CHI = ip_str_noi_dung_chi; gd.ID_DON_VI = ip_dc_id_don_vi; gd.NAM = ip_dc_nam; gd.LOAI = ip_str_loai; gd.SO_BAO_CAO = CIPConvert.ToDecimal(ip_str_so_bao_cao.Replace(",", "").Replace(".", "")); gd.SO_XET_DUYET = CIPConvert.ToDecimal(ip_str_so_xet_duyet.Replace(",", "").Replace(".", "")); if (ip_dc_id_giao_dich < 0) { db.GD_PL02_KINH_PHI_DA_SU_DUNG_DE_NGHI_QUYET_TOAN.Add(gd); } db.SaveChanges(); } } catch (Exception) { throw; } }