using DataEntity.Device;
|
using DataEntity.Page;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Configuration;
|
using System.Data;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Text;
|
using System.Threading.Tasks;
|
using XCommon.SqlSugar;
|
using DbType = SqlSugar.DbType;
|
|
namespace DataRWDAL.Base
|
{
|
public class BaseDB
|
{
|
/// <summary>
|
/// 数据库连接信息
|
/// </summary>
|
private static readonly string m_connString = ConfigurationManager.AppSettings["mysqlstring"];
|
|
/// <summary>
|
/// DB实例化
|
/// </summary>
|
/// <returns></returns>
|
public static SqlSugarClient GetInstance()
|
{
|
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
|
{
|
ConnectionString = m_connString,
|
DbType = DbType.MySql,
|
IsAutoCloseConnection = true,
|
ConfigureExternalServices = new ConfigureExternalServices()
|
{
|
SqlFuncServices = ExtMethods.GetExpMethods,
|
}
|
});
|
|
db.Ado.IsEnableLogEvent = true;
|
return db;
|
}
|
|
/// <summary>
|
/// 获取分页数据
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="pagination"></param>
|
/// <param name="whereExpression"></param>
|
/// <param name="orderExpression"></param>
|
/// <param name="orderType"></param>
|
/// <returns></returns>
|
public static Tuple<List<T>, int> GetPage<T>(Pagination pagination, Expression<Func<T, bool>> whereExpression,
|
Expression<Func<T, object>> orderExpression, OrderByType orderType)
|
{
|
using (var db = GetInstance())
|
{
|
var totalCount = 0;
|
List<T> lstResult = null;
|
if (orderExpression == null)
|
{
|
lstResult = db.Queryable<T>().Where(whereExpression).ToPageList(pagination.Current, pagination.PageSize, ref totalCount).ToList();
|
}
|
else
|
{
|
lstResult = db.Queryable<T>().Where(whereExpression).OrderBy(orderExpression, orderType).
|
ToPageList(pagination.Current, pagination.PageSize, ref totalCount).ToList();
|
}
|
|
return new Tuple<List<T>, int>(lstResult, totalCount);
|
}
|
}
|
|
public static List<T> GetList<T>(int topNum, Expression<Func<T, bool>> whereExpression, Expression<Func<T, object>> orderExpression, OrderByType orderType)
|
{
|
using (var db = GetInstance())
|
{
|
var _list = new List<T>();
|
if (orderExpression == null)
|
{
|
if (topNum == -1)
|
{
|
_list = db.Queryable<T>().Where(whereExpression).ToList();
|
}
|
else
|
{
|
_list = db.Queryable<T>().Where(whereExpression).Take(topNum).ToList();
|
}
|
}
|
else
|
{
|
if (topNum == -1)
|
{
|
_list = db.Queryable<T>().Where(whereExpression).OrderBy(orderExpression, orderType).ToList();
|
}
|
else
|
{
|
_list = db.Queryable<T>().Where(whereExpression).OrderBy(orderExpression, orderType).Take(topNum).ToList();
|
}
|
}
|
return _list;
|
}
|
}
|
|
public static void CreateClassFile()
|
{
|
using (var db = GetInstance())
|
{
|
//db.DbFirst.CreateClassFile(@"D:\Model\bak", "FlowManage.Model.Model");
|
|
db.DbFirst
|
.SettingClassTemplate(old =>
|
{
|
return "{using}\r\n\r\nnamespace {Namespace}\r\n{\r\n\t{ClassDescription}{SugarTable}\r\n\tpublic partial class {ClassName} : BaseModel\r\n\t {\r\n\t{PropertyName}\r\n\t }\r\n}\r\n\r\n";
|
})
|
.SettingNamespaceTemplate(old =>
|
{
|
//修改using命名空间
|
return "using SqlSugar;\r\nusing System;\r\nusing System.ComponentModel;\r\nusing System.Linq;\r\nusing System.Text;";
|
})
|
.SettingPropertyDescriptionTemplate(old =>
|
{
|
return @" /// <summary>
|
/// {PropertyDescription}
|
/// </summary>";
|
})
|
.SettingPropertyTemplate(old =>
|
{
|
return old;
|
})
|
//.SettingConstructorTemplate(old =>
|
// {
|
// return old;//修改构造函数
|
// })
|
.CreateClassFile(@"D:\Model\bak", "FlowManage.Model.Model");
|
}
|
}
|
}
|
}
|
