public void FillDatasetWithProc(DataSet op_ds, string ip_str_table_name, string ip_str_column_name)
{
CStoredProc v_cstore = new CStoredProc("get_data_to_dataset_with_table_name_and_column_name");
v_cstore.addNVarcharInputParam("@TABLE_NAME", ip_str_table_name);
v_cstore.addNVarcharInputParam("@COLUMN_NAME", ip_str_column_name);
v_cstore.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetLogin(DataSet v_ds, string user,string pass, decimal id_chi_nhanh)
{
CStoredProc v_cstore = new CStoredProc("check_login");
v_cstore.addNVarcharInputParam("@user", user);
v_cstore.addNVarcharInputParam("@pass", pass);
v_cstore.addDecimalInputParam("@id_chi_nhanh", id_chi_nhanh);
v_cstore.fillDataSetByCommand(this, v_ds);
}
internal void FillDatasetCBO(DataSet op_ds, string ip_str_table_name, string ip_str_value_field, string ip_str_display_field, string ip_str_condition)
{
CStoredProc v_cstore = new CStoredProc("get_data_for_cbo");
v_cstore.addNVarcharInputParam("@TABLE_NAME", ip_str_table_name);
v_cstore.addNVarcharInputParam("@COLUMN_VALUE", ip_str_value_field);
v_cstore.addNVarcharInputParam("@COLUMN_DISPLAY", ip_str_display_field);
v_cstore.addNVarcharInputParam("@CONDITION", ip_str_condition);
v_cstore.fillDataSetByCommand(this, op_ds);
}
private void load_data_grid(string ip_str_tu_khoa)
{
DS_DM_DAT v_ds_dm_dat = new DS_DM_DAT();
if (ip_str_tu_khoa.Equals(String.Empty))
{
m_us_dm_dat.FillDataset(v_ds_dm_dat);
}
else
{
CStoredProc v_cstore = new CStoredProc("pr_DM_DAT_Search");
v_cstore.addNVarcharInputParam("@TU_KHOA", ip_str_tu_khoa);
v_cstore.fillDataSetByCommand(m_us_dm_dat, v_ds_dm_dat);
}
m_grv_danh_sach_nha.DataSource = v_ds_dm_dat.DM_DAT;
m_grv_danh_sach_nha.DataBind();
}
public static string ExecuteFuntionSql(string ip_str_funtion_name, params object[] parameters)
{
string v_str_select = "select dbo." + ip_str_funtion_name;
string v_str_param = "";
foreach(object item in parameters)
{
v_str_param = v_str_param + "'" + item.ToString()+ "'" + ",";
}
string v_query = v_str_select + "(" + v_str_param;
if(parameters.Length > 0)
{
v_query = v_query.Substring(0, v_query.LastIndexOf(","));
}
v_query = v_query + ")";
CStoredProc v_sp = new CStoredProc("pr_execute_funtion_sql");
v_sp.addNVarcharInputParam("@ip_str_query", v_query);
DataSet v_ds = new DataSet();
v_ds.Tables.Add();
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
v_sp.fillDataSetByCommand(v_us, v_ds);
return v_ds.Tables[0].Rows[0][0].ToString();
}
public void get_dm_uy_nhiem_chi_by_don_vi_va_ngay_thang(DS_DM_GIAI_NGAN op_ds
, decimal ip_dc_id_don_vi
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, string ip_nguon_ns)
{
CStoredProc v_sp = new CStoredProc("pr_get_dm_uy_nhiem_chi_by_don_vi_va_ngay_thang");
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_sp.addNVarcharInputParam("@ip_nguon_ns", ip_nguon_ns);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void FillData2DatasetGiaiNgan(
DataSet ip_ds,
DateTime ip_dat_tu_ngay,
DateTime ip_dat_den_ngay,
decimal ip_dc_id_don_vi,
decimal ip_dc_id_loai_nhiem_vu,
decimal ip_dc_id_cong_trinh,
decimal ip_dc_id_du_an,
string ip_str_tu_khoa,
string ip_str_nguon_ns,
decimal ip_dc_id_giai_ngan,
string ip_str_proc)
{
CStoredProc v_prc = new CStoredProc(ip_str_proc);
v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_prc.addDecimalInputParam("@ip_dc_id_loai_nhiem_vu", ip_dc_id_loai_nhiem_vu);
v_prc.addDecimalInputParam("@ip_dc_id_cong_trinh", ip_dc_id_cong_trinh);
v_prc.addDecimalInputParam("@ip_dc_id_du_an", ip_dc_id_du_an);
v_prc.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_prc.addNVarcharInputParam("@ip_nguon_ns", ip_str_nguon_ns);
v_prc.addDecimalInputParam("@ip_dc_id_giai_ngan", ip_dc_id_giai_ngan);
v_prc.fillDataSetByCommand(this, ip_ds);
}
public void fill_data_bo_loc(DS_V_HT_LOG_TRUY_CAP op_ds_ht_log_truy_cap
, string ip_str_username
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_hanh_dong)
{
CStoredProc v_cstore = new CStoredProc("pr_V_HT_LOG_TRUY_CAP_filter");
v_cstore.addNVarcharInputParam("@USERNAME", ip_str_username);
v_cstore.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay);
v_cstore.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay);
v_cstore.addDecimalInputParam("@ID_LOAI_HANH_DONG", ip_dc_id_hanh_dong);
v_cstore.fillDataSetByCommand(this, op_ds_ht_log_truy_cap);
}
public void FillDataset(
decimal ip_dc_bo_tinh
, decimal ip_dc_don_vi_chu_quan
, decimal ip_dc_don_vi_su_dung
, decimal ip_dc_id_loai_tai_san
, decimal ip_id_trang_thai
, string ip_str_tu_khoa
, string ip_str_user_name
, DS_V_DM_OTO op_ds_v_dm_oto)
{
CStoredProc v_obj_procedure = new CStoredProc("pr_V_DM_OTO_Search");
v_obj_procedure.addDecimalInputParam("@ip_id_bo_tinh", ip_dc_bo_tinh);
v_obj_procedure.addDecimalInputParam("@ip_id_dvql", ip_dc_don_vi_chu_quan);
v_obj_procedure.addDecimalInputParam("@ip_id_dvsd", ip_dc_don_vi_su_dung);
v_obj_procedure.addDecimalInputParam("@ip_id_loai_tai_san", ip_dc_id_loai_tai_san);
v_obj_procedure.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
v_obj_procedure.addDecimalInputParam("@ip_id_trang_thai", ip_id_trang_thai);
v_obj_procedure.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_obj_procedure.fillDataSetByCommand(this, op_ds_v_dm_oto);
}
internal void FillDatasetWithTableName(DataSet op_ds, string ip_str_table_name)
{
CStoredProc v_cstore = new CStoredProc("get_data_from_table");
v_cstore.addNVarcharInputParam("@TABLE_NAME", ip_str_table_name);
v_cstore.fillDataSetByCommand(this, op_ds);
}
public void FillDataset(
DS_DM_DON_VI op_ds_don_vi
, decimal ip_dc_id_loai_don_vi
, decimal ip_dc_id_don_vi_cap_tren1
, decimal ip_dc_id_don_vi_cap_tren2
, string ip_str_loai_hinh_don_vi
, string ip_str_user_name
)
{
CStoredProc v_obj_procedure = new CStoredProc("pr_DM_DON_VI_loai_hinh_don_vi_Select_by_user_name");
v_obj_procedure.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
v_obj_procedure.addDecimalInputParam("@ip_dc_loai_don_vi", ip_dc_id_loai_don_vi);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_dv_cap_tren1", ip_dc_id_don_vi_cap_tren1);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_dv_cap_tren2", ip_dc_id_don_vi_cap_tren2);
v_obj_procedure.addNVarcharInputParam("@ip_str_loai_hinh_don_vi", ip_str_loai_hinh_don_vi);
v_obj_procedure.fillDataSetByCommand(this, op_ds_don_vi);
}
public void thay_doi_trang_thai_lao_dong(decimal ip_dc_id_nhan_vien
, decimal ip_dc_id_trang_thai_chuyen
, DateTime ip_dat_ngay_lap
, string ip_str_nguoi_lap)
{
CStoredProc v_sp = new CStoredProc("pr_thay_doi_trang_thai_lao_dong");
v_sp.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
v_sp.addDecimalInputParam("@ip_dc_id_trang_thai_chuyen", ip_dc_id_trang_thai_chuyen);
v_sp.addDatetimeInputParam("@ip_dat_ngay_lap", ip_dat_ngay_lap);
v_sp.addNVarcharInputParam("@ip_str_nguoi_lap", ip_str_nguoi_lap);
v_sp.ExecuteCommand(this);
}
public void FillDataset(DS_V_RPT_410_BAO_CAO_TAI_CHINH_THEO_LOP_MON op_ds
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_lop_mon
, string ip_str_search)
{
CStoredProc v_obj_spr = new CStoredProc("f410_bao_cao_tai_chinh_theo_lop_mon");
v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
v_obj_spr.addDatetimeInputParam("@ip_dat_dau_thang", ip_dat_tu_ngay);
v_obj_spr.addDatetimeInputParam("@ip_dat_cuoi_thang", ip_dat_den_ngay);
v_obj_spr.addNVarcharInputParam("@ip_str_search", ip_str_search);
v_obj_spr.fillDataSetByCommand(this, op_ds);
}
public void search(string ip_str_tu_khoa, DS_DM_TAI_SAN_KHAC ip_ds_dm_tai_san_khac)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_TAI_SAN_KHAC_Search");
v_cstore.addNVarcharInputParam("@TU_KHOA", ip_str_tu_khoa);
v_cstore.fillDataSetByCommand(this, ip_ds_dm_tai_san_khac);
}
public bool check_ma_valid(string ip_str_ma_tai_san)
{
DS_DM_TAI_SAN_KHAC v_ds_dm_tai_san_khac = new DS_DM_TAI_SAN_KHAC();
CStoredProc v_cstore = new CStoredProc("pr_DM_TAI_SAN_KHAC_check_ma_tai_san_khac");
v_cstore.addNVarcharInputParam("@ip_str_ma_tai_san", ip_str_ma_tai_san);
v_cstore.fillDataSetByCommand(this, v_ds_dm_tai_san_khac);
if (v_ds_dm_tai_san_khac.DM_TAI_SAN_KHAC.Rows.Count == 0)
return true;
return false;
}
public void load_oto_by_ten(DS_V_DM_OTO op_ds_oto, string ip_str_search, decimal ip_dc_id_dv_su_dung)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_OTO_Search_by_Ten");
v_cstore.addNVarcharInputParam("@ip_str_ten_oto_search", ip_str_search);
v_cstore.addDecimalInputParam("@ip_dc_id_dv_su_dung", ip_dc_id_dv_su_dung);
v_cstore.fillDataSetByCommand(this, op_ds_oto);
}
public void FillDatasetLoadDataToGridOto_by_tu_khoa(
string ip_str_tu_khoa
, decimal ip_dc_id_bo_tinh
, decimal ip_dc_id_don_vi_chu_quan
, decimal ip_dc_id_don_vi_su_dung
, decimal ip_dc_id_trang_thai
, decimal ip_dc_id_loai_tai_san
, string ip_str_loai_hinh_don_vi
, string ip_str_user_name
, DS_V_DM_OTO op_ds_v_dm_oto)
{
CStoredProc v_obj_procedure = new CStoredProc("pr_V_DM_OTO_Load_data_to_grid_by_tu_khoa");
v_obj_procedure.addDecimalInputParam("@ip_dc_id_bo_tinh", ip_dc_id_bo_tinh);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_don_vi_chu_quan", ip_dc_id_don_vi_chu_quan);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_don_vi_su_dung", ip_dc_id_don_vi_su_dung);
v_obj_procedure.addNVarcharInputParam("@ip_str_loai_hinh_don_vi", ip_str_loai_hinh_don_vi);
v_obj_procedure.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_trang_thai", ip_dc_id_trang_thai);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_loai_tai_san", ip_dc_id_loai_tai_san);
v_obj_procedure.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_obj_procedure.fillDataSetByCommand(this, op_ds_v_dm_oto);
}
public bool check_is_having_ma_don_vi(string ip_str_ma_don_vi)
{
DS_DM_DON_VI v_ds_dm_don_vi = new DS_DM_DON_VI();
CStoredProc v_cstore = new CStoredProc("pr_DM_DON_VI_check_ma_don_vi");
v_cstore.addNVarcharInputParam("@ip_str_ma_don_vi", ip_str_ma_don_vi);
v_cstore.fillDataSetByCommand(this, v_ds_dm_don_vi);
if (v_ds_dm_don_vi.DM_DON_VI.Rows.Count == 0)
return false;
return true;
}
/// <summary>
///
/// </summary>
/// <param name="op_ds_don_vi"></param>
/// <param name="ip_dc_id_loai_don_vi"></param>
/// <param name="ip_dc_id_don_vi"></param>
/// <param name="ip_dc_id_don_vi_cap_tren1"></param>
/// <param name="ip_dc_id_don_vi_cap_tren2"></param>
/// <param name="ip_str_user_name"></param>
public void FillDataset(
WebDS.DS_DM_DON_VI op_ds_don_vi
, decimal ip_dc_id_loai_don_vi
, decimal ip_dc_id_don_vi_cap_tren1
, decimal ip_dc_id_don_vi_cap_tren2
, string ip_str_user_name)
{
CStoredProc cstored = new CStoredProc("pr_DM_DON_VI_Select_by_user_name");
cstored.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
cstored.addDecimalInputParam("@ip_dc_loai_don_vi", ip_dc_id_loai_don_vi);
cstored.addDecimalInputParam("@ip_dc_id_dv_cap_tren1", ip_dc_id_don_vi_cap_tren1);
cstored.addDecimalInputParam("@ip_dc_id_dv_cap_tren2", ip_dc_id_don_vi_cap_tren2);
cstored.fillDataSetByCommand(this, op_ds_don_vi);
}
public void FillDatasetGiaoKHByIdDonVi(DS_V_DM_QUYET_DINH_KH ip_ds, decimal ip_dc_id_don_vi, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, string ip_str_filter)
{
CStoredProc v_prc = new CStoredProc("pr_F190_danh_sach_quyet_dinh_giao_kh");
v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_prc.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_filter);
v_prc.fillDataSetByCommand(this, ip_ds);
}
public void FillDataSet_Load_data_to_grid_danh_muc_don_vi_by_key_word(
DS_DM_DON_VI op_ds_don_vi
, decimal v_dc_id_loai_don_vi
, string v_str_user_name
, string v_str_key_word)
{
CStoredProc cstored = new CStoredProc("pr_DM_DON_VI_Load_to_grid_danh_muc_by_key_word");
cstored.addDecimalInputParam("@ip_dc_loai_don_vi", v_dc_id_loai_don_vi);
cstored.addNVarcharInputParam("@ip_str_user_name", v_str_user_name);
cstored.addNVarcharInputParam("@ip_str_key_word", v_str_key_word);
cstored.fillDataSetByCommand(this, op_ds_don_vi);
}
internal void FillDatasetWithQuery(DataSet op_ds, string ip_query)
{
CStoredProc v_cstore = new CStoredProc("pr_fill_ds_with_query");
v_cstore.addNVarcharInputParam("@SQL_QUERY", ip_query);
v_cstore.fillDataSetByCommand(this, op_ds);
}
public void get_grid_giai_ngan(DS_GRID_GIAI_NGAN op_ds
, decimal ip_dc_id_don_vi
, decimal ip_dc_id_dm_uy_nhiem_chi
, decimal ip_dc_id_user
, string ip_str_is_nguon_ns)
{
CStoredProc v_sp = new CStoredProc("pr_F304_nhap_giai_ngan_theo_unc");
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_sp.addDecimalInputParam("@ip_dc_id_dm_uy_nhiem_chi", ip_dc_id_dm_uy_nhiem_chi);
v_sp.addDecimalInputParam("@ip_dc_id_user", ip_dc_id_user);
v_sp.addNVarcharInputParam("@ip_str_is_nguon_ns", ip_str_is_nguon_ns);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetSearch_hocvien_tuyenmoi(DS_V_GD_THONG_KE ip_m_ds, string ip_v_str_tim_kiem, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, decimal v_id_loai_dinh_muc)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_THONG_KE_Search_hocvien_tuyenmoi");
v_stored_proc.addNVarcharInputParam("@TU_KHOA", ip_v_str_tim_kiem);
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay);
v_stored_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", v_id_loai_dinh_muc);
v_stored_proc.fillDataSetByCommand(this, ip_m_ds);
}
internal void FillDatasetSQLInjection(DataSet v_ds, string p)
{
CStoredProc v_cstore = new CStoredProc("sqlInjection");
v_cstore.addNVarcharInputParam("@str_query", p);
v_cstore.fillDataSetByCommand(this, v_ds);
}
public void get_grid_giay_rut_du_toan(DataSet op_ds
, decimal ip_dc_id_don_vi
, decimal ip_dc_id_dm_uy_nhiem_chi
, decimal ip_dc_id_user
, string ip_str_is_nguon_ns)
{
CStoredProc v_sp = new CStoredProc("pr_F305_giay_rut_du_toan_ngan_sach");
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_sp.addDecimalInputParam("@ip_dc_id_dm_uy_nhiem_chi", ip_dc_id_dm_uy_nhiem_chi);
v_sp.addDecimalInputParam("@ip_dc_id_user", ip_dc_id_user);
v_sp.addNVarcharInputParam("@ip_str_is_nguon_ns", ip_str_is_nguon_ns);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void bc_tra_cuu_giao_von_theo_du_an(DataSet ip_ds, decimal ip_dc_id_cong_trinh_du_an, string ip_str_ten_du_an, decimal ip_dc_id_don_vi, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_prc = new CStoredProc("pr_bao_cao_tra_cuu_giao_von_theo_du_an");
v_prc.addDecimalInputParam("@ip_dc_id_du_an_cong_trinh", ip_dc_id_cong_trinh_du_an);
v_prc.addNVarcharInputParam("@ip_str_ten_du_an", ip_str_ten_du_an);
v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_prc.fillDataSetByCommand(this, ip_ds);
}
public DataTable LayDanhSachHeSoLNS(string ip_str_filter, decimal ip_dc_thang, decimal ip_dc_nam)
{
CStoredProc v_cstore = new CStoredProc("pr_LNS_danh_sach_he_so_lns_GetAll");
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_cstore.addNVarcharInputParam("@ip_str_option", ip_str_filter);
v_cstore.addDecimalInputParam("@thang", ip_dc_thang);
v_cstore.addDecimalInputParam("@nam", ip_dc_nam);
v_cstore.fillDataSetByCommand(this, v_ds);
return v_ds.Tables[0];
}
public void update_cau_hoi_cu()
{
CStoredProc v_cstore = new CStoredProc("pr_GD_CAU_HOI_HOC_VIEN_Update_cau_hoi_cu");
v_cstore.addDecimalInputParam("@ID", this.dcID);
v_cstore.addDecimalInputParam("@ID_TRANG_THAI", this.dcID_TRANG_THAI);
v_cstore.addDecimalInputParam("@ID_DANH_GIA", this.dcID_DANH_GIA);
v_cstore.addNVarcharInputParam("@GHI_CHU_Y_KIEN_KHAC", this.strGHI_CHU_Y_KIEN_KHAC);
v_cstore.ExecuteCommand(this);
}
public void bc_giao_von_quy_bao_tri_theo_qd(DataSet ip_ds
, decimal ip_id_don_vi
, decimal ip_dc_id_loai_nhiem_vu
, decimal ip_dc_id_cong_trinh
, decimal ip_dc_id_du_an
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, string ip_str_tu_khoa
, string ip_nguon_ns)
{
CStoredProc v_prc = new CStoredProc("pr_A256_giao_von_theo_quyet_dinh");
v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_id_don_vi);
v_prc.addDecimalInputParam("@ip_dc_id_du_an", ip_dc_id_du_an);
v_prc.addDecimalInputParam("@ip_dc_id_cong_trinh", ip_dc_id_cong_trinh);
v_prc.addDecimalInputParam("@ip_dc_id_loai_nhiem_vu", ip_dc_id_loai_nhiem_vu);
v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_prc.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_prc.addNVarcharInputParam("@ip_nguon_ns", ip_nguon_ns);
v_prc.fillDataSetByCommand(this, ip_ds);
}