private void load_data_2_excel_search(decimal ip_dc_id_dot_tt)
{
string v_str_ma_dot_tt = "";
if (ip_dc_id_dot_tt == 0)
{
v_str_ma_dot_tt = "All";
}
else
{
v_str_ma_dot_tt = get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue));
}
m_v_ds_gd_thanh_toan.Clear();
if (m_rdl_loai_hop_dong.Items[0].Selected)
// All
{
m_str_loai_hd = "All";
}
else if (m_rdl_loai_hop_dong.Items[1].Selected)
// Vận hành
{
m_str_loai_hd = "VH";
}
// Học liệu
else
{
m_str_loai_hd = "HL";
}
m_us_v_gd_thanh_toan.fill_dataset_by_dot_tt_va_loai_hd(v_str_ma_dot_tt, m_str_loai_hd,
CIPConvert.ToDecimal(m_cbo_thang_thanh_toan.SelectedValue),
CIPConvert.ToDecimal(m_cbo_nam_thanh_toan.SelectedValue),
CIPConvert.ToDecimal(m_cbo_don_vi_thanh_toan.SelectedValue),
m_v_ds_gd_thanh_toan
, CIPConvert.ToStr(Session["UserName"]));
}
private void load_data_2_excel_search(decimal ip_dc_id_giang_vien
, decimal ip_dc_dv_thanh_toan
, decimal ip_dc_trang_thai_tt
, string ip_str_reference_code
, decimal ip_dc_thang_tt
, decimal ip_dc_nam_tt)
{
//string v_str_ma_dot_tt = "";
//if (ip_dc_id_dot_tt == 0) v_str_ma_dot_tt = "All";
//else v_str_ma_dot_tt = get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue));
m_v_ds_gd_thanh_toan.Clear();
if (m_rdl_loai_hop_dong.Items[0].Selected)
// All
{
m_str_loai_hd = "All";
}
else if (m_rdl_loai_hop_dong.Items[1].Selected)
// Vận hành
{
m_str_loai_hd = "VH";
}
// Học liệu
else
{
m_str_loai_hd = "HL";
}
m_us_v_gd_thanh_toan.fill_dataset_by_giang_vien_va_dv_thanh_toan(ip_dc_id_giang_vien,
ip_dc_dv_thanh_toan,
ip_dc_trang_thai_tt,
ip_str_reference_code,
m_str_loai_hd,
ip_dc_thang_tt,
ip_dc_nam_tt,
m_v_ds_gd_thanh_toan, CIPConvert.ToStr(Session["UserName"]));
}
private void load_data_2_grid_search(decimal ip_dc_thang_tt, decimal ip_dc_nam_tt)
{
string v_str_po_phu_trach = "";
//if (ip_dc_id_dot_tt == 0) v_str_ma_dot_tt = "All";
v_str_po_phu_trach = get_ten_truy_nhap_by_id(CIPConvert.ToDecimal(m_cbo_po_lap_bang_ke.SelectedValue));
m_v_ds_gd_thanh_toan.Clear();
if (m_rdl_loai_hop_dong.Items[0].Selected)
// All
{
m_str_loai_hd = "All";
}
else if (m_rdl_loai_hop_dong.Items[1].Selected)
// Vận hành
{
m_str_loai_hd = "VH";
}
// Học liệu
else
{
m_str_loai_hd = "HL";
}
m_us_v_gd_thanh_toan.fill_dataset_by_po_phu_trach_va_thoi_gian(v_str_po_phu_trach, m_str_loai_hd, ip_dc_thang_tt, ip_dc_nam_tt, m_v_ds_gd_thanh_toan);
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";
}
else
{
m_lbl_thong_bao.Text = "";
}
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";
}
private void load_data_2_excel_search(string ip_str_so_hd)
{
//string v_str_ma_dot_tt = "";
//if (ip_dc_id_dot_tt == 0) v_str_ma_dot_tt = "All";
//else v_str_ma_dot_tt = get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue));
m_v_ds_gd_thanh_toan.Clear();
if (m_rdl_loai_hop_dong.Items[0].Selected)
// All
{
m_str_loai_hd = "All";
}
else if (m_rdl_loai_hop_dong.Items[1].Selected)
// Vận hành
{
m_str_loai_hd = "VH";
}
// Học liệu
else
{
m_str_loai_hd = "HL";
}
m_us_v_gd_thanh_toan.fill_dataset_by_so_hop_dong(m_str_loai_hd, ip_str_so_hd, m_v_ds_gd_thanh_toan, CIPConvert.ToStr(Session["UserName"]));
}