OTS/OTSIncAMeasureApp/1-OTSMeasure/Measure/DBDataTransition/IncADataDB.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;

using System.Drawing;
using System.Linq;
using Microsoft.Office.Interop.Excel;
using OTSCLRINTERFACE;
using OTSDataType;
using OTSMeasureApp._0_OTSModel.OTSDataType;
using OTSModelSharp.DTLBase;
using DataTable = System.Data.DataTable;
using Rectangle = System.Drawing.Rectangle;

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

        }
        public bool SaveAParticle(COTSParticleClr a_pParticle, CPosXrayClr a_pXray)
        {
            var tableInfoPtr = GetTableInfo();
            var datastorePtr = GetDatastore();
          

            System.Drawing.Rectangle rec = (System.Drawing.Rectangle)a_pParticle.GetParticleRect();
            System.Drawing.Point xrayPos = (System.Drawing.Point)a_pParticle.GetXRayPos();
            System.Drawing.Point semPos = (System.Drawing.Point)a_pParticle.GetSEMPos();
            System.Drawing.Point otsfieldPos= (System.Drawing.Point)a_pParticle.GetFieldOTSPos();   
           
            String sInsertFormat = tableInfoPtr.GetInsertCommandFormatString(true);
            var cmd = tableInfoPtr.GetInsertCommand(true);

            var paras = cmd.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.GetActualArea();
            paras[8].Value = xrayPos.X;
            paras[9].Value = xrayPos.Y;

            paras[10].Value = a_pParticle.GetFeretDiameter();
            paras[11].Value = (int)(a_pParticle.GetFeature().GetSegmentsList().Count);
            paras[12].Value = otsfieldPos.X;
            paras[13].Value = otsfieldPos.Y;
            paras[14].Value = a_pParticle.GetParticleId();
            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.GetTypeId();
            paras[24].Value = a_pParticle.GetTypeName();
            paras[25].Value = a_pParticle.GetTypeColor();
            paras[26].Value = semPos.X;
            paras[27].Value = semPos.Y;
            paras[28].Value = a_pParticle.GetGrpId();
            paras[29].Value = a_pParticle.GetGrpName();
            paras[30].Value = a_pParticle.GetGrpColor();

            paras[31].Value = a_pParticle.GetConnectedParticlesName();

            List<KeyValuePair<string, SQLiteParameter[]>> cmds = new List<KeyValuePair<string, SQLiteParameter[]>>();
            cmds.Add(cmd);


            datastorePtr.ExecuteNonQueryBatch(ref cmds);




            return true;
        }

        public bool UpdateIsSubParticleState(COTSParticleClr a_pParticle)
        {

            var tableInfoPtr = GetTableInfo();

            var datastorePtr = GetDatastore();

            String sSQLCommand = "Update IncAData SET SubParticles='IsSubParticle' WHERE FieldId = {0} AND ParticleId ={1};";
            sSQLCommand = String.Format(sSQLCommand,
     
             a_pParticle.GetFieldId(),
             a_pParticle.GetParticleId());
            //var helper = new SQLiteHelper(datastorePtr);      
            if (datastorePtr.RunCommand(sSQLCommand) != true)
            {
                return false;
            }
            return true;
        }
        public bool ClearAllMergedParticles()
        {

            var tableInfoPtr = GetTableInfo();

            var datastorePtr = GetDatastore();

            String sSQLCommand = "DELETE FROM IncAData WHERE SubParticles LIKE '%:%';";
           
            if (datastorePtr.RunCommand(sSQLCommand) != true)
            {
                return false;
            }
            return true;
        }
        public KeyValuePair<string,SQLiteParameter[]> GetUpdataAIncACmd(COTSParticleClr a_pParticle)
        {
            string sSQLCommand = "Update IncAData set TypeId=@TypeId,TypeName= @TypeName,TypeColor=@TypeColor,GroupId=@GroupId,GroupName=@GroupName,GroupColor=@GroupColor 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[8];
            paras[0] = new SQLiteParameter("TypeId");
            paras[0].Value = a_pParticle.GetTypeId();
            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("GroupId");
            paras[3].Value = a_pParticle.GetGrpId();
            paras[4] = new SQLiteParameter("GroupName");
            paras[4].Value = a_pParticle.GetGrpName();
            paras[5] = new SQLiteParameter("GroupColor");
            paras[5].Value = a_pParticle.GetGrpColor();

            paras[6] = new SQLiteParameter("FieldId");
            paras[6].Value = a_pParticle.GetFieldId();
            paras[7] = new SQLiteParameter("ParticleId");
            paras[7].Value = a_pParticle.GetParticleId();

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

        public KeyValuePair<string,SQLiteParameter[]> GegInsertingAnParticleCmd(COTSParticleClr a_pParticle)
        {

            var tableInfoPtr = GetTableInfo();

         


            var sInsertCmd = tableInfoPtr.GetInsertCommand(true);
           
            System.Drawing.Rectangle rec = (System.Drawing.Rectangle)a_pParticle.GetParticleRect();
            System.Drawing.Point xrayPos = (System.Drawing.Point)a_pParticle.GetXRayPos();
            System.Drawing.Point semPos = (System.Drawing.Point)a_pParticle.GetSEMPos();
            System.Drawing.Point fldOTSPos = (System.Drawing.Point)a_pParticle.GetFieldOTSPos();

            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.GetActualArea();
            paras[8].Value = xrayPos.X;
            paras[9].Value = xrayPos.Y;

            paras[10].Value = a_pParticle.GetFeretDiameter();
            paras[11].Value = (int)(a_pParticle.GetFeature().GetSegmentsList().Count);
            paras[12].Value = fldOTSPos.X;
            paras[13].Value = fldOTSPos.Y;
            paras[14].Value = a_pParticle.GetParticleId();
            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.GetTypeId();
            paras[24].Value = a_pParticle.GetTypeName();
            paras[25].Value = a_pParticle.GetTypeColor();
            paras[26].Value = semPos.X;
            paras[27].Value = semPos.Y;
            paras[28].Value = a_pParticle.GetGrpId();
            paras[29].Value = a_pParticle.GetGrpName();
            paras[30].Value = a_pParticle.GetGrpColor();



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

        public bool GetAllFieldsRecord(double pixelsize,ref List<COTSField> allFlds)
        {
            var allRecords = this.GetQueryOfAllRecord();
            
            Dictionary<int, COTSField> mapFld = new Dictionary<int, COTSField>();                                       //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))
                {
                    System.Drawing.Point fldPos = new System.Drawing.Point();
                    fldPos.X = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_FieldPosX]);
                    fldPos.Y = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_FieldPosY]);
                    System.Drawing.Point fldSEMPos = new System.Drawing.Point();
                    fldSEMPos.X = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_SEMPOS_X]);
                    fldSEMPos.Y = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_SEMPOS_Y]);

                    COTSField fld = new COTSField(new PointF(fldPos.X,fldPos.Y),pixelsize);
                   
                    fld.SetId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_FIELD_ID]));
                    fld.SetOTSPosition(fldPos);
                    fld.SetSemPos(fldSEMPos);
                    List<COTSParticleClr> ps = fld.GetListAnalysisParticles();
                    COTSParticleClr p = new COTSParticleClr();
                    p.SetFieldId(fld.GetId());
                    p.SetFieldOTSPos(fldPos);
                    p.SetSEMPos(fldSEMPos);
                    p.SetParticleId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_PARTICLE_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.SetConnectedParticlesName("");
                    byte aveGray = Convert.ToByte(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_AVE_GRAY]);
                    p.SetAveGray(aveGray);
                    p.SetActualArea(Convert.ToDouble(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.SetFeretDiameter(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DFERET]));

                    p.SetTypeId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_TYPE_ID]));
                    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;
                    fld.SetIsMeasureComplete(true);
                }
                else
                {
                    COTSField fld = mapFld[curFldId];
                    List<COTSParticleClr> ps = fld.GetListAnalysisParticles();
                    System.Drawing.Point fldPos = new System.Drawing.Point();
                    fldPos.X = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_FieldPosX]);
                    fldPos.Y = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_FieldPosY]);
                    System.Drawing.Point fldSEMPos = new System.Drawing.Point();
                    fldSEMPos.X = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_SEMPOS_X]);
                    fldSEMPos.Y = Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_SEMPOS_Y]);
                    COTSParticleClr p = new COTSParticleClr();
                    p.SetFieldId(fld.GetId());
                    p.SetFieldOTSPos(fld.GetOTSPosition());
                    p.SetParticleId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_PARTICLE_ID]));
                    p.SetSEMPos(fldSEMPos);
                    p.SetFieldOTSPos(fldPos);
                    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.SetActualArea(Convert.ToDouble(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.SetFeretDiameter(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.F_DFERET]));

                    p.SetTypeId(Convert.ToInt32(allRecords.Rows[i][(int)CIncADataTable.ColumnID.N_TYPE_ID]));
                    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 GetQueryOfAllRecord()
        {
  
            var datastorePtr = GetDatastore();
    
            var tableInfoPtr = GetTableInfo();
      

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

            DataTable t1 = datastorePtr.QueryByCmdForDataTable(sSQLCommand);



            return t1;
        }
        public void DeleteDataByFieldNo(int fieldStartNo)
        {
            string sSQLCommand;

            var datastorePtr = GetDatastore();
            sSQLCommand = "delete  from IncAData where FieldId>=" + fieldStartNo.ToString();
            if (!datastorePtr.RunCommand(sSQLCommand))
            {

                return;
            }
        }
    }
}