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