DEMOMySql/MicroServices/Procurement/Procurement.Host/Services/Common.cs

using System.Text;
using System.Threading.Tasks;
using System;
using System.Collections.Generic;
using Procurement.ViewModel;
using System.Text.Json;
using Procurement.EntityFrameworkCore.SqlRepositories;
using Procurement.Controllers;
using System.Collections;
using Procurement.Enums;
using Volo.Abp.Domain.Repositories;
using System.Data.SqlClient;
using System.Data;

namespace Procurement.Services
{
    public class Common
    {
        private readonly ISqlRepository _repository;

        public Common(ISqlRepository sqlRepository)
        {
            _repository = sqlRepository;
        }

        public async Task<dynamic> GetCommonItems(string domain, string type, string keyword = "", string keyword2 = "")
        {
            SqlParameter[] parameters = {
                                               new SqlParameter { ParameterName = "@Domain", Value = domain,SqlDbType=SqlDbType.VarChar },
                                               new SqlParameter { ParameterName = "@Type", Value = type,SqlDbType=SqlDbType.VarChar },
                                               new SqlParameter { ParameterName = "@KeyWord", Value = keyword,SqlDbType=SqlDbType.VarChar },
                                               new SqlParameter { ParameterName = "@KeyWord2", Value = keyword2,SqlDbType=SqlDbType.VarChar },
                                           };
            dynamic items = await _repository.GetSingleListByProcAsync("pr_WMS_GetCommonList", parameters);
            return items;
        }
    }
}