using Dapper;
using Estsh.Core.Base;
using Estsh.Core.Models;
using Estsh.Core.Repositories;

namespace Estsh.Core.Repository.IRepositories
{
    public interface ISAPOrderImportRepository : IBaseRepository<BaseEntity>
    {

        #region 公共方法
        public List<SysPart> getPartInfo(string partNo);
        public List<SysFactory> getFactoryInfo(string factoryCode);
        public List<SysFactory> getFactoryCode();
        public List<SysWarehouse> getErpWarehouseInfo(string erpWarehouse);
        public List<SysVendor> getVendorInfo(string vendorCode);
        public List<SysCustomer> getCustomerInfo(string customCode);
        public bool ExecuteSqlTransaction(List<string> SqlStrings);
        public bool ExecuteSqlTransaction(List<string> SqlStrings, List<DynamicParameters> Parameters,ref string msg);

        #endregion

        #region 采购计划

        public string GetWeekNo();
        public string GetOrderNo();
        public string GetMonthOrderNo();
        public string InsertSAPOData();
        public string InsertMonthlyPlanData();

        public List<SapDspo> IfZDATE(string zdate, string lifnr, string zcjsj);

        public bool delDSPO(string zdate, string lifnr);

        public string updateSapDspo(string EBELN, string REVNO, int EVRTP, string LIFNR, string MATNR,
            string ZDEV_NUM, string UNIT, string PSTYP, string ZDATE, string ZCJSJ, string WERKS,
            string LGORT, string ZPZPS, string ZSTAS, decimal BSTRF);

        public string insertSapDspo(string EBELN, string REVNO, int EVRTP, string LIFNR, string MATNR,
            string ZDEV_NUM, string UNIT, string PSTYP, string ZDATE, string ZCJSJ, string WERKS,
            string LGORT, string ZPZPS, string ZSTAS, decimal BSTRF);
        public List<SapDspo> getSapDspoInfo(string ebeln, string evrtp);

        #endregion

        #region 零星出入库
        /// <summary>
        /// 根据编号和行号获取零星出入库指令信息
        /// </summary>
        /// <param name="zinstNo"></param>
        /// <param name="zeile"></param>
        /// <returns></returns>
        public List<SapMisco> getSapMiscoInfo(string zinstNo, string zeile);
        public string getUpdateSapMisco(string ZINSTNO, string ZEILE, string WERKS, string LGORT, string MATNR,
            string ERFMG, string ERFME, string SOBKZ, string HTEXT, string ZZLZT, string ZACTION);
        public string getInsertSapMisco(string ZINSTNO, string ZEILE, string WERKS, string LGORT, string MATNR,
            string ERFMG, string ERFME, string SOBKZ, string HTEXT, string ZZLZT, string ZACTION);
        #endregion

        #region 非JIS发运
        /// <summary>
        /// 根据编号和行号获取非JIS发运指令
        /// </summary>
        /// <param name="vbeln"></param>
        /// <param name="postnr"></param>
        /// <returns></returns>
        public List<SapDn> getSapDnInfo(string vbeln, string postnr);
        public string getInsertSapDn(string VBELN, string POSNR, string WERKS, string LGORT, string LFDAT,
            string KUNNR, string MATNR, string KDMAT, string LFIMG, string MEINS);
        #endregion

        #region  SAP供应商退货指令（SMRR/DMR)

        /// <summary>
        /// 根据编号和行号获取供应商退货指令信息
        /// </summary>
        /// <param name="zinstno"></param>
        /// <param name="zeile"></param>
        /// <returns></returns>
        public List<SapReto> getSapRetoInfo(string zinstno, string zeile);

        public string getUpdateSapReto(string ZACTION, string ZINSTNO, string ZEILE, string LIFNR, string UMWRK, string MATNR,
           string LGORT, string ERFMG, string ERFME, string BKTXT, string ZQMD, string ZZLZT);

        public string getInsertSapReto(string ZACTION, string ZINSTNO, string ZEILE, string LIFNR, string UMWRK, string MATNR,
           string LGORT, string ERFMG, string ERFME, string BKTXT, string ZQMD, string ZZLZT);

        #endregion

        #region SAP NC入库指令

        public List<SapMovo> getSapMovoInfo(string refid, string zeile);

        public string getUpdateSapMovo(string REFID, string ACTION, string ZEILE, string WERKS, string LGORT, string UMLGO,
            string MATNR, string UMMAT, string ERFMG, string ERFME, string ZSTAT, string SOBKZ, string HTEXT, string ZZLZT, string SGTXT, string ORDTYP);

        public string getInsertSapMovo(string REFID, string ACTION, string ZEILE, string WERKS, string LGORT, string UMLGO,
            string MATNR, string UMMAT, string ERFMG, string ERFME, string ZSTAT, string SOBKZ, string HTEXT, string ZZLZT, string SGTXT, string ORDTYP);
        #endregion

        #region  SAP 盘点表

        public List<SapCyco> getSapCycoInfo(string iblnr, string zeili);
        public string getInsertSapCyco(string IBLNR, string ZEILI, string MATNR, string MEINS, string WERKS, string LGORT, string ZSTAT, string SOBKZ, string ZXM,
            string ZDJBS, string XLOEK, string GJAHR);

        #endregion

        #region  SAP 盘点调差指令

        public List<SapDifo> getSapDifoInfo(string iblnr, string zeili);
        public string getInsertSapDifo(string WERKS, string IBLNR, string ZEILI, string ZTZBS, string GJAHR);
        public List<WmsCheckStock> getCheckStockInfo(string orderNo);
        #endregion

        #region  销售退货收货指令

        public List<SapRdn> getSapRdnInfo(string vbeln, string postnr);

        public string getInsertSapRdn(string VBELN, string POSNR, string WERKS, string LGORT, string LFDAT, string KUNNR,
            string MATNR, string LFIMG, string MEINS);
        #endregion
    }
}