OTS/OTSIncAMeasureApp/0-OTSModel/Measure/GetParticleData/SmallParticles/SmallParticleInfoDB.cs

using OTSCOMMONCLR;
using OTSDataType;
using OTSModelSharp.DTLBase;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

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

       public bool SaveAKindOfSmallParticle( CSmallParticleInfo a_pParticleInfo,  CPosXrayClr a_pXray, System.Drawing.Point fldPos)
	   {
		
        var tableInfoPtr = GetTableInfo();
		
		var datastorePtr = GetDatastore();

            String sInsertFormat = tableInfoPtr.GetInsertCommandFormatString();
        


          string  sSQLCommand=string.Format(sInsertFormat,
        a_pParticleInfo.FieldId,

        a_pParticleInfo.AveGray,

        a_pParticleInfo.Area,

        a_pParticleInfo.TypeId,

        a_pParticleInfo.TypeName,
        a_pParticleInfo.TypeColor,
        a_pParticleInfo.Quantity
        );
            if (!datastorePtr.RunCommand(sSQLCommand))
			{
				

                return false;
			}

            return true;
	   }

      public  bool UpdataAKindOfSamllParticle( CSmallParticleInfo a_pParticleInfo)
	  {
        var tableInfoPtr = GetTableInfo();

		var datastorePtr = GetDatastore();

		//String sSQLCommand = "Update \'{0}\' WHERE {1} = {2} AND {3} ={4} AND {5} ={6} AND {7} = {8}; ";

            string sSQLCommand = "Update SmallParticleInfo set AveGray = {0},Area = {1},IncAId={2} where FieldID = {3} and IncAId = {2}";
            sSQLCommand=string.Format(sSQLCommand,
                a_pParticleInfo.AveGray,
                a_pParticleInfo.Area,
                a_pParticleInfo.TypeId,
                a_pParticleInfo.FieldId
                
                );


          
            //var helper = new SQLiteHelper(datastorePtr);
            if(datastorePtr.RunCommand( sSQLCommand)!=true)
		{			
			return false;
		}
		return true;
	  }

        public    DataTable GetQueryById( long a_nFieldId)
	    {

        DataTable query;
        var datastorePtr = GetDatastore();
        
        var tableInfoPtr = GetTableInfo();
  
        var sFieldIdColumnName = tableInfoPtr.GetColumnName((int)CSmallParticleInfoTable.ColumnID.N_FIELD_ID - (int)CSmallParticleInfoTable.ColumnID.MIN);

            String sSQLCommand = "";
            String.Format("SELECT * FROM \'{0}\' WHERE {1} = {2} AND {3} ={4} AND {5} ={6} AND {7} = {8}; ",
			(String) tableInfoPtr.GetTableName(),
			 sFieldIdColumnName,a_nFieldId);

            //var helper = new SQLiteHelper(datastorePtr);

            query = datastorePtr.QueryByCmdForDataTable(sSQLCommand);
           
		return query;
	    }

       public  DataTable GetQueryOfAllRecord()
        {
            DataTable query;

            var datastorePtr = GetDatastore();
            
            var tableInfoPtr = GetTableInfo();

            String sSQLCommand = "";
            String.Format("SELECT * FROM \'{0}\' WHERE {1} = {2} AND {3} ={4} AND {5} ={6} AND {7} = {8};",
                (String)tableInfoPtr.GetTableName());

            //var helper = new SQLiteHelper(datastorePtr);

            query = datastorePtr.QueryByCmdForDataTable(sSQLCommand);
         
            return query;
        }
    }
}