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