/// <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); } }