private void load_data_2_grid_search(string ip_str_ma_dot_tt, string ip_str_so_hd) { US_V_GD_THANH_TOAN v_us_gd_thanh_toan = new US_V_GD_THANH_TOAN(); DS_V_GD_THANH_TOAN v_ds_gd_thanh_toan = new DS_V_GD_THANH_TOAN(); //decimal v_dc_id_hdong = get_id_by_so_hop_dong(ip_str_so_hd); //if (v_dc_id_hdong == 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.Visible = false; // return; //} v_us_gd_thanh_toan.f403_load_thanh_toan_by_ma_dot_tt_va_trang_thai_tt_va_like_so_hd(ip_str_ma_dot_tt, CIPConvert.ToDecimal(lblUser.ToolTip), ip_str_so_hd, v_ds_gd_thanh_toan, CIPConvert.ToStr(Session["UserName"])); //v_us_gd_thanh_toan.FillDataset(v_ds_gd_thanh_toan, " WHERE SO_PHIEU_THANH_TOAN = '" + ip_str_ma_dot_tt + "' AND SO_HOP_DONG LIKE N'%" + ip_str_so_hd + "%' AND ID_TRANG_THAI_THANH_TOAN = " + CIPConvert.ToDecimal(lblUser.ToolTip) + " ORDER BY ID"); if (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_grv_danh_sach_du_toan.Visible = true; } m_grv_danh_sach_du_toan.DataSource = v_ds_gd_thanh_toan.V_GD_THANH_TOAN; m_grv_danh_sach_du_toan.DataBind(); lbl_danh_sach_chung_tu.Text = "Danh sách các chứng từ: " + v_ds_gd_thanh_toan.V_GD_THANH_TOAN.Rows.Count + " chứng từ"; }
private void load_data_2_grid_search(string ip_str_ma_dot_tt, string ip_str_so_hd, decimal ip_dc_id_trang_thai_tt) { US_V_GD_THANH_TOAN v_us_gd_thanh_toan = new US_V_GD_THANH_TOAN(); DS_V_GD_THANH_TOAN v_ds_gd_thanh_toan = new DS_V_GD_THANH_TOAN(); v_us_gd_thanh_toan.f403_load_thanh_toan_by_ma_dot_tt_va_trang_thai_tt_va_like_so_hd(ip_str_ma_dot_tt, ip_dc_id_trang_thai_tt, m_txt_so_hd_search.Text.Trim(), v_ds_gd_thanh_toan, CIPConvert.ToStr(Session["UserName"])); //v_us_gd_thanh_toan.FillDataset(v_ds_gd_thanh_toan, " WHERE SO_PHIEU_THANH_TOAN = '" + ip_str_ma_dot_tt + "' AND SO_HOP_DONG like N'%" + m_txt_so_hd_search.Text.Trim()+"%' AND ID_TRANG_THAI_THANH_TOAN = " + ip_dc_id_trang_thai_tt); if (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.Visible = true; m_grv_danh_sach_du_toan.DataSource = v_ds_gd_thanh_toan.V_GD_THANH_TOAN; m_grv_danh_sach_du_toan.DataBind(); m_lbl_danh_sach_chung_tu_ton_dong.Text = "Danh sách các chứng từ tồn đọng: " + v_ds_gd_thanh_toan.V_GD_THANH_TOAN.Rows.Count + " chứng từ"; }
private void load_data_2_grid_search(string ip_str_ma_dot_tt, string ip_str_so_hd) { US_V_GD_THANH_TOAN v_us_gd_thanh_toan = new US_V_GD_THANH_TOAN(); DS_V_GD_THANH_TOAN v_ds_gd_thanh_toan = new DS_V_GD_THANH_TOAN(); v_us_gd_thanh_toan.f403_load_thanh_toan_by_ma_dot_tt_va_trang_thai_tt_va_like_so_hd(ip_str_ma_dot_tt, 0, ip_str_so_hd, v_ds_gd_thanh_toan, CIPConvert.ToStr(Session["UserName"])); if (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_grv_danh_sach_du_toan.Visible = true; m_lbl_danh_sach_thanh_toan.Text = "Danh sách thanh toán: " + v_ds_gd_thanh_toan.V_GD_THANH_TOAN.Rows.Count + " thanh toán"; } m_grv_danh_sach_du_toan.DataSource = v_ds_gd_thanh_toan.V_GD_THANH_TOAN; m_grv_danh_sach_du_toan.DataBind(); }