public void FillDatasetByIDDuAn(DS_GD_CHI_TIET_DU_AN v_ds, decimal i_dc_id)
{
CStoredProc v_sp = new CStoredProc("pr_GD_CHI_TIET_DU_AN_select_by_id_du_an");
v_sp.addDecimalInputParam("@ID_DA", i_dc_id);
v_sp.fillDataSetByCommand(this, v_ds);
}
public void FillDatasetTrangThaiYes(DS_GD_CHI_TIET_DU_AN v_ds, decimal dc_id_nv)
{
CStoredProc v_sp = new CStoredProc("pr_GD_CHI_TIET_DU_AN_select_trang_thai_yes");
v_sp.addDecimalInputParam("@ID_NV", dc_id_nv);
v_sp.fillDataSetByCommand(this, v_ds);
}
public void FillDatasetByID(DS_DM_NHAN_SU op_ds_dm_nhan_su, decimal ip_dc_id)
{
CStoredProc cstored = new CStoredProc("pr_DM_NHAN_SU_Search_by_ID");
cstored.addDecimalInputParam("@ID_NS", ip_dc_id);
cstored.fillDataSetByCommand(this, op_ds_dm_nhan_su);
}
public void DeleteChiTietDuAnById(DS_GD_CHI_TIET_DU_AN v_ds_gd_chi_tiet_da, decimal i_dc_id)
{
CStoredProc v_sp = new CStoredProc("pr_GD_CHI_TIET_DU_AN_Delete");
v_sp.addDecimalInputParam("@ID", i_dc_id);
v_sp.fillDataSetByCommand(this, v_ds_gd_chi_tiet_da);
}
public void FillDatasetByIDNS(DS_GD_CHI_TIET_DU_AN v_ds, decimal v_dc_id_ns)
{
CStoredProc v_sp = new CStoredProc("pr_GD_CHI_TIET_DU_AN_select_by_ID_NS");
v_sp.addDecimalInputParam("@ID_NS", v_dc_id_ns);
v_sp.fillDataSetByCommand(this, v_ds);
}
public void FillDatasetQuyenDaCapByIdUserGroup(DS_HT_PHAN_QUYEN_HE_THONG op_ds, decimal ip_dc_id)
{
CStoredProc v_stored_proc = new CStoredProc("pr_HT_PHAN_QUYEN_HE_THONG_quyen_da_cap_select_by_id_nhom_quyen");
v_stored_proc.addDecimalInputParam("@ID_USER_GROUP", ip_dc_id);
v_stored_proc.fillDataSetByCommand(this, op_ds);
}
public void load_hop_dong_by_id_giang_vien(decimal ip_dc_id_giang_vien, DS_V_DM_HOP_DONG_KHUNG ip_ds_v_dm_hop_dong_khung)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_HOP_DONG_KHUNG_Load_Hop_Dong_cbo_by_Id_Giang_Vien");
v_cstore.addDecimalInputParam("@ID_GIANG_VIEN", ip_dc_id_giang_vien);
v_cstore.fillDataSetByCommand(this, ip_ds_v_dm_hop_dong_khung);
}
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 FillDataset_search_by_ma_dv(DS_V_DM_DON_VI op_ds, string ip_str_ma_dv, decimal ip_dc_phap_nhan)
{
CStoredProc v_cst = new CStoredProc("pr_V_DM_DON_VI_search_by_ma_dv");
v_cst.addDecimalInputParam("@ip_dc_phap_nhan", ip_dc_phap_nhan);
v_cst.addNVarcharInputParam("@ip_str_ma_dv", ip_str_ma_dv);
v_cst.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetByKeyWord(DS_V_DM_DON_VI op_ds_v_v_dm_don_vi, string ip_str_trang_thai, decimal ip_dc_phap_nhan)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_DM_DON_VI_search_all");
v_stored_proc.addDecimalInputParam("@ip_dc_phap_nhan", ip_dc_phap_nhan);
v_stored_proc.addNVarcharInputParam("@ip_str_trang_thai", ip_str_trang_thai);
v_stored_proc.fillDataSetByCommand(this, op_ds_v_v_dm_don_vi);
}
public void chuyen_cong_viec_qua_thanh_toan(string ip_str_id_cac_cong_viec
, decimal ip_dc_id_dot_thanh_toan
, string ip_str_user_lap_thanh_toan
, string ip_str_thoi_gian_lop_mon
, decimal ip_dc_thoi_diem_thanh_toan_thang
, decimal ip_dc_thoi_diem_thanh_toan_nam)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_GV_CONG_VIEC_MOI_Chuyen_Qua_Thanh_Toan");
v_cstore.addDecimalInputParam("@ID_DOT_THANH_TOAN", ip_dc_id_dot_thanh_toan);
v_cstore.addNVarcharInputParam("@USER_LAP_THANH_TOAN", ip_str_user_lap_thanh_toan);
v_cstore.addNVarcharInputParam("@THOI_GIAN_LOP_MON", ip_str_thoi_gian_lop_mon);
v_cstore.addNVarcharInputParam("@ID_CAC_CONG_VIEC", ip_str_id_cac_cong_viec);
v_cstore.addDecimalInputParam("@THOI_DIEM_THANG", ip_dc_thoi_diem_thanh_toan_thang);
v_cstore.addDecimalInputParam("@THOI_DIEM_NAM", ip_dc_thoi_diem_thanh_toan_nam);
v_cstore.ExecuteCommand(this);
}
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 update_quyen_group(decimal i_dc_id_user_group, string i_str_chuc_nangs)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_QUYEN_GROUP_UpdateQuyen4Group");
v_cstore.addDecimalInputParam("@ID_USER_GROUP", i_dc_id_user_group);
v_cstore.addNVarcharInputParam("@ID_CHUC_NANG", i_str_chuc_nangs);
v_cstore.ExecuteCommand(this);
}
public void FillDatasetByIdChucNangAndFormName(DS_V_HT_CONTROL_IN_FORM op_ds, decimal ip_dc_id, string ip_form_name)
{
CStoredProc v_sp = new CStoredProc("pr_V_HT_CONTROL_IN_FORM_select_by_ID_CN");
v_sp.addDecimalInputParam("@ID_CHUC_NANG", ip_dc_id);
v_sp.addNVarcharInputParam("@FORM_NAME", ip_form_name);
v_sp.fillDataSetByCommand(this, op_ds);
}
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 FillDatasetSearchByIdQuyetDinh(DS_V_GD_CONG_TAC op_ds
, decimal ip_dc_id_quyet_dinh)
{
CStoredProc v_store = new CStoredProc("pr_V_GD_CONG_TAC_Select_by_ID_QUYET_DINH");
v_store.addDecimalInputParam("@ID_QUYET_DINH", ip_dc_id_quyet_dinh);
v_store.fillDataSetByCommand(this, op_ds);
}
public void update_quyen_group(decimal i_dc_id_user_group, string i_arr_dc_don_vi)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_QUAN_HE_SU_DUNG_DU_LIEU_UpdateQuyen4Group");
v_cstore.addDecimalInputParam("@ID_USER_GROUP", i_dc_id_user_group);
v_cstore.addNVarcharInputParam("@ID_DON_VI", i_arr_dc_don_vi);
v_cstore.ExecuteCommand(this);
}
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 load_hop_dong_by_id_giang_vien_cm_da_ky(decimal ip_dc_id_giang_vien, DS_V_DM_HOP_DONG_KHUNG ip_ds_v_dm_hop_dong_khung)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_HOP_DONG_KHUNG_Load_data_2_cbo_by_Id_Giang_Vien_CM_da_ky");
ip_ds_v_dm_hop_dong_khung.EnforceConstraints = false;
v_cstore.addDecimalInputParam("@ID_GIANG_VIEN", ip_dc_id_giang_vien);
v_cstore.fillDataSetByCommand(this, ip_ds_v_dm_hop_dong_khung);
}
public decimal count_trang_thai_hien_tai_phap_nhan(decimal ip_dc_id_nhan_su
, decimal ip_dc_id_phap_nhan
, decimal ip_dc_id_update
)
{
decimal v_dc_count = 0;
CStoredProc v_cst = new CStoredProc("pr_V_GD_TRANG_THAI_LAO_DONG_count_hien_tai_theo_phap_nhan");
v_cst.addDecimalInputParam("@ID_NHAN_SU", ip_dc_id_nhan_su);
v_cst.addDecimalInputParam("@ID_PHAP_NHAN", ip_dc_id_phap_nhan);
v_cst.addDecimalInputParam("@ID_UPDATE", ip_dc_id_update);
SqlParameter v_sql = v_cst.addDecimalOutputParam("@count", v_dc_count);
v_cst.ExecuteCommand(this);
v_dc_count = CIPConvert.ToDecimal(v_sql.Value);
return(v_dc_count);
}
public void load_ds_xu_ly_noi_bo_cau_hoi(DS_V_GD_LICH_GOI_NOI_BO op_ds, decimal ip_dc_id_cau_hoi)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_LICH_GOI_NOI_BO_Load_ds_xu_ly_by_cau_hoi");
v_cstore.addDecimalInputParam("@ID_CAU_HOI", ip_dc_id_cau_hoi);
v_cstore.fillDataSetByCommand(this, op_ds);
}
public void FillDataset_Search(DS_V_GD_TRANG_THAI_LAO_DONG op_ds, string ip_str_search, decimal ip_dc_id_phap_nhan)
{
CStoredProc v_sp = new CStoredProc("pr_V_GD_TRANG_THAI_LAO_DONG_search");
v_sp.addNVarcharInputParam("@ip_str_search", ip_str_search);
v_sp.addDecimalInputParam("@id_phap_nhan", ip_dc_id_phap_nhan);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void load_ds_nguoi_dai_dien_by_id_to_chuc(DS_V_DM_NGUOI_DAI_DIEN op_ds_dm_nguoi_dai_dien)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_NGUOI_DAI_DIEN_Load_Ds_Nguoi_Dai_Dien_By_To_Chuc");
v_cstore.addDecimalInputParam("@ID_DON_VI", this.dcID_DON_VI);
v_cstore.addNVarcharInputParam("@CHUC_VU", this.strNDD_CHUC_VU);
v_cstore.fillDataSetByCommand(this, op_ds_dm_nguoi_dai_dien);
}
public void FillDataset_chuc_vu_hien_tai(DS_V_GD_QUA_TRINH_LAM_VIEC op_ds, string ip_str_ma_nv, decimal ip_dc_id_phap_nhan)
{
CStoredProc v_sp = new CStoredProc("pr_V_GD_QUA_TRINH_LAM_VIEC_chuc_vu_hien_tai");
v_sp.addNVarcharInputParam("@MA_NHAN_VIEN", ip_str_ma_nv);
v_sp.addDecimalInputParam("@ID_PHAP_NHAN", ip_dc_id_phap_nhan);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void thay_doi_trang_thai_thong_tin_ho_so()
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_GIANG_VIEN_Thay_Doi_Trang_Thai");
v_cstore.addNVarcharInputParam("@TRANG_THAI_HO_SO", this.strCO_LOI_YN);
v_cstore.addDecimalInputParam("@ID_GIANG_VIEN", this.dcID);
v_cstore.ExecuteCommand(this);
}
public void FillDataSet_Now_By_Ma_NV_Id_PN(DS_V_GD_QUA_TRINH_LAM_VIEC op_ds, string ip_ma_nv, decimal ip_id_phap_nhan)
{
CStoredProc v_sp = new CStoredProc("pr_V_GD_QUA_TRINH_LAM_VIEC_Now_By_Ma_NV_Id_PN");
v_sp.addDecimalInputParam("@ip_id_phap_nhan", ip_id_phap_nhan);
v_sp.addNVarcharInputParam("@ip_ma_nhan_vien", ip_ma_nv);
v_sp.fillDataSetByCommand(this, op_ds);
}
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 FillDatasetByIdUserGroupAndMaPhanQuyen(DS_HT_PHAN_QUYEN_CHO_NHOM op_ds, decimal ip_dc_id, string ip_str)
{
CStoredProc v_stored_proc = new CStoredProc("pr_HT_PHAN_QUYEN_CHO_NHOM_select_by_ma_pq");
v_stored_proc.addNVarcharInputParam("@MA_PHAN_QUYEN", ip_str);
v_stored_proc.addDecimalInputParam("@ID_USER_GROUP", ip_dc_id);
v_stored_proc.fillDataSetByCommand(this, op_ds);
}
public void FillDataSet_Search_by_trang_thai_hop_dong(DS_GD_HOP_DONG op_ds, string trang_thai_hop_dong, decimal id_nhan_su)
{
CStoredProc v_sp = new CStoredProc("pr_V_GD_HOP_DONG_LAO_DONG_by_trang_thai_hop_dong");
v_sp.addNVarcharInputParam("@trang_thai_hop_dong", trang_thai_hop_dong);
v_sp.addDecimalInputParam("@id_nhan_su", id_nhan_su);
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);
}
