C# CStoredProc.addDecimalOutputParam方法代码示例

        public void load_tong_so_hs_dang_hoc(DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, ref decimal  ip_dc_tong_so_hs_dang_hoc)
        {
            CStoredProc v_pr = new CStoredProc("pr_load_tong_so_hs_dang_hoc");
            v_pr.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
            v_pr.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
            SqlParameter v_pa = v_pr.addDecimalOutputParam("@op_dc_tong_so_hs_dang_hoc", ip_dc_tong_so_hs_dang_hoc);

            v_pr.ExecuteCommand(this);
            ip_dc_tong_so_hs_dang_hoc = CIPConvert.ToDecimal(v_pa.Value);
        }

        public bool check_diem_danh_hs(
            decimal ip_dc_id_hoc_sinh
            , decimal ip_dc_id_lop_mon
            , decimal ip_dc_id_nguoi_diem_danh
            , DateTime ip_dat_tai_ngay
            , ref decimal op_dc_id_gd_diem_danh)
        {
            DS_GD_DIEM_DANH op_ds_diem_danh = new DS_GD_DIEM_DANH();
            CStoredProc v_obj_spr = new CStoredProc("pr_kiem_tra_hoc_sinh_diem_danh");
            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);
            v_obj_spr.addDecimalInputParam("@ip_dc_id_nguoi_diem_danh", ip_dc_id_nguoi_diem_danh);
            v_obj_spr.addDatetimeInputParam("@ip_dat_tai_ngay", ip_dat_tai_ngay);
            SqlParameter v_id_gd_diem_danh = v_obj_spr.addDecimalOutputParam("@op_dc_id_gd_diem_danh", 0);

            v_obj_spr.ExecuteCommand(this);

            op_dc_id_gd_diem_danh = CIPConvert.ToDecimal(v_id_gd_diem_danh.Value);
            if (op_dc_id_gd_diem_danh == -1)
            {
                return false;
            }
            else
                return true;
        }

        public decimal get_tong_tien_dinh_muc_hang_thang(decimal ip_id_trung_tam, decimal ip_id_loai_dinh_muc, DateTime ip_dau_thang, DateTime ip_cuoi_thang)
        {
            CStoredProc v_store_proc = new CStoredProc("[pr_get_tong_tien_dm_theo_thang]");
            v_store_proc.addDecimalInputParam("@ID_TRUNG_TAM ", ip_id_trung_tam);
            v_store_proc.addDatetimeInputParam("@DAU_THANG", ip_dau_thang.Date);
            v_store_proc.addDatetimeInputParam("@CUOI_THANG", ip_cuoi_thang.Date);
            v_store_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_id_loai_dinh_muc);
            SqlParameter v_obj_tong_tien_dinh_muc = v_store_proc.addDecimalOutputParam("@TONG_TIEN", 0);

            v_store_proc.ExecuteCommand(this);
            if(v_obj_tong_tien_dinh_muc.Value!=null)
            return CIPConvert.ToDecimal(v_obj_tong_tien_dinh_muc.Value);
            return 0;
        }

 public void Insert_nhom_nguoi_dung()
 {
     CStoredProc v_cstore = new CStoredProc("pr_HT_USER_GROUP_Insert");
     v_cstore.addNVarcharInputParam("@USER_GROUP_NAME", this.strUSER_GROUP_NAME);
     v_cstore.addNVarcharInputParam("@DESCRIPTION", this.strDESCRIPTION);
     v_cstore.addDecimalInputParam("@ID_DON_VI", this.dcID_DON_VI);
     v_cstore.addDecimalOutputParam("@ID", this.dcID);
     v_cstore.ExecuteCommand(this);
 }

        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 void get_co_so_dinh_muc_ap_dung_tu_ngay(decimal ip_id_trung_tam, decimal ip_id_loai_dinh_muc
            , DateTime ip_from_date, DateTime ip_to_date
            , ref decimal op_id_co_so_dinh_muc, ref DateTime op_ap_dung_tu_ngay
            , ref string op_ten_co_so_dinh_muc)
        {
            CStoredProc v_proc = new CStoredProc("pr_get_co_so_dinh_muc_ap_dung_tu_ngay");

            v_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_id_trung_tam);
            v_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_id_loai_dinh_muc);
            v_proc.addDatetimeInputParam("@FROM_DATE", ip_from_date);
            v_proc.addDatetimeInputParam("@TO_DATE", ip_to_date);

            SqlParameter v_obj_id_co_so_dinh_muc = v_proc.addDecimalOutputParam("@ID_CO_SO_DINH_MUC", -1);
            SqlParameter v_obj_ten_co_so_dinh_muc = v_proc.addNVarcharOutputParam("@TEN_CO_SO_DINH_MUC", -1);
            SqlParameter v_obj_ap_dung_tu_ngay = v_proc.addDatetimeOutputParam("@AP_DUNG_TU_NGAY", -1);

            v_proc.ExecuteCommand(this);

            op_id_co_so_dinh_muc = CIPConvert.ToDecimal(v_obj_id_co_so_dinh_muc.Value);
            string temp = v_obj_ap_dung_tu_ngay.Value.ToString();
            if(temp != "") {
            temp = temp.Substring(0, temp.IndexOf(" "));
            op_ap_dung_tu_ngay = CIPConvert.ToDatetime(temp);
            }
            if(v_obj_ten_co_so_dinh_muc.Value.ToString() != "") {
            op_ten_co_so_dinh_muc = CIPConvert.ToStr(v_obj_ten_co_so_dinh_muc.Value);
            }
        }

 public bool is_so_tien_null(US_DM_BILL ip_us_dm_bill, string ip_so_bill)
 {
     CStoredProc v_proc = new CStoredProc("pr_is_so_tien_null");
     v_proc.addNVarcharInputParam("@SO_BILL", ip_so_bill);
     SqlParameter v_obj_is_so_tien_null = v_proc.addDecimalOutputParam("@SO_TIEN", 0);
     v_proc.ExecuteCommand(ip_us_dm_bill);
     if(CIPConvert.ToDecimal(v_obj_is_so_tien_null.Value) == -1) {
     return true;
     }
     return false;
 }

        public void Find_id_gd_phieu_thu(decimal ip_dc_id_lop_mon, DateTime ip_dat_ngay_thu, ref decimal op_dc_id_gd_phieu_thu)
        {
            CStoredProc v_obj = new CStoredProc("pr_get_id_gd_hoc_by_id_lop_ngay_thu");

            v_obj.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
            v_obj.addDatetimeInputParam("@ip_dat_ngay_thu", ip_dat_ngay_thu);
            SqlParameter v_id_gd_phieu_thu = v_obj.addDecimalOutputParam("@op_dc_id_gd_phieu_thu", 0);
            v_obj.ExecuteCommand(this);
            op_dc_id_gd_phieu_thu = CIPConvert.ToDecimal(v_id_gd_phieu_thu.Value);
        }

        public decimal getIDNhanVienByMaNV(string ip_str_ma_nv)
        {
            CStoredProc v_sp = new CStoredProc("pr_get_id_nhan_vien_by_ma_nv");
            v_sp.addNVarcharInputParam("@ip_str_ma_nv", ip_str_ma_nv);

            SqlParameter v_para = v_sp.addDecimalOutputParam("@op_dc_id_nhan_vien", -1);

            v_sp.ExecuteCommand(this);

            return Convert.ToDecimal(v_para.Value);
        }

        public void tinh_tuoi_nhan_vien(DateTime ip_dat_ngay_sinh, ref decimal op_dc_so_tuoi)
        {
            CStoredProc v_obj_csp = new CStoredProc("pr_get_so_tuoi_nhan_vien");
            v_obj_csp.addDatetimeInputParam("@ip_dat_ngay_sinh", ip_dat_ngay_sinh);

            SqlParameter v_op_result = v_obj_csp.addDecimalOutputParam("@op_dc_so_tuoi", 0);

            v_obj_csp.ExecuteCommand(this);

            op_dc_so_tuoi = Convert.ToDecimal(v_op_result.Value);
        }

        public void kiem_tra_thang_da_giam_tru_chua(decimal ip_dc_thang, decimal ip_dc_nam, ref decimal op_dc_thang_da_giam_tru)
        {
            CStoredProc v_obj = new CStoredProc("pr_CHECK_DA_GIAM_TRU_THANG_DO_YN");

            v_obj.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
            v_obj.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);

            SqlParameter v_dc_thang_da_giam_tru = v_obj.addDecimalOutputParam("@op_dc_thang_da_giam_tru", 0);
            v_obj.ExecuteCommand(this);
            op_dc_thang_da_giam_tru = CIPConvert.ToDecimal(v_dc_thang_da_giam_tru.Value);
        }

        //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 void get_thong_tin_qua_trinh_tinh_luong(decimal ip_thang, decimal ip_nam, out decimal op_sl_nv_can_tinh_luong, out decimal op_sl_nv_da_tinh_luong)
        {
            op_sl_nv_can_tinh_luong = 0;
            op_sl_nv_da_tinh_luong = 0;

            CStoredProc v_sp = new CStoredProc("pr_get_thong_tin_qua_trinh_tinh_luong");
            v_sp.addDecimalInputParam("@ip_dat_thang", ip_thang);
            v_sp.addDecimalInputParam("@ip_dat_nam", ip_nam);

            SqlParameter v_para_all = v_sp.addDecimalOutputParam("@op_dc_so_luong_nv_tinh_luong", 0);
            SqlParameter v_para_da_tinh = v_sp.addDecimalOutputParam("@op_dc_so_luong_da_tinh_luong", 0);

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

        public void Find_ID_GD_DIEM_DANH(decimal ip_dc_id_lop_mon, DateTime ip_dat_tai_ngay, ref decimal op_dc_id_gd_diem_danh)
        {
            CStoredProc v_obj = new CStoredProc("pr_get_id_diem_danh_by_id_lop_mon_va_ngay_diem_danh");

            v_obj.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
            v_obj.addDatetimeInputParam("@ip_dat_tai_ngay", ip_dat_tai_ngay);
            SqlParameter v_id_gd_diem_danh = v_obj.addDecimalOutputParam("@op_dc_id_gd_diem_danh", 0);
            v_obj.ExecuteCommand(this);
            op_dc_id_gd_diem_danh = CIPConvert.ToDecimal(v_id_gd_diem_danh.Value);
        }

        public void FillDataset_2_lbl_tong_so(DS_V_F316_DM_HOC_SINH_LOP_MON op_ds_tong_so_hoc_sinh,
            decimal ip_dc_id_lop_mon,
            ref decimal op_dc_tong_so_hoc_sinh)
        {
            CStoredProc v_obj_spr = new CStoredProc("pr_tinh_tong_so_hoc_sinh_theo_lop_mon");
            v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
            SqlParameter v_tong_so_hoc_sinh = v_obj_spr.addDecimalOutputParam("@op_dc_tong_so_hoc_sinh", op_dc_tong_so_hoc_sinh);

            v_obj_spr.fillDataSetByCommand(this, op_ds_tong_so_hoc_sinh);

            op_dc_tong_so_hoc_sinh = CIPConvert.ToDecimal(v_tong_so_hoc_sinh.Value);
        }