using LampInspectionMachine.Model;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LampInspectionMachine.DataBase
{
    public class SqlSugarHelper
    {

        public static SqlSugarScope Db = new SqlSugarScope(new ConnectionConfig()
        {
            ConnectionString = "datasource=Project.db",//连接符字串
            DbType = DbType.Sqlite,//数据库类型
            IsAutoCloseConnection = true //不设成true要手动close
        },
         db =>
         {

             db.Aop.OnLogExecuting = (sql, pars) =>
             {


                 Console.WriteLine(UtilMethods.GetNativeSql(sql, pars));


             };

         });


        public static void CreataDatabase()
        {

            //建库
            Db.DbMaintenance.CreateDatabase("ProjectData");
            CreataDataTable();
        }


        public static void CreataDataTable()
        {
            //建表 
            Db.CodeFirst.InitTables<ProjectData>();

            //Db.CodeFirst.InitTables<SettingModel>();

          
        }

      

        public static List<ProjectData> QueryablePage(int pagenumber)
        {
            return Db.Queryable<ProjectData>().ToPageList(pagenumber, 50);
        }
        public static List<ProjectData> QueryableTake()
        {
            //查询 
            return Db.Queryable<ProjectData>().Take(30).OrderBy(it => it.id, OrderByType.Desc).ToList();
        }

   
        public static List<ProjectData> QueryableProjectData()
        {
            //查询 
            return Db.Queryable<ProjectData>().ToList();
        }

        

        public static List<ProjectData> QueryableBySn(string sn)
        {
            //条件查询
            return Db.Queryable<ProjectData>().Where(it => it.orderId == sn).ToList();
        }
        

      
      
        public static void Insertable(ProjectData data)
        {

            //插入
            Db.Insertable(data).ExecuteCommand();
        }
        public static void Updateable(ProjectData data)
        {

            //更新
           // Db.Updateable(data).ExecuteCommand(); //注意  需要条件
        }
    

       

       

      
        public static void Updateable()
        {

            //删除
            Db.Deleteable<ProjectData>().Where(it => it.id == 1).ExecuteCommand();
        }




    }
}