internal void InitialDataSourceSystem() { var fileName = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager .AppSettings["DataSourceSystem"]); ReadFromExcel readFromExcel = new ReadFromExcel(); //按Row获取当前行的所有数据 int rowCount = readFromExcel.GetRowCount(fileName); for (int i = 2; i <= rowCount; i++) { var columnData = readFromExcel.ReadRowFromExcel((uint)i, fileName); //获取第一个数为来源系统名称 //数据必须大于等2才是正确的 if (columnData.Count >= 2) { WriteBaseData writeBaseData = new WriteBaseData(); //第二列为来源系统Guid DataSourceSystem dataSourceSystem = new DataSourceSystem(); dataSourceSystem.Name = columnData.ElementAt(0); dataSourceSystem.ID = Guid.Parse(columnData.ElementAt(1)); //写入数据库 dataSourceSystem = writeBaseData.AddDataSourceSystem(dataSourceSystem); } } }
internal DataSourceSystem AddDataSourceSystem(DataSourceSystem dataSourceSystem) { DataSourceSystem item = null; if (dataSourceSystem != null && dataSourceSystem.Name == null) { return(item); } using (ImsDbContext context = new ImsDbContext()) { //先用ID查重 if (dataSourceSystem.ID != null) { item = context.DataSourceSystems.Find(dataSourceSystem.ID); } //或用Name查重 else { if (dataSourceSystem.Name != null) { item = context.DataSourceSystems.Where(d => d.Name == dataSourceSystem.Name).FirstOrDefault(); } } if (item == null) { //如果为null,说明数据库不存在该项,添加 item = dataSourceSystem; context.DataSourceSystems.Add(item); context.SaveChanges(); } } return(item); }