/// <summary>
/// 初始化设备模型和类型表
/// </summary>
public void InitDevModelAndType()
{
////设备模型信息\\DevTypeModel.sql
//string initFile = AppDomain.CurrentDomain.BaseDirectory + "Data\\设备模型信息\\DevTypeModel.sql";
//if (File.Exists(initFile))
//{
// try
// {
// string txt = File.ReadAllText(initFile);
// int count = Db.Database.ExecuteNonQuery(txt);
// }
// catch (Exception ex)
// {
// Log.Error("执行sql语句失败", ex);
// }
//}
//else
//{
// Log.Info("sql文件不存在:" + initFile);
//}
//因为sqlite不支持改成从表格导入
var list = DbInfoHelper.GetDevModels();
DevModels.AddRange(list);
var list2 = DbInfoHelper.GetDevTypes();
DevTypes.AddRange(list2);
}
/// <summary>
/// 初始化设备模型和类型表
/// </summary>
public void InitDevModelAndType()
{
var list = DbInfoHelper.GetDevModels();
DevModels.AddRange(list);
var list2 = DbInfoHelper.GetDevTypes();
DevTypes.AddRange(list2);
}
/// <summary>
/// 新增数据库中没有增加的设备模型
/// </summary>
/// <param name="resultAction"></param>
public void AddDevModelTypeByExcel(Action <int, int> resultAction = null)
{
int modelCount = 0;
int typeCount = 0;
var list = DbInfoHelper.GetDevModels();
var devModelList = DevModels.ToList();
List <DevModel> newModels = new List <DevModel>();
foreach (var item in list)
{
if (string.IsNullOrEmpty(item.Name))
{
continue;
}
if (devModelList == null)
{
newModels.Add(item);
}
else
{
DevModel model = devModelList.Find(i => i.Name == item.Name);
if (model == null)
{
newModels.Add(item);
}
}
}
if (newModels.Count != 0)
{
modelCount = newModels.Count;
DevModels.AddRange(newModels);
}
var list2 = DbInfoHelper.GetDevTypes();
var devTypeList = DevTypes.ToList();
List <DevType> newTypes = new List <DevType>();
foreach (var item in list2)
{
if (string.IsNullOrEmpty(item.TypeName))
{
continue;
}
if (devTypeList == null)
{
newTypes.Add(item);
}
else
{
DevType model = devTypeList.Find(i => i.TypeName == item.TypeName);
if (model == null)
{
newTypes.Add(item);
}
}
}
if (newTypes.Count != 0)
{
typeCount = newTypes.Count;
DevTypes.AddRange(newTypes);
}
ClearModelTypeNullData(devModelList, DevModels, devTypeList, DevTypes);
if (resultAction != null)
{
resultAction(modelCount, typeCount);
}
}
