Esempio n. 1
0
        /// <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);
                }
            }
        }
Esempio n. 2
0
        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);
                }
            }
        }
Esempio n. 3
0
        /// <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);
                }
            }
        }
Esempio n. 4
0
        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);
                }
            }
        }
Esempio n. 5
0
        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);
                    }
                }
            }
        }
Esempio n. 6
0
        /// <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);
                    }
                }
            }
        }
Esempio n. 7
0
        /// <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);
                }
            }
        }