everlight.eap/backend/DllEapDal/FileParamsDal.cs

using Cksoft.Data;
using Cksoft.Unity;
using DllEapEntity;
using System;
using System.Collections.Generic;
using System.Linq;
using DllEapEntity.Dtos;
namespace DllEapDal
{
    public class FileParamsDal
    {
        private IDatabase CurrDb = null;
        public FileParamsDal(IDatabase db)
        {
            CurrDb = db;
        }
        public int ImportFileParams(int modelid,List<FileParams> fileparam, string usercode, ref string errorinfo)
        {
            try
            {
                //删除机型参数
                string sqlstr = $"delete from fileparams where modelid={modelid}";
                CurrDb.ExecuteBySql(sqlstr);
                //批量插入
                CurrDb.InsertFor<FileParams>(fileparam, usercode);
                return 1;
            }
            catch (Exception e)
            {
                errorinfo = e.Message;
                return -1;
            }
        }


        #region Web
        public IEnumerable<FileParams> GetFileParams(string filter)
        {
            string errorinfo = string.Empty;
            return CurrDb.FindListForCondition<FileParams>(filter, ref errorinfo);
        }
        #endregion

    }
}