示例#1
0
        public ShellViewModel()
        {
            Application.Current.DispatcherUnhandledException += Current_DispatcherUnhandledException;

            MySQLLaunchModels   = new ObservableCollection <MySQLLaunchModel>();
            MySQLInstanceModels = new ObservableCollection <MySQLInstanceModel>();

            _viewService                   = new ViewService();
            _launchCfgService              = new LaunchConfigService();
            _mySQLCfgService               = new MySQLConfigService();
            _mySQLService                  = new MySQLService();
            _mySQLService.NewInstaceFound += _mySQLService_NewInstaceFound;
            _mySQLService.InstanceLost    += _mySQLService_InstanceLost;

            _logService = new LogService();
            _logService.LogContentChanged += _logService_LogContentChanged;

            CommandCreateNew = new CommandImpl(OnRequestCreateNewLaunchModel);
            CommandCopyCurrentLaunchModel    = new CommandImpl(OnRequestCopyCurrentLaunchModel);
            CommandRenameSelectedModel       = new CommandImpl(OnRequestRenameSelectedModel);
            CommandDeleteSelectedLaunchModel = new CommandImpl(OnRequestDeleteSelectedLaunchModel);

            CommandInitMySQLDataDir = new CommandImpl(OnRequestInitMySQLDataDir);
            CommandStartMySQL       = new CommandImpl(OnRequestStartMySQL, CanStartMySQL);
            CommandStopMySQL        = new CommandImpl(OnRequestStopMySQL, CanStopMySQL);
            CommandReStartMySQL     = new CommandImpl(OnRequestReStartMySQL, CanReStartMySQL);

            CommandRefreshIni = new CommandImpl(OnRequestRefreshIni);
            CommandSaveIni    = new CommandImpl(OnRequestSaveIni);

            _ = LoadModels();
        }
 public LoginViewModel()
 {
     this.User         = new User();
     this.LoginCommand = new DelegateCommand(new Action(LoginExecute));
     this.connection   = new MySqlConnection(
         "server=localhost;User Id=admin;password=admin;Database=hr");
     this.service = new MySQLService();
 }
示例#3
0
        static void Main(string[] args)
        {
            string exePath          = @"F:\C_shap\Git\MyORM\trunk\TestApp";
            string mySQL_conStr     = "Your MySQL connection string";
            string sqlServer_conStr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + exePath + @"\TestDataBases\SQLServerDB.mdf" + ";Integrated Security=True;Connect Timeout=30";
            string sqlite_conStr    = @"Data Source=" + exePath + @"\TestDataBases\SQLiteDB.db";

            // step 1  SetConnectionString
            MySQLService.SetConnection(mySQL_conStr);
            SQLServerService.SetConnection(sqlServer_conStr);
            SQLiteService.SetConnection(sqlite_conStr);

            DataBaseTypesEnum DBType  = DataBaseTypesEnum.SQLite;
            SQLService        service = null;

            switch (DBType)
            {
            case DataBaseTypesEnum.MySQL:
            {
                //step 2 tell Service that which type of database you want to use in default
                ModelBase.SetDefaultService(DataBaseTypesEnum.MySQL);

                //step 3 create a new instance and use it
                service = new MySQLService();
                break;
            }

            case DataBaseTypesEnum.SQLServer:
            {
                ModelBase.SetDefaultService(DataBaseTypesEnum.SQLServer);
                service = new SQLServerService();
                break;
            }

            case DataBaseTypesEnum.SQLite:
            {
                ModelBase.SetDefaultService(DataBaseTypesEnum.SQLite);
                service = new SQLiteService();
                break;
            }
            }

            LoadById(service);

            ReadAll(service);

            ReadByCondition(service);

            ReadPageList(service);

            Update(service);

            Insert(service);

            Delete(service);

            Console.ReadKey();
        }
        //Initialize
        public PageViewModel()
        {
            this.SelectCommand = new DelegateCommand(new Action(SelectExecute));
            this.SubmitCommand = new DelegateCommand(new Action(SubmitExecute));
            this.connection    = new MySqlConnection(
                "server=localhost;User Id=admin;password=admin;Database=hr");
            this.service = new MySQLService();

            this.editedIndexs = new List <int>();
            this.statements   = new List <string>();
            SelectExecute();
        }
        public MyStaffPageViewModel()
        {
            Me          = new StaffViewModel();
            Me.Username = App.Username;
            statement   = string.Format("select No, Name, Gender, date_format(Birthday, '%Y-%m-%d') as Birthday, Department, Position, date_format(EntryDate, '%Y-%m-%d') as EntryDate," +
                                        " date_format(ContractDate, '%Y-%m-%d') as ContractDate, Username, Password, Authority, Status from staff where Username='******'", Me.Username);
            connection = new MySqlConnection(
                "server=localhost;User Id=admin;password=admin;Database=hr");
            service = new MySQLService();
            DataTable table = service.QueryManipulation(statement, connection);

            Me.No           = (int)table.Rows[0]["No"];
            Me.Name         = (string)table.Rows[0]["Name"];
            Me.Gender       = (string)table.Rows[0]["Gender"];
            Me.Birthday     = (string)table.Rows[0]["Birthday"];
            Me.Department   = (string)table.Rows[0]["Department"];
            Me.Position     = (string)table.Rows[0]["Position"];
            Me.EntryDate    = (string)table.Rows[0]["EntryDate"];
            Me.ContractDate = (string)table.Rows[0]["ContractDate"];
            Me.Status       = (string)table.Rows[0]["Status"];
        }