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);
}
