public void Delete(decimal ip_dc_id)
{
CStoredProc v_cst = new CStoredProc("pr_V_DM_DON_VI_Delete_by_ID");
v_cst.addDecimalInputParam("@ID", ip_dc_id);
v_cst.ExecuteCommand(this);
}
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 FillDatasetByID_TRANG_THAI_PARENT(DS_V_DM_TRANG_THAI_UNG_VIEN op_ds)
{
CStoredProc cstored = new CStoredProc("pr_V_DM_TRANG_THAI_UNG_VIEN_Select_by_ID_Parent");
//cstored.addDecimalInputParam("@ID_NS", i_str_search);
cstored.fillDataSetByCommand(this, op_ds);
}
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 load_ds_assign_qlht(DS_GD_XU_LY_NOI_BO op_ds, decimal ip_dc_id_cau_hoi)
{
CStoredProc v_cstore = new CStoredProc("pr_GD_XU_LY_NOI_BO_Load_ds_assign_cau_hoi_cho_QLHT");
v_cstore.addDecimalInputParam("@ID_CAU_HOI", ip_dc_id_cau_hoi);
v_cstore.fillDataSetByCommand(this, op_ds);
}
public void DeleteAllQuyenOfUser(decimal i_dc_user_id)
{
CStoredProc v_obj = new CStoredProc("pr_HT_QUYEN_USER_Delele_All_Quyen_Of_user");
v_obj.addDecimalInputParam("@ip_dc_user_id", i_dc_user_id);
v_obj.ExecuteCommand(this);
}
public void FillDatasetByID(DS_DM_DU_AN op_ds_dm_da, decimal i_dc_id)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_select_by_ID");
v_sp.addDecimalInputParam("@ID", i_dc_id);
v_sp.fillDataSetByCommand(this, op_ds_dm_da);
}
public void load_mau_email_by_ma_mau(DS_DM_MAU_EMAIL op_ds, string ip_str_ma_mail)
{
CStoredProc v_cstore = new CStoredProc("pr_DM_MAU_EMAIL_Load_Mau_Mail_By_Ma");
v_cstore.addNVarcharInputParam("@MA_MAU_MAIL", ip_str_ma_mail);
v_cstore.fillDataSetByCommand(this, op_ds);
}
public void load_gd_cau_hoi_by_id_cau_hoi()
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_CAU_HOI_YEU_CAU_Load_Cau_Hoi_By_Id_Cau_Hoi_Hoc_Vien");
DS_V_GD_CAU_HOI_YEU_CAU v_ds = new DS_V_GD_CAU_HOI_YEU_CAU();
v_cstore.addDecimalInputParam("@ID_CAU_HOI", this.dcID_CAU_HOI);
v_cstore.fillDataSetByCommand(this, v_ds);
if (v_ds.V_GD_CAU_HOI_YEU_CAU.Rows.Count > 0)
{
DataRow2Me(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0]);
//this.strNOI_DUNG_CAU_HOI = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NOI_DUNG_CAU_HOI]);
//this.strNOI_DUNG_TRA_LOI = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NOI_DUNG_TRA_LOI]);
//this.strHO_TEN_SINH_VIEN = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.HO_TEN_SINH_VIEN]);
//this.strMA_SINH_VIEN = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.MA_SINH_VIEN]);
//this.strLOP = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.LOP]);
//this.strNOI_SINH = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NOI_SINH]);
//this.datNGAY_SINH = CIPConvert.ToDatetime(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NGAY_SINH].ToString());
//this.strTRUONG = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.TRUONG]);
//this.strSO_DIEN_THOAI = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.SO_DIEN_THOAI]);
//this.dcID_TRANG_THAI = CIPConvert.ToDecimal(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.ID_TRANG_THAI]);
}
}
public void load_nguoi_dai_dien_by_acc_scm(DS_V_DM_NGUOI_DAI_DIEN op_ds_dm_nguoi_dai_dien, string ip_str_acc_scm)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_NGUOI_DAI_DIEN_Load_Nguoi_Dai_Dien_By_Acc_SCM");
v_cstore.addNVarcharInputParam("@ACC_SCM", ip_str_acc_scm);
v_cstore.fillDataSetByCommand(this, op_ds_dm_nguoi_dai_dien);
}
public void FillDataset_By_Ma_cap(DS_V_DM_CAP_BAC op_ds, string ip_str_ma_cap)
{
CStoredProc v_sp = new CStoredProc("pr_V_DM_CAP_BAC_By_Ma_cap");
v_sp.addNVarcharInputParam("@ip_str_ma_cap", ip_str_ma_cap);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetSearch(DS_V_DM_NHAN_SU_DU_AN op_ds_nhan_su, string v_str_tu_khoa)
{
CStoredProc v_sp = new CStoredProc("pr_V_NHAN_SU_DU_AN_search");
v_sp.addNVarcharInputParam("@STR_DU_AN", v_str_tu_khoa);
v_sp.fillDataSetByCommand(this, op_ds_nhan_su);
}
public void FillDatasetSearch(DS_DM_CHUC_VU op_ds, string i_str_search)
{
CStoredProc v_sp = new CStoredProc("pr_DM_CHUC_VU_search");
v_sp.addNVarcharInputParam("@STR_SEARCH", i_str_search);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void Filldataset_by_ID_phap_nhan(DS_V_DM_DON_VI op_ds, decimal ip_dc_id_phap_nhan)
{
CStoredProc v_cst = new CStoredProc("pr_V_DM_DON_VI_search_by_id_phap_nhan");
v_cst.addDecimalInputParam("@id_phap_nhan", ip_dc_id_phap_nhan);
v_cst.fillDataSetByCommand(this, op_ds);
}
public void load_giang_vien_CM_dang_cong_tac_by_Po(DS_V_DM_GIANG_VIEN ip_ds_v_dm_giang_vien, string ip_str_po)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_GIANG_VIEN_Load_data_2_cbo_GV_CM_by_PO");
v_cstore.addNVarcharInputParam("@USERNAME", ip_str_po);
v_cstore.fillDataSetByCommand(this, ip_ds_v_dm_giang_vien);
}
public void load_dot_thanh_toan_by_trang_thai_tru_kho(decimal ip_dc_trang_thai_dot, DS_V_DM_DOT_THANH_TOAN op_ds_dm_dot_thanh_toan)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Load_Dot_Thanh_Toan_by_Trang_thai_tru_kho");
v_cstore.addDecimalInputParam("@ID_TRANG_THAI_DOT_THANH_TOAN", ip_dc_trang_thai_dot);
v_cstore.fillDataSetByCommand(this, op_ds_dm_dot_thanh_toan);
}
public void search_mon_hoc(string ip_str_tu_khoa, DS_DM_MON_HOC op_ds_dm_mon_hoc)
{
CStoredProc v_store = new CStoredProc("pr_V_DM_MON_HOC_Search");
v_store.addNVarcharInputParam("@TU_KHOA", ip_str_tu_khoa);
v_store.fillDataSetByCommand(this, op_ds_dm_mon_hoc);
}
public void duyet_toan_bo_chung_tu()
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Duyet_Tat_Ca_Chung_Tu");
v_cstore.addNVarcharInputParam("@MA_DOT_THANH_TOAN", this.strMA_DOT_TT);
v_cstore.ExecuteCommand(this);
}
public void DeleteDuAnById(DS_DM_DU_AN v_ds_dm_du_an, decimal i_dc_id)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_Delete");
v_sp.addDecimalInputParam("@ID", i_dc_id);
v_sp.fillDataSetByCommand(this, v_ds_dm_du_an);
}
public void xac_nhan_toan_bo_ngan_hang()
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Xac_Nhan_Toan_Bo_Ngan_Hang");
v_cstore.addNVarcharInputParam("@MA_DOT_THANH_TOAN", this.strMA_DOT_TT);
v_cstore.ExecuteCommand(this);
}
public void FillDataset_search_by_ma_da(DS_DM_DU_AN op_ds_dm_da, string i_str_id)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_select_by_ma_da");
v_sp.addNVarcharInputParam("@MA_DA", i_str_id);
v_sp.fillDataSetByCommand(this, op_ds_dm_da);
}
public void dong_dot_thanh_toan()
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Dong_Dot_Thanh_Toan");
v_cstore.addNVarcharInputParam("@MA_DOT_THANH_TOAN", this.strMA_DOT_TT);
v_cstore.ExecuteCommand(this);
}
public void FillDatasetByIDQuyetDinh(DS_DM_DU_AN op_ds_dm_da, decimal ip_dc_id_quyet_dinh)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_select_by_id_quyet_dinh");
v_sp.addDecimalInputParam("@id_quyet_dinh", ip_dc_id_quyet_dinh);
v_sp.fillDataSetByCommand(this, op_ds_dm_da);
}
public void check_so_hop_dong(DS_DM_HOP_DONG_KHUNG ip_ds_dm_hop_dong_khung, string ip_str_so_hop_dong)
{
CStoredProc v_cstore = new CStoredProc("pr_DM_HOP_DONG_KHUNG_check_so_hop_dong");
v_cstore.addNVarcharInputParam("@So_Hop_dong", ip_str_so_hop_dong);
v_cstore.fillDataSetByCommand(this, ip_ds_dm_hop_dong_khung);
}
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);
}
public void FillDatasetByKeyWord(DS_V_GD_CHI_TIET_CAP_BAC op_ds_v_v_dm_don_vi, string ip_str_key_word)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_CHI_TIET_CAP_BAC_search");
v_stored_proc.addNVarcharInputParam("@ip_str_search", ip_str_key_word);
v_stored_proc.fillDataSetByCommand(this, op_ds_v_v_dm_don_vi);
}
public void Upload_trang_thai_hop_dong(US_GD_HOP_DONG op_us)
{
CStoredProc v_sp = new CStoredProc("pr_GD_HOP_DONG_Update_Trang_thai_hop_dong");
v_sp.addDecimalInputParam("@ID", op_us.dcID);
v_sp.ExecuteCommand(op_us);
}
public void load_blacklist_by_dien_thoai(DS_V_DM_BLACK_LIST op_ds, string ip_str_so_dien_thoai)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_BLACK_LIST_Load_blacklist_by_dien_thoai");
v_cstore.addNVarcharInputParam("@SO_DIEN_THOAI", ip_str_so_dien_thoai);
v_cstore.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 bao_cao_thong_ke_gv(DS_RPT_BAO_CAO_THONG_KE_TRANG_THAI_GIANG_VIEN op_ds_bao_cao_thong_ke_trang_thai_giang_vien)
{
CStoredProc v_cstore = new CStoredProc("rpt_pr_DM_GIANG_VIEN");
op_ds_bao_cao_thong_ke_trang_thai_giang_vien.EnforceConstraints = false;
v_cstore.fillDataSetByCommand(this, op_ds_bao_cao_thong_ke_trang_thai_giang_vien);
}
