OTS/OTSIncAMeasureApp/0-OTSModel/Measure/DBDataTransition/IncADataDB.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;
using System.Diagnostics;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using OTSCLRINTERFACE;
using OTSDataType;
using OTSModelSharp.DTLBase;

namespace OTSModelSharp
{
   public  class CIncADataDB : CSQLiteDB 
    {
        public CIncADataDB(IDBStoreBase _conStr, IDBTableBase _table) : base(_conStr, _table)
        {

        }

       

      public  bool UpdataAIncA(COTSParticleClr a_pParticle)
        {
        
            if (a_pParticle == null)
            {
                return false;
            }

           

            var datastorePtr = GetDatastore();

            string sSQLCommand = "Update IncAData set AveGray = {0},Area ={1},IncAId={2} where FieldID = {3} and ParticleId = {4} ";  //sSQLCommand.Format(sSQLCommand,a_pParticle->GetAveGray(),a_pParticle->GetArea(),a_pParticle->GetType(),a_pParticle->GetFieldId(),a_pParticle->GetTagId());
            sSQLCommand = string.Format(sSQLCommand, a_pParticle.GetAveGray(), a_pParticle.GetArea(), a_pParticle.GetType(), a_pParticle.GetFieldId(), a_pParticle.GetTagId());
            var ret = datastorePtr.RunCommand( sSQLCommand);
            
            return ret;
        }
        public KeyValuePair<string,SQLiteParameter[]> GetUpdataAIncACmd(COTSParticleClr a_pParticle)
        {

            //if (a_pParticle == null)
            //{
            //    return "";
            //}



            //var datastorePtr = GetDatastore();

            string sSQLCommand = "Update IncAData set TypeId=@TypeId,TypeName= @TypeName,TypeColor=@TypeColor where FieldID =@FieldId and ParticleId =@ParticleId ";  //sSQLCommand.Format(sSQLCommand,a_pParticle->GetAveGray(),a_pParticle->GetArea(),a_pParticle->GetType(),a_pParticle->GetFieldId(),a_pParticle->GetTagId());
            var paras = new SQLiteParameter[5];
            paras[0] = new SQLiteParameter("TypeId");
            paras[0].Value = a_pParticle.GetClassifyId();
            paras[1] = new SQLiteParameter("TypeName");
            paras[1].Value = a_pParticle.GetTypeName();
            paras[2] = new SQLiteParameter("TypeColor");
            paras[2].Value = a_pParticle.GetTypeColor();
            paras[3] = new SQLiteParameter("FieldId");
            paras[3].Value = a_pParticle.GetFieldId();
            paras[4] = new SQLiteParameter("ParticleId");
            paras[4].Value = a_pParticle.GetTagId();

            //sSQLCommand = string.Format(sSQLCommand,  a_pParticle.GetClassifyId(),a_pParticle.GetTypeName(),a_pParticle.GetTypeColor(), a_pParticle.GetFieldId(), a_pParticle.GetTagId());
            

            return new KeyValuePair<string, SQLiteParameter[]>(sSQLCommand,paras);
        }

        public bool SaveAIncA(COTSParticleClr a_pParticle,  System.Drawing.Point fldPos)
        {
       
            var tableInfoPtr = GetTableInfo();
          
            if (tableInfoPtr==null)
            {
                return false;
            }
            var datastorePtr = GetDatastore();
          

            string sInsertFormat = tableInfoPtr.GetInsertCommandFormatString(true);
            string sSQLCommand;
            Rectangle rec = (Rectangle)a_pParticle.GetParticleRect();
            System.Drawing.Point xrayPos = (System.Drawing.Point)a_pParticle.GetXRayPos();
            System.Drawing.Point semPos = (System.Drawing.Point)a_pParticle.GetAbsolutPos();
            sSQLCommand =string.Format(sInsertFormat, a_pParticle.GetFieldId(), a_pParticle.GetAnalysisId(), a_pParticle.GetAveGray(), rec.Left, rec.Top, rec.Width, rec.Height, a_pParticle.GetArea(), xrayPos.X, xrayPos.Y, a_pParticle.GetClassifyId(),  (int)(a_pParticle.GetFeature().GetSegmentsList().Count), fldPos.X, fldPos.Y, a_pParticle.GetTagId(), a_pParticle.GetDMAX(), a_pParticle.GetDMIN(), a_pParticle.GetDMPERP(), a_pParticle.GetDPRIMETER(), a_pParticle.GetORIENTATION(), a_pParticle.GetDINSCR(), a_pParticle.GetDMEAN(), a_pParticle.GetDELONG(), a_pParticle.GetFeretDiameter(), a_pParticle.GetTypeName(), a_pParticle.GetTypeColor(),semPos.X,semPos.Y);

            if (!datastorePtr.RunCommand(sSQLCommand))
            {

                return false;
            }


            return true;
        }
        public KeyValuePair<string,SQLiteParameter[]> GegInsertingAnIncACmd(COTSParticleClr a_pParticle, System.Drawing.Point fldPos)
        {

            var tableInfoPtr = GetTableInfo();

         


            var sInsertCmd = tableInfoPtr.GetInsertCommand(true);
           
            Rectangle rec = (Rectangle)a_pParticle.GetParticleRect();
            System.Drawing.Point xrayPos = (System.Drawing.Point)a_pParticle.GetXRayPos();
            System.Drawing.Point semPos = (System.Drawing.Point)a_pParticle.GetAbsolutPos();
           
      
            var paras = sInsertCmd.Value;
            paras[0].Value = a_pParticle.GetFieldId();
            paras[1].Value = a_pParticle.GetAnalysisId();
            paras[2].Value = a_pParticle.GetAveGray();
            paras[3].Value = rec.Left;
            paras[4].Value = rec.Top;
            paras[5].Value = rec.Width;
            paras[6].Value = rec.Height;
            paras[7].Value = a_pParticle.GetArea();
            paras[8].Value = xrayPos.X;
            paras[9].Value = xrayPos.Y;

            paras[10].Value = a_pParticle.GetClassifyId();
            paras[11].Value = (int)(a_pParticle.GetFeature().GetSegmentsList().Count);
            paras[12].Value = fldPos.X;
            paras[13].Value = fldPos.Y;
            paras[14].Value = a_pParticle.GetTagId();
            paras[15].Value = a_pParticle.GetDMAX();
            paras[16].Value = a_pParticle.GetDMIN();
            paras[17].Value = a_pParticle.GetDMPERP();
            paras[18].Value = a_pParticle.GetDPRIMETER();
            paras[19].Value = a_pParticle.GetORIENTATION();
            paras[20].Value = a_pParticle.GetDINSCR();
            paras[21].Value = a_pParticle.GetDMEAN();
            paras[22].Value = a_pParticle.GetDELONG();
            paras[23].Value = a_pParticle.GetFeretDiameter();
            paras[24].Value = a_pParticle.GetTypeName();
            paras[25].Value = a_pParticle.GetTypeColor();
            paras[26].Value = semPos.X;
            paras[27].Value = semPos.Y;
          
           

            return new KeyValuePair<string, SQLiteParameter[]>(sInsertCmd.Key,paras);
        }

        public bool GetAllFieldsRecord(ref List<COTSFieldData> allFlds)
        {
            var allRecords = this.GetQueryOfAllRecord();
            Dictionary<int, COTSFieldData> mapFld = new Dictionary<int, COTSFieldData>();                                       //std.map<int, COTSFieldDataPtr> mapFld = new std.map<int, COTSFieldDataPtr>();
            for (int i = 0; i < allRecords.Rows.Count; i++)
            {
                int curFldId = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_FIELD_ID]);  //GetColIntValue((int)CIncADataTable.ColumnID.N_FIELD_ID);
                if (!mapFld.Keys.Contains(curFldId))
                {
                    COTSFieldData fld = new COTSFieldData();

                    fld.SetId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_FIELD_ID]));
                    System.Drawing.Point fldPos =new System.Drawing.Point();
                    fldPos.X = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_FldPosX]);
                    fldPos.Y = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_FldPosY]);
                    fld.SetOTSPosition(fldPos);
                    List<COTSParticleClr> ps = fld.GetListAnalysisParticles();
                    COTSParticleClr p = new COTSParticleClr();
                    p.SetFieldId(fld.GetId());
                    p.SetTagId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_PARTICLE_ID]));
                    p.SetType(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_TYPE_ID]));
                    int top = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_RECT_TOP]);
                    int left = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_RECT_LEFT]);
                    int width = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_RECT_WIDTH]);
                    int height = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_RECT_HEIGHT]);
                    Rectangle r = new Rectangle(left, top, left + width, top + height);
                    p.SetParticleRect(r);
                    p.SetSubParticles("");
                    byte aveGray = Convert.ToByte(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_AVE_GRAY]);
                    p.SetAveGray(aveGray);
                    p.SetArea(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_AREA]));
                    p.SetAnalysisId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_XRAY_ID]));
                    p.SetDMAX(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DMAX]));
                    p.SetDMIN(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DMIN]));
                    p.SetDMPERP(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DPERP]));
                    p.SetDINSCR(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DINSCR]));
                    p.SetDMEAN(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DMEAN]));
                    p.SetDELONG(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DELONG]));
                    p.SetDPRIMETER(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_PERIMETER]));
                    p.SetORIENTATION(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_ORIENTATION]));
                    p.SetTypeName(allRecords.Rows[i][(int)CIncADataTable.ColumnID.S_NAME].ToString());
                    p.SetTypeColor(allRecords.Rows[i][(int)CIncADataTable.ColumnID.S_COLOR].ToString());
                    ps.Add(p);
                    allFlds.Add(fld);
                    mapFld[curFldId] = fld;
                }
                else
                {
                    COTSFieldData fld = mapFld[curFldId];
                    List<COTSParticleClr> ps = fld.GetListAnalysisParticles();
                    COTSParticleClr p = new COTSParticleClr();
                    p.SetFieldId(fld.GetId());
                    p.SetTagId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_PARTICLE_ID]));
                    p.SetType(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_TYPE_ID]));
                    int top = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_RECT_TOP]);
                    int left = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_RECT_LEFT]);
                    int width = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_RECT_WIDTH]);
                    int height = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_RECT_HEIGHT]);
                    Rectangle r = new Rectangle(left, top, left + width, top + height);
                    p.SetParticleRect(r);
                    //p.SetSubParticles("");                   
                    p.SetAveGray(Convert.ToByte(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_AVE_GRAY]));
                    p.SetArea(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_AREA]));
                    p.SetAnalysisId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_XRAY_ID]));
                    p.SetDMAX(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DMAX]));
                    p.SetDMIN(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DMIN]));
                    p.SetDMPERP(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DPERP]));
                    p.SetDINSCR(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DINSCR]));
                    p.SetDMEAN(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DMEAN]));
                    p.SetDELONG(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DELONG]));
                    p.SetDPRIMETER(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_PERIMETER]));
                    p.SetORIENTATION(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_ORIENTATION]));
                    p.SetTypeName(allRecords.Rows[i][(int)CIncADataTable.ColumnID.S_NAME].ToString());
                    p.SetTypeColor(allRecords.Rows[i][(int)CIncADataTable.ColumnID.S_COLOR].ToString());
                    ps.Add(p);
                }
            }
            return true;
        }


        protected DataTable GetQueryById(int a_nXrayId, int a_nFieldId)
        {
            CSQLiteTable query = new CSQLiteTable();
            var datastorePtr = GetDatastore();
  
            var tableInfoPtr = GetTableInfo();
    
            string sXrayIdColumnName = tableInfoPtr.GetColumnName((int)CIncADataTable.ColumnID.N_XRAY_ID - (int)CIncADataTable.ColumnID.MIN);     //tableInfoPtr.GetColumnName((int)CIncADataTable.ColumnID.N_XRAY_ID - (int)CIncADataTable.ColumnID.MIN);
            string sFieldIdColumnName = tableInfoPtr.GetColumnName((int)CIncADataTable.ColumnID.N_FIELD_ID - (int)CIncADataTable.ColumnID.MIN);    //tableInfoPtr.GetColumnName((int)CIncADataTable.ColumnID.N_FIELD_ID - (int)CIncADataTable.ColumnID.MIN);
            string sSQLCommand=string.Format("SELECT * FROM \'{0}\' WHERE {1} = {2} AND %s = {3};", (string)tableInfoPtr.GetTableName(), (string)sFieldIdColumnName, a_nFieldId, (string)sXrayIdColumnName, a_nXrayId);
            DataTable t1 =datastorePtr.QueryByCmdForDataTable(sSQLCommand);

            return t1;
        }
        protected DataTable GetQueryOfAllRecord()
        {
  
            var datastorePtr = GetDatastore();
    
            var tableInfoPtr = GetTableInfo();
      

            string sSQLCommand= string.Format("SELECT * FROM \'{0}\';", (string)tableInfoPtr.GetTableName());

            DataTable t1 = datastorePtr.QueryByCmdForDataTable(sSQLCommand);



            return t1;
        }
      
       
     
    }
}