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