Exemplo n.º 1
0
    private void load_data_2_grid_search_trang_thai(string ip_str_ma_dot_tt, decimal ip_dc_id_trang_thai_tt)
    {
        // ip_dc_id_trang_thai_tt = 0, =1 hay =2, tức là tất cả, hay đã duyệt hay chưa duyệt
        // Số phiếu thanh toán là mã đợt thanh toán
        if (ip_dc_id_trang_thai_tt == 0)
        {
            load_data_2_grid(ip_str_ma_dot_tt);
        }
        else
        {
            if (ip_dc_id_trang_thai_tt == 1)
            {
                m_us_v_gd_thanh_toan.f412_load_thanh_toan_by_ma_dot_tt_va_trang_thai_tt_va_loai_hd(ip_str_ma_dot_tt, ID_TRANG_THAI_THANH_TOAN.CHUNG_TU_DA_DUOC_DUYET, "HL", m_v_ds_gd_thanh_toan, CIPConvert.ToStr(Session["UserName"]));
            }
            //m_us_v_gd_thanh_toan.FillDataset(m_v_ds_gd_thanh_toan, " WHERE SO_PHIEU_THANH_TOAN = '" + ip_str_ma_dot_tt + "' AND ID_TRANG_THAI_THANH_TOAN=" + get_id_trang_thai_da_duyet() + " AND LOAI_HOP_DONG='HL' ORDER BY ID");
            else
            {
                m_us_v_gd_thanh_toan.f412_load_thanh_toan_by_ma_dot_tt_va_trang_thai_tt_va_loai_hd(ip_str_ma_dot_tt, ID_TRANG_THAI_THANH_TOAN.CHUNG_TU_KHONG_DUOC_DUYET, "HL", m_v_ds_gd_thanh_toan, CIPConvert.ToStr(Session["UserName"]));
            }
            //m_us_v_gd_thanh_toan.FillDataset(m_v_ds_gd_thanh_toan, " WHERE SO_PHIEU_THANH_TOAN = '" + ip_str_ma_dot_tt + "' AND ID_TRANG_THAI_THANH_TOAN=" + get_id_trang_thai_chua_duyet() + " AND LOAI_HOP_DONG='HL' ORDER BY ID");

            if (m_v_ds_gd_thanh_toan.V_GD_THANH_TOAN.Rows.Count == 0)
            {
                m_lbl_thong_bao.Visible = true;
                m_lbl_thong_bao.Text    = "Không có Thanh toán nào phù hợp";
            }
            m_grv_danh_sach_du_toan.DataSource = m_v_ds_gd_thanh_toan.V_GD_THANH_TOAN;
            m_grv_danh_sach_du_toan.DataBind();
            m_lbl_danh_sach_thanh_toan.Text = "Danh sách Thanh toán: " + m_v_ds_gd_thanh_toan.V_GD_THANH_TOAN.Rows.Count + " thanh toán";
        }
    }