OTS/OTSIncAReportApp/3-ServiceCenter/DataOperation/DataAccess/FieldData.cs

using DevExpress.CodeParser;
using OTSCommon.DBOperate.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.IO;

namespace OTSIncAReportApp.DataOperation.DataAccess
{
    public class FieldData
    {
        private SqlHelper dbHelper;
        //测量文件地址
        private string filePath;
        public FieldData(string path)
        {
            dbHelper = new SqlHelper("data source='" + path + "\\FIELD_FILES\\Inclusion.db'");
            filePath = path + "\\FIELD_FILES\\";
        }
        
       
        /// <summary>
        /// 获取SegmentList
        /// </summary>
        /// <param name="model">Feature</param>
        /// <returns></returns>
        public List<Field> GetFieldList()
        {
            //获取field信息
            string sql = "select fieldid,fieldposx,fieldposy from field ";//select fieldid,fieldposx,fieldposy from field
            DataTable DT = dbHelper.ExecuteDataTable(sql, null);
            string checksql = "SELECT COUNT(*) AS field_exists FROM pragma_table_info('IncAData') WHERE name = 'SubParticles';";
            var checkresult = dbHelper.ExecuteQueryResult(checksql);
            if (Convert.ToInt32( checkresult) == 0)
            {
                string alterSql = "ALTER TABLE IncAData ADD COLUMN SubParticles TEXT";
                dbHelper.ExecuteQueryResult(alterSql);
            } 
            
            string sqlp = "select * from IncAData where SubParticles isnull or SubParticles='IsSubParticle'";
            DataTable DTP = dbHelper.ExecuteDataTable(sqlp, null);
            //获取Segment信息

            string strs = @"select *  from Segment ";
            DataTable DTS = dbHelper.ExecuteDataTable(strs, null);
            //获取Element信息
            string sqle = @"select *  from ElementChemistry ";
            DataTable DTE = dbHelper.ExecuteDataTable(sqle, null);

            List<Field> Fields = new List<Field>();

            DirectoryInfo info = new DirectoryInfo(filePath);
            //int count = info.GetFiles("*.bmp").Length;
            int fldcount = DT.Rows.Count;
            for (int i=0;i< fldcount; i++)
            {
                
                string imagePath = filePath + "Field" + DT.Rows[i]["FieldId"].ToString() + ".bmp";


                Field modelf = new Field() { FieldID = Convert.ToInt32(DT.Rows[i]["FieldId"].ToString()), FieldPosX = Convert.ToInt32(DT.Rows[i]["fieldposx"].ToString()), FieldPosY = Convert.ToInt32(DT.Rows[i]["fieldposy"].ToString()), FieldImageName = imagePath };

                DataRow[] drp = DTP.Select("fieldid=" + DT.Rows[i]["FieldId"].ToString());

                List<Particle> listp = dbHelper.RowsToList<Particle>(drp);

                foreach (Particle modelp in listp)
                {
                    //添加FeatureList信息
                    DataRow[] drs = DTS.Select("fieldid=" + DT.Rows[i]["FieldId"].ToString() + " and particleid=" + modelp.ParticleId.ToString());
                    List<Segment> flist = dbHelper.RowsToList<Segment>(drs);
                    modelp.SegmentList = flist;

                    //添加ElementList信息
                    DataRow[] dre = DTE.Select("fieldid=" + DT.Rows[i]["FieldId"].ToString() + " and XRayId=" + modelp.XrayId.ToString());
                    List<Element> elist = dbHelper.RowsToList<Element>(dre);
                    modelp.ElementList = elist;
                }

                modelf.ParticleList = listp;

                Fields.Add(modelf);
            }
          

            return Fields;

        }
        /// <summary>
        /// 获取SegmentDataTable
        /// </summary>
        /// <param name="model">Feature</param>
        /// <returns></returns>
        public DataTable GetGeneralInfo()
        {
            //存放查询数据的数据表
            DataTable DT = null;

            string sql = "select * from GeneralInfo";
            DT = dbHelper.ExecuteDataTable(sql, null);
            return DT;

        }
        /// <summary>
        /// 获取filed数量
        /// </summary>
        /// <param name="model">Feature</param>
        /// <returns></returns>
        public int GetFiledCount()
        {
            //存放查询数据的数据表
            DataTable DT = null;

            string sql = "select FieldId from Field";
            DT = dbHelper.ExecuteDataTable(sql, null);
            return DT.Rows.Count;

        }
        /// <summary>
        /// 获取颗粒数量
        /// </summary>
        /// <param name="model">Feature</param>
        /// <returns></returns>
        public int GetparticleCount()
        {
            //存放查询数据的数据表
            DataTable DT = null;

            string sql = "select 1 from IncAData  where SubParticles is not 'IsSubParticle'";
            DT = dbHelper.ExecuteDataTable(sql, null);
            return DT.Rows.Count;

        }

        /// <summary>
        /// 获取所有的颗粒信息
        /// </summary>
        /// <returns></returns>
        public DataTable GetAllParticle_DataTable()
        {
            DataTable DT = null;
            string sql = "select * from IncAData where typeid > 9 and SubParticles is not 'IsSubParticle'";
            DT = dbHelper.ExecuteDataTable(sql, null);
            return DT;
        }

        /// <summary>
        /// 获取颗粒总面积
        /// </summary>
        /// <param name="model">Feature</param>
        /// <returns></returns>
        public double GetparticleArea()
        {
            DataTable DT = null;
            string sql = "select sum(Area) from IncAData where SubParticles is not 'IsSubParticle'";
            DT = dbHelper.ExecuteDataTable(sql, null);
            if (DT == null) return 0;
            double particleArea = 0;
            if(double.TryParse(DT.Rows[0][0].ToString(),out particleArea))
            {
               return particleArea;
            }else{
                return 0;
            }

        }
 
    }
}