using Dapper;
using Estsh.Core.Model.ExcelModel;
using Estsh.Core.Model.Result;
using Estsh.Core.Models;
using Estsh.Core.Repositories;
using Estsh.Core.Util;

namespace Estsh.Core.Repository.IRepositories
{
    public interface ISerialNumberQueryRepository : IBaseRepository<GSnKeyparts>
    {
        public List<KeyValueResult> GetPartNo();
        public List<GSnKeyparts> GetSNInfo(string whereStr, Pager pager, ref int totalCount);
        public List<GSnStatus> GetSNCurrentData(string whereStr, Pager pager, ref int totalCount);
        public List<SerialNumberQuery> getTableListByPage(string whereStr, Pager pager, ref int totalCount);
        public string kpsnGetSN(string sn);
        public bool IsSerialNumberQueryHistory();
        public List<GSnTravel> GetSNTravelData(string whereStr, Pager pager, ref int totalCount);
        public List<GSnKeydata> GetKeyData(string whereStr, Pager pager, ref int totalCount);
        public List<SysKeydata> DTtemp(string sn);
        public List<GSnKeyparts> GetKeyParts(string whereStr, Pager pager, ref int totalCount);
        public List<GSnDefect> GetRepairDetials(string whereStr, Pager pager, ref int totalCount);
        public List<GSnKeyparts> GetKPSN(string srcSN);
        public List<GSnKeyparts> valiDationKPSN(string strKPSN);
        public string GetPSN(string srcSN);
        public List<SysModel> GetSNModelTypeInfo(string sn);
        public List<SysPart> GetSNPartInfo(string sn);

        public List<GSnStatus> GetSNBasicInfo(string sn);
        public List<SysPartSnRule> getPartSnRule();
    }
}