private void load_data_to_grid() { if (!check_validate_input_report_is_ok()) return; US_V_DM_GIAI_NGAN v_us = new US_V_DM_GIAI_NGAN(); DS_V_DM_GIAI_NGAN v_ds = new DS_V_DM_GIAI_NGAN(); v_ds.EnforceConstraints = false; v_us.FillDatasetByProc( v_ds , CIPConvert.ToDatetime(m_txt_tu_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT) , CIPConvert.ToDatetime(m_txt_den_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT) , CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue) , m_txt_tu_khoa_tim_kiem.Text.Trim() ); //Edit dataset: Chỉ rõ Uỷ nhiệm chi là Nguồn nào? for (int i = 0; i < v_ds.V_DM_GIAI_NGAN.Count; i++) { if (v_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.IS_NGUON_NS_YN].ToString().Equals(STR_NGUON.NGAN_SACH)) v_ds.Tables[0].Rows[i]["NGUON_NS_YN"] = "Giấy rút dự toán Ngân sách"; else v_ds.Tables[0].Rows[i]["NGUON_NS_YN"] = "Uỷ nhiệm chi Quỹ Bảo trì"; } v_ds.AcceptChanges(); m_grv_bao_cao_giao_von.DataSource = v_ds.V_DM_GIAI_NGAN; m_grv_bao_cao_giao_von.DataBind(); }
private void load_content_print(decimal ip_dc_id_dm_unc) { US_DM_GIAI_NGAN v_us = new US_DM_GIAI_NGAN(ip_dc_id_dm_unc); m_lbl_so_unc.Text = v_us.strSO_UNC; m_lbl_so_tien_ghi_bang_chu.Text = v_us.strTTDVH_SO_TIEN; US_V_DM_GIAI_NGAN v_us_v_giai_ngan = new US_V_DM_GIAI_NGAN(); m_ds = new DS_V_DM_GIAI_NGAN(); m_ds.EnforceConstraints = false; US_DM_THONG_TIN_DON_VI v_us_thong_tin_don_vi = new US_DM_THONG_TIN_DON_VI(); decimal v_dc_id_don_vi = m_dc_id_don_vi; //if (Request.QueryString["ip_dc_id_don_vi"] != null) //{ // v_dc_id_don_vi = CIPConvert.ToDecimal(Request.QueryString["ip_dc_id_don_vi"]); //} v_us_thong_tin_don_vi.InitByID_DON_VI(v_dc_id_don_vi); US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(v_dc_id_don_vi); v_us_v_giai_ngan.FillDataset(m_ds, "where " + V_DM_GIAI_NGAN.ID_DON_VI + "=" + v_dc_id_don_vi + " and " + V_DM_GIAI_NGAN.ID + "=" + ip_dc_id_dm_unc); //load data to Noi dung thanh toan for (int i = 0; i < m_ds.V_DM_GIAI_NGAN.Count; i++) { m_dc_tong_tien += CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_NOP_THUE]) + CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_TT_CHO_DV_HUONG]); m_dc_tong_tien_nop_thue += CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_NOP_THUE]); m_dc_tong_tien_thanh_toan_cho_don_vi_huong += CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_TT_CHO_DV_HUONG]); } //load info Don vi tra tien m_lbl_don_vi_rut_du_toan.Text = v_us_dm_don_vi.strTEN_DON_VI; m_lbl_tai_kbns.Text = v_us_thong_tin_don_vi.strKHO_BAC; m_lbl_tai_khoan.Text = v_us.strMA_TKKT; m_lbl_ma_dvqhns.Text = v_us.strMA_DVQHNS; m_lbl_ma_ctmt_da_htct.Text = v_us.strMA_CTMT_DA_HTCT; m_lbl_so_tien_ghi_bang_chu.Text = "..........................................................................................................."; m_lbl_so_tien_ghi_bang_chu.Text = IP.Core.IPCommon.CRead.ChuyenSo(m_dc_tong_tien.ToString()); //load info Nop thue m_lbl_nt_ten_don_vi.Text = v_us.strNT_TEN_DON_VI; m_lbl_nt_ma_so_thue.Text = v_us.strNT_MA_SO_THUE; m_lbl_nt_ma_ndkt.Text = v_us.strNT_MA_NDKT; m_lbl_nt_ma_chuong.Text = v_us.strNT_MA_CHUONG; m_lbl_nt_co_quan_quan_ly_thu.Text = v_us.strNT_CQ_QL_THU; m_lbl_nt_ma_cq_thu.Text = v_us.strNT_MA_CQ_THU; m_lbl_nt_so_tien_nop_thue.Text = IP.Core.IPCommon.CRead.ChuyenSo(m_dc_tong_tien_nop_thue.ToString()); //load info Thanh toan cho don vi huong m_lbl_ttdvh_don_vi_nhan_tien.Text = v_us.strTTDVH_DON_VI_NHAN_TIEN; m_lbl_ttdvh_ma_dvqhns.Text = v_us.strTTDVH_MA_DVQHNS; m_lbl_ttdvh_dia_chi.Text = v_us.strTTDVH_DIA_CHI; m_lbl_ttdvh_tai_khoan.Text = v_us.strTTDVH_TAI_KHOAN; m_lbl_ttdvh_ma_ctmt_da_htct.Text = v_us.strTTDVH_MA_CTMT_DA_VA_HTCT; m_lbl_ttdvh_tai_kbnn.Text = v_us.strTTDVH_KHO_BAC; m_lbl_ttdvh_so_tien_thanh_toan.Text = IP.Core.IPCommon.CRead.ChuyenSo(m_dc_tong_tien_thanh_toan_cho_don_vi_huong.ToString()); m_lbl_cmnd_so.Text = v_us.strNGUOI_NHAN_TIEN_CMND_SO; m_lbl_cap_ngay.Text = v_us.strNGUOI_NHAN_TIEN_CAP_NGAY; m_lbl_noi_cap.Text = v_us.strNGUOI_NHAN_TIEN_NOI_CAP; m_lbl_ten_ctmt_da.Text = v_us.strTEN_CTMT_DA; m_lbl_ma_cap_ns.Text = v_us.strMA_CAP_NS; m_lbl_nam_ns.Text = v_us.datNGAY_THANG.Year.ToString(); m_lbl_so_ckc_hdk.Text = v_us.strSO_CKC_HDK; m_lbl_so_ckc_hdth.Text = v_us.strSO_CKC_HDTH; if (v_us.strIS_NGUON_NS_YN == "N") { m_lbl_tai_khoan.Text = v_us_thong_tin_don_vi.strMA_TKKT1; } else { m_lbl_tai_khoan.Text = v_us_thong_tin_don_vi.strMA_TKKT2; } //m_ckb_thuc_chi.Checked = getISCheck(v_us.strTHUC_CHI_YN); //m_ckb_tam_ung.Checked = getISCheck(v_us.strTAM_UNG_YN); //m_ckb_ung_truoc_chua_du_dk_thanh_toan.Checked = getISCheck(v_us.strUNG_TRUOC_CHUA_DU_DK_THANH_TOAN_YN); //m_ckb_ung_truoc_du_dk_thanh_toan.Checked = getISCheck(v_us.strUNG_TRUOC_DU_DK_THANH_TOAN_YN); //m_ckb_chuyen_khoan.Checked = getISCheck(v_us.strCHUYEN_KHOAN_YN); //m_ckb_tien_mat.Checked = getISCheck(v_us.strTIEN_MAT_YN); }
private void load_content_print(decimal ip_dc_id_dm_unc) { US_DM_GIAI_NGAN v_us = new US_DM_GIAI_NGAN(ip_dc_id_dm_unc); US_V_DM_GIAI_NGAN v_us_v_giai_ngan = new US_V_DM_GIAI_NGAN(); DS_V_DM_GIAI_NGAN v_ds = new DS_V_DM_GIAI_NGAN(); v_ds.EnforceConstraints = false; US_DM_THONG_TIN_DON_VI v_us_thong_tin_don_vi = new US_DM_THONG_TIN_DON_VI(); decimal v_dc_id_don_vi = Person.get_id_don_vi(); if (Request.QueryString["ip_dc_id_don_vi"]!=null) { v_dc_id_don_vi = CIPConvert.ToDecimal(Request.QueryString["ip_dc_id_don_vi"]); } v_us_thong_tin_don_vi.InitByID_DON_VI(v_dc_id_don_vi); US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(v_dc_id_don_vi); v_us_v_giai_ngan.FillDataset(v_ds, "where " + V_DM_GIAI_NGAN.ID_DON_VI + "=" + v_dc_id_don_vi +" and "+V_DM_GIAI_NGAN.ID+"="+ip_dc_id_dm_unc); m_lbl_ngay_thang.Text = " " + CIPConvert.ToStr(v_us.datNGAY_THANG, "dd") + " tháng " + CIPConvert.ToStr(v_us.datNGAY_THANG, "MM") + " năm " + CIPConvert.ToStr(v_us.datNGAY_THANG, "yyyy"); //load data to Noi dung thanh toan m_grv.DataSource = v_ds.V_DM_GIAI_NGAN; m_grv.DataBind(); decimal v_dc_tong_tien=0; decimal v_dc_nop_thue = 0; decimal v_dc_don_vi_huong = 0; for (int i = 0; i < v_ds.V_DM_GIAI_NGAN.Count; i++) { v_dc_tong_tien+=CIPConvert.ToDecimal( v_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_NOP_THUE]) +CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_TT_CHO_DV_HUONG]); v_dc_nop_thue += CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_NOP_THUE]); v_dc_don_vi_huong += CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_TT_CHO_DV_HUONG]); } //load info Don vi tra tien m_lbl_so_unc.Text = v_us.strSO_UNC; m_lbl_so_tien_ghi_bang_chu.Text = v_us.strTTDVH_SO_TIEN; m_lbl_dia_chi.Text = v_us_thong_tin_don_vi.strDIA_CHI; m_lbl_tai_kho_bac_nha_nuoc.Text = v_us_thong_tin_don_vi.strKHO_BAC; m_lbl_ma_tkkt.Text = v_us.strMA_TKKT ; m_lbl_ma_dvqhns.Text = v_us.strMA_DVQHNS; m_lbl_ma_ctmt_da_htct.Text = v_us.strMA_CTMT_DA_HTCT; m_lbl_so_tien_ghi_bang_chu.Text = "..........................................................................................................."; m_lbl_so_tien_ghi_bang_chu.Text = IP.Core.IPCommon.CRead.ChuyenSo(v_dc_tong_tien.ToString()); //load info Nop thue m_lbl_nt_ten_don_vi.Text = v_us.strNT_TEN_DON_VI; m_lbl_nt_ma_so_thue.Text = v_us.strNT_MA_SO_THUE; m_lbl_nt_ma_ndkt.Text = v_us.strNT_MA_NDKT; m_lbl_nt_ma_chuong.Text = v_us.strNT_MA_CHUONG; m_lbl_nt_co_quan_quan_ly_thu.Text = v_us.strNT_CQ_QL_THU; m_lbl_nt_ma_cq_thu.Text = v_us.strNT_MA_CQ_THU; m_lbl_nt_so_tien_nop_thue.Text = IP.Core.IPCommon.CRead.ChuyenSo(v_dc_nop_thue.ToString()); ; //load info Thanh toan cho don vi huong m_lbl_ttdvh_don_vi_nhan_tien.Text = v_us.strTTDVH_DON_VI_NHAN_TIEN; m_lbl_ttdvh_ma_dvqhns.Text = v_us.strTTDVH_MA_DVQHNS; m_lbl_ttdvh_dia_chi.Text = v_us.strTTDVH_DIA_CHI; m_lbl_ttdvh_tai_khoan.Text = v_us.strTTDVH_TAI_KHOAN; m_lbl_ttdvh_ma_ctmt_da_htct.Text = v_us.strTTDVH_MA_CTMT_DA_VA_HTCT; m_lbl_ttdvh_tai_kbnn.Text = v_us.strTTDVH_KHO_BAC; m_lbl_ttdvh_so_tien_thanh_toan_dvh.Text = IP.Core.IPCommon.CRead.ChuyenSo(v_dc_don_vi_huong.ToString()); }