public void GetTables()
        {
            MySqlService mySqlService = new MySqlService();
            var          tables       = mySqlService.GetTables(connectionInfo, "sys");

            CollectionAssert.Contains(tables, "sys_config");
        }
        public override string OnResponse(string data)
        {
            DefaultReq defaultReq = null;

            try
            {
                defaultReq = JsonConvert.DeserializeObject <DefaultReq>(data);
            }
            catch (Exception e)
            {
                MySqlService.log.Warn("传入的参数有误:" + e);
                return(null);
            }
            MySqlService.InitCommomData();

            string  _tag          = defaultReq.tag;
            int     _connId       = defaultReq.connId;
            JObject _responseData = new JObject();

            _responseData.Add(MyCommon.TAG, _tag);
            _responseData.Add(MyCommon.CONNID, _connId);
            _responseData.Add(MyCommon.CODE, (int)Consts.Code.Code_OK);

            return(_responseData.ToString());
        }
Exemple #3
0
        /// <summary>
        /// Adds a service to the list of services.
        /// </summary>
        /// <param name="service">Service to add.</param>
        /// <param name="machine">Machine containing the service.</param>
        /// <param name="setPage">Flag indicating if the Services tab must be focused.</param>
        private void AddService(MySqlService service, Machine machine, bool setPage)
        {
            if (service == null)
            {
                return;
            }

            if (service.Host == null)
            {
                service.Host = machine;
                service.SetServiceParameters(true);
            }

            ListViewItem newItem = new ListViewItem(service.DisplayName)
            {
                Tag = service
            };

            newItem.SubItems.Add(machine.Name);
            newItem.SubItems.Add(service.Status.ToString());
            MonitoredServicesListView.Items.Add(newItem);

            if (!setPage)
            {
                return;
            }

            ItemsTabControl.SelectedIndex = 0;
            newItem.Selected = true;
        }
        public void GetDatabases()
        {
            MySqlService mySqlService = new MySqlService();
            var          databases    = mySqlService.GetDatabases(connectionInfo);

            CollectionAssert.Contains(databases, "sys");
        }
        public void GetViews()
        {
            MySqlService mySqlService = new MySqlService();
            var          views        = mySqlService.GetViews(connectionInfo, "sys");

            CollectionAssert.Contains(views, "host_summary");
        }
        //tag(string):SupplyGold
        //uid(string)
        //todayCount(int)
        //goldNum(int)
        public static void SendSupplyGold(string uid)
        {
            UserInfo userInfo = NHibernateHelper.userInfoManager.GetByUid(uid);

            if (userInfo.Gold < 1500)
            {
                var config = NHibernateHelper.commonConfigManager.GetByUid(uid);
                if (config == null)
                {
                    config = ModelFactory.CreateConfig(uid);
                }
                if (config.free_gold_count > 0)
                {
                    userInfo.Gold += 2000;
                    config.free_gold_count--;
                    NHibernateHelper.commonConfigManager.Update(config);
                    NHibernateHelper.userInfoManager.Update(userInfo);

                    MySqlService.log.Info($"{uid}发放补助金");
                    //给logic服务器推送
                    IntPtr connId;
                    if (MySqlService.serviceDic.TryGetValue(TljServiceType.LogicService, out connId))
                    {
                        var jObject = new JObject();
                        jObject.Add(MyCommon.TAG, Consts.Tag_SupplyGold);
                        jObject.Add(MyCommon.UID, uid);
                        int temp = 0;
                        if (config.free_gold_count == 2)
                        {
                            temp = 1;
                        }
                        else if (config.free_gold_count == 1)
                        {
                            temp = 2;
                        }
                        else if (config.free_gold_count == 0)
                        {
                            temp = 3;
                        }
                        jObject.Add("todayCount", temp);
                        jObject.Add("goldNum", 2000);
                        MySqlService.Instance().sendMessage(connId, jObject.ToString());
                        MySqlService.log.Info($"主动发送给logic:{jObject.ToString()}");


                        //记录玩家财富变化日志
                        int afterGold  = userInfo.Gold;
                        int changeGold = 2000;

                        StatictisLogUtil.ChangeWealth(userInfo.Uid, userInfo.NickName, MyCommon.GOLD, "奖励金发放", afterGold - changeGold, changeGold, afterGold);
                    }
                }
            }
        }
Exemple #7
0
        public static void Main(string[] args)
        {
            PrintGreeting();

            if (!MySqlService.IsInstalled())
            {
                Console.WriteLine("MySQL server is not installed in your computer.");
                MySqlService.InstallMySql();
            }
            BuildWebHost(args).Run();
        }
Exemple #8
0
 private void btn_Refresh_Click(object sender, EventArgs e)
 {
     btn_Refresh.Enabled = false;
     try
     {
         string      connectionString = string.Concat("Server=", txb_Server.Text, ";Database=information_schema", ";Uid=", txb_Username.Text, ";Pwd=", txb_Password.Text, ";");
         IAdoService adoService       = new MySqlService();
         cbb_Database.DataSource = adoService.GetAllDatabase(connectionString);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
     btn_Refresh.Enabled = true;
 }
Exemple #9
0
    public static void insertOrder(int chair, int table, int sofa, int totalsum)
    {
        MySqlConnection con = MySqlService.getConnection();

        con.Open();
        MySqlCommand comm = con.CreateCommand();

        comm.CommandText = "INSERT INTO uzsakymai(kedes,stalai,sofos,suma) VALUES(@kedes, @stalai, @sofos, @suma)";
        comm.Parameters.AddWithValue("@kedes", chair);
        comm.Parameters.AddWithValue("@stalai", table);
        comm.Parameters.AddWithValue("@sofos", sofa);
        comm.Parameters.AddWithValue("@suma", totalsum);
        comm.ExecuteNonQuery();
        con.Close();
    }
Exemple #10
0
 public static void insertOrder(int chair, int table, int sofa, int totalsum)
 {
     using (MySqlConnection con = MySqlService.getConnection())
     {
         try
         {
             con.Open();
             AddBaldas(chair, table, sofa, totalsum, con);
             MessageBox.Show("Your order was placed");
         } catch (Exception e)
         {
             MessageBox.Show("Unable to connect to MySql");
         }
     }
 }
Exemple #11
0
        /// <summary>
        /// Event delegate method fired when the <see cref="UpdateTrayIconCheckBox"/> checked status changes.
        /// </summary>
        /// <param name="sender">Sender object.</param>
        /// <param name="e">Event arguments.</param>
        private void UpdateTrayIconCheckBox_CheckedChanged(object sender, EventArgs e)
        {
            if (_selectedItem == null)
            {
                return;
            }

            if (_selectedItem is MySqlService)
            {
                MySqlService selectedService = _selectedItem as MySqlService;
                selectedService.UpdateTrayIconOnStatusChange = UpdateTrayIconCheckBox.Checked;
                _servicesHaveChanges = true;
            }
            else if (_selectedItem is MySqlInstance)
            {
                MySqlInstance selectedInstance = _selectedItem as MySqlInstance;
                selectedInstance.UpdateTrayIconOnStatusChange = UpdateTrayIconCheckBox.Checked;
                _instancesHaveChanges = true;
            }
        }
Exemple #12
0
        /// <summary>
        /// Event delegate method fired when the <see cref="NotifyOnStatusChangeCheckBox"/> checked status changes.
        /// </summary>
        /// <param name="sender">Sender object.</param>
        /// <param name="e">Event arguments.</param>
        private void NotifyOnStatusChangeCheckBox_CheckedChanged(object sender, EventArgs e)
        {
            if (_selectedItem == null)
            {
                return;
            }

            if (_selectedItem is MySqlService)
            {
                MySqlService selectedService = _selectedItem as MySqlService;
                selectedService.NotifyOnStatusChange = NotifyOnStatusChangeCheckBox.Checked;
                _servicesHaveChanges = true;
            }
            else if (_selectedItem is MySqlInstance)
            {
                MySqlInstance selectedInstance = _selectedItem as MySqlInstance;
                selectedInstance.MonitorAndNotifyStatus = NotifyOnStatusChangeCheckBox.Checked;
                _instancesHaveChanges = true;
            }
        }
Exemple #13
0
 public static List <Baldas> getBaldai()
 {
     using (MySqlConnection con = MySqlService.getConnection())
     {
         using (MySqlCommand cmd = new MySqlCommand("select Pavadinimas, Kaina, Laikas from baldai", con))
         {
             try
             {
                 con.Open();
                 return(extractBaldai(cmd));
             } catch (Exception e)
             {
                 MessageBox.Show("Unable to connect to MySql");
                 List <Baldas> baldai = new List <Baldas>();
                 baldai.Add(new Baldas(Tipas.DESK, 10, 5));
                 baldai.Add(new Baldas(Tipas.CHAIR, 10, 5));
                 baldai.Add(new Baldas(Tipas.SOFA, 10, 5));
                 return(baldai);
             }
         }
     }
 }
Exemple #14
0
        /// <summary>
        /// Sets the availability of controls related to services or instances based on the selected item.
        /// </summary>
        private void SetDialogControlsAvailability()
        {
            DeleteButton.Enabled = _selectedItem != null;
            NotifyOnStatusChangeCheckBox.Enabled = DeleteButton.Enabled;
            UpdateTrayIconCheckBox.Enabled       = DeleteButton.Enabled;

            if (_selectedItem == null)
            {
                NotifyOnStatusChangeCheckBox.Checked         = false;
                UpdateTrayIconCheckBox.Checked               = false;
                InstanceMonitorIntervalNumericUpDown.Value   = 0;
                InstanceMonitorIntervalNumericUpDown.Enabled = false;
                InstanceMonitorIntervalUOMComboBox.Text      = string.Empty;
                InstanceMonitorIntervalUOMComboBox.Enabled   = false;
            }
            else if (_selectedItem is MySqlService)
            {
                MySqlService service = _selectedItem as MySqlService;
                NotifyOnStatusChangeCheckBox.Checked         = service.NotifyOnStatusChange;
                UpdateTrayIconCheckBox.Checked               = service.UpdateTrayIconOnStatusChange;
                InstanceMonitorIntervalNumericUpDown.Value   = 0;
                InstanceMonitorIntervalNumericUpDown.Enabled = false;
                InstanceMonitorIntervalUOMComboBox.Text      = string.Empty;
                InstanceMonitorIntervalUOMComboBox.Enabled   = false;
            }
            else if (_selectedItem is MySqlInstance)
            {
                MySqlInstance instance = _selectedItem as MySqlInstance;
                NotifyOnStatusChangeCheckBox.Checked             = instance.MonitorAndNotifyStatus;
                UpdateTrayIconCheckBox.Checked                   = instance.UpdateTrayIconOnStatusChange;
                InstanceMonitorIntervalNumericUpDown.Enabled     = true;
                InstanceMonitorIntervalNumericUpDown.Value       = instance.MonitoringInterval;
                InstanceMonitorIntervalUOMComboBox.Enabled       = true;
                InstanceMonitorIntervalUOMComboBox.SelectedIndex = (int)instance.MonitoringIntervalUnitOfMeasure;
            }
        }
Exemple #15
0
    public static DataTable getOrderTable()
    {
        using (MySqlConnection con = MySqlService.getConnection())
        {
            try
            {
                con.Open();

                MySqlDataAdapter MyDA         = new MySqlDataAdapter();
                string           sqlSelectAll = "SELECT * from uzsakymai";
                MyDA.SelectCommand = new MySqlCommand(sqlSelectAll, con);

                DataTable table = new DataTable();
                MyDA.Fill(table);

                return(table);
            }
            catch (Exception e)
            {
                MessageBox.Show("Unable to connect to MySql");
                return(new DataTable());
            }
        }
    }
Exemple #16
0
        static void Main(string[] args)
        {
            try
            {
                var argList = ReadArgs(args);
                if (argList == null)
                {
                    return;
                }

                var dbType = GetSwitchInput(argList, "-t", "Database Type:\n1. SQL Server\n2. MySQL\n3. PostgreSQL", new Dictionary <string, string> {
                    { "1", _msSql }, { "2", _mySql }, { "3", _postgreSql }
                });

                var connectionString = GetInput(argList, "-c", "ConnectionString:", optional: true);
                var skip             = !string.IsNullOrWhiteSpace(connectionString);
                var setting          = new DatabaseSettingModel
                {
                    ConnectionString = connectionString,
                    DbType           = dbType,
                    HostString       = GetInput(argList, "-s", "Server name or IP address:", skip: skip),
                    DatabaseName     = GetInput(argList, "-d", "Database name:", skip: skip && dbType == _msSql),
                    UserName         = GetInput(argList, "-u", "Username:"******"-p", "Password:"******"Can't get any table info");
                }

                IExporter exporter = new HtmlExporter();

                var stream = exporter.Export(setting, tableInfos);
                stream.Seek(0, SeekOrigin.Begin);
                using (var fileStream = new FileStream($"{setting.DatabaseName}.html", FileMode.Create))
                {
                    stream.CopyTo(fileStream);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.ToString());
                System.Threading.Thread.Sleep(5000);
            }
        }
Exemple #17
0
        private void cbDatabase_DropDownOpened(object sender, EventArgs e)
        {
            cbDatabase.ItemsSource = new List <string> {
                "<Loading databases>"
            };
            var sel = Enum.Parse <ConnectionProvider>(cbProvider.SelectedItem.ToString());

            try
            {
                switch (sel)
                {
                case ConnectionProvider.MsSql:
                    var conInfo = new MsSqlConnectionInfo
                    {
                        Server            = txtServer.Text,
                        Port              = Convert.ToInt32(string.IsNullOrWhiteSpace(txtPort.Text) ? "-1" : txtPort.Text),
                        TrustedConnection = chkIntegratedSecurity.IsChecked.Value,
                        Username          = txtUsername.Text,
                        Password          = txtPassword.Password
                    };

                    var mssql = new MsSqlService();
                    cbDatabase.ItemsSource = mssql.LoadDatabase(conInfo);
                    break;

                case ConnectionProvider.PostgreSql:
                    var npgInfo = new NpgConnectionInfo
                    {
                        Server            = txtServer.Text,
                        Port              = Convert.ToInt32(string.IsNullOrWhiteSpace(txtPort.Text) ? "-1" : txtPort.Text),
                        TrustedConnection = chkIntegratedSecurity.IsChecked.Value,
                        Username          = txtUsername.Text,
                        Password          = txtPassword.Password
                    };

                    var npgsql = new NpgService();
                    cbDatabase.ItemsSource = npgsql.LoadDatabase(npgInfo);
                    break;

                case ConnectionProvider.MySql:

                    if (chkIntegratedSecurity.IsChecked == true)
                    {
                        throw new InvalidOperationException("Integrated Security doesnt supported by MySql Server");
                    }

                    var myInfo = new MySqlConnectionInfo
                    {
                        Server   = txtServer.Text,
                        Port     = Convert.ToInt32(string.IsNullOrWhiteSpace(txtPort.Text) ? "-1" : txtPort.Text),
                        Username = txtUsername.Text,
                        Password = txtPassword.Password
                    };

                    var mysql = new MySqlService();
                    cbDatabase.ItemsSource = mysql.LoadDatabase(myInfo);
                    break;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        public List <EJ.DBColumn> GetCurrentColumns(IDatabaseService db, string tablename)
        {
            var dbnameMatch = System.Text.RegularExpressions.Regex.Match(db.ConnectionString, @"database=(?<dname>(\w)+)", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
            var dbname      = dbnameMatch.Groups["dname"].Value;

            MySqlService mySqlService = (MySqlService)db;


            List <EJ.DBColumn> result = new List <EJ.DBColumn>();

            var table = db.SelectTable($"select * from information_schema.COLUMNS where TABLE_SCHEMA='{dbname}' and TABLE_NAME='{tablename}'");
            //获取主键
            var pkcolumnName = db.ExecSqlString(@"SELECT
C.COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS c
WHERE
c.CONSTRAINT_SCHEMA = '" + dbname + @"'
AND c.CONSTRAINT_NAME = 'PRIMARY'
AND c.TABLE_NAME = '" + tablename + @"'
")?.ToString();


            foreach (var row in table.Rows)
            {
                EJ.DBColumn column = new EJ.DBColumn();
                column.Name    = row["COLUMN_NAME"].ToSafeString();
                column.CanNull = row["IS_NULLABLE"].ToSafeString() == "YES";
                column.dbType  = row["DATA_TYPE"].ToSafeString().ToLower();
                column.caption = row["COLUMN_COMMENT"]?.ToString();
                int typeindex = -1;
                for (int i = 0; i < Database.MySql.MySqlTableService.ColumnType.Count; i++)
                {
                    if (string.Equals(Database.MySql.MySqlTableService.ColumnType[i], column.dbType, StringComparison.CurrentCultureIgnoreCase))
                    {
                        typeindex = i;
                        break;
                    }
                }
                if (typeindex >= 0)
                {
                    column.dbType = EntityDB.Design.ColumnType.SupportTypes[typeindex];
                }
                else if (column.dbType.EndsWith("int"))
                {
                    column.dbType = "int";
                }
                else if (column.dbType == "enum" || column.dbType == "set")
                {
                    column.dbType = "varchar";
                }
                else
                {
                    for (int i = 0; i < Way.EntityDB.Design.ColumnType.SupportTypes.Count; i++)
                    {
                        if (string.Equals(Way.EntityDB.Design.ColumnType.SupportTypes[i], column.dbType, StringComparison.CurrentCultureIgnoreCase))
                        {
                            typeindex = i;
                            break;
                        }
                    }

                    if (typeindex >= 0)
                    {
                        column.dbType = EntityDB.Design.ColumnType.SupportTypes[typeindex];
                    }
                    else
                    {
                        column.dbType = "[未识别]" + column.dbType;
                    }
                }
                column.defaultValue    = row["COLUMN_DEFAULT"].ToSafeString();
                column.IsAutoIncrement = row["EXTRA"].ToSafeString().Contains("auto_increment");
                if (!string.IsNullOrEmpty(pkcolumnName))
                {
                    column.IsPKID = column.Name == pkcolumnName;
                }
                if (column.dbType.Contains("char"))
                {
                    column.length = row["CHARACTER_MAXIMUM_LENGTH"].ToSafeString();
                }
                column.ChangedProperties.Clear();
                result.Add(column);
            }
            return(result);
        }