EICP3.0_69/SCADA_DAQ.DAL/LocalDB.cs


using System;
using System.Collections.Generic;
using System.Linq.Expressions;
using SCADA.CommonLib;
using SCADA.CommonLib.Data;
using SCADA.CommonLib.Data.DIL;
using SCADA.CommonLib.Data.DIL.Sqlite;

namespace LocalDB
{
    namespace DBSchema
    {
    public class SP
                   {
	                     
                   }

            
    }

    namespace DBNames
    {
    public static class T_Col_Name
                          {
	                        /// <summary> 
             /// Sys_Service
             /// </summary>
             public class Sys_Service
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @ID=nameof(@ID);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ServiceName_Str=nameof(@ServiceName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ServiceState_Str=nameof(@ServiceState_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ServiceType_Str=nameof(@ServiceType_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @StartTime_Dt=nameof(@StartTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @StartSquence_Int=nameof(@StartSquence_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @StartDelay_Int=nameof(@StartDelay_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ServiceDescribe_Str=nameof(@ServiceDescribe_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ServiceMessage_Str=nameof(@ServiceMessage_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ServiceConfig_Str=nameof(@ServiceConfig_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsEnable_Bit=nameof(@IsEnable_Bit);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateUser_Str=nameof(@CreateUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateDate_Dt=nameof(@CreateDate_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsSync_Bit=nameof(@IsSync_Bit);
                    
             }
             /// <summary> 
             /// sqlite_sequence
             /// </summary>
             public class sqlite_sequence
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @name=nameof(@name);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @seq=nameof(@seq);
                    
             }
             /// <summary> 
             /// Sys_User_Session
             /// </summary>
             public class Sys_User_Session
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @ID=nameof(@ID);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @OrgID_Int=nameof(@OrgID_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @AppName_Str=nameof(@AppName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @VersionNumber_Str=nameof(@VersionNumber_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @SessionID_Str=nameof(@SessionID_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @UserID_Str=nameof(@UserID_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @HostName_Str=nameof(@HostName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @MacAddr_Str=nameof(@MacAddr_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IpAddr_Str=nameof(@IpAddr_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @StartTime_Dt=nameof(@StartTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @LastOnLineTime_Dt=nameof(@LastOnLineTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ModifyTime_Dt=nameof(@ModifyTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ModifyUser_Str=nameof(@ModifyUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateUser_Str=nameof(@CreateUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Remark_Str=nameof(@Remark_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsEnable=nameof(@IsEnable);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsPhantom_Bit=nameof(@IsPhantom_Bit);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsSync_bit=nameof(@IsSync_bit);
                    
             }
             /// <summary> 
             /// SysApp_DayStatistics
             /// </summary>
             public class SysApp_DayStatistics
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @ID=nameof(@ID);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @OrgID_Int=nameof(@OrgID_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @SubINV_Int=nameof(@SubINV_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Day_Str=nameof(@Day_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @DayStartTime_Dt=nameof(@DayStartTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Source_Str=nameof(@Source_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @DayEndTime_Dt=nameof(@DayEndTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @AppName_Str=nameof(@AppName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @GroupName_Str=nameof(@GroupName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Value_Dec=nameof(@Value_Dec);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Remark_Str=nameof(@Remark_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateUser_Str=nameof(@CreateUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsSync_bit=nameof(@IsSync_bit);
                    
             }
             /// <summary> 
             /// SysApp_MonthStatistics
             /// </summary>
             public class SysApp_MonthStatistics
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @ID=nameof(@ID);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @OrgID_Int=nameof(@OrgID_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @SubINV_Int=nameof(@SubINV_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Month_Str=nameof(@Month_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @MonthStartTime_Dt=nameof(@MonthStartTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @MonthEndTime_Dt=nameof(@MonthEndTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Source_Str=nameof(@Source_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @AppName_Str=nameof(@AppName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @GroupName_Str=nameof(@GroupName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Value_Dec=nameof(@Value_Dec);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Remark_Str=nameof(@Remark_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateUser_Str=nameof(@CreateUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsSync_bit=nameof(@IsSync_bit);
                    
             }
             /// <summary> 
             /// SysApp_YearStatistics
             /// </summary>
             public class SysApp_YearStatistics
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @ID=nameof(@ID);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @OrgID_Int=nameof(@OrgID_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @SubINV_Int=nameof(@SubINV_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Year_Str=nameof(@Year_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @YearStartTime_Dt=nameof(@YearStartTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @YearEndTime_Dt=nameof(@YearEndTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Source_Str=nameof(@Source_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @AppName_Str=nameof(@AppName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @GroupName_Str=nameof(@GroupName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Value_Dec=nameof(@Value_Dec);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Remark_Str=nameof(@Remark_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateUser_Str=nameof(@CreateUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsSync_bit=nameof(@IsSync_bit);
                    
             }
             /// <summary> 
             /// Sys_Table_Comment
             /// </summary>
             public class Sys_Table_Comment
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @ID=nameof(@ID);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Type_Str=nameof(@Type_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Group_Str=nameof(@Group_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @TableName_Str=nameof(@TableName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Comment_Str=nameof(@Comment_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
                    
             }
             /// <summary> 
             /// sqlite_stat1
             /// </summary>
             public class sqlite_stat1
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @tbl=nameof(@tbl);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @idx=nameof(@idx);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @stat=nameof(@stat);
                    
             }
             /// <summary> 
             /// App_Common_ProductLog
             /// </summary>
             public class App_Common_ProductLog
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @ID=nameof(@ID);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @OrgID_Int=nameof(@OrgID_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @SubINV_Int=nameof(@SubINV_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Line_Str=nameof(@Line_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @DeviceID_Str=nameof(@DeviceID_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @BarCode_Str=nameof(@BarCode_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ProductModel_Str=nameof(@ProductModel_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @TestResult_Int=nameof(@TestResult_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @NGDesc_Str=nameof(@NGDesc_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Index_int=nameof(@Index_int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @LotQty_int=nameof(@LotQty_int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateUser_Str=nameof(@CreateUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ModifyTime_Dt=nameof(@ModifyTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ModifyUser_Str=nameof(@ModifyUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Remark_Str=nameof(@Remark_Str);
                    
             }
             /// <summary> 
             /// Sys_JobScheduler
             /// </summary>
             public class Sys_JobScheduler
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @ID=nameof(@ID);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @JobName_Str=nameof(@JobName_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @JobState_Str=nameof(@JobState_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @JobType_Str=nameof(@JobType_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ExcutePolicy_Str=nameof(@ExcutePolicy_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @JobParameter_Str=nameof(@JobParameter_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @LastExcuteTime_Dt=nameof(@LastExcuteTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @NextExcuteTime_Dt=nameof(@NextExcuteTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @JobDescribe_Str=nameof(@JobDescribe_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @JobMessage_Str=nameof(@JobMessage_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @TriggerWhenStart_bit=nameof(@TriggerWhenStart_bit);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsEnable_Bit=nameof(@IsEnable_Bit);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @NeedRestart_Bit=nameof(@NeedRestart_Bit);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateUser_Str=nameof(@CreateUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateDate_Dt=nameof(@CreateDate_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsSync_Bit=nameof(@IsSync_Bit);
                    
             }
             /// <summary> 
             /// Sys_JobSchedulerExcuteLog
             /// </summary>
             public class Sys_JobSchedulerExcuteLog
             {
             	/// <summary>
                /// 
                /// </summary>
                 public const string @ID=nameof(@ID);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @JobId_Int=nameof(@JobId_Int);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @JobType_Str=nameof(@JobType_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ElapsedTime_Dec=nameof(@ElapsedTime_Dec);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ExcuteStartTime_Dt=nameof(@ExcuteStartTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ExcuteFinishTime_Dt=nameof(@ExcuteFinishTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @NextExcuteTime_Dt=nameof(@NextExcuteTime_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @ExcuteResult_Bit=nameof(@ExcuteResult_Bit);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @Message_Str=nameof(@Message_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateUser_Str=nameof(@CreateUser_Str);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @CreateDate_Dt=nameof(@CreateDate_Dt);
                    /// <summary>
                /// 
                /// </summary>
                 public const string @IsSync_Bit=nameof(@IsSync_Bit);
                    
             }
             
                          }
            
    public static class V_Col_Name
                  {
	                 
                   }

                
     public static class SP_Paramters
                    {
                    	
                    }
            
    }

    namespace DBModel
    {
    
	                    /// <summary> 
             /// 
             /// </summary>
             public class Sys_Service:ObservableObject
             {
             	  private System.Int64 _ID;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int64 ID
                {
                get {return _ID;}
                set{
                    if(value!=(_ID))
                    {
                        _ID=value;
                        OnPropertyChanged(nameof( ID));
                    }
                }
            }
              private System.String _ServiceName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String ServiceName_Str
                {
                get {return _ServiceName_Str;}
                set{
                    if(value!=(_ServiceName_Str))
                    {
                        _ServiceName_Str=value;
                        OnPropertyChanged(nameof( ServiceName_Str));
                    }
                }
            }
              private System.String _ServiceState_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String ServiceState_Str
                {
                get {return _ServiceState_Str;}
                set{
                    if(value!=(_ServiceState_Str))
                    {
                        _ServiceState_Str=value;
                        OnPropertyChanged(nameof( ServiceState_Str));
                    }
                }
            }
              private System.String _ServiceType_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String ServiceType_Str
                {
                get {return _ServiceType_Str;}
                set{
                    if(value!=(_ServiceType_Str))
                    {
                        _ServiceType_Str=value;
                        OnPropertyChanged(nameof( ServiceType_Str));
                    }
                }
            }
              private System.DateTime _StartTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime StartTime_Dt
                {
                get {return _StartTime_Dt;}
                set{
                    if(value!=(_StartTime_Dt))
                    {
                        _StartTime_Dt=value;
                        OnPropertyChanged(nameof( StartTime_Dt));
                    }
                }
            }
              private System.Int32 _StartSquence_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 StartSquence_Int
                {
                get {return _StartSquence_Int;}
                set{
                    if(value!=(_StartSquence_Int))
                    {
                        _StartSquence_Int=value;
                        OnPropertyChanged(nameof( StartSquence_Int));
                    }
                }
            }
              private System.Int32 _StartDelay_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 StartDelay_Int
                {
                get {return _StartDelay_Int;}
                set{
                    if(value!=(_StartDelay_Int))
                    {
                        _StartDelay_Int=value;
                        OnPropertyChanged(nameof( StartDelay_Int));
                    }
                }
            }
              private System.String _ServiceDescribe_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String ServiceDescribe_Str
                {
                get {return _ServiceDescribe_Str;}
                set{
                    if(value!=(_ServiceDescribe_Str))
                    {
                        _ServiceDescribe_Str=value;
                        OnPropertyChanged(nameof( ServiceDescribe_Str));
                    }
                }
            }
              private System.Object _ServiceMessage_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.Object ServiceMessage_Str
                {
                get {return _ServiceMessage_Str;}
                set{
                    if(value!=(_ServiceMessage_Str))
                    {
                        _ServiceMessage_Str=value;
                        OnPropertyChanged(nameof( ServiceMessage_Str));
                    }
                }
            }
              private System.String _ServiceConfig_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String ServiceConfig_Str
                {
                get {return _ServiceConfig_Str;}
                set{
                    if(value!=(_ServiceConfig_Str))
                    {
                        _ServiceConfig_Str=value;
                        OnPropertyChanged(nameof( ServiceConfig_Str));
                    }
                }
            }
              private System.Boolean _IsEnable_Bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsEnable_Bit
                {
                get {return _IsEnable_Bit;}
                set{
                    if(value!=(_IsEnable_Bit))
                    {
                        _IsEnable_Bit=value;
                        OnPropertyChanged(nameof( IsEnable_Bit));
                    }
                }
            }
              private System.String _CreateUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String CreateUser_Str
                {
                get {return _CreateUser_Str;}
                set{
                    if(value!=(_CreateUser_Str))
                    {
                        _CreateUser_Str=value;
                        OnPropertyChanged(nameof( CreateUser_Str));
                    }
                }
            }
              private System.DateTime _CreateDate_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime CreateDate_Dt
                {
                get {return _CreateDate_Dt;}
                set{
                    if(value!=(_CreateDate_Dt))
                    {
                        _CreateDate_Dt=value;
                        OnPropertyChanged(nameof( CreateDate_Dt));
                    }
                }
            }
              private System.Boolean _IsSync_Bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsSync_Bit
                {
                get {return _IsSync_Bit;}
                set{
                    if(value!=(_IsSync_Bit))
                    {
                        _IsSync_Bit=value;
                        OnPropertyChanged(nameof( IsSync_Bit));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class sqlite_sequence:ObservableObject
             {
             	  private System.Object _name;
                /// <summary>
                /// 
                /// </summary>
                 public System.Object name
                {
                get {return _name;}
                set{
                    if(value!=(_name))
                    {
                        _name=value;
                        OnPropertyChanged(nameof( name));
                    }
                }
            }
              private System.Object _seq;
                /// <summary>
                /// 
                /// </summary>
                 public System.Object seq
                {
                get {return _seq;}
                set{
                    if(value!=(_seq))
                    {
                        _seq=value;
                        OnPropertyChanged(nameof( seq));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class Sys_User_Session:ObservableObject
             {
             	  private System.Int64 _ID;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int64 ID
                {
                get {return _ID;}
                set{
                    if(value!=(_ID))
                    {
                        _ID=value;
                        OnPropertyChanged(nameof( ID));
                    }
                }
            }
              private System.Int32 _OrgID_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 OrgID_Int
                {
                get {return _OrgID_Int;}
                set{
                    if(value!=(_OrgID_Int))
                    {
                        _OrgID_Int=value;
                        OnPropertyChanged(nameof( OrgID_Int));
                    }
                }
            }
              private System.String _AppName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String AppName_Str
                {
                get {return _AppName_Str;}
                set{
                    if(value!=(_AppName_Str))
                    {
                        _AppName_Str=value;
                        OnPropertyChanged(nameof( AppName_Str));
                    }
                }
            }
              private System.String _VersionNumber_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String VersionNumber_Str
                {
                get {return _VersionNumber_Str;}
                set{
                    if(value!=(_VersionNumber_Str))
                    {
                        _VersionNumber_Str=value;
                        OnPropertyChanged(nameof( VersionNumber_Str));
                    }
                }
            }
              private System.String _SessionID_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String SessionID_Str
                {
                get {return _SessionID_Str;}
                set{
                    if(value!=(_SessionID_Str))
                    {
                        _SessionID_Str=value;
                        OnPropertyChanged(nameof( SessionID_Str));
                    }
                }
            }
              private System.String _UserID_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String UserID_Str
                {
                get {return _UserID_Str;}
                set{
                    if(value!=(_UserID_Str))
                    {
                        _UserID_Str=value;
                        OnPropertyChanged(nameof( UserID_Str));
                    }
                }
            }
              private System.String _HostName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String HostName_Str
                {
                get {return _HostName_Str;}
                set{
                    if(value!=(_HostName_Str))
                    {
                        _HostName_Str=value;
                        OnPropertyChanged(nameof( HostName_Str));
                    }
                }
            }
              private System.String _MacAddr_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String MacAddr_Str
                {
                get {return _MacAddr_Str;}
                set{
                    if(value!=(_MacAddr_Str))
                    {
                        _MacAddr_Str=value;
                        OnPropertyChanged(nameof( MacAddr_Str));
                    }
                }
            }
              private System.String _IpAddr_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String IpAddr_Str
                {
                get {return _IpAddr_Str;}
                set{
                    if(value!=(_IpAddr_Str))
                    {
                        _IpAddr_Str=value;
                        OnPropertyChanged(nameof( IpAddr_Str));
                    }
                }
            }
              private System.DateTime _StartTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime StartTime_Dt
                {
                get {return _StartTime_Dt;}
                set{
                    if(value!=(_StartTime_Dt))
                    {
                        _StartTime_Dt=value;
                        OnPropertyChanged(nameof( StartTime_Dt));
                    }
                }
            }
              private System.DateTime _LastOnLineTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime LastOnLineTime_Dt
                {
                get {return _LastOnLineTime_Dt;}
                set{
                    if(value!=(_LastOnLineTime_Dt))
                    {
                        _LastOnLineTime_Dt=value;
                        OnPropertyChanged(nameof( LastOnLineTime_Dt));
                    }
                }
            }
              private System.DateTime _ModifyTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime ModifyTime_Dt
                {
                get {return _ModifyTime_Dt;}
                set{
                    if(value!=(_ModifyTime_Dt))
                    {
                        _ModifyTime_Dt=value;
                        OnPropertyChanged(nameof( ModifyTime_Dt));
                    }
                }
            }
              private System.String _ModifyUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String ModifyUser_Str
                {
                get {return _ModifyUser_Str;}
                set{
                    if(value!=(_ModifyUser_Str))
                    {
                        _ModifyUser_Str=value;
                        OnPropertyChanged(nameof( ModifyUser_Str));
                    }
                }
            }
              private System.DateTime _CreateTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime CreateTime_Dt
                {
                get {return _CreateTime_Dt;}
                set{
                    if(value!=(_CreateTime_Dt))
                    {
                        _CreateTime_Dt=value;
                        OnPropertyChanged(nameof( CreateTime_Dt));
                    }
                }
            }
              private System.String _CreateUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String CreateUser_Str
                {
                get {return _CreateUser_Str;}
                set{
                    if(value!=(_CreateUser_Str))
                    {
                        _CreateUser_Str=value;
                        OnPropertyChanged(nameof( CreateUser_Str));
                    }
                }
            }
              private System.String _Remark_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Remark_Str
                {
                get {return _Remark_Str;}
                set{
                    if(value!=(_Remark_Str))
                    {
                        _Remark_Str=value;
                        OnPropertyChanged(nameof( Remark_Str));
                    }
                }
            }
              private System.Boolean _IsEnable;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsEnable
                {
                get {return _IsEnable;}
                set{
                    if(value!=(_IsEnable))
                    {
                        _IsEnable=value;
                        OnPropertyChanged(nameof( IsEnable));
                    }
                }
            }
              private System.Boolean _IsPhantom_Bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsPhantom_Bit
                {
                get {return _IsPhantom_Bit;}
                set{
                    if(value!=(_IsPhantom_Bit))
                    {
                        _IsPhantom_Bit=value;
                        OnPropertyChanged(nameof( IsPhantom_Bit));
                    }
                }
            }
              private System.Boolean _IsSync_bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsSync_bit
                {
                get {return _IsSync_bit;}
                set{
                    if(value!=(_IsSync_bit))
                    {
                        _IsSync_bit=value;
                        OnPropertyChanged(nameof( IsSync_bit));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class SysApp_DayStatistics:ObservableObject
             {
             	  private System.Int64 _ID;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int64 ID
                {
                get {return _ID;}
                set{
                    if(value!=(_ID))
                    {
                        _ID=value;
                        OnPropertyChanged(nameof( ID));
                    }
                }
            }
              private System.Int32 _OrgID_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 OrgID_Int
                {
                get {return _OrgID_Int;}
                set{
                    if(value!=(_OrgID_Int))
                    {
                        _OrgID_Int=value;
                        OnPropertyChanged(nameof( OrgID_Int));
                    }
                }
            }
              private System.Int32 _SubINV_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 SubINV_Int
                {
                get {return _SubINV_Int;}
                set{
                    if(value!=(_SubINV_Int))
                    {
                        _SubINV_Int=value;
                        OnPropertyChanged(nameof( SubINV_Int));
                    }
                }
            }
              private System.String _Day_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Day_Str
                {
                get {return _Day_Str;}
                set{
                    if(value!=(_Day_Str))
                    {
                        _Day_Str=value;
                        OnPropertyChanged(nameof( Day_Str));
                    }
                }
            }
              private System.DateTime _DayStartTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime DayStartTime_Dt
                {
                get {return _DayStartTime_Dt;}
                set{
                    if(value!=(_DayStartTime_Dt))
                    {
                        _DayStartTime_Dt=value;
                        OnPropertyChanged(nameof( DayStartTime_Dt));
                    }
                }
            }
              private System.String _Source_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Source_Str
                {
                get {return _Source_Str;}
                set{
                    if(value!=(_Source_Str))
                    {
                        _Source_Str=value;
                        OnPropertyChanged(nameof( Source_Str));
                    }
                }
            }
              private System.DateTime _DayEndTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime DayEndTime_Dt
                {
                get {return _DayEndTime_Dt;}
                set{
                    if(value!=(_DayEndTime_Dt))
                    {
                        _DayEndTime_Dt=value;
                        OnPropertyChanged(nameof( DayEndTime_Dt));
                    }
                }
            }
              private System.String _AppName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String AppName_Str
                {
                get {return _AppName_Str;}
                set{
                    if(value!=(_AppName_Str))
                    {
                        _AppName_Str=value;
                        OnPropertyChanged(nameof( AppName_Str));
                    }
                }
            }
              private System.String _GroupName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String GroupName_Str
                {
                get {return _GroupName_Str;}
                set{
                    if(value!=(_GroupName_Str))
                    {
                        _GroupName_Str=value;
                        OnPropertyChanged(nameof( GroupName_Str));
                    }
                }
            }
              private System.Decimal _Value_Dec;
                /// <summary>
                /// 
                /// </summary>
                 public System.Decimal Value_Dec
                {
                get {return _Value_Dec;}
                set{
                    if(value!=(_Value_Dec))
                    {
                        _Value_Dec=value;
                        OnPropertyChanged(nameof( Value_Dec));
                    }
                }
            }
              private System.String _Remark_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Remark_Str
                {
                get {return _Remark_Str;}
                set{
                    if(value!=(_Remark_Str))
                    {
                        _Remark_Str=value;
                        OnPropertyChanged(nameof( Remark_Str));
                    }
                }
            }
              private System.DateTime _CreateTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime CreateTime_Dt
                {
                get {return _CreateTime_Dt;}
                set{
                    if(value!=(_CreateTime_Dt))
                    {
                        _CreateTime_Dt=value;
                        OnPropertyChanged(nameof( CreateTime_Dt));
                    }
                }
            }
              private System.String _CreateUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String CreateUser_Str
                {
                get {return _CreateUser_Str;}
                set{
                    if(value!=(_CreateUser_Str))
                    {
                        _CreateUser_Str=value;
                        OnPropertyChanged(nameof( CreateUser_Str));
                    }
                }
            }
              private System.Boolean _IsSync_bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsSync_bit
                {
                get {return _IsSync_bit;}
                set{
                    if(value!=(_IsSync_bit))
                    {
                        _IsSync_bit=value;
                        OnPropertyChanged(nameof( IsSync_bit));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class SysApp_MonthStatistics:ObservableObject
             {
             	  private System.Int64 _ID;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int64 ID
                {
                get {return _ID;}
                set{
                    if(value!=(_ID))
                    {
                        _ID=value;
                        OnPropertyChanged(nameof( ID));
                    }
                }
            }
              private System.Int32 _OrgID_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 OrgID_Int
                {
                get {return _OrgID_Int;}
                set{
                    if(value!=(_OrgID_Int))
                    {
                        _OrgID_Int=value;
                        OnPropertyChanged(nameof( OrgID_Int));
                    }
                }
            }
              private System.Int32 _SubINV_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 SubINV_Int
                {
                get {return _SubINV_Int;}
                set{
                    if(value!=(_SubINV_Int))
                    {
                        _SubINV_Int=value;
                        OnPropertyChanged(nameof( SubINV_Int));
                    }
                }
            }
              private System.String _Month_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Month_Str
                {
                get {return _Month_Str;}
                set{
                    if(value!=(_Month_Str))
                    {
                        _Month_Str=value;
                        OnPropertyChanged(nameof( Month_Str));
                    }
                }
            }
              private System.DateTime _MonthStartTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime MonthStartTime_Dt
                {
                get {return _MonthStartTime_Dt;}
                set{
                    if(value!=(_MonthStartTime_Dt))
                    {
                        _MonthStartTime_Dt=value;
                        OnPropertyChanged(nameof( MonthStartTime_Dt));
                    }
                }
            }
              private System.DateTime _MonthEndTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime MonthEndTime_Dt
                {
                get {return _MonthEndTime_Dt;}
                set{
                    if(value!=(_MonthEndTime_Dt))
                    {
                        _MonthEndTime_Dt=value;
                        OnPropertyChanged(nameof( MonthEndTime_Dt));
                    }
                }
            }
              private System.String _Source_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Source_Str
                {
                get {return _Source_Str;}
                set{
                    if(value!=(_Source_Str))
                    {
                        _Source_Str=value;
                        OnPropertyChanged(nameof( Source_Str));
                    }
                }
            }
              private System.String _AppName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String AppName_Str
                {
                get {return _AppName_Str;}
                set{
                    if(value!=(_AppName_Str))
                    {
                        _AppName_Str=value;
                        OnPropertyChanged(nameof( AppName_Str));
                    }
                }
            }
              private System.String _GroupName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String GroupName_Str
                {
                get {return _GroupName_Str;}
                set{
                    if(value!=(_GroupName_Str))
                    {
                        _GroupName_Str=value;
                        OnPropertyChanged(nameof( GroupName_Str));
                    }
                }
            }
              private System.Decimal _Value_Dec;
                /// <summary>
                /// 
                /// </summary>
                 public System.Decimal Value_Dec
                {
                get {return _Value_Dec;}
                set{
                    if(value!=(_Value_Dec))
                    {
                        _Value_Dec=value;
                        OnPropertyChanged(nameof( Value_Dec));
                    }
                }
            }
              private System.String _Remark_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Remark_Str
                {
                get {return _Remark_Str;}
                set{
                    if(value!=(_Remark_Str))
                    {
                        _Remark_Str=value;
                        OnPropertyChanged(nameof( Remark_Str));
                    }
                }
            }
              private System.DateTime _CreateTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime CreateTime_Dt
                {
                get {return _CreateTime_Dt;}
                set{
                    if(value!=(_CreateTime_Dt))
                    {
                        _CreateTime_Dt=value;
                        OnPropertyChanged(nameof( CreateTime_Dt));
                    }
                }
            }
              private System.String _CreateUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String CreateUser_Str
                {
                get {return _CreateUser_Str;}
                set{
                    if(value!=(_CreateUser_Str))
                    {
                        _CreateUser_Str=value;
                        OnPropertyChanged(nameof( CreateUser_Str));
                    }
                }
            }
              private System.Boolean _IsSync_bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsSync_bit
                {
                get {return _IsSync_bit;}
                set{
                    if(value!=(_IsSync_bit))
                    {
                        _IsSync_bit=value;
                        OnPropertyChanged(nameof( IsSync_bit));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class SysApp_YearStatistics:ObservableObject
             {
             	  private System.Int64 _ID;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int64 ID
                {
                get {return _ID;}
                set{
                    if(value!=(_ID))
                    {
                        _ID=value;
                        OnPropertyChanged(nameof( ID));
                    }
                }
            }
              private System.Int32 _OrgID_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 OrgID_Int
                {
                get {return _OrgID_Int;}
                set{
                    if(value!=(_OrgID_Int))
                    {
                        _OrgID_Int=value;
                        OnPropertyChanged(nameof( OrgID_Int));
                    }
                }
            }
              private System.Int32 _SubINV_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 SubINV_Int
                {
                get {return _SubINV_Int;}
                set{
                    if(value!=(_SubINV_Int))
                    {
                        _SubINV_Int=value;
                        OnPropertyChanged(nameof( SubINV_Int));
                    }
                }
            }
              private System.String _Year_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Year_Str
                {
                get {return _Year_Str;}
                set{
                    if(value!=(_Year_Str))
                    {
                        _Year_Str=value;
                        OnPropertyChanged(nameof( Year_Str));
                    }
                }
            }
              private System.DateTime _YearStartTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime YearStartTime_Dt
                {
                get {return _YearStartTime_Dt;}
                set{
                    if(value!=(_YearStartTime_Dt))
                    {
                        _YearStartTime_Dt=value;
                        OnPropertyChanged(nameof( YearStartTime_Dt));
                    }
                }
            }
              private System.DateTime _YearEndTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime YearEndTime_Dt
                {
                get {return _YearEndTime_Dt;}
                set{
                    if(value!=(_YearEndTime_Dt))
                    {
                        _YearEndTime_Dt=value;
                        OnPropertyChanged(nameof( YearEndTime_Dt));
                    }
                }
            }
              private System.String _Source_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Source_Str
                {
                get {return _Source_Str;}
                set{
                    if(value!=(_Source_Str))
                    {
                        _Source_Str=value;
                        OnPropertyChanged(nameof( Source_Str));
                    }
                }
            }
              private System.String _AppName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String AppName_Str
                {
                get {return _AppName_Str;}
                set{
                    if(value!=(_AppName_Str))
                    {
                        _AppName_Str=value;
                        OnPropertyChanged(nameof( AppName_Str));
                    }
                }
            }
              private System.String _GroupName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String GroupName_Str
                {
                get {return _GroupName_Str;}
                set{
                    if(value!=(_GroupName_Str))
                    {
                        _GroupName_Str=value;
                        OnPropertyChanged(nameof( GroupName_Str));
                    }
                }
            }
              private System.Decimal _Value_Dec;
                /// <summary>
                /// 
                /// </summary>
                 public System.Decimal Value_Dec
                {
                get {return _Value_Dec;}
                set{
                    if(value!=(_Value_Dec))
                    {
                        _Value_Dec=value;
                        OnPropertyChanged(nameof( Value_Dec));
                    }
                }
            }
              private System.String _Remark_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Remark_Str
                {
                get {return _Remark_Str;}
                set{
                    if(value!=(_Remark_Str))
                    {
                        _Remark_Str=value;
                        OnPropertyChanged(nameof( Remark_Str));
                    }
                }
            }
              private System.DateTime _CreateTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime CreateTime_Dt
                {
                get {return _CreateTime_Dt;}
                set{
                    if(value!=(_CreateTime_Dt))
                    {
                        _CreateTime_Dt=value;
                        OnPropertyChanged(nameof( CreateTime_Dt));
                    }
                }
            }
              private System.String _CreateUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String CreateUser_Str
                {
                get {return _CreateUser_Str;}
                set{
                    if(value!=(_CreateUser_Str))
                    {
                        _CreateUser_Str=value;
                        OnPropertyChanged(nameof( CreateUser_Str));
                    }
                }
            }
              private System.Boolean _IsSync_bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsSync_bit
                {
                get {return _IsSync_bit;}
                set{
                    if(value!=(_IsSync_bit))
                    {
                        _IsSync_bit=value;
                        OnPropertyChanged(nameof( IsSync_bit));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class Sys_Table_Comment:ObservableObject
             {
             	  private System.Int64 _ID;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int64 ID
                {
                get {return _ID;}
                set{
                    if(value!=(_ID))
                    {
                        _ID=value;
                        OnPropertyChanged(nameof( ID));
                    }
                }
            }
              private System.String _Type_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Type_Str
                {
                get {return _Type_Str;}
                set{
                    if(value!=(_Type_Str))
                    {
                        _Type_Str=value;
                        OnPropertyChanged(nameof( Type_Str));
                    }
                }
            }
              private System.String _Group_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Group_Str
                {
                get {return _Group_Str;}
                set{
                    if(value!=(_Group_Str))
                    {
                        _Group_Str=value;
                        OnPropertyChanged(nameof( Group_Str));
                    }
                }
            }
              private System.String _TableName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String TableName_Str
                {
                get {return _TableName_Str;}
                set{
                    if(value!=(_TableName_Str))
                    {
                        _TableName_Str=value;
                        OnPropertyChanged(nameof( TableName_Str));
                    }
                }
            }
              private System.Object _Comment_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.Object Comment_Str
                {
                get {return _Comment_Str;}
                set{
                    if(value!=(_Comment_Str))
                    {
                        _Comment_Str=value;
                        OnPropertyChanged(nameof( Comment_Str));
                    }
                }
            }
              private System.DateTime _CreateTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime CreateTime_Dt
                {
                get {return _CreateTime_Dt;}
                set{
                    if(value!=(_CreateTime_Dt))
                    {
                        _CreateTime_Dt=value;
                        OnPropertyChanged(nameof( CreateTime_Dt));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class sqlite_stat1:ObservableObject
             {
             	  private System.Object _tbl;
                /// <summary>
                /// 
                /// </summary>
                 public System.Object tbl
                {
                get {return _tbl;}
                set{
                    if(value!=(_tbl))
                    {
                        _tbl=value;
                        OnPropertyChanged(nameof( tbl));
                    }
                }
            }
              private System.Object _idx;
                /// <summary>
                /// 
                /// </summary>
                 public System.Object idx
                {
                get {return _idx;}
                set{
                    if(value!=(_idx))
                    {
                        _idx=value;
                        OnPropertyChanged(nameof( idx));
                    }
                }
            }
              private System.Object _stat;
                /// <summary>
                /// 
                /// </summary>
                 public System.Object stat
                {
                get {return _stat;}
                set{
                    if(value!=(_stat))
                    {
                        _stat=value;
                        OnPropertyChanged(nameof( stat));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class App_Common_ProductLog:ObservableObject
             {
             	  private System.Int64 _ID;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int64 ID
                {
                get {return _ID;}
                set{
                    if(value!=(_ID))
                    {
                        _ID=value;
                        OnPropertyChanged(nameof( ID));
                    }
                }
            }
              private System.Int32 _OrgID_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 OrgID_Int
                {
                get {return _OrgID_Int;}
                set{
                    if(value!=(_OrgID_Int))
                    {
                        _OrgID_Int=value;
                        OnPropertyChanged(nameof( OrgID_Int));
                    }
                }
            }
              private System.Int32 _SubINV_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 SubINV_Int
                {
                get {return _SubINV_Int;}
                set{
                    if(value!=(_SubINV_Int))
                    {
                        _SubINV_Int=value;
                        OnPropertyChanged(nameof( SubINV_Int));
                    }
                }
            }
              private System.String _Line_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Line_Str
                {
                get {return _Line_Str;}
                set{
                    if(value!=(_Line_Str))
                    {
                        _Line_Str=value;
                        OnPropertyChanged(nameof( Line_Str));
                    }
                }
            }
              private System.String _DeviceID_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String DeviceID_Str
                {
                get {return _DeviceID_Str;}
                set{
                    if(value!=(_DeviceID_Str))
                    {
                        _DeviceID_Str=value;
                        OnPropertyChanged(nameof( DeviceID_Str));
                    }
                }
            }
              private System.String _BarCode_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String BarCode_Str
                {
                get {return _BarCode_Str;}
                set{
                    if(value!=(_BarCode_Str))
                    {
                        _BarCode_Str=value;
                        OnPropertyChanged(nameof( BarCode_Str));
                    }
                }
            }
              private System.String _ProductModel_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String ProductModel_Str
                {
                get {return _ProductModel_Str;}
                set{
                    if(value!=(_ProductModel_Str))
                    {
                        _ProductModel_Str=value;
                        OnPropertyChanged(nameof( ProductModel_Str));
                    }
                }
            }
              private System.Int32 _TestResult_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 TestResult_Int
                {
                get {return _TestResult_Int;}
                set{
                    if(value!=(_TestResult_Int))
                    {
                        _TestResult_Int=value;
                        OnPropertyChanged(nameof( TestResult_Int));
                    }
                }
            }
              private System.String _NGDesc_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String NGDesc_Str
                {
                get {return _NGDesc_Str;}
                set{
                    if(value!=(_NGDesc_Str))
                    {
                        _NGDesc_Str=value;
                        OnPropertyChanged(nameof( NGDesc_Str));
                    }
                }
            }
              private System.Int32 _Index_int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 Index_int
                {
                get {return _Index_int;}
                set{
                    if(value!=(_Index_int))
                    {
                        _Index_int=value;
                        OnPropertyChanged(nameof( Index_int));
                    }
                }
            }
              private System.Int32 _LotQty_int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 LotQty_int
                {
                get {return _LotQty_int;}
                set{
                    if(value!=(_LotQty_int))
                    {
                        _LotQty_int=value;
                        OnPropertyChanged(nameof( LotQty_int));
                    }
                }
            }
              private System.String _CreateUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String CreateUser_Str
                {
                get {return _CreateUser_Str;}
                set{
                    if(value!=(_CreateUser_Str))
                    {
                        _CreateUser_Str=value;
                        OnPropertyChanged(nameof( CreateUser_Str));
                    }
                }
            }
              private System.DateTime _CreateTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime CreateTime_Dt
                {
                get {return _CreateTime_Dt;}
                set{
                    if(value!=(_CreateTime_Dt))
                    {
                        _CreateTime_Dt=value;
                        OnPropertyChanged(nameof( CreateTime_Dt));
                    }
                }
            }
              private System.DateTime _ModifyTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime ModifyTime_Dt
                {
                get {return _ModifyTime_Dt;}
                set{
                    if(value!=(_ModifyTime_Dt))
                    {
                        _ModifyTime_Dt=value;
                        OnPropertyChanged(nameof( ModifyTime_Dt));
                    }
                }
            }
              private System.String _ModifyUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String ModifyUser_Str
                {
                get {return _ModifyUser_Str;}
                set{
                    if(value!=(_ModifyUser_Str))
                    {
                        _ModifyUser_Str=value;
                        OnPropertyChanged(nameof( ModifyUser_Str));
                    }
                }
            }
              private System.String _Remark_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Remark_Str
                {
                get {return _Remark_Str;}
                set{
                    if(value!=(_Remark_Str))
                    {
                        _Remark_Str=value;
                        OnPropertyChanged(nameof( Remark_Str));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class Sys_JobScheduler:ObservableObject
             {
             	  private System.Int64 _ID;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int64 ID
                {
                get {return _ID;}
                set{
                    if(value!=(_ID))
                    {
                        _ID=value;
                        OnPropertyChanged(nameof( ID));
                    }
                }
            }
              private System.String _JobName_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String JobName_Str
                {
                get {return _JobName_Str;}
                set{
                    if(value!=(_JobName_Str))
                    {
                        _JobName_Str=value;
                        OnPropertyChanged(nameof( JobName_Str));
                    }
                }
            }
              private System.String _JobState_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String JobState_Str
                {
                get {return _JobState_Str;}
                set{
                    if(value!=(_JobState_Str))
                    {
                        _JobState_Str=value;
                        OnPropertyChanged(nameof( JobState_Str));
                    }
                }
            }
              private System.String _JobType_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String JobType_Str
                {
                get {return _JobType_Str;}
                set{
                    if(value!=(_JobType_Str))
                    {
                        _JobType_Str=value;
                        OnPropertyChanged(nameof( JobType_Str));
                    }
                }
            }
              private System.String _ExcutePolicy_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String ExcutePolicy_Str
                {
                get {return _ExcutePolicy_Str;}
                set{
                    if(value!=(_ExcutePolicy_Str))
                    {
                        _ExcutePolicy_Str=value;
                        OnPropertyChanged(nameof( ExcutePolicy_Str));
                    }
                }
            }
              private System.String _JobParameter_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String JobParameter_Str
                {
                get {return _JobParameter_Str;}
                set{
                    if(value!=(_JobParameter_Str))
                    {
                        _JobParameter_Str=value;
                        OnPropertyChanged(nameof( JobParameter_Str));
                    }
                }
            }
              private System.DateTime _LastExcuteTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime LastExcuteTime_Dt
                {
                get {return _LastExcuteTime_Dt;}
                set{
                    if(value!=(_LastExcuteTime_Dt))
                    {
                        _LastExcuteTime_Dt=value;
                        OnPropertyChanged(nameof( LastExcuteTime_Dt));
                    }
                }
            }
              private System.DateTime _NextExcuteTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime NextExcuteTime_Dt
                {
                get {return _NextExcuteTime_Dt;}
                set{
                    if(value!=(_NextExcuteTime_Dt))
                    {
                        _NextExcuteTime_Dt=value;
                        OnPropertyChanged(nameof( NextExcuteTime_Dt));
                    }
                }
            }
              private System.String _JobDescribe_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String JobDescribe_Str
                {
                get {return _JobDescribe_Str;}
                set{
                    if(value!=(_JobDescribe_Str))
                    {
                        _JobDescribe_Str=value;
                        OnPropertyChanged(nameof( JobDescribe_Str));
                    }
                }
            }
              private System.Object _JobMessage_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.Object JobMessage_Str
                {
                get {return _JobMessage_Str;}
                set{
                    if(value!=(_JobMessage_Str))
                    {
                        _JobMessage_Str=value;
                        OnPropertyChanged(nameof( JobMessage_Str));
                    }
                }
            }
              private System.Boolean _TriggerWhenStart_bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean TriggerWhenStart_bit
                {
                get {return _TriggerWhenStart_bit;}
                set{
                    if(value!=(_TriggerWhenStart_bit))
                    {
                        _TriggerWhenStart_bit=value;
                        OnPropertyChanged(nameof( TriggerWhenStart_bit));
                    }
                }
            }
              private System.Boolean _IsEnable_Bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsEnable_Bit
                {
                get {return _IsEnable_Bit;}
                set{
                    if(value!=(_IsEnable_Bit))
                    {
                        _IsEnable_Bit=value;
                        OnPropertyChanged(nameof( IsEnable_Bit));
                    }
                }
            }
              private System.Boolean _NeedRestart_Bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean NeedRestart_Bit
                {
                get {return _NeedRestart_Bit;}
                set{
                    if(value!=(_NeedRestart_Bit))
                    {
                        _NeedRestart_Bit=value;
                        OnPropertyChanged(nameof( NeedRestart_Bit));
                    }
                }
            }
              private System.String _CreateUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String CreateUser_Str
                {
                get {return _CreateUser_Str;}
                set{
                    if(value!=(_CreateUser_Str))
                    {
                        _CreateUser_Str=value;
                        OnPropertyChanged(nameof( CreateUser_Str));
                    }
                }
            }
              private System.DateTime _CreateDate_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime CreateDate_Dt
                {
                get {return _CreateDate_Dt;}
                set{
                    if(value!=(_CreateDate_Dt))
                    {
                        _CreateDate_Dt=value;
                        OnPropertyChanged(nameof( CreateDate_Dt));
                    }
                }
            }
              private System.Boolean _IsSync_Bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsSync_Bit
                {
                get {return _IsSync_Bit;}
                set{
                    if(value!=(_IsSync_Bit))
                    {
                        _IsSync_Bit=value;
                        OnPropertyChanged(nameof( IsSync_Bit));
                    }
                }
            }
            
             }
             /// <summary> 
             /// 
             /// </summary>
             public class Sys_JobSchedulerExcuteLog:ObservableObject
             {
             	  private System.Int64 _ID;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int64 ID
                {
                get {return _ID;}
                set{
                    if(value!=(_ID))
                    {
                        _ID=value;
                        OnPropertyChanged(nameof( ID));
                    }
                }
            }
              private System.Int32 _JobId_Int;
                /// <summary>
                /// 
                /// </summary>
                 public System.Int32 JobId_Int
                {
                get {return _JobId_Int;}
                set{
                    if(value!=(_JobId_Int))
                    {
                        _JobId_Int=value;
                        OnPropertyChanged(nameof( JobId_Int));
                    }
                }
            }
              private System.String _JobType_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String JobType_Str
                {
                get {return _JobType_Str;}
                set{
                    if(value!=(_JobType_Str))
                    {
                        _JobType_Str=value;
                        OnPropertyChanged(nameof( JobType_Str));
                    }
                }
            }
              private System.Decimal _ElapsedTime_Dec;
                /// <summary>
                /// 
                /// </summary>
                 public System.Decimal ElapsedTime_Dec
                {
                get {return _ElapsedTime_Dec;}
                set{
                    if(value!=(_ElapsedTime_Dec))
                    {
                        _ElapsedTime_Dec=value;
                        OnPropertyChanged(nameof( ElapsedTime_Dec));
                    }
                }
            }
              private System.DateTime _ExcuteStartTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime ExcuteStartTime_Dt
                {
                get {return _ExcuteStartTime_Dt;}
                set{
                    if(value!=(_ExcuteStartTime_Dt))
                    {
                        _ExcuteStartTime_Dt=value;
                        OnPropertyChanged(nameof( ExcuteStartTime_Dt));
                    }
                }
            }
              private System.DateTime _ExcuteFinishTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime ExcuteFinishTime_Dt
                {
                get {return _ExcuteFinishTime_Dt;}
                set{
                    if(value!=(_ExcuteFinishTime_Dt))
                    {
                        _ExcuteFinishTime_Dt=value;
                        OnPropertyChanged(nameof( ExcuteFinishTime_Dt));
                    }
                }
            }
              private System.DateTime _NextExcuteTime_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime NextExcuteTime_Dt
                {
                get {return _NextExcuteTime_Dt;}
                set{
                    if(value!=(_NextExcuteTime_Dt))
                    {
                        _NextExcuteTime_Dt=value;
                        OnPropertyChanged(nameof( NextExcuteTime_Dt));
                    }
                }
            }
              private System.Boolean _ExcuteResult_Bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean ExcuteResult_Bit
                {
                get {return _ExcuteResult_Bit;}
                set{
                    if(value!=(_ExcuteResult_Bit))
                    {
                        _ExcuteResult_Bit=value;
                        OnPropertyChanged(nameof( ExcuteResult_Bit));
                    }
                }
            }
              private System.String _Message_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String Message_Str
                {
                get {return _Message_Str;}
                set{
                    if(value!=(_Message_Str))
                    {
                        _Message_Str=value;
                        OnPropertyChanged(nameof( Message_Str));
                    }
                }
            }
              private System.String _CreateUser_Str;
                /// <summary>
                /// 
                /// </summary>
                 public System.String CreateUser_Str
                {
                get {return _CreateUser_Str;}
                set{
                    if(value!=(_CreateUser_Str))
                    {
                        _CreateUser_Str=value;
                        OnPropertyChanged(nameof( CreateUser_Str));
                    }
                }
            }
              private System.DateTime _CreateDate_Dt;
                /// <summary>
                /// 
                /// </summary>
                 public System.DateTime CreateDate_Dt
                {
                get {return _CreateDate_Dt;}
                set{
                    if(value!=(_CreateDate_Dt))
                    {
                        _CreateDate_Dt=value;
                        OnPropertyChanged(nameof( CreateDate_Dt));
                    }
                }
            }
              private System.Boolean _IsSync_Bit;
                /// <summary>
                /// 
                /// </summary>
                 public System.Boolean IsSync_Bit
                {
                get {return _IsSync_Bit;}
                set{
                    if(value!=(_IsSync_Bit))
                    {
                        _IsSync_Bit=value;
                        OnPropertyChanged(nameof( IsSync_Bit));
                    }
                }
            }
            
             }
             
            
    }

    namespace DIL
    {
           public class DILDB:SQLiteDB
        {
        #region Auto Declare
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_Service{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable sqlite_sequence{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_User_Session{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable SysApp_DayStatistics{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable SysApp_MonthStatistics{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable SysApp_YearStatistics{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_Table_Comment{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable sqlite_stat1{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable App_Common_ProductLog{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_JobScheduler{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_JobSchedulerExcuteLog{get;private set;}
public DILDB(string folderPath, string fileName,string username=null,string password=null):base(folderPath, fileName,username,password)
{
Sys_Service=CreateTable("ID","Sys_Service");
sqlite_sequence=CreateTable("ID","sqlite_sequence");
Sys_User_Session=CreateTable("ID","Sys_User_Session");
SysApp_DayStatistics=CreateTable("ID","SysApp_DayStatistics");
SysApp_MonthStatistics=CreateTable("ID","SysApp_MonthStatistics");
SysApp_YearStatistics=CreateTable("ID","SysApp_YearStatistics");
Sys_Table_Comment=CreateTable("ID","Sys_Table_Comment");
sqlite_stat1=CreateTable("ID","sqlite_stat1");
App_Common_ProductLog=CreateTable("ID","App_Common_ProductLog");
Sys_JobScheduler=CreateTable("ID","Sys_JobScheduler");
Sys_JobSchedulerExcuteLog=CreateTable("ID","Sys_JobSchedulerExcuteLog");
}
#endregion
}
#region V1版本数据库架构
public class DILDBV1:BaseDB
{
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_Service{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable sqlite_sequence{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_User_Session{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable SysApp_DayStatistics{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable SysApp_MonthStatistics{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable SysApp_YearStatistics{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_Table_Comment{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable sqlite_stat1{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable App_Common_ProductLog{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_JobScheduler{get;private set;}
 /// <summary> 
 ///  
 /// </summary> 
public BaseTable Sys_JobSchedulerExcuteLog{get;private set;}
private BaseDB innerDb = null;
public DILDBV1(BaseDB db )
{
                innerDb = db;
                SO = db.SO;
                DatabaseType = db.DatabaseType;
                DatabaseInfo = db.DatabaseInfo;
                ServerName = db.ServerName;
Sys_Service=innerDb.CreateTable("ID","Sys_Service");
sqlite_sequence=innerDb.CreateTable("ID","sqlite_sequence");
Sys_User_Session=innerDb.CreateTable("ID","Sys_User_Session");
SysApp_DayStatistics=innerDb.CreateTable("ID","SysApp_DayStatistics");
SysApp_MonthStatistics=innerDb.CreateTable("ID","SysApp_MonthStatistics");
SysApp_YearStatistics=innerDb.CreateTable("ID","SysApp_YearStatistics");
Sys_Table_Comment=innerDb.CreateTable("ID","Sys_Table_Comment");
sqlite_stat1=innerDb.CreateTable("ID","sqlite_stat1");
App_Common_ProductLog=innerDb.CreateTable("ID","App_Common_ProductLog");
Sys_JobScheduler=innerDb.CreateTable("ID","Sys_JobScheduler");
Sys_JobSchedulerExcuteLog=innerDb.CreateTable("ID","Sys_JobSchedulerExcuteLog");
}

            public override BaseTable CreateTable(string tableName)
            {
                return innerDb.CreateTable(tableName);
            }

            public override BaseTable CreateTable(string id, string tableName)
            {
                return innerDb.CreateTable(id, tableName);
            }

            protected override string GetCnn()
            {
                return innerDb.ConnectionString;
            }

            public override void Init(string server, string database, string username, string password)
            {
                throw new NotImplementedException();
            }

            public override DateTime? GetDate()
            {
                 return  innerDb.GetDate();
            }

            public override List<TableInfo> GetTables()
            {
                return innerDb.GetTables();
            }

            public override List<ColumnInfo> GetTableColumns()
            {
               return innerDb.GetTableColumns();
            }

            public override List<TableInfo> GetViews()
            {
                return innerDb.GetViews();
            }

            public override List<ColumnInfo> GetViewColumns()
            {
                return innerDb.GetViewColumns();
            }

            

            public override ExecuteResult UpdateTableComment(string tableName, string comment)
            {
                return innerDb.UpdateTableComment(tableName, comment);
            }

            public override ExecuteResult UpdateColumnComment(string tableName, string columnName, string comment)
            {
                return innerDb.UpdateColumnComment(tableName,columnName, comment);
            }

            public override bool BatchUpdateOrInsert<T>(IEnumerable<T> modelList, Expression<Func<T, dynamic>> onRelations, string destinationTableName = null, Expression<Func<T, dynamic>> updateProperts = null)
            {
                return innerDb.BatchUpdateOrInsert(modelList, onRelations, destinationTableName, updateProperts);
            }

            public override int BatchDelete(IEnumerable<object> ids, string destinationTableName, string idColumn = "ID")
            {
                return base.BatchDelete(ids, destinationTableName, idColumn);
            }

            public override int BatchDelete<T>(IEnumerable<T> modelList, Expression<Func<T, dynamic>> onRelations, string destinationTableName = null)
            {
                return base.BatchDelete(modelList, onRelations, destinationTableName);
            }
#endregion

        }
    }
}