public void fill_data_by_search(decimal i_dc_id_mon_hoc , string i_str_online_yn , string i_str_offline_yn , string i_str_bt_gky_yn , string i_str_key_word , string i_str_bat_dau_tu , string i_str_bat_dau_den , string i_str_ket_thuc_tu , string i_str_ket_thuc_den , string i_str_thi_tu , string i_str_thi_den , DS_GD_LOP_MON i_ds) { try { CStoredProc v_object = new CStoredProc("pr_GD_LOP_MON_Fill_By_Search"); v_object.addDecimalInputParam("@ip_id_mon_hoc", i_dc_id_mon_hoc); v_object.addNVarcharInputParam("@ip_online_yn", i_str_online_yn); v_object.addNVarcharInputParam("@ip_offline_yn", i_str_offline_yn); v_object.addNVarcharInputParam("@ip_bt_gky_yn", i_str_bt_gky_yn); v_object.addNVarcharInputParam("@ip_key_word", i_str_key_word); v_object.addDatetimeInputParam("@ip_ngay_bat_dau_tu", CIPConvert.ToDatetime(i_str_bat_dau_tu, "dd/MM/yyyy")); v_object.addDatetimeInputParam("@ip_ngay_bat_dau_den", CIPConvert.ToDatetime(i_str_bat_dau_den, "dd/MM/yyyy")); v_object.addDatetimeInputParam("@ip_ngay_ket_thuc_tu", CIPConvert.ToDatetime(i_str_ket_thuc_tu, "dd/MM/yyyy")); v_object.addDatetimeInputParam("@ip_ngay_ket_thuc_den", CIPConvert.ToDatetime(i_str_ket_thuc_den, "dd/MM/yyyy")); v_object.addDatetimeInputParam("@ip_ngay_thi_tu", CIPConvert.ToDatetime(i_str_thi_tu, "dd/MM/yyyy")); v_object.addDatetimeInputParam("@ip_ngay_thi_den", CIPConvert.ToDatetime(i_str_thi_den, "dd/MM/yyyy")); v_object.fillDataSetByCommand(this, i_ds); } catch (Exception v_e) { throw v_e; } }
public void FillDatasetSearch(DS_V_GD_LUONG_THEO_QD op_ds, decimal ip_dc_id_phap_nhan, string ip_str_keyword, bool ip_bool_luong_hien_tai, decimal ip_dc_id_ky, decimal ip_dc_id_loai_luong, DateTime ip_dat_tu_ngay_ap_dung, DateTime ip_dat_den_ngay_ap_dung) { CStoredProc v_sp = new CStoredProc("pr_V_GD_LUONG_THEO_QD_Search"); v_sp.addDecimalInputParam("@ip_dc_id_phap_nhan", ip_dc_id_phap_nhan); v_sp.addNVarcharInputParam("@ip_str_keyword", ip_str_keyword); v_sp.addNVarcharInputParam("@ip_str_luong_hien_tai", ip_bool_luong_hien_tai ? "Y" : "N"); v_sp.addDecimalInputParam("@ip_dc_id_ky", ip_dc_id_ky); v_sp.addDecimalInputParam("@ip_dc_id_loai_luong", ip_dc_id_loai_luong); DateTime v_dat; // Chuyển thời gian về đầu ngày v_dat = new DateTime(ip_dat_tu_ngay_ap_dung.Year, ip_dat_tu_ngay_ap_dung.Month, ip_dat_tu_ngay_ap_dung.Day, 0, 0, 0); v_sp.addDatetimeInputParam("@ip_dat_tu_ngay_ap_dung", v_dat); // Chuyển thời gian về cuối ngày v_dat = new DateTime(ip_dat_den_ngay_ap_dung.Year, ip_dat_den_ngay_ap_dung.Month, ip_dat_den_ngay_ap_dung.Day, 23, 59, 59); v_sp.addDatetimeInputParam("@ip_dat_den_ngay_ap_dung", v_dat); v_sp.fillDataSetByCommand(this, op_ds); }
public void load_ds_don_hang(DateTime ip_dat_tu_ngay , DateTime ip_dat_den_ngay , string ip_str_ma_don_hang , string ip_str_user_dat_hang , decimal ip_dc_id_thoi_han_hoan_thanh , decimal ip_dc_id_trang_thai_don_hang , decimal ip_dc_id_nguoi_dung , string ip_str_da_danh_gia_yn , decimal ip_dc_id_nguoi_tiep_nhan , decimal ip_dc_id_nguoi_xu_ly , decimal ip_dc_id_loai_yeu_cau , decimal ip_dc_id_danh_gia_tu_khach_hang , DateTime ip_dat_hoan_thanh_tu_ngay , DateTime ip_dat_hoan_thanh_den_ngay , DS_V_GD_DAT_HANG op_ds) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_DAT_HANG_load_ds_don_hang_v30"); v_cstore.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay); v_cstore.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay); v_cstore.addNVarcharInputParam("@MA_DON_HANG", ip_str_ma_don_hang); v_cstore.addNVarcharInputParam("@USER_DAT_HANG", ip_str_user_dat_hang); v_cstore.addDecimalInputParam("@ID_THOI_HAN", ip_dc_id_thoi_han_hoan_thanh); v_cstore.addDecimalInputParam("@ID_TRANG_THAI", ip_dc_id_trang_thai_don_hang); v_cstore.addDecimalInputParam("@ID_USER", ip_dc_id_nguoi_dung); v_cstore.addDecimalInputParam("@ID_NGUOI_XU_LY", ip_dc_id_nguoi_xu_ly); v_cstore.addDecimalInputParam("@ID_NGUOI_TIEP_NHAN", ip_dc_id_nguoi_tiep_nhan); v_cstore.addDecimalInputParam("@ID_LOAI_YEU_CAU", ip_dc_id_loai_yeu_cau); v_cstore.addDecimalInputParam("@ID_DANH_GIA_TU_KHACH_HANG", ip_dc_id_danh_gia_tu_khach_hang); v_cstore.addNVarcharInputParam("@DA_DANH_GIA_YN", ip_str_da_danh_gia_yn); v_cstore.addDatetimeInputParam("@HOAN_THANH_TU_NGAY", ip_dat_hoan_thanh_tu_ngay); v_cstore.addDatetimeInputParam("@HOAN_THANH_DEN_NGAY", ip_dat_hoan_thanh_den_ngay); v_cstore.fillDataSetByCommand(this, op_ds); }
public void change_pass_word() { CStoredProc v_cstore = new CStoredProc("pr_HT_NGUOI_SU_DUNG_Change_Password"); v_cstore.addNVarcharInputParam("@v_str_mat_khau_moi", this.strMAT_KHAU); v_cstore.addNVarcharInputParam("@v_str_ten_dang_nhap", this.strTEN_TRUY_CAP); v_cstore.ExecuteCommand(this); }
/// <summary> /// FillDataset dùng cho việc load combobox loại quyết định /// </summary> /// <param name="v_op_ds">Output Dataset</param> /// <param name="i_str_loai">Có các loại: Chức vụ, Trạng thái, Lương, Tất cả</param> /// <param name="i_str_mien_nhiem_yn">"Y" hoặc "N": Dùng kèm với loại "Chức vụ"</param> public void FillDataset_load_loai_quyet_dinh(DS_CM_DM_TU_DIEN v_op_ds, string i_str_loai, string i_str_mien_nhiem_yn) { CStoredProc v_sp = new CStoredProc("pr_CM_DM_TU_DIEN_Load_loai_quyet_dinh"); v_sp.addNVarcharInputParam("@LOAI", i_str_loai); v_sp.addNVarcharInputParam("@MIEN_NHIEM_YN", i_str_mien_nhiem_yn); v_sp.fillDataSetByCommand(this, v_op_ds); }
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) { CStoredProc v_cstore = new CStoredProc("pr_check_login"); v_cstore.addNVarcharInputParam("@v_str_ma_sinh_vien", user); v_cstore.addNVarcharInputParam("@v_str_mat_khau", pass); v_cstore.fillDataSetByCommand(this, v_ds); }
public void check_trung_giang_vien_dvtt(DS_GD_HO_SO_GV_DETAIL ip_ds_gd_hs_gv_detail, decimal ip_id_ho_so, string ip_str_loai_ho_so) { CStoredProc v_cstore = new CStoredProc("pr_GD_HO_SO_GV_DETAIL_check_trung"); v_cstore.addNVarcharInputParam("@id_ho_so", ip_id_ho_so); v_cstore.addNVarcharInputParam("@loai_ho_so", ip_str_loai_ho_so); v_cstore.fillDataSetByCommand(this, ip_ds_gd_hs_gv_detail); }
public void check_trung_ma_du_an(DS_DM_HO_SO_GIANG_VIEN ip_ds_dm_hs_gv, decimal ip_id_giang_vien, decimal ip_id_dv_tt) { CStoredProc v_cstore = new CStoredProc("pr_DM_HO_SO_GIANG_VIEN_check_trung"); v_cstore.addNVarcharInputParam("@id_giang_vien", ip_id_giang_vien); v_cstore.addNVarcharInputParam("@id_don_vi_thanh_toan", ip_id_dv_tt); v_cstore.fillDataSetByCommand(this, ip_ds_dm_hs_gv); }
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); }
public void load_dat_hang_by_ma(string ip_str_ma_dat_hang , string ip_str_username , DS_V_GD_DAT_HANG op_ds) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_DAT_HANG_load_dat_hang_by_ma"); v_cstore.addNVarcharInputParam("@MA_DAT_HANG", ip_str_ma_dat_hang); v_cstore.addNVarcharInputParam("@USERNAME", ip_str_username); v_cstore.fillDataSetByCommand(this, op_ds); }
// LinhDH 09/05/2012 public void f501_load_thanh_toan_by_ma_dot_tt_va_trang_thai_tt(string ip_str_ma_dot_tt, decimal ip_dc_trang_thai_tt, DS_V_GD_THANH_TOAN op_ds_v_gd_thanh_toan, string ip_str_po) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_GetThanhToanByDotThanhToan_TrangThaiTT_va_loai_hd"); v_cstore.addNVarcharInputParam("@MA_DOT_TT", ip_str_ma_dot_tt); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_TT", ip_dc_trang_thai_tt); v_cstore.addNVarcharInputParam("@LOAI_HOP_DONG", ""); v_cstore.addNVarcharInputParam("@USER_NAME", ip_str_po); v_cstore.fillDataSetByCommand(this, op_ds_v_gd_thanh_toan); }
public void loc_du_lieu_gv_cong_viec_moi(DS_GD_GV_CONG_VIEC_MOI op_ds_gd_cv_moi, string ip_str_ma_du_an, decimal ip_dc_cong_viec, decimal ip_dc_trang_thai, string ip_str_tu_khoa) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_GV_CONG_VIEC_MOI_Search"); v_cstore.addNVarcharInputParam("@SO_HOP_DONG", ip_str_ma_du_an); v_cstore.addDecimalInputParam("@ID_CONG_VIEC", ip_dc_cong_viec); v_cstore.addDecimalInputParam("@ID_TRANG_THAI", ip_dc_trang_thai); v_cstore.addNVarcharInputParam("@TU_KHOA", ip_str_tu_khoa); v_cstore.fillDataSetByCommand(this, op_ds_gd_cv_moi); }
public void chinh_sua_chung_tu() { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Chinh_Sua_Chung_Tu"); v_cstore.addDecimalInputParam("@ID", this.dcID); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_THANH_TOAN", this.dcID_TRANG_THAI_THANH_TOAN); v_cstore.addNVarcharInputParam("@SO_PHIEU_THANH_TOAN", this.strSO_PHIEU_THANH_TOAN); v_cstore.addNVarcharInputParam("@DESCRIPTION", this.strDESCRIPTION); v_cstore.ExecuteCommand(this); }
public 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); }
public void xu_ly_xac_nhan_ngan_hang() { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Xac_Nhan_NganHang"); v_cstore.addDecimalInputParam("@ID", this.dcID); v_cstore.addNVarcharInputParam("@MA_DOT_TT_CU", this.strSO_PHIEU_THANH_TOAN); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_DOT_TT", this.dcID_TRANG_THAI_THANH_TOAN); v_cstore.addNVarcharInputParam("@DESCRIPTION", this.strDESCRIPTION); v_cstore.ExecuteCommand(this); }
public void readd_black_list() { CStoredProc v_cstore = new CStoredProc("pr_V_DM_BLACK_LIST_ReAdd_Black_List"); v_cstore.addDecimalInputParam("@ID_NGUOI_DUNG", this.dcID_NGUOI_ADD); v_cstore.addNVarcharInputParam("@DIEN_THOAI", this.strSO_DIEN_THOAI); v_cstore.addNVarcharInputParam("@GHI_CHU_LY_DO", this.strGHI_CHU_LY_DO); v_cstore.addNVarcharInputParam("@HO_TEN_CHU_DIEN_THOAI", this.strHO_TEN_CHU_DIEN_THOAI); v_cstore.ExecuteCommand(this); }
public void them_cau_tra_loi() { CStoredProc v_cstore = new CStoredProc("pr_V_DM_CAU_HOI_Them_Cau_Tra_Loi"); v_cstore.addDecimalInputParam("@ID_CAU_HOI", this.dcID); v_cstore.addDecimalInputParam("@NGUOI_TAO", this.dcNGUOI_TAO); v_cstore.addNVarcharInputParam("@CAU_TRA_LOI", this.strCAU_TRA_LOI); v_cstore.addDatetimeInputParam("@NGAY_TAO", this.datNGAY_TAO); v_cstore.addNVarcharInputParam("@LINK_TAI_LIEU", this.strLINK_TL_THAM_KHAO); v_cstore.ExecuteCommand(this); }
public void fill_dataset_by_so_hop_dong(string ip_str_loai_hop_dong, string ip_str_so_hop_dong, DS_V_GD_THANH_TOAN ip_ds_gd_thanh_toan, string ip_str_po) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_GetThanhToanBySoHopDong"); v_cstore.addNVarcharInputParam("@LOAI_HOP_DONG", ip_str_loai_hop_dong); v_cstore.addNVarcharInputParam("@SO_HOP_DONG", ip_str_so_hop_dong); v_cstore.addNVarcharInputParam("@USER_NAME", ip_str_po); v_cstore.fillDataSetByCommand(this, ip_ds_gd_thanh_toan); }
public void FillDatasetByKeyWord(DS_V_DM_DON_VI op_ds_v_v_dm_don_vi, string ip_str_key_word, decimal ip_dc_loaidv, decimal ip_dc_capdv, string ip_str_trangthai, decimal ip_dc_phannhan) { CStoredProc v_stored_proc = new CStoredProc("pr_V_DM_DON_VI_search"); v_stored_proc.addNVarcharInputParam("@ip_str_search", ip_str_key_word); v_stored_proc.addDecimalInputParam("@ip_dc_loai_dv", ip_dc_loaidv); v_stored_proc.addDecimalInputParam("@ip_dc_cap_dv", ip_dc_capdv); v_stored_proc.addNVarcharInputParam("@ip_str_trang_thai", ip_str_trangthai); v_stored_proc.addDecimalInputParam("@ip_dc_phap_nhan", ip_dc_phannhan); v_stored_proc.fillDataSetByCommand(this, op_ds_v_v_dm_don_vi); }
public void xu_ly_thanh_toan_chua_duoc_thanh_toan() { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Xu_Ly_Chung_Tu_Chua_Duoc_Thanh_Toan"); v_cstore.addDecimalInputParam("@ID", this.dcID); v_cstore.addNVarcharInputParam("@MA_DOT_TT_MOI", this.strSO_PHIEU_THANH_TOAN); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_DOT_TT", this.dcID_TRANG_THAI_THANH_TOAN); v_cstore.addNVarcharInputParam("@DESCRIPTION", this.strDESCRIPTION); v_cstore.addDatetimeInputParam("@NGAY_THANH_TOAN_TUONG_UNG", this.datNGAY_THANH_TOAN); v_cstore.ExecuteCommand(this); }
public void FillDatasetFillFullTreeChucNang( string ip_str_hien_thi_yn , decimal ip_dc_user_group , string ip_str_having_quyen_yn , DS_HT_CHUC_NANG op_ds_ht_chuc_nang) { CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_select_full_tree_chuc_nang"); v_cstore.addNVarcharInputParam("@ip_str_hien_thi_yn", ip_str_hien_thi_yn); v_cstore.addDecimalInputParam("@ip_id_user_group", ip_dc_user_group); v_cstore.addNVarcharInputParam("@ip_str_having_quyen_yn", ip_str_having_quyen_yn); v_cstore.fillDataSetByCommand(this, op_ds_ht_chuc_nang); }
// LinhDH 10/08/2012 public void f410_load_data_2_grid(string ip_str_ma_dot_tt, decimal ip_dc_trang_thai_tt1, decimal ip_dc_trang_thai_tt2, DS_V_GD_THANH_TOAN op_ds_v_gd_thanh_toan, string ip_str_po) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_410_load_data_2_grid"); v_cstore.addNVarcharInputParam("@MA_DOT_TT", ip_str_ma_dot_tt); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_TT1", ip_dc_trang_thai_tt1); v_cstore.addNVarcharInputParam("@ID_TRANG_THAI_TT2", ip_dc_trang_thai_tt2); v_cstore.addNVarcharInputParam("@USER_NAME", ip_str_po); v_cstore.fillDataSetByCommand(this, op_ds_v_gd_thanh_toan); }
public void cap_nhat_don_hang() { CStoredProc v_cstore = new CStoredProc("pr_V_GD_DAT_HANG_cap_nhat_don_hang"); v_cstore.addDecimalInputParam("@ID_DON_HANG", this.dcID); v_cstore.addDecimalInputParam("@ID_TRANG_THAI", this.dcID_TRANG_THAI); v_cstore.addNVarcharInputParam("@PHAN_HOI_TU_DVMC", this.strPHAN_HOI_TU_DVMC); v_cstore.addDecimalInputParam("@ID_LOAI_THOI_GIAN_CAN_HOAN_THANH", this.dcID_LOAI_THOI_GIAN_CAN_HOAN_THANH); v_cstore.addNVarcharInputParam("@LICH_SU_TRAO_DOI", this.strLICH_SU_TRAO_DOI); v_cstore.addDecimalInputParam("@ID_NGUOI_SUA_CUOI", this.dcID_NGUOI_SUA_CUOI); v_cstore.addNVarcharInputParam("@USER_NGUOI_XU_LY", this.strNGUOI_XU_LY); v_cstore.ExecuteCommand(this); }
public void fill_dataset_by_po_phu_trach_va_thoi_gian(string ip_str_po_phu_trach, string ip_str_loai_hop_dong, decimal ip_dc_thang_tt, decimal ip_dc_nam_tt, DS_V_GD_THANH_TOAN ip_ds_gd_thanh_toan) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_GetThanhToanByPOPhuTrachvaThoiGian"); v_cstore.addNVarcharInputParam("@PO_PHU_TRACH", ip_str_po_phu_trach); v_cstore.addDecimalInputParam("@THANG_TT", ip_dc_thang_tt); v_cstore.addDecimalInputParam("@NAM_TT", ip_dc_nam_tt); v_cstore.addNVarcharInputParam("@LOAI_HOP_DONG", ip_str_loai_hop_dong); v_cstore.fillDataSetByCommand(this, ip_ds_gd_thanh_toan); }
public void fill_dataset_by_dot_tt_va_loai_hd(string ip_str_ma_dot, string ip_str_loai_hd, decimal ip_dc_thang_tt, decimal ip_dc_nam_tt, decimal ip_dc_dv_thanh_toan, DS_V_GD_THANH_TOAN ip_ds_gd_thanh_toan, string ip_str_po) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_GetThanhToanByDotAndLoaiHD"); v_cstore.addNVarcharInputParam("@MA_DOT_TT", ip_str_ma_dot); v_cstore.addNVarcharInputParam("@LOAI_HOP_DONG", ip_str_loai_hd); v_cstore.addDecimalInputParam("@THANG_TT", ip_dc_thang_tt); v_cstore.addDecimalInputParam("@NAM_TT", ip_dc_nam_tt); v_cstore.addDecimalInputParam("@ID_DON_VI_TT", ip_dc_dv_thanh_toan); v_cstore.addNVarcharInputParam("@USER_NAME", ip_str_po); v_cstore.fillDataSetByCommand(this, ip_ds_gd_thanh_toan); }
public void f409_load_thanh_toan_by_ma_dot_tt_va_trang_thai_tt_va_gvien_so_hd(string ip_str_ma_dot_tt , decimal ip_dc_trang_thai_tt, decimal ip_dc_id_giang_vien , decimal ip_str_so_hdong , DS_V_GD_THANH_TOAN op_ds_v_gd_thanh_toan , string ip_str_po) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_GetThanhToanByDotThanhToan_TrangThaiTT_va_id_gv_id_HD"); v_cstore.addNVarcharInputParam("@MA_DOT_TT", ip_str_ma_dot_tt); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_TT", ip_dc_trang_thai_tt); v_cstore.addDecimalInputParam("@ID_GIANG_VIEN", ip_dc_id_giang_vien); v_cstore.addNVarcharInputParam("@USER_NAME", ip_str_po); v_cstore.addNVarcharInputParam("@ID_HOP_DONG_KHUNG", ip_str_so_hdong); v_cstore.fillDataSetByCommand(this, op_ds_v_gd_thanh_toan); }
public void FillDataSet_Search_like_ma_hop_dong(DS_GD_HOP_DONG op_ds, string ma_hop_dong) { CStoredProc v_sp = new CStoredProc("GD_HOP_DONG_Search_like_ma_hop_dong"); v_sp.addNVarcharInputParam("@MA_HOP_DONG", ma_hop_dong); v_sp.fillDataSetByCommand(this, op_ds); }
public void FillDatasetSearch(DS_V_DM_TRANG_THAI_UNG_VIEN op_ds, string i_str_search) { CStoredProc v_sp = new CStoredProc("pr_V_DM_TRANG_THAI_UNG_VIEN_search"); v_sp.addNVarcharInputParam("@STR_SEARCH", i_str_search); v_sp.fillDataSetByCommand(this, op_ds); }
public void FillDatasetSearchByMaHopDong(DS_GD_HOP_DONG op_ds, string ip_str_ma_hop_dong) { CStoredProc v_sp = new CStoredProc("pr_GD_HOP_DONG_Search_by_ma_hop_dong"); v_sp.addNVarcharInputParam("@MA_HOP_DONG", ip_str_ma_hop_dong); v_sp.fillDataSetByCommand(this, op_ds); }