using ATC_MaterialBind.Entity;
using Microsoft.Extensions.Logging;
using SlnMesnac.Model.domain;
using SlnMesnac.Repository.service.@base;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Threading.Tasks;

namespace SlnMesnac.Repository.service.Impl
{
    public class StationQualityInfoServiceImpl : BaseServiceImpl<StationQualityInfo>, IStationQualityInfoService
    {
        private Repository<StationQualityInfo> _repository;
        public StationQualityInfoServiceImpl(Repository<StationQualityInfo> repository ):base(repository)
        {
            _repository = repository;
        }

        public async Task<List<StationQualityInfo>> GetProductQuality(string P_Bar_Code, string P_StationCode)
        {
            List<StationQualityInfo> stationQualityList = null;
            try
            {
                var parameter1 = new SugarParameter("@BarCode", P_Bar_Code);
                var parameter2 = new SugarParameter("@StationCode", P_StationCode);//ÉèÖÃΪoutput
                stationQualityList = _repository.Context.Ado.UseStoredProcedure().SqlQuery<StationQualityInfo>("pro_AllProductionQualityInfo", parameter1, parameter2);
                return stationQualityList;
            }
            catch (Exception ex)
            {
                return stationQualityList;
            }
        }
        public string GetNewMainBarcode()
        {
            try
            {
                var parameter1 = new SugarParameter("@Head", "M");
                var dt = _rep.Context.Ado.UseStoredProcedure().GetString("SP_Pro_GetNewMainBarcode", parameter1);
                return dt;
            }
            catch (Exception ex)
            {

                throw;
            }
        }
    }
}