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