public void delete_by_id_gd_chi_tiet_chuc_vu(decimal ip_dc_id_chi_tiet_chuc_vu) { CStoredProc v_sp = new CStoredProc("pr_V_GD_QUA_TRINH_LAM_VIEC_Delete"); v_sp.addDecimalInputParam("@ID", ip_dc_id_chi_tiet_chuc_vu); v_sp.ExecuteCommand(this); }
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 DeleteAllQuyenOfGroupUser(decimal i_dc_group_user_id) { CStoredProc v_obj = new CStoredProc("pr_HT_PHAN_QUYEN_HE_THONG_Delele_All_Quyen_Of_group_user"); v_obj.addDecimalInputParam("@ip_dc_group_user_id", i_dc_group_user_id); v_obj.ExecuteCommand(this); }
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 delete_by_id_gd_chi_tiet_trang_thai_ld(decimal ip_dc_id_chi_tiet_trang_thai_lao_dong) { CStoredProc v_sp = new CStoredProc("pr_V_GD_TRANG_THAI_LAO_DONG_Delete"); v_sp.addDecimalInputParam("@ID", ip_dc_id_chi_tiet_trang_thai_lao_dong); v_sp.ExecuteCommand(this); }
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 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 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 delete_by_id(decimal ip_dc_id) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_QUYET_DINH_Delete"); v_cstore.addDecimalInputParam("@ID", ip_dc_id); v_cstore.ExecuteCommand(this); }
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 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); }
public void duyet_xac_nhan_giang_vien() { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Update_GiangVien"); v_cstore.addDecimalInputParam("@ID", this.dcID); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_THANH_TOAN", this.dcID_TRANG_THAI_THANH_TOAN); v_cstore.ExecuteCommand(this); }
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 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 cap_nhat_trang_thai_cong_viec(decimal ip_dc_trang_thai_moi) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_GV_CONG_VIEC_MOI_Cap_Nhat_Trang_Thai"); v_cstore.addDecimalInputParam("@ID", this.dcID); v_cstore.addDecimalInputParam("@ID_TRANG_THAI", ip_dc_trang_thai_moi); v_cstore.ExecuteCommand(this); }
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 danh_gia_don_hang(decimal ip_id_don_hang, decimal ip_dc_id_danh_gia, string ip_str_y_kien_khac) { CStoredProc v_cstore = new CStoredProc("pr_V_GD_DAT_HANG_danh_gia_don_hang"); v_cstore.addDecimalInputParam("@ID_DON_HANG", ip_id_don_hang); v_cstore.addDecimalInputParam("@ID_DANH_GIA", ip_dc_id_danh_gia); v_cstore.addNVarcharInputParam("@Y_KIEN_KHAC", ip_str_y_kien_khac); v_cstore.ExecuteCommand(this); }
public string get_ma_dat_hang_tiep_theo() { string v_output = ""; CStoredProc v_cstore = new CStoredProc("pr_get_ma_don_hang"); SqlParameter v_result = v_cstore.addNVarcharOutputParam("@MA_DON_HANG", v_output); v_cstore.ExecuteCommand(this); return(v_result.Value.ToString()); }
public void cap_nhat_trang_thai_cau_hoi() { CStoredProc v_cstore = new CStoredProc("pr_V_GD_XU_LY_NOI_BO_Update_TrangThaiCauHoi"); v_cstore.addDecimalInputParam("@ID", this.dcID); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_CAU_HOI", this.dcID_TRANG_THAI_CAU_HOI); v_cstore.ExecuteCommand(this); }
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 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 update_xac_nhan_ngan_hang() { CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Update_NganHang"); v_cstore.addDecimalInputParam("@ID", this.dcID); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_THANH_TOAN", this.dcID_TRANG_THAI_THANH_TOAN); // Cập nhật cả Mô tả của thanh toán chứa mã đợt thanh toán cũ của thanh toán v_cstore.addNVarcharInputParam("@DESCRIPTION", this.strDESCRIPTION); v_cstore.ExecuteCommand(this); }
public void Count_Nhan_vien(ref decimal op_dc_tong_so, ref decimal op_dc_hien_tai) { CStoredProc v_sp = new CStoredProc("pr_V_GD_QUA_TRINH_LAM_VIEC_Count"); SqlParameter v_pa1 = v_sp.addDecimalOutputParam("@SO_LUONG_HIEN_TAI", op_dc_hien_tai); SqlParameter v_pa2 = v_sp.addDecimalOutputParam("@TONG_SO", op_dc_tong_so); v_sp.ExecuteCommand(this); op_dc_tong_so = CIPConvert.ToDecimal(v_pa2.Value); op_dc_hien_tai = CIPConvert.ToDecimal(v_pa1.Value); }
public void Count_Nhan_vien(ref decimal op_dc_hien_tai) { CStoredProc v_sp = new CStoredProc("pr_V_GD_TRANG_THAI_LD_Count"); SqlParameter v_pa1 = v_sp.addDecimalOutputParam("@SO_LUONG_HIEN_TAI", op_dc_hien_tai); v_sp.ExecuteCommand(this); op_dc_hien_tai = CIPConvert.ToDecimal(v_pa1.Value); //op_dc_hien_tai = CIPConvert.ToDecimal(cmd.Parameters["@SO_LUONG_HIEN_TAI"].Value.ToString()); //op_dc_tong_so = CIPConvert.ToDecimal(cmd.Parameters["@TONG_SO"].Value.ToString()); }
public void update_cau_hoi_cu() { CStoredProc v_cstore = new CStoredProc("pr_GD_CAU_HOI_HOC_VIEN_Update_cau_hoi_cu"); v_cstore.addDecimalInputParam("@ID", this.dcID); v_cstore.addDecimalInputParam("@ID_TRANG_THAI", this.dcID_TRANG_THAI); v_cstore.addDecimalInputParam("@ID_DANH_GIA", this.dcID_DANH_GIA); v_cstore.addNVarcharInputParam("@GHI_CHU_Y_KIEN_KHAC", this.strGHI_CHU_Y_KIEN_KHAC); v_cstore.ExecuteCommand(this); }
public DateTime get_thoi_diem_can_hoan_thanh(string time) { string v_output = ""; CStoredProc v_cstore = new CStoredProc("pr_get_thoi_diem_can_hoan_thanh"); v_cstore.addNVarcharInputParam("@string_time", time); SqlParameter v_result = v_cstore.addDatetimeOutputParam("@thoi_diem_can_hoan_thanh", v_output); v_cstore.ExecuteCommand(this); return((DateTime)v_result.Value); }
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 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 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 string get_ten_nguoi_su_dung(decimal v_id) { string v_ten = ""; CStoredProc v_cstore = new CStoredProc("get_ten_nguoi_su_dung"); v_cstore.addNVarcharInputParam("@id", v_id); SqlParameter v_result = v_cstore.addNVarcharOutputParam("@ten", v_ten); v_cstore.ExecuteCommand(this); return((string)v_result.Value); }