public void FillDatasetSearch(DS_V_DM_DU_AN_QUYET_DINH_TU_DIEN op_ds,
decimal v_dc_form_mode,
string i_str_search,
DateTime v_dat_tu_ngay,
DateTime v_dat_den_ngay,
decimal v_dc_trang_thai,
decimal v_dc_loai_du_an,
decimal v_dc_co_che,
decimal v_dc_tim_kiem_theo_ngay,
decimal ip_dc_id_phap_nhan,
decimal ip_dc_id_loai_quyet_dinh)
{
CStoredProc v_sp = new CStoredProc("pr_V_DM_DU_AN_QUYET_DINH_TU_DIEN_search");
v_sp.addDecimalInputParam("@form_mode", v_dc_form_mode);
v_sp.addNVarcharInputParam("@str_search", i_str_search);
v_sp.addDatetimeInputParam("@tu_ngay", v_dat_tu_ngay);
v_sp.addDatetimeInputParam("@den_ngay", v_dat_den_ngay);
v_sp.addDecimalInputParam("@id_trang_thai_du_an", v_dc_trang_thai);
v_sp.addDecimalInputParam("@id_loai_du_an", v_dc_loai_du_an);
v_sp.addDecimalInputParam("@id_co_che", v_dc_co_che);
v_sp.addDecimalInputParam("@tim_kiem_theo_ngay", v_dc_tim_kiem_theo_ngay);
v_sp.addDecimalInputParam("@id_phap_nhan", ip_dc_id_phap_nhan);
v_sp.addDecimalInputParam("@id_loai_quyet_dinh", ip_dc_id_loai_quyet_dinh);
v_sp.fillDataSetByCommand(this, op_ds);
}
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);
}
internal void FillReportBOByTimeCreated(DataSet v_ds, DateTime StartDate, DateTime EndDate)
{
CStoredProc v_cstore = new CStoredProc("get_ReportBOByTimeCreated");
v_cstore.addDatetimeInputParam("@startDate", StartDate);
v_cstore.addDatetimeInputParam("@endDate", EndDate);
v_cstore.fillDataSetByCommand(this, v_ds);
}
public void FillDataset(DateTime ip_dat_bat_dau, DateTime ip_dat_ket_thuc, string ip_txt_search, DS_V_GD_TRANG_THAI_LAO_DONG op_ds_v_gd_trang_thai_lao_dong)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_TRANG_THAI_LAO_DONG_search_datetime");
v_stored_proc.addDatetimeInputParam("@ip_dat_bat_dau", ip_dat_bat_dau);
v_stored_proc.addDatetimeInputParam("@ip_dat_ket_thuc", ip_dat_ket_thuc);
v_stored_proc.addNVarcharInputParam("@ip_str_search", ip_txt_search);
v_stored_proc.fillDataSetByCommand(this, op_ds_v_gd_trang_thai_lao_dong);
}
internal void FillAllOrder(DataSet v_ds, DateTime StartDate, DateTime EndDate, string orderstate)
{
CStoredProc v_cstore = new CStoredProc("getAllOrder");
v_cstore.addDatetimeInputParam("@startDate", StartDate);
v_cstore.addDatetimeInputParam("@endDate", EndDate);
v_cstore.addNVarcharInputParam("@arrayOrderState", orderstate);
v_cstore.fillDataSetByCommand(this, v_ds);
}
public void FillDatasetBonhiem(DS_V_GD_QUA_TRINH_LAM_VIEC op_ds, string ip_str_search, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, decimal ip_id_loai_qd, decimal ip_dc_phap_nhan)
{
CStoredProc v_sp = new CStoredProc("pr_V_GD_QUA_TRINH_LAM_VIEC_danh_sach_bo_nhiem");
v_sp.addNVarcharInputParam("@ip_str_tim_kiem", ip_str_search);
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_sp.addDecimalInputParam("@ip_dc_id_loai_qd", ip_id_loai_qd);
v_sp.addDecimalInputParam("@ip_dc_phap_nhan", ip_dc_phap_nhan);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetByProc(DS_RPT_BO_NHIEM op_ds_rpt, string ip_str_keyword, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, decimal ip_dc_loai_qd, decimal ip_dc_phap_nhan)
{
CStoredProc v_sp = new CStoredProc("pr_RPT_BO_NHIEM");
v_sp.addNVarcharInputParam("@ip_str_keyword", ip_str_keyword);
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_sp.addDecimalInputParam("@ip_dc_id_loai_qd", ip_dc_loai_qd);
v_sp.addDecimalInputParam("@ip_dc_phap_nhan", ip_dc_phap_nhan);
v_sp.fillDataSetByCommand(this, op_ds_rpt);
}
public void FillDataset(DS_RPT_SO_LUONG_NV op_ds, decimal ip_id_don_vi, string ip_str_ma_son_vi, decimal ip_id_ttld, decimal ip_id_phap_nhan, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_sp = new CStoredProc("pr_RPT_SO_LUONG_NV_2");
v_sp.addDecimalInputParam("@ip_dc_phap_nhan", ip_id_phap_nhan);
v_sp.addNVarcharInputParam("@ip_str_ma_don_vi", ip_str_ma_son_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.addDecimalInputParam("@ip_dc_id_don_vi", ip_id_don_vi);
v_sp.addDecimalInputParam("@ip_dc_id_ttld", ip_id_ttld);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetByManhanvien(DS_V_GD_QUA_TRINH_LAM_VIEC op_ds,
string ip_str_ma_nv,
DateTime ip_dat_ngay_bat_dau,
DateTime ip_dat_ngay_ket_thuc)
{
CStoredProc v_sp = new CStoredProc("pr_V_GD_QUA_TRINH_LAM_VIEC_By_Ma_nhan_vien");
v_sp.addDecimalInputParam("@MA_NHAN_VIEN", ip_str_ma_nv);
v_sp.addDatetimeInputParam("@NGAY_BAT_DAU", ip_dat_ngay_bat_dau);
v_sp.addDatetimeInputParam("@NGAY_KET_THUC", ip_dat_ngay_ket_thuc);
v_sp.fillDataSetByCommand(this, op_ds);
}
public DataSet load_bao_cao_cham_cong(DateTime i_dt_tu_ngay
, DateTime i_dt_den_ngay
, decimal i_dc_id_nguoi_dung)
{
DataSet v_ds = new DataSet();
CStoredProc v_cstore = new CStoredProc("pr_load_ds_cham_cong");
v_cstore.addDatetimeInputParam("@TU_NGAY", i_dt_tu_ngay);
v_cstore.addDatetimeInputParam("@DEN_NGAY", i_dt_den_ngay);
v_cstore.addDecimalInputParam("@ID_NGUOI_DUNG", i_dc_id_nguoi_dung);
v_cstore.fillData2DataSet(this, v_ds);
return(v_ds);
}
public DataSet tong_hop_so_luong_cau_hoi_theo_ngay(DateTime i_dt_tu_ngay
, DateTime i_dt_den_ngay)
{
DataSet v_ds = new DataSet();
v_ds.Tables.Add();
CStoredProc v_cstore = new CStoredProc("pr_fillTongHopSoLuongCauHoiTheoNgay");
v_cstore.addDatetimeInputParam("@TU_NGAY", i_dt_tu_ngay);
v_cstore.addDatetimeInputParam("@DEN_NGAY", i_dt_den_ngay);
v_cstore.fillDataSetByCommand(this, v_ds);
return(v_ds);
}
public void FillDataset_search(DS_V_GD_QUA_TRINH_LAM_VIEC op_ds,
string ip_str_tim_kiem,
decimal ip_dc_trang_thai,
DateTime ip_dat_ngay_bat_dau,
DateTime ip_dat_ngay_ket_thuc)
{
var command = new CStoredProc("pr_V_GD_QUA_TRINH_LAM_VIEC_Search");
command.addNVarcharInputParam("@TIM_KIEM", ip_str_tim_kiem);
command.addDecimalInputParam("@ID_TRANG_THAI_CV", ip_dc_trang_thai);
command.addDatetimeInputParam("@NGAY_BAT_DAU", ip_dat_ngay_bat_dau);
command.addDatetimeInputParam("@NGAY_KET_THUC", ip_dat_ngay_ket_thuc);
command.fillDataSetByCommand(this, op_ds);
}
public void FillDataset_search(DS_V_GD_HOP_DONG_LAO_DONG op_ds,
string ip_str_nhan_vien,
decimal ip_dc_loai_hop_dong,
DateTime ip_dat_ngay_bat_dau,
DateTime ip_dat_ngay_ket_thuc)
{
var command = new CStoredProc("pr_V_GD_HOP_DONG_LAO_DONG_Search");
command.addNVarcharInputParam("@NHAN_VIEN", ip_str_nhan_vien);
command.addDecimalInputParam("@ID_LOAI_HOP_DONG", ip_dc_loai_hop_dong);
command.addDatetimeInputParam("@NGAY_BAT_DAU", ip_dat_ngay_bat_dau);
command.addDatetimeInputParam("@NGAY_KET_THUC", ip_dat_ngay_ket_thuc);
command.fillDataSetByCommand(this, op_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 FillDatasetSapKetThuc(DS_DM_DU_AN op_ds_dm_da, DateTime i_dat_now)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_sap_ket_thuc");
v_sp.addDatetimeInputParam("@DAT_NOW", i_dat_now);
v_sp.fillDataSetByCommand(this, op_ds_dm_da);
}
public void fill_data_by_search(decimal i_dc_id_giang_vien,
decimal i_dc_id_don_vi_tt,
string i_str_bat_dau_tu,
string i_str_ket_thuc_tu,
decimal i_dc_id_trang_thai,
DS_DM_HO_SO_GIANG_VIEN i_ds)
{
CStoredProc v_object = new CStoredProc("pr_DM_HO_SO_GIANG_VIEN_Fill_By_Search");
v_object.addDecimalInputParam("@ip_id_giang_vien", i_dc_id_giang_vien);
v_object.addDecimalInputParam("@ip_id_don_vi_tt", i_dc_id_don_vi_tt);
v_object.addDecimalInputParam("@ip_id_trang_thai", i_dc_id_trang_thai);
v_object.addDatetimeInputParam("@ip_ngay_bat_dau_tu", CIPConvert.ToDatetime(i_str_bat_dau_tu, "dd/MM/yyyy"));
v_object.addDatetimeInputParam("@ip_ngay_ket_thuc_tu", CIPConvert.ToDatetime(i_str_ket_thuc_tu, "dd/MM/yyyy"));
v_object.fillDataSetByCommand(this, i_ds);
}
public void FillDatasetByProc(DS_GD_QUA_TRINH_CONG_TAC op_ds_v_qua_trinh_cong_tac
, string ip_str_key_word
, string ip_str_lua_chon
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_phap_nhan)
{
CStoredProc v_stored_proc = new CStoredProc("pr_GD_QUA_TRINH_CONG_TAC");
v_stored_proc.addNVarcharInputParam("@ip_str_search", ip_str_key_word);
v_stored_proc.addNVarcharInputParam("@ip_str_lua_chon", ip_str_lua_chon);
v_stored_proc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_stored_proc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_stored_proc.addDecimalInputParam("@ip_dc_phap_nhan", ip_dc_id_phap_nhan);
v_stored_proc.fillDataSetByCommand(this, op_ds_v_qua_trinh_cong_tac);
}
public void FillDatasetGDChiTietChucVu(DataSet op_ds, DateTime ip_dat)
{
CStoredProc v_cstore = new CStoredProc("rpt_tinh_hinh_dao_tao");
v_cstore.addDatetimeInputParam("@ip_dat_ngay_bao_cao", ip_dat);
v_cstore.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetSearch(DS_V_GD_CONG_TAC op_ds
, string ip_str_search
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay,
decimal ip_dc_tim_kiem_theo,
decimal ip_dc_id_phap_nhan)
{
CStoredProc v_store = new CStoredProc("pr_V_GD_CONG_TAC_search");
v_store.addNVarcharInputParam("@ip_str_search", ip_str_search);
v_store.addDatetimeInputParam("@tu_ngay", ip_dat_tu_ngay);
v_store.addDatetimeInputParam("@den_ngay", ip_dat_den_ngay);
v_store.addDecimalInputParam("@tim_kiem_theo_ngay", ip_dc_tim_kiem_theo);
v_store.addDecimalInputParam("@id_phap_nhan", ip_dc_id_phap_nhan);
v_store.fillDataSetByCommand(this, op_ds);
}
public void fill_danh_sach_yeu_cau_hoc_vien(DS_GD_CUOC_GOI_YEU_CAU i_ds
, string dien_thoai
, string i_str_ho_ten
, DateTime i_dt_tu_ngay
, DateTime i_dt_den_ngay
, decimal i_dc_id_trang_thai)
{
CStoredProc v_cstore = new CStoredProc("pr_GD_CUOC_GOI_YEU_CAU_fill_danh_sach_yeu_cau_hoc_vien");
v_cstore.addNVarcharInputParam("@DIEN_THOAI", dien_thoai);
v_cstore.addNVarcharInputParam("@HO_TEN", i_str_ho_ten);
v_cstore.addDatetimeInputParam("@TU_NGAY", i_dt_tu_ngay);
v_cstore.addDatetimeInputParam("@DEN_NGAY", i_dt_den_ngay);
v_cstore.addDecimalInputParam("@ID_TRANG_THAI", i_dc_id_trang_thai);
v_cstore.fillDataSetByCommand(this, i_ds);
}
internal void FillDatasetChungChiHetHan(DataSet v_ds, DateTime dateTime)
{
CStoredProc v_cstore = new CStoredProc("get_chung_chi_het_han_theo_ngach");
v_cstore.addDatetimeInputParam("@ngay", dateTime);
v_cstore.fillDataSetByCommand(this, v_ds);
}
public void FillDatasetByProc(DS_RPT_DON_VI_TRANG_THAI op_ds_rpt, DateTime ip_dat_thoi_diem, decimal ip_dc_phap_nhan)
{
CStoredProc v_sp = new CStoredProc("pr_RPT_DON_VI_TRANG_THAI");
v_sp.addDatetimeInputParam("@THOI_DIEM", ip_dat_thoi_diem);
v_sp.addDecimalInputParam("@ID_PHAP_NHAN", ip_dc_phap_nhan);
v_sp.fillDataSetByCommand(this, op_ds_rpt);
}
public void FillDataset(DS_RPT_NHAN_SU_PERFECT op_ds, decimal ip_id_phap_nhan, DateTime ip_thoi_diem)
{
CStoredProc v_sp = new CStoredProc("pr_RPT_NHAN_SU_PERFECT_FillData");
v_sp.addDecimalInputParam("@ip_id_phap_nhan", ip_id_phap_nhan);
v_sp.addDatetimeInputParam("@ip_thoi_diem", ip_thoi_diem);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetSearchCapCacThoiDiem(DS_V_GD_CHI_TIET_CAP_BAC op_ds_v_gd_chi_tiet_cap_bac, string ip_str_key_word, DateTime ip_dat_thoi_diem)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_CHI_TIET_CAP_BAC_select_by_MA_CAP_BAC_THOI_DIEM");
v_stored_proc.addNVarcharInputParam("@MA_CAP_BAC", ip_str_key_word);
v_stored_proc.addDatetimeInputParam("@THOI_DIEM", ip_dat_thoi_diem);
v_stored_proc.fillDataSetByCommand(this, op_ds_v_gd_chi_tiet_cap_bac);
}
public void FillDatasetByProc(DS_RPT_SO_LUONG_NV_THEO_LOAI op_ds_rpt, DateTime ip_dat_thoi_diem, decimal ip_dc_phap_nhan)
{
CStoredProc v_sp = new CStoredProc("pr_RPT_SO_LUONG_NV_THEO_LOAI");
v_sp.addDatetimeInputParam("@ip_dat_thoi_diem", ip_dat_thoi_diem);
v_sp.addDecimalInputParam("@ip_dc_phap_nhan", ip_dc_phap_nhan);
v_sp.fillDataSetByCommand(this, op_ds_rpt);
}
public void FillDatasetTuNgayDenNgay(
DS_V_DM_NHAN_SU_DU_AN op_ds_nhan_su,
string v_str_tu_khoa,
DateTime v_dat_tu_ngay,
DateTime v_dat_den_ngay,
decimal v_dc_tim_kiem_theo_ngay,
decimal ip_dc_id_phap_nhan)
{
CStoredProc v_sp = new CStoredProc("pr_V_NHAN_SU_DU_AN_tu_ngay_den_ngay");
v_sp.addNVarcharInputParam("@ip_str_keyword", v_str_tu_khoa);
v_sp.addDatetimeInputParam("@tu_ngay", v_dat_tu_ngay);
v_sp.addDatetimeInputParam("@den_ngay", v_dat_den_ngay);
v_sp.addDecimalInputParam("@tim_kiem_theo_ngay", v_dc_tim_kiem_theo_ngay);
v_sp.addDecimalInputParam("@id_phap_nhan", ip_dc_id_phap_nhan);
v_sp.fillDataSetByCommand(this, op_ds_nhan_su);
}
public void FillDatasetByProc(DS_RPT_LUONG_THEO_QD op_ds_rpt, DateTime ip_dau_nam, decimal ip_dc_phap_nhan)
{
CStoredProc v_sp = new CStoredProc("pr_v_gd_luong_theo_qd");
v_sp.addDatetimeInputParam("@IP_DAU_NAM", ip_dau_nam);
v_sp.addDecimalInputParam("@ID_PHAP_NHAN", ip_dc_phap_nhan);
v_sp.fillDataSetByCommand(this, op_ds_rpt);
}
public void FillDatase_NhanSu_TheoPhongBan(DS_V_GD_QUA_TRINH_LAM_VIEC op_ds, string ip_str_search, DateTime ip_dat_thoi_diem)
{
CStoredProc v_sp = new CStoredProc("pr_V_GD_QUA_TRINH_LAM_VIEC_Search_NhanVien_TheoPhongBanTaiMotThoiDiem");
v_sp.addNVarcharInputParam("@ip_str_tim_kiem", ip_str_search);
v_sp.addDatetimeInputParam("@ip_dat_thoi_diem", ip_dat_thoi_diem);
v_sp.fillDataSetByCommand(this, op_ds);
}
internal void GetTimeByProcedure(DataSet v_ds, decimal id_time, DateTime deadline)
{
CStoredProc v_cstore = new CStoredProc("get_start_date");
v_cstore.addDecimalInputParam("@id_khoang_thoi_gian", id_time);
v_cstore.addDatetimeInputParam("@deadline", deadline);
v_cstore.fillDataSetByCommand(this, v_ds);
}
