/// <summary>
/// 初始化科室类别.
/// </summary>
/// <exception cref="NotImplementedException"></exception>
internal void InitialDepartmentCategory()
{
var fileName = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager
.AppSettings["DepartmentCategory"]);
//第一列为类别的名称，第二列开始为Guid
ReadFromExcel readFromExcel = new ReadFromExcel();
//按Row获取当前行的所有数据
int rowCount = readFromExcel.GetRowCount(fileName);
for (int i = 2; i <= rowCount; i++)
{
var columnData = readFromExcel.ReadRowFromExcel((uint)i, fileName);
//获取第一个数为类别
//第二列为类别的Guid,数据必须大于等2才是正确的
if (columnData.Count >= 2)
{
//var firstData = columnData.First();
WriteBaseData writeBaseData = new WriteBaseData();
DepartmentCategory departmentCategory = new DepartmentCategory();
departmentCategory.Name = columnData.ElementAt(0);
departmentCategory.DepartmentCategoryID = Guid.Parse(columnData.ElementAt(1));
//写入数据库
departmentCategory = writeBaseData.AddDepartmentCategory(departmentCategory);
}
}
}
internal void InitialIndicatorAlgorithm()
{
var fileName = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager
.AppSettings["IndicatorAlgorithm"]);
ReadFromExcel readFromExcel = new ReadFromExcel();
//按Row获取当前行的所有数据
int rowCount = readFromExcel.GetRowCount(fileName);
for (int i = 2; i <= rowCount; i++)
{
var columnData = readFromExcel.ReadRowFromExcel((uint)i, fileName);
//数据必须大于等5才是正确的
//第1列为结果项目的Guid,
//第2列为第一个项目的Guid
//第3列为第二个项目的Guid
//第4列为操作符
//第5列为备注
if (columnData.Count >= 5)
{
//var firstData = columnData.First();
WriteBaseData writeBaseData = new WriteBaseData();
IndicatorAlgorithm indicatorAlgorithm = new IndicatorAlgorithm();
indicatorAlgorithm.ResultOperationID = Guid.Parse(columnData.ElementAt(0));
indicatorAlgorithm.FirstOperationID = Guid.Parse(columnData.ElementAt(1));
indicatorAlgorithm.SecondOperationID = Guid.Parse(columnData.ElementAt(2));
indicatorAlgorithm.Operation = columnData.ElementAt(3);
indicatorAlgorithm.Remarks = columnData.ElementAt(4);
indicatorAlgorithm.ID = System.Guid.NewGuid();
writeBaseData.AddIndicatorAlgorithm(indicatorAlgorithm);
}
}
}
/// <summary>
/// 初始化Indicator项目
/// </summary>
public void InitialIndicator()
{
var indicatorFile = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["Indicator"]);
ReadFromExcel readFromExcel = new ReadFromExcel();
//按Row获取当前行的所有数据
//先获Row总数，从第二行开始取数据，第一行为标题
int rowCount = readFromExcel.GetRowCount(indicatorFile);
for (int i = 2; i <= rowCount; i++)
{
var columnData = readFromExcel.ReadRowFromExcel((uint)i, indicatorFile);
//将该列按照IndicatorItem录入，再插入到数据库
if (columnData.Count >= 8)
{
IndicatorItem indicatorItem = new IndicatorItem();
//按照顺序填充
indicatorItem.Name = columnData.ElementAt(0);
indicatorItem.Unit = columnData.ElementAt(1);
indicatorItem.IsAuto = columnData.ElementAt(2);
indicatorItem.DataSystem = columnData.ElementAt(3);
indicatorItem.Department = columnData.ElementAt(4);
indicatorItem.Remarks = columnData.ElementAt(5);
indicatorItem.DutyDepartment = columnData.ElementAt(6);
indicatorItem.GuidId = Guid.Parse(columnData.ElementAt(7));
//写入数据库
WriteBaseData writeBaseData = new WriteBaseData();
writeBaseData.AddIndicator(indicatorItem);
}
}
}
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);
}
}
}
public void InitialDepartmentCategoryIndicatorMap()
{
var fileName = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["DepartmentCategoryIndicatorMap"]);
ReadFromExcel readFromExcel = new ReadFromExcel();
//按Row获取当前行的所有数据
//第一行为列标题，第二行开始是数据
int rowCount = readFromExcel.GetRowCount(fileName);
for (int i = 2; i <= rowCount; i++)
{
var columnData = readFromExcel.ReadRowFromExcel((uint)i, fileName);
//获取第一个数为科室类别
if (columnData.Count >= 2)
{
var firstData = columnData.First();
WriteBaseData writeBaseData = new WriteBaseData();
DepartmentCategory departmentCategory = new DepartmentCategory();
//将第一个数当作类别，找到科室类别
departmentCategory.Name = firstData;
departmentCategory = writeBaseData.FindDepartmentCategoryByName(departmentCategory.Name);
if (departmentCategory == null)
{
return;
}
columnData.Remove(firstData);
//第二列及之后的数据为项目名称
foreach (var data in columnData)
{
//依次将第二个列之后的项目插入到科室类别项目表中
//如果该项目不在数据库，继续下一个数据
var indicator = writeBaseData.FindIndicatorByName(data);
if (indicator == null)
{
continue;
}
//将Indicator添加进去
DepartmentCategoryIndicatorMap item = new DepartmentCategoryIndicatorMap();
item.DepartmentCategoryID = departmentCategory.DepartmentCategoryID;
item.IndicatorID = indicator.IndicatorID;
writeBaseData.AddDepartmentCategoryIndicatorMap(item);
}
}
}
}
/// <summary>
/// 初始化科室与科室类别
/// </summary>
public void InitialDepartmentAndCategory()
{
var departmentCategoryFile = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["DepartmentCategory"]);
//第一列为Category，先获取，再填充到
//从第二列开始，每列为科室，所属类别为第一列
//获取当前表格的总共Row数
ReadFromExcel readFromExcel = new ReadFromExcel();
//按Row获取当前行的所有数据
int rowCount = readFromExcel.GetRowCount(departmentCategoryFile);
for (int i = 2; i <= rowCount; i++)
{
var columnData = readFromExcel.ReadRowFromExcel((uint)i, departmentCategoryFile);
//获取第一个数为类别
if (columnData.Count >= 2)
{
var firstData = columnData.First();
WriteBaseData writeBaseData = new WriteBaseData();
DepartmentCategory departmentCategory = new DepartmentCategory();
//将第一个数当作类别，插入科室类别表中
departmentCategory.Name = firstData;
departmentCategory = writeBaseData.AddDepartmentCategory(departmentCategory);
if (departmentCategory == null)
{
return;
}
columnData.Remove(firstData);
foreach (var data in columnData)
{
//依次将第二个列之后的科室名插入到科室表中
Department department = new Department();
department.DepartmentName = data;
department.DepartmentCategoryID = departmentCategory.DepartmentCategoryID;
writeBaseData.AddDepartment(department);
}
}
}
}
/// <summary>
/// 初始化科室.
/// </summary>
public void InitialDepartment()
{
var fileName = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager
.AppSettings["Department"]);
//第一列为科室名称，第二列所属科室类别，第三列为科室的Guid
ReadFromExcel readFromExcel = new ReadFromExcel();
//按Row获取当前行的所有数据
int rowCount = readFromExcel.GetRowCount(fileName);
for (int i = 2; i <= rowCount; i++)
{
var columnData = readFromExcel.ReadRowFromExcel((uint)i, fileName);
//获取第一个数为科室名称
//数据必须大于等3才是正确的
if (columnData.Count >= 3)
{
WriteBaseData writeBaseData = new WriteBaseData();
//DepartmentCategory departmentCategory = new DepartmentCategory();
//第二列为科室类别
var name = columnData.ElementAt(1);
var departmentCategory = writeBaseData.FindDepartmentCategoryByName(name);
if (departmentCategory == null)
{
return;
}
Department department = new Department();
//第一列为科室名称
department.DepartmentName = columnData.ElementAt(0);
//第三列为科室Guid
department.DepartmentID = Guid.Parse(columnData.ElementAt(2));
department.DepartmentCategoryID = departmentCategory.DepartmentCategoryID;
//添加department
writeBaseData.AddDepartment(department);
}
}
}
