using System.Data;
using Estsh.Core.Models;
using Estsh.Core.Repository.IRepositories;
using Estsh.Core.Services.IServices;
using Estsh.Core.Model.Result;
using Estsh.Core.Model.Models;
using Estsh.Core.Util;
using Estsh.Core.Dapper;

/***************************************************************************************************
 *
 * 更新人：sitong.dong
 * 描述：无条码收货
 * 修改时间：2022.06.22
 * 修改日志：系统迭代升级
 *
 **************************************************************************************************/
namespace Estsh.Core.Services
{
    public class PurchaseNoBarcodeService : BaseService<SysStock>, IPurchaseNoBarcodeService
    {
        private readonly IPurchaseNoBarcodeRepository repository;

        public PurchaseNoBarcodeService(IPurchaseNoBarcodeRepository _repository) : base(_repository)
        {
            repository = _repository;
        }

        public List<SysStock> getQueryByPage(string whereStr, Pager pager, string direction, string sort)
        {
            string where = " 1=1 ";
            if (!string.IsNullOrEmpty(whereStr))
            {
                where += whereStr;
            }
            String orderBy = "";
            if (sort != null && !"".Equals(sort.Trim()))
            {
                orderBy += typeof(SysStock).GetEntityColumnName(sort.Trim()) + " " + direction;
            }
            else
            {
                orderBy += " ruid " + direction;
            }
            List<SysStock> result = repository.getQueryByPage(pager.pageSize, pager.pageNo, where, orderBy);
            return result;
        }

        /// <summary>
        /// 获取服务器日期、时间
        /// </summary>
        /// <param name="flag">格式标志</param>
        /// <returns></returns>
        public string GetServerDateTime(string flag)
        {
          return  repository.GetServerDateTime(flag);
        }
        /// <summary>
        /// 生产单据号
        /// </summary>
        /// <param name="item"></param>
        /// <param name="prefix"></param>
        /// <returns></returns>
        public string GetOrderNo(string item, string prefix)
        {
            return repository.GetOrderNo(item, prefix);
        }

        public int delete(String ids)
        {
            return repository.delete(ids);
        }

        /// <summary>
        /// 启用
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public int EnableData(String ids)
        {
            ids = ids.Substring(0, ids.Length - 1);
            return this.repository.EnableData(ids);
        }

        /// <summary>
        /// 禁用
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public int DisableData(String ids)
        {
            ids = ids.Substring(0, ids.Length - 1);
            return this.repository.DisableData(ids);
        }


        /// <summary>
        /// 获取厂区内容
        /// </summary>
        /// <returns></returns>
        public List<KeyValueResult> GetFactoryInfo()
        {
            return repository.GetFactoryInfo();
        }

        /// <summary>
        /// 获取厂区代码
        /// </summary>
        /// <returns></returns>
        public string GetFactoryId(int userID)
        {
            return repository.GetFactoryId(userID);
        }

        /// <summary>
        /// 获取项目、车型内容
        /// </summary>
        /// <returns></returns>
        public List<KeyValueResult> GetModelType()
        {
            return repository.GetModelType();
        }

        /// <summary>
        /// 获取供应商信息
        /// </summary>
        /// <returns></returns>
        public List<SysVendor> GetVendorInfo(string key)
        {
            return repository.GetVendorInfo(key);
        }

        /// <summary>
        /// 获取采购单编号
        /// </summary>
        /// <returns></returns>
        public List<dynamic> GetBuyNoInfo(string key)
        {
            return repository.GetBuyNoInfo(key);
        }

        /// <summary>
        /// 获了零件信息
        /// </summary>
        /// <param name="type">零件类型</param>
        /// <returns></returns>
        public List<SysPart> GetPartInfo(int type,string part_no)
        {
            return repository.GetPartInfo(type, part_no);
        }

        /// <summary>
        /// 是否为采购单内零件
        /// </summary>
        /// <param name="buyNo">采购单</param>
        /// <param name="partNo">零件号</param>
        /// <returns></returns>
        public bool IsPoPartNo(string buyNo, string partNo)
        {
            return repository.IsPoPartNo(buyNo, partNo);
        }

        public string DataSaveTransact(DataTable dtData, int userID)
        {
            return repository.DataSaveTransact(dtData,userID);
        }

        /// <summary>
        /// 箱条码生成(零件号(18)+批号(6)+流水号(3))
        /// </summary>
        /// <param name="partNo">零件号</param>
        /// <param name="lotNo">批号</param>
        /// <param name="seq">流水号</param>
        /// <returns></returns>
        public string GetCartonNo(string partNo, string lotNo, int seq)
        {
            return repository.GetCartonNo(partNo, lotNo, seq);
        }

        /// <summary>
        /// 验证零件是否存在线边库位
        /// </summary>
        /// <param name="partNo">零件号所在行ID</param>
        /// <returns></returns>
        public bool IsExistLineLocate(string partId)
        {
            return repository.IsExistLineLocate(partId);
        }

        /// <summary>
        /// 验证线边库位是否存在相应零件库存
        /// </summary>
        /// <param name="partId">零件号所在行ID</param>
        /// <param name="lotNo">批号</param>
        /// <returns></returns>
        public bool IsExistPartLotNo(string partId, string lotNo)
        {
            return repository.IsExistPartLotNo(partId, lotNo);
        }
    }
}