namespace HStation.Service.Assets
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public class DbFirstHelper
|
{
|
/// <summary>
|
/// 初始化
|
/// </summary>
|
public static bool Initial(out string msg)
|
{
|
msg = string.Empty;
|
try
|
{
|
var connectConfig = HStation.Assets.ConfigHelper.DefaultConnectionConfig;
|
if (connectConfig == null)
|
{
|
msg = "连接配置初始化失败";
|
return false;
|
}
|
|
connectConfig.ConfigureExternalServices = new ConfigureExternalServices()
|
{
|
EntityService = (property, column) =>
|
{
|
//除主键外其他列都可空
|
if (!column.IsPrimarykey)
|
{
|
column.IsNullable = true;
|
}
|
if (column.DataType == StaticConfig.CodeFirst_BigString)
|
{
|
if (Settings.AssetsParasHelper.Assets.DataBase.DbType == HStation.Assets.DbType.PostgreSql)
|
{
|
column.DataType = "character varying";
|
}
|
}
|
}
|
};
|
|
var typeList = new List<Type>()
|
{
|
typeof(Entity.AssetsPumpGroup),
|
typeof(Entity.AssetsPumpGroupAndMainMapping),
|
typeof(Entity.AssetsPumpMain),
|
typeof(Entity.AssetsPumpMainAndPartMapping),
|
typeof(Entity.AssetsPumpPartMain),
|
typeof(Entity.AssetsPumpPropContent),
|
typeof(Entity.AssetsPumpSeries),
|
typeof(Entity.AssetsPumpType),
|
typeof(Entity.AssetsPumpSeriesTypeMapping),
|
typeof(Entity.AssetsPumpSeriesManufacturerMapping),
|
|
//阀门
|
typeof(Entity.AssetsValveMain),
|
typeof(Entity.AssetsValveSeries),
|
typeof(Entity.AssetsValveCoefficient),
|
|
//弯头
|
typeof(Entity.AssetsElbowMain),
|
typeof(Entity.AssetsElbowSeries),
|
typeof(Entity.AssetsElbowCoefficient),
|
|
//三通
|
typeof(Entity.AssetsThreelinkMain),
|
typeof(Entity.AssetsThreelinkSeries),
|
typeof(Entity.AssetsThreelinkCoefficient),
|
|
//四通
|
typeof(Entity.AssetsFourlinkMain),
|
typeof(Entity.AssetsFourlinkSeries),
|
typeof(Entity.AssetsFourlinkCoefficient),
|
|
//管道
|
typeof(Entity.AssetsPipeMain),
|
typeof(Entity.AssetsPipeSeries),
|
typeof(Entity.AssetsPipeCoefficient),
|
|
//喷头
|
typeof(Entity.AssetsSprinklerMain),
|
typeof(Entity.AssetsSprinklerSeries),
|
typeof(Entity.AssetsSprinklerCoefficient),
|
|
//厂商
|
typeof(Entity.AssetsManufacturer),
|
typeof(Entity.AssetsManufacturerMapping),
|
|
//自定义
|
typeof(Entity.AssetsUserDefined),
|
|
//空压机
|
typeof(Entity.AssetsExchangerMain),
|
typeof(Entity.AssetsExchangerMainAndPartMapping),
|
typeof(Entity.AssetsExchangerPartMain),
|
typeof(Entity.AssetsExchangerPropContent),
|
typeof(Entity.AssetsExchangerSeries),
|
typeof(Entity.AssetsExchangerCoefficient),
|
|
//换热器
|
typeof(Entity.AssetsCompressorPartMain),
|
typeof(Entity.AssetsCompressorMain),
|
typeof(Entity.AssetsCompressorMainAndPartMapping),
|
typeof(Entity.AssetsCompressorPropContent),
|
typeof(Entity.AssetsCompressorSeries),
|
typeof(Entity.AssetsCompressorCoefficient),
|
|
//成套设备
|
typeof(Entity.AssetsPackageMain),
|
typeof(Entity.AssetsPackagePumpMapping),
|
typeof(Entity.AssetsPackageSeries),
|
};
|
|
using (var db = new SqlSugarClient(connectConfig))
|
{
|
//设置字符串默认长度
|
//db.CodeFirst.SetStringDefaultLength(250);
|
//db.CodeFirst.SetStringDefaultLength(int.MaxValue);
|
//建库：如果不存在创建数据库存在不会重复创建 createdb;注意 ：Oracle和个别国产库需不支持该方法，需要手动建库
|
db.DbMaintenance.CreateDatabase();
|
db.CodeFirst.InitTables
|
(
|
typeList.ToArray()
|
);
|
}
|
|
return true;
|
}
|
catch (Exception ex)
|
{
|
msg = ex.Message;
|
return false;
|
}
|
}
|
}
|
}
|
