CentrifugalTime/DataBase/SqlSugarHelper.cs

using DefaultEdit.Model;
using SqlSugar;
using System;
using System.Collections.Generic;

namespace DefaultEdit.DataBase
{
    public class SqlSugarHelper
    {

        public static SqlSugarScope Db = new SqlSugarScope(new ConnectionConfig()
        {
            ConnectionString = "DataSource=Project; ",//连接符字串  Data Source=127.0.0.1; Port=3306;User Id=root; Password=root;Charset=utf8;TreatTinyAsBoolean=false;
            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<tb_formulasdata>();
        }



        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<tb_formulasdata> Queryabletb_formulasdata()
        {
            //查询 
            return Db.Queryable<tb_formulasdata>().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();
        }




    }
}