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

using OTSCommon.DBOperate.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;

namespace OTSIncAReportApp.DataOperation.DataAccess
{
    public class FeatureData
    {
        private SqlHelper dbHelper;

        public FeatureData(string path)
        {
            dbHelper = new SqlHelper("data source='" + path + "'");
        }

        /// <summary>
        /// 获取SegmentDataTable
        /// </summary>
        /// <param name="model">Feature</param>
        /// <returns></returns>
        public DataTable GetSegmentsDT(Segment model)
        {
            //存放查询数据的数据表
            DataTable DT = null;
            SQLiteParameter[] Parameter = new SQLiteParameter[2]
            {
                new SQLiteParameter("@FieldId", model.FieldId),
                new SQLiteParameter("@ParticleId", model.ParticleId)
            };
            string sql = "select * from Segment where Fieldid=@FieldId and ParticleId=@ParticleId";
            DT = dbHelper.ExecuteDataTable(sql, Parameter);
            return DT;

        }

        /// <summary>
        /// 获取SegmentList
        /// </summary>
        /// <param name="model">Feature</param>
        /// <returns></returns>
        public List<Segment> GetSegmentsList(Segment model)
        {
            //存放查询数据的数据表
            SQLiteParameter[] Parameter = new SQLiteParameter[2]
            {
                new SQLiteParameter("@FieldId", model.FieldId),
                new SQLiteParameter("@ParticleId", model.ParticleId)
            };
            string sql = "select * from Segment where Fieldid=@FieldId and ParticleId=@ParticleId";
            DataTable DT = dbHelper.ExecuteDataTable(sql, Parameter);
            var result = new List<Segment>();
            foreach (DataRow dr in DT.Rows)
            {
                Segment item = new Segment() { Start = Convert.ToInt32(dr["Start"]), Height = Convert.ToInt32(dr["Height"]), Length = Convert.ToInt32(dr["Length"]) };
                result.Add(item);
            }
            return result;

        }

    }
}