using System;
using System.Collections.Generic;
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
{
///
/// sqlite_sequence
///
public class sqlite_sequence
{
///
///
///
public const string @name=nameof(@name);
///
///
///
public const string @seq=nameof(@seq);
}
///
/// Sys_User_Session
///
public class Sys_User_Session
{
///
///
///
public const string @ID=nameof(@ID);
///
///
///
public const string @OrgID_Int=nameof(@OrgID_Int);
///
///
///
public const string @AppName_Str=nameof(@AppName_Str);
///
///
///
public const string @VersionNumber_Str=nameof(@VersionNumber_Str);
///
///
///
public const string @SessionID_Str=nameof(@SessionID_Str);
///
///
///
public const string @UserID_Str=nameof(@UserID_Str);
///
///
///
public const string @HostName_Str=nameof(@HostName_Str);
///
///
///
public const string @MacAddr_Str=nameof(@MacAddr_Str);
///
///
///
public const string @IpAddr_Str=nameof(@IpAddr_Str);
///
///
///
public const string @StartTime_Dt=nameof(@StartTime_Dt);
///
///
///
public const string @LastOnLineTime_Dt=nameof(@LastOnLineTime_Dt);
///
///
///
public const string @ModifyTime_Dt=nameof(@ModifyTime_Dt);
///
///
///
public const string @ModifyUser_Str=nameof(@ModifyUser_Str);
///
///
///
public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
///
///
///
public const string @CreateUser_Str=nameof(@CreateUser_Str);
///
///
///
public const string @Remark_Str=nameof(@Remark_Str);
///
///
///
public const string @IsEnable=nameof(@IsEnable);
///
///
///
public const string @IsPhantom_Bit=nameof(@IsPhantom_Bit);
///
///
///
public const string @IsSync_bit=nameof(@IsSync_bit);
}
///
/// SysApp_DayStatistics
///
public class SysApp_DayStatistics
{
///
///
///
public const string @ID=nameof(@ID);
///
///
///
public const string @OrgID_Int=nameof(@OrgID_Int);
///
///
///
public const string @SubINV_Int=nameof(@SubINV_Int);
///
///
///
public const string @Day_Str=nameof(@Day_Str);
///
///
///
public const string @DayStartTime_Dt=nameof(@DayStartTime_Dt);
///
///
///
public const string @Source_Str=nameof(@Source_Str);
///
///
///
public const string @DayEndTime_Dt=nameof(@DayEndTime_Dt);
///
///
///
public const string @AppName_Str=nameof(@AppName_Str);
///
///
///
public const string @GroupName_Str=nameof(@GroupName_Str);
///
///
///
public const string @Value_Dec=nameof(@Value_Dec);
///
///
///
public const string @Remark_Str=nameof(@Remark_Str);
///
///
///
public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
///
///
///
public const string @CreateUser_Str=nameof(@CreateUser_Str);
///
///
///
public const string @IsSync_bit=nameof(@IsSync_bit);
}
///
/// SysApp_MonthStatistics
///
public class SysApp_MonthStatistics
{
///
///
///
public const string @ID=nameof(@ID);
///
///
///
public const string @OrgID_Int=nameof(@OrgID_Int);
///
///
///
public const string @SubINV_Int=nameof(@SubINV_Int);
///
///
///
public const string @Month_Str=nameof(@Month_Str);
///
///
///
public const string @MonthStartTime_Dt=nameof(@MonthStartTime_Dt);
///
///
///
public const string @MonthEndTime_Dt=nameof(@MonthEndTime_Dt);
///
///
///
public const string @Source_Str=nameof(@Source_Str);
///
///
///
public const string @AppName_Str=nameof(@AppName_Str);
///
///
///
public const string @GroupName_Str=nameof(@GroupName_Str);
///
///
///
public const string @Value_Dec=nameof(@Value_Dec);
///
///
///
public const string @Remark_Str=nameof(@Remark_Str);
///
///
///
public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
///
///
///
public const string @CreateUser_Str=nameof(@CreateUser_Str);
///
///
///
public const string @IsSync_bit=nameof(@IsSync_bit);
}
///
/// SysApp_YearStatistics
///
public class SysApp_YearStatistics
{
///
///
///
public const string @ID=nameof(@ID);
///
///
///
public const string @OrgID_Int=nameof(@OrgID_Int);
///
///
///
public const string @SubINV_Int=nameof(@SubINV_Int);
///
///
///
public const string @Year_Str=nameof(@Year_Str);
///
///
///
public const string @YearStartTime_Dt=nameof(@YearStartTime_Dt);
///
///
///
public const string @YearEndTime_Dt=nameof(@YearEndTime_Dt);
///
///
///
public const string @Source_Str=nameof(@Source_Str);
///
///
///
public const string @AppName_Str=nameof(@AppName_Str);
///
///
///
public const string @GroupName_Str=nameof(@GroupName_Str);
///
///
///
public const string @Value_Dec=nameof(@Value_Dec);
///
///
///
public const string @Remark_Str=nameof(@Remark_Str);
///
///
///
public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
///
///
///
public const string @CreateUser_Str=nameof(@CreateUser_Str);
///
///
///
public const string @IsSync_bit=nameof(@IsSync_bit);
}
///
/// Sys_Table_Comment
///
public class Sys_Table_Comment
{
///
///
///
public const string @ID=nameof(@ID);
///
///
///
public const string @Type_Str=nameof(@Type_Str);
///
///
///
public const string @Group_Str=nameof(@Group_Str);
///
///
///
public const string @TableName_Str=nameof(@TableName_Str);
///
///
///
public const string @Comment_Str=nameof(@Comment_Str);
///
///
///
public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
}
///
/// sqlite_stat1
///
public class sqlite_stat1
{
///
///
///
public const string @tbl=nameof(@tbl);
///
///
///
public const string @idx=nameof(@idx);
///
///
///
public const string @stat=nameof(@stat);
}
///
/// App_Common_ProductLog
///
public class App_Common_ProductLog
{
///
///
///
public const string @ID=nameof(@ID);
///
///
///
public const string @OrgID_Int=nameof(@OrgID_Int);
///
///
///
public const string @SubINV_Int=nameof(@SubINV_Int);
///
///
///
public const string @Line_Str=nameof(@Line_Str);
///
///
///
public const string @DeviceID_Str=nameof(@DeviceID_Str);
///
///
///
public const string @BarCode_Str=nameof(@BarCode_Str);
///
///
///
public const string @ProductModel_Str=nameof(@ProductModel_Str);
///
///
///
public const string @TestResult_Int=nameof(@TestResult_Int);
///
///
///
public const string @NGDesc_Str=nameof(@NGDesc_Str);
///
///
///
public const string @Index_int=nameof(@Index_int);
///
///
///
public const string @LotQty_int=nameof(@LotQty_int);
///
///
///
public const string @CreateUser_Str=nameof(@CreateUser_Str);
///
///
///
public const string @CreateTime_Dt=nameof(@CreateTime_Dt);
///
///
///
public const string @ModifyTime_Dt=nameof(@ModifyTime_Dt);
///
///
///
public const string @ModifyUser_Str=nameof(@ModifyUser_Str);
///
///
///
public const string @Remark_Str=nameof(@Remark_Str);
}
///
/// Sys_JobSchedulerExcuteLog
///
public class Sys_JobSchedulerExcuteLog
{
///
///
///
public const string @ID=nameof(@ID);
///
///
///
public const string @JobId_Int=nameof(@JobId_Int);
///
///
///
public const string @JobType_Str=nameof(@JobType_Str);
///
///
///
public const string @ElapsedTime_Dec=nameof(@ElapsedTime_Dec);
///
///
///
public const string @ExcuteStartTime_Dt=nameof(@ExcuteStartTime_Dt);
///
///
///
public const string @ExcuteFinishTime_Dt=nameof(@ExcuteFinishTime_Dt);
///
///
///
public const string @NextExcuteTime_Dt=nameof(@NextExcuteTime_Dt);
///
///
///
public const string @ExcuteResult_Bit=nameof(@ExcuteResult_Bit);
///
///
///
public const string @Message_Str=nameof(@Message_Str);
///
///
///
public const string @CreateUser_Str=nameof(@CreateUser_Str);
///
///
///
public const string @CreateDate_Dt=nameof(@CreateDate_Dt);
///
///
///
public const string @IsSync_Bit=nameof(@IsSync_Bit);
}
///
/// Sys_JobScheduler
///
public class Sys_JobScheduler
{
///
///
///
public const string @ID=nameof(@ID);
///
///
///
public const string @JobName_Str=nameof(@JobName_Str);
///
///
///
public const string @JobState_Str=nameof(@JobState_Str);
///
///
///
public const string @JobType_Str=nameof(@JobType_Str);
///
///
///
public const string @ExcutePolicy_Str=nameof(@ExcutePolicy_Str);
///
///
///
public const string @JobParameter_Str=nameof(@JobParameter_Str);
///
///
///
public const string @LastExcuteTime_Dt=nameof(@LastExcuteTime_Dt);
///
///
///
public const string @NextExcuteTime_Dt=nameof(@NextExcuteTime_Dt);
///
///
///
public const string @JobDescribe_Str=nameof(@JobDescribe_Str);
///
///
///
public const string @JobMessage_Str=nameof(@JobMessage_Str);
///
///
///
public const string @TriggerWhenStart_bit=nameof(@TriggerWhenStart_bit);
///
///
///
public const string @IsEnable_Bit=nameof(@IsEnable_Bit);
///
///
///
public const string @NeedRestart_Bit=nameof(@NeedRestart_Bit);
///
///
///
public const string @CreateUser_Str=nameof(@CreateUser_Str);
///
///
///
public const string @CreateDate_Dt=nameof(@CreateDate_Dt);
///
///
///
public const string @IsSync_Bit=nameof(@IsSync_Bit);
}
///
/// Sys_Service
///
public class Sys_Service
{
///
///
///
public const string @ID=nameof(@ID);
///
///
///
public const string @ServiceName_Str=nameof(@ServiceName_Str);
///
///
///
public const string @ServiceState_Str=nameof(@ServiceState_Str);
///
///
///
public const string @ServiceType_Str=nameof(@ServiceType_Str);
///
///
///
public const string @StartTime_Dt=nameof(@StartTime_Dt);
///
///
///
public const string @StartSquence_Int=nameof(@StartSquence_Int);
///
///
///
public const string @StartDelay_Int=nameof(@StartDelay_Int);
///
///
///
public const string @ServiceDescribe_Str=nameof(@ServiceDescribe_Str);
///
///
///
public const string @ServiceMessage_Str=nameof(@ServiceMessage_Str);
///
///
///
public const string @ServiceConfig_Str=nameof(@ServiceConfig_Str);
///
///
///
public const string @IsEnable_Bit=nameof(@IsEnable_Bit);
///
///
///
public const string @CreateUser_Str=nameof(@CreateUser_Str);
///
///
///
public const string @CreateDate_Dt=nameof(@CreateDate_Dt);
///
///
///
public const string @IsSync_Bit=nameof(@IsSync_Bit);
}
}
public static class V_Col_Name
{
}
public static class SP_Paramters
{
}
}
namespace DBModel
{
///
///
///
public class sqlite_sequence:ObservableObject
{
private System.Object _name;
///
///
///
public System.Object name
{
get {return _name;}
set{
if(value!=(_name))
{
_name=value;
OnPropertyChanged(nameof( name));
}
}
}
private System.Object _seq;
///
///
///
public System.Object seq
{
get {return _seq;}
set{
if(value!=(_seq))
{
_seq=value;
OnPropertyChanged(nameof( seq));
}
}
}
}
///
///
///
public class Sys_User_Session:ObservableObject
{
private System.Int64 _ID;
///
///
///
public System.Int64 ID
{
get {return _ID;}
set{
if(value!=(_ID))
{
_ID=value;
OnPropertyChanged(nameof( ID));
}
}
}
private System.Int32 _OrgID_Int;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.Boolean IsEnable
{
get {return _IsEnable;}
set{
if(value!=(_IsEnable))
{
_IsEnable=value;
OnPropertyChanged(nameof( IsEnable));
}
}
}
private System.Boolean _IsPhantom_Bit;
///
///
///
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;
///
///
///
public System.Boolean IsSync_bit
{
get {return _IsSync_bit;}
set{
if(value!=(_IsSync_bit))
{
_IsSync_bit=value;
OnPropertyChanged(nameof( IsSync_bit));
}
}
}
}
///
///
///
public class SysApp_DayStatistics:ObservableObject
{
private System.Int64 _ID;
///
///
///
public System.Int64 ID
{
get {return _ID;}
set{
if(value!=(_ID))
{
_ID=value;
OnPropertyChanged(nameof( ID));
}
}
}
private System.Int32 _OrgID_Int;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.Boolean IsSync_bit
{
get {return _IsSync_bit;}
set{
if(value!=(_IsSync_bit))
{
_IsSync_bit=value;
OnPropertyChanged(nameof( IsSync_bit));
}
}
}
}
///
///
///
public class SysApp_MonthStatistics:ObservableObject
{
private System.Int64 _ID;
///
///
///
public System.Int64 ID
{
get {return _ID;}
set{
if(value!=(_ID))
{
_ID=value;
OnPropertyChanged(nameof( ID));
}
}
}
private System.Int32 _OrgID_Int;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.Boolean IsSync_bit
{
get {return _IsSync_bit;}
set{
if(value!=(_IsSync_bit))
{
_IsSync_bit=value;
OnPropertyChanged(nameof( IsSync_bit));
}
}
}
}
///
///
///
public class SysApp_YearStatistics:ObservableObject
{
private System.Int64 _ID;
///
///
///
public System.Int64 ID
{
get {return _ID;}
set{
if(value!=(_ID))
{
_ID=value;
OnPropertyChanged(nameof( ID));
}
}
}
private System.Int32 _OrgID_Int;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.Boolean IsSync_bit
{
get {return _IsSync_bit;}
set{
if(value!=(_IsSync_bit))
{
_IsSync_bit=value;
OnPropertyChanged(nameof( IsSync_bit));
}
}
}
}
///
///
///
public class Sys_Table_Comment:ObservableObject
{
private System.Int64 _ID;
///
///
///
public System.Int64 ID
{
get {return _ID;}
set{
if(value!=(_ID))
{
_ID=value;
OnPropertyChanged(nameof( ID));
}
}
}
private System.String _Type_Str;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.DateTime CreateTime_Dt
{
get {return _CreateTime_Dt;}
set{
if(value!=(_CreateTime_Dt))
{
_CreateTime_Dt=value;
OnPropertyChanged(nameof( CreateTime_Dt));
}
}
}
}
///
///
///
public class sqlite_stat1:ObservableObject
{
private System.Object _tbl;
///
///
///
public System.Object tbl
{
get {return _tbl;}
set{
if(value!=(_tbl))
{
_tbl=value;
OnPropertyChanged(nameof( tbl));
}
}
}
private System.Object _idx;
///
///
///
public System.Object idx
{
get {return _idx;}
set{
if(value!=(_idx))
{
_idx=value;
OnPropertyChanged(nameof( idx));
}
}
}
private System.Object _stat;
///
///
///
public System.Object stat
{
get {return _stat;}
set{
if(value!=(_stat))
{
_stat=value;
OnPropertyChanged(nameof( stat));
}
}
}
}
///
///
///
public class App_Common_ProductLog:ObservableObject
{
private System.Int64 _ID;
///
///
///
public System.Int64 ID
{
get {return _ID;}
set{
if(value!=(_ID))
{
_ID=value;
OnPropertyChanged(nameof( ID));
}
}
}
private System.Int32 _OrgID_Int;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.String Remark_Str
{
get {return _Remark_Str;}
set{
if(value!=(_Remark_Str))
{
_Remark_Str=value;
OnPropertyChanged(nameof( Remark_Str));
}
}
}
}
///
///
///
public class Sys_JobSchedulerExcuteLog:ObservableObject
{
private System.Int64 _ID;
///
///
///
public System.Int64 ID
{
get {return _ID;}
set{
if(value!=(_ID))
{
_ID=value;
OnPropertyChanged(nameof( ID));
}
}
}
private System.Int32 _JobId_Int;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.Boolean IsSync_Bit
{
get {return _IsSync_Bit;}
set{
if(value!=(_IsSync_Bit))
{
_IsSync_Bit=value;
OnPropertyChanged(nameof( IsSync_Bit));
}
}
}
}
///
///
///
public class Sys_JobScheduler:ObservableObject
{
private System.Int64 _ID;
///
///
///
public System.Int64 ID
{
get {return _ID;}
set{
if(value!=(_ID))
{
_ID=value;
OnPropertyChanged(nameof( ID));
}
}
}
private System.String _JobName_Str;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.String JobDescribe_Str
{
get {return _JobDescribe_Str;}
set{
if(value!=(_JobDescribe_Str))
{
_JobDescribe_Str=value;
OnPropertyChanged(nameof( JobDescribe_Str));
}
}
}
private System.String _JobMessage_Str;
///
///
///
public System.String JobMessage_Str
{
get {return _JobMessage_Str;}
set{
if(value!=(_JobMessage_Str))
{
_JobMessage_Str=value;
OnPropertyChanged(nameof( JobMessage_Str));
}
}
}
private System.Boolean _TriggerWhenStart_bit;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.Boolean IsSync_Bit
{
get {return _IsSync_Bit;}
set{
if(value!=(_IsSync_Bit))
{
_IsSync_Bit=value;
OnPropertyChanged(nameof( IsSync_Bit));
}
}
}
}
///
///
///
public class Sys_Service:ObservableObject
{
private System.Int64 _ID;
///
///
///
public System.Int64 ID
{
get {return _ID;}
set{
if(value!=(_ID))
{
_ID=value;
OnPropertyChanged(nameof( ID));
}
}
}
private System.String _ServiceName_Str;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
public System.String ServiceDescribe_Str
{
get {return _ServiceDescribe_Str;}
set{
if(value!=(_ServiceDescribe_Str))
{
_ServiceDescribe_Str=value;
OnPropertyChanged(nameof( ServiceDescribe_Str));
}
}
}
private System.String _ServiceMessage_Str;
///
///
///
public System.String ServiceMessage_Str
{
get {return _ServiceMessage_Str;}
set{
if(value!=(_ServiceMessage_Str))
{
_ServiceMessage_Str=value;
OnPropertyChanged(nameof( ServiceMessage_Str));
}
}
}
private System.String _ServiceConfig_Str;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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;
///
///
///
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
///
///
///
public BaseTable sqlite_sequence{get;private set;}
///
///
///
public BaseTable Sys_User_Session{get;private set;}
///
///
///
public BaseTable SysApp_DayStatistics{get;private set;}
///
///
///
public BaseTable SysApp_MonthStatistics{get;private set;}
///
///
///
public BaseTable SysApp_YearStatistics{get;private set;}
///
///
///
public BaseTable Sys_Table_Comment{get;private set;}
///
///
///
public BaseTable sqlite_stat1{get;private set;}
///
///
///
public BaseTable App_Common_ProductLog{get;private set;}
///
///
///
public BaseTable Sys_JobSchedulerExcuteLog{get;private set;}
///
///
///
public BaseTable Sys_JobScheduler{get;private set;}
///
///
///
public BaseTable Sys_Service{get;private set;}
public DILDB(string folderPath, string fileName,string username=null,string password=null):base(folderPath, fileName,username,password)
{
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_JobSchedulerExcuteLog=CreateTable("ID","Sys_JobSchedulerExcuteLog");
Sys_JobScheduler=CreateTable("ID","Sys_JobScheduler");
Sys_Service=CreateTable("ID","Sys_Service");
}
#endregion
}
#region V1版本数据库架构
public class DILDBV1:BaseDB
{
///
///
///
public BaseTable sqlite_sequence{get;private set;}
///
///
///
public BaseTable Sys_User_Session{get;private set;}
///
///
///
public BaseTable SysApp_DayStatistics{get;private set;}
///
///
///
public BaseTable SysApp_MonthStatistics{get;private set;}
///
///
///
public BaseTable SysApp_YearStatistics{get;private set;}
///
///
///
public BaseTable Sys_Table_Comment{get;private set;}
///
///
///
public BaseTable sqlite_stat1{get;private set;}
///
///
///
public BaseTable App_Common_ProductLog{get;private set;}
///
///
///
public BaseTable Sys_JobSchedulerExcuteLog{get;private set;}
///
///
///
public BaseTable Sys_JobScheduler{get;private set;}
///
///
///
public BaseTable Sys_Service{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;
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_JobSchedulerExcuteLog=innerDb.CreateTable("ID","Sys_JobSchedulerExcuteLog");
Sys_JobScheduler=innerDb.CreateTable("ID","Sys_JobScheduler");
Sys_Service=innerDb.CreateTable("ID","Sys_Service");
}
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 GetTables()
{
return innerDb.GetTables();
}
public override List GetTableColumns()
{
return innerDb.GetTableColumns();
}
public override List GetViews()
{
return innerDb.GetViews();
}
public override List 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);
}
#endregion
}
}
}