C# CStoredProc.addNVarcharOutputParam方法代码示例

 public void gen_ma_nhan_vien(ref string v_str_op_ma_nhan_vien)
 {
     CStoredProc v_obj_csp = new CStoredProc("pr_gen_ma_nhan_vien");
     SqlParameter v_op_str = v_obj_csp.addNVarcharOutputParam("@op_ma_nhan_vien", "");
     v_obj_csp.ExecuteCommand(this);
     v_str_op_ma_nhan_vien = v_op_str.Value.ToString();
 }

        public bool KiemTraNhanVienCoCongTacChua(decimal ip_dc_id_nhan_vien, decimal ip_dc_id_don_vi)
        {
            CStoredProc v_cstore = new CStoredProc("pr_NS_nhan_vien_thuoc_phong_ban_Check");
            v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
            v_cstore.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
            SqlParameter v_para = v_cstore.addNVarcharOutputParam("@op_str_yn", "");
            v_cstore.ExecuteCommand(this);

            return v_para.Value.ToString() == "Y" ? true : false;
        }

        public bool IsLockBangLuong(decimal ip_dc_thang, decimal ip_dc_nam)
        {
            CStoredProc v_pr = new CStoredProc("pr_TL_infor_lock_bang_luong_Get");
            v_pr.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
            v_pr.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
            SqlParameter v_para = v_pr.addNVarcharOutputParam("@op_str_lock_yn", "");

            v_pr.ExecuteCommand(this);
            return v_para.Value.ToString() == "Y" ? true : false;
        }

        public bool KiemTraThoiGianHeSoLNSHopLeForInsert(decimal ip_dc_id_nhan_vien, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
        {
            CStoredProc v_cstore = new CStoredProc("pr_HD_du_lieu_hs_lns_hop_le_CheckInsert");
            v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
            v_cstore.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
            v_cstore.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);

            SqlParameter v_yn = v_cstore.addNVarcharOutputParam("@op_str_hop_le_yn", "");
            v_cstore.ExecuteCommand(this);

            return v_yn.Value.ToString() == "Y" ? true : false;
        }

        public bool KiemTraQuyCoNhanVienChua(decimal ip_dc_id_quy, decimal ip_dc_id_nhan_vien)
        {
            CStoredProc v_obj = new CStoredProc("pr_TNK_nhan_vien_ton_tai_trong_quy_Check");

            v_obj.addDecimalInputParam("@ip_dc_id_quy_tien", ip_dc_id_quy);
            v_obj.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
            SqlParameter v_para_yn = v_obj.addNVarcharOutputParam("@op_yn", "");
            v_obj.ExecuteCommand(this);
            var v_bol_ket_qua = v_para_yn.Value.ToString() == "Y" ? true : false;
            return v_bol_ket_qua;
        }

        public bool KiemTraThoiGianHopDongHopLeForUpdate(decimal ip_dc_id_gd_hop_dong, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
        {
            CStoredProc v_cstore = new CStoredProc("pr_HD_du_lieu_hop_dong_hop_le_CheckUpdate");
            v_cstore.addDecimalInputParam("@ip_dc_id_gd_hop_hong", ip_dc_id_gd_hop_dong);
            v_cstore.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
            v_cstore.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);

            SqlParameter v_yn = v_cstore.addNVarcharOutputParam("@op_str_hop_le_yn", "");
            v_cstore.ExecuteCommand(this);

            return v_yn.Value.ToString() == "Y" ? true : false;
        }

        public void LayMaMucLNSCuaHopDong(decimal ip_dc_id_hop_dong_con_hieu_luc, out decimal op_dc_he_so, out string op_str_ma, out string op_str_muc)
        {
            CStoredProc v_sp = new CStoredProc("pr_HD_ma_muc_lns_Get");
            v_sp.addDecimalInputParam("@ip_dc_id_hop_dong_con_hieu_luc", @ip_dc_id_hop_dong_con_hieu_luc);

            SqlParameter v_p_he_so = v_sp.addDecimalOutputParam("@op_dc_he_so", (decimal)1.123);
            v_p_he_so.Precision = 6;
            v_p_he_so.Scale = 2;
            SqlParameter v_p_muc = v_sp.addNVarcharOutputParam("@op_str_muc_lns", "");
            SqlParameter v_p_ma = v_sp.addNVarcharOutputParam("@op_str_ma_lns", "");

            v_sp.ExecuteCommand(this);
            op_dc_he_so = Convert.ToDecimal(v_p_he_so.Value);
            op_str_ma = v_p_ma.Value.ToString();
            op_str_muc = v_p_muc.Value.ToString();
        }

 public string get_all_ma_phong_ban_by_id_user_group(decimal ip_dc_id_user_group)
 {
     string v_str_ma_phong_ban = "";
     CStoredProc v_sp = new CStoredProc("pr_HT_QUAN_HE_SU_DUNG_DU_LIEU_get_all_ma_phong_ban_by_id_user_group");
     v_sp.addDecimalInputParam("@ip_dc_id_user_group", ip_dc_id_user_group);
     SqlParameter v_sql_para = v_sp.addNVarcharOutputParam("@ip_str_phong_ban", v_str_ma_phong_ban);
     v_sp.ExecuteCommand(this);
     v_str_ma_phong_ban = v_sql_para.Value.ToString();
     return v_str_ma_phong_ban;
 }

        public bool IsExistNhanVienInDB(string ip_str_ma_nv)
        {
            CStoredProc v_sp = new CStoredProc("pr_is_exist_nhan_vien");
            v_sp.addNVarcharInputParam("@ip_str_ma_nv", ip_str_ma_nv);

            SqlParameter v_para = v_sp.addNVarcharOutputParam("@op_yn_is_exist", "");

            v_sp.ExecuteCommand(this);

            if (v_para.Value.ToString() == "Y")
            {
                return true;
            }
            else if (v_para.Value.ToString() == "N")
            {
                return false;
            }
            else
            {
                throw new Exception();
            }
        }

        public bool QuyThuongDaChiaNhanVienChua(decimal ip_dc_id_quy_tien_thuong)
        {
            CStoredProc v_sp = new CStoredProc("pr_quy_thuong_da_chia_nhan_vien_chua");
            v_sp.addDecimalInputParam("@ip_dc_id_quy_thuong", ip_dc_id_quy_tien_thuong);

            SqlParameter v_para = v_sp.addNVarcharOutputParam("@op_str_yn", "");
            v_sp.ExecuteCommand(this);

            return v_para.Value.ToString() == "Y" ? true : false;//Y la da chia thuog cho nhan vien, N la chua chia thuong
        }

        public bool KiemTraCoDuLieu(decimal ip_dc_thang, decimal ip_dc_nam, decimal ip_dc_id_loai_tien_khac)
        {
            CStoredProc v_cstore = new CStoredProc("pr_TL_infor_du_lieu_khoan_tien_khac_Get");
            v_cstore.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
            v_cstore.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
            v_cstore.addDecimalInputParam("@ip_dc_id_loai_tien_khac", ip_dc_id_loai_tien_khac);

            SqlParameter v_para = v_cstore.addNVarcharOutputParam("@op_ton_tai_yn", "");
            v_cstore.ExecuteCommand(this);
            return v_para.Value.ToString() == "Y" ? true : false;
        }

        public bool KiemTraXemDaInsertThuong2014Chua(decimal ip_id_quy_tien, decimal ip_dc_id_nhan_vien)
        {
            CStoredProc v_sp = new CStoredProc("pr_check_before_insert_thuong_2k14");
            v_sp.addDecimalInputParam("@ip_dc_id_quy_tien", ip_id_quy_tien);
            v_sp.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
            SqlParameter v_yn = v_sp.addNVarcharOutputParam("@op_yn_insert", "");
            v_sp.ExecuteCommand(this);

            return v_yn.Value.ToString() == "Y" ? false : true;//Y la chua co
        }

        //Bang luong
        public void LayTrangThaiBangLuong(decimal ip_dc_thang
            , decimal ip_dc_nam
            , out decimal op_sl_nv_can_tinh_luong
            , out decimal op_sl_nv_da_tinh_luong
            , out bool op_bol_co_du_lieu_chua
            , out bool op_bol_chot_bang_luong)
        {
            op_sl_nv_can_tinh_luong = 0;
            op_sl_nv_da_tinh_luong = 0;

            CStoredProc v_sp = new CStoredProc("pr_TL_trang_thai_bang_luong_Get");
            v_sp.addDecimalInputParam("@ip_i_thang", ip_dc_thang);
            v_sp.addDecimalInputParam("@ip_i_nam", ip_dc_nam);

            SqlParameter v_para_all = v_sp.addDecimalOutputParam("@op_i_tong_so_nhan_vien_can_tinh", 0);
            SqlParameter v_para_da_tinh = v_sp.addDecimalOutputParam("@op_i_so_luong_nhan_vien_da_tinh", 0);
            SqlParameter v_para_co_du_lieu_chua = v_sp.addNVarcharOutputParam("@op_str_co_du_lieu_chua", "");
            SqlParameter v_para_chot_bang_luong = v_sp.addNVarcharOutputParam("@op_str_chot_bang_luong", "");
            v_sp.ExecuteCommand(this);

            op_sl_nv_can_tinh_luong = CIPConvert.ToDecimal(v_para_all.Value);
            op_sl_nv_da_tinh_luong = CIPConvert.ToDecimal(v_para_da_tinh.Value);
            op_bol_co_du_lieu_chua = v_para_co_du_lieu_chua.Value.ToString() == "Y" ? true : false;
            op_bol_chot_bang_luong = v_para_chot_bang_luong.Value.ToString() == "Y" ? true : false;
        }

        public bool kiem_tra_nhan_vien_co_duoc_tinh_luong_thang(decimal ip_dc_id_nhan_vien, decimal ip_dc_thang, decimal ip_dc_nam)
        {
            CStoredProc v_pr = new CStoredProc("pr_TL_nhan_vien_duoc_tinh_luong_Check");
            v_pr.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
            v_pr.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
            v_pr.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
            SqlParameter v_para = v_pr.addNVarcharOutputParam("@op_str_yn","");

            v_pr.ExecuteCommand(this);

            return v_para.Value.ToString() == "Y" ? true : false;
        }

 public void check_hoc_sinh_lm(decimal ip_dc_id_hoc_sinh, decimal ip_dc_id_lop_mon, ref string op_ket_qua_yn)
 {
     CStoredProc v_obj_spr = new CStoredProc("f315_check_hs_trong_lm");
     v_obj_spr.addDecimalInputParam("@ip_dc_id_hoc_sinh", ip_dc_id_hoc_sinh);
     v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
     SqlParameter v_op_ket_qua_yn = v_obj_spr.addNVarcharOutputParam("@op_ket_qua_yn", op_ket_qua_yn);
     v_obj_spr.ExecuteCommand(this);
     op_ket_qua_yn = v_op_ket_qua_yn.Value.ToString();
 }