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