public static void Delete(string timeStamp) { TestPosition test = null; for (int i = 0, maxi = (null == gTestPositions ? 0 : gTestPositions.Count); i < maxi; i++) { TestPosition testPosition = gTestPositions[i]; if (testPosition.time.Equals(timeStamp)) { test = testPosition; break; } } if (null != test) { gTestPositions.Remove(test); } try { MysqlUtil.Execute(string.Format(MYSQL_DELETE, timeStamp), MysqlConnection); } catch { Logger.DebugFormat("Delete failed !"); } }
public static void Add(Vector3 position, float rotation, string timeStamp) { DataRecord dataRecord = new DataRecord(); dataRecord.AddField(FIELD_MAP_ID, MapId.ToString()); dataRecord.AddField(FIELD_POSITION_TYPE, Type); dataRecord.AddField(FIELD_X, position.x.ToString()); dataRecord.AddField(FIELD_Y, position.y.ToString()); dataRecord.AddField(FIELD_Z, position.z.ToString()); dataRecord.AddField(FIELD_ROTATION, rotation.ToString()); dataRecord.AddField(FIELD_TIME, timeStamp); MysqlUtil.Add(dataRecord, TABLE, MysqlConnection); if (!Exsit(timeStamp)) { TestPosition testPosition = new TestPosition(); testPosition.mapId = MapId.ToString(); testPosition.type = Type; testPosition.x = position.x; testPosition.y = position.y; testPosition.z = position.z; testPosition.rotation = rotation; testPosition.time = timeStamp; gTestPositions.Add(testPosition); } }
private void setCourseById() { string sql = string.Format("select * from t_course where id={0}", commodityID); DataRow reader = MysqlUtil.GetDataRow(sql); this.c_id.Text = reader["cid"].ToString(); this.c_name.Text = reader["cname"].ToString(); this.c_marke.Text = reader["remake"].ToString(); }
public override void DoAction(IEventArgs args) { DataRecord dr = new DataRecord(); dr.AddField("time", DateTime.Now.Ticks.ToString()); dr.AddField("key", key); dr.AddField("message", FreeUtil.ReplaceVar(message, args)); MysqlUtil.Add(dr, "simple_log", FreeRuleConfig.MysqlConnection); }
private void SetcombocClass() { //select * from t_course; string sql = string.Format("select * from t_course"); DataTable reader = MysqlUtil.GetDataTable(sql); this.s_course.DataSource = reader; this.s_course.ValueMember = "cid"; //用于修改 this.s_course.DisplayMember = "cname"; //显示课程名称 this.s_course.SelectedIndex = -1; //便于搜索 }
private static void IniDesc() { if (descDic == null) { descDic = new Dictionary <int, string>(); List <DataRecord> list = MysqlUtil.SelectRecords("select * from text_lang", FreeRuleConfig.MysqlConnection); foreach (DataRecord dr in list) { descDic.Add(int.Parse(dr.GetValue("id")), dr.GetValue("text")); } } }
private static void Initial() { if (dic == null) { dic = new Dictionary <int, string>(); List <DataRecord> list = MysqlUtil.SelectRecords("select * from rule_replace", FreeRuleConfig.MysqlConnection); foreach (DataRecord dr in list) { dic.Add(int.Parse(dr.GetValue("race")), dr.GetValue("free")); } } }
protected static void RecordMultiResult(CaseKey key, TestValue[] tvs, string table) { DataRecord dr = new DataRecord(); dr.AddField("rule", key.rule); dr.AddField("suit", key.suit); dr.AddField("case", key.caseName); dr.AddField("field", tvs[0].Name); dr.AddField("value", TestValue.ToRecords(tvs)); Debug.LogFormat("table:{0}, dr:{1}", table, dr); MysqlUtil.Add(dr, table, FreeRuleConfig.MysqlConnection); }
/// <summary> /// 获取选中数据库的数据表列表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DatabaseListBox_OnSelectionChanged(object sender, SelectionChangedEventArgs e) { _tableList = null; if (DatabaseListBox.SelectedItem == null) { return; } string selectedDatabase = DatabaseListBox.SelectedItem.ToString(); if (string.IsNullOrWhiteSpace(selectedDatabase)) { return; } _databaseNameStr = selectedDatabase; try { var useDatabaseCmd = MysqlUtil.GetSqlCommand($"use {_databaseNameStr};", _mySqlConnection); useDatabaseCmd.ExecuteNonQuery(); var sqlCmd = MysqlUtil.GetSqlCommand("show tables;", _mySqlConnection); _tableList = new List <string>(); using (MySqlDataReader mySqlDataReader = sqlCmd.ExecuteReader()) { while (mySqlDataReader.Read()) { if (mySqlDataReader.HasRows) { string tableName = mySqlDataReader.GetString(0); _tableList.Add(tableName); } } } TableListBox.ItemsSource = _tableList; } catch (Exception exception) { MessageBox.Show("获取数据表信息失败," + exception.Message); } }
public static string GetRuleXml(string name, bool mysql) { if (mysql) { List <DataRecord> list = MysqlUtil.SelectRecords("select * from rule where `key` = '" + name + "'", MysqlConnection); if (list.Count > 0) { return(RemoveComment(list[0].GetValue("config"))); } } else { return(RemoveComment(GetFileContent(Application.dataPath + "/Config/Server/Rule/" + name + ".xml", Encoding.UTF8))); } return(""); }
private string GetBeanClassReturnString(TableModel tableModel) { List <ColumnModel> columnModels = tableModel.ColumnModels; StringBuilder sb = new StringBuilder(); string tableName = MysqlUtil.GetModelColumnName(tableModel.TableName); char firstChar = tableName[0]; if (firstChar >= 'a' && firstChar <= 'z') { firstChar = (char)(firstChar - 32); tableName = firstChar + tableName.Substring(1); } sb.AppendLine("@Data"); sb.AppendLine("@AllArgsConstructor"); sb.AppendLine("@NoArgsConstructor"); sb.AppendLine($"@Table(name = \"{tableModel.TableName}\")"); sb.Append($"public class {tableName}"); sb.AppendLine("{"); foreach (var columnModel in columnModels) { if (string.IsNullOrWhiteSpace(columnModel.DataType)) { continue; } string dataType = MysqlUtil.GetMappedType(columnModel.DataType); string attributeLine = $"\t@Column(name = \"{columnModel.OriginalColumnName}\")"; string fieldLine = $"\tprivate {dataType} {columnModel.NewColumnName};"; if (columnModel.IsPrimaryKey) { sb.AppendLine("\t@Id"); } sb.AppendLine(attributeLine); sb.AppendLine(fieldLine); sb.AppendLine(); } sb.AppendLine("}"); return(sb.ToString()); }
private void ChooseTable(string selectedTableName) { string selectColumnNameSql = $"SELECT column_name, data_type, column_key FROM information_schema.columns WHERE table_schema='{_databaseNameStr}' AND table_name='{selectedTableName}';"; var sqlCmd = MysqlUtil.GetSqlCommand(selectColumnNameSql, _mySqlConnection); List <ColumnModel> columnModels = new List <ColumnModel>(); try { using (var dataReader = sqlCmd.ExecuteReader()) { while (dataReader.Read()) { if (dataReader.HasRows) { string originalName = dataReader.GetString(0); originalName = originalName.ToLower(); string dataTypeStr = dataReader.GetString(1); string columnKey = dataReader.GetString(2); string newColumnName = MysqlUtil.GetModelColumnName(originalName); ColumnModel columnModel = new ColumnModel(originalName, newColumnName, dataTypeStr); if (!string.IsNullOrWhiteSpace(columnKey) || "PRI".Equals(columnKey.ToUpper())) { columnModel.IsPrimaryKey = true; } columnModels.Add(columnModel); } } } } catch (Exception exception) { MessageBox.Show("获取表信息失败,错误原因:" + exception.Message); } TableModel tableModel = new TableModel(selectedTableName, columnModels); SetMessageTxtBox(tableModel); }
public static void Initial(bool mysql) { dic.Clear(); if (mysql) { List <DataRecord> list = MysqlUtil.SelectRecords("select * from rule_replace", FreeRuleConfig.MysqlConnection); foreach (DataRecord dr in list) { dic.Add(int.Parse(dr.GetValue("race")), dr.GetValue("free")); } return; } string path = Application.dataPath + "/Config/Server/Rule/rule_replace.xml"; FileStream fs = null; try { XmlSerializer xs = new XmlSerializer(typeof(RuleMapConfig)); fs = new FileStream(path, FileMode.Open, FileAccess.Read); RuleMapConfig ruleMapConfig = (RuleMapConfig)xs.Deserialize(fs); if (null != ruleMapConfig) { foreach (RuleMapConfigItem ruleMapConfigItem in ruleMapConfig.items) { dic[ruleMapConfigItem.race] = ruleMapConfigItem.free; } } fs.Close(); } catch (Exception e) { if (fs != null) { fs.Close(); } _logger.Error("error : " + e.ToString()); } }
private void AddCourse() { int result = MysqlUtil.DoInsert("t_course", new string[] { "cid", "cname", "remake" }, new object[] { c_id.Text.Trim(), c_name.Text.Trim(), c_marke.Text.Trim() } ); if (result == 1) { MessageBox.Show("添加成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //添加成功后置空表单 this.setNull(); this.Close(); } else { MessageBox.Show("添加失败", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void EditCourse() { int result = MysqlUtil.DoUpdate("t_course", new string[] { "cid", "cname", "remake" }, new object[] { c_id.Text.Trim(), c_name.Text.Trim(), c_marke.Text.Trim() }, new string[] { "id" }, new object[] { this.commodityID } ); if (result == 1) { MessageBox.Show("修改成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //添加成功后置空表单 this.Close(); } else { MessageBox.Show("修改失败", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void EditPassword() { int result = MysqlUtil.DoUpdate( "t_user", new string[] { "password" }, new object[] { new_password.Text.Trim() }, new string[] { "id" }, new object[] { user.Id } ); if (result == 1) { MessageBox.Show("修改成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("修改失败。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void AddStudent() { string sex = radio_boy.Checked ? "男" : "女"; int result = MysqlUtil.DoInsert("t_students", new string[] { "sid", "sname", "sex", "age", "major", "cid", "class_id" }, new object[] { stu_id.Text.Trim(), stu_name.Text.Trim(), sex, Convert.ToInt32(stu_age.Text.Trim()), stu_major.Text.Trim(), stu_course.SelectedValue, Convert.ToInt32(stu_class.Text.Trim()) } ); if (result == 1) { MessageBox.Show("添加成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //添加成功后置空表单 this.SetNull(); this.Close(); } else { MessageBox.Show("添加失败", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private static void Initial() { if (correct == null) { correct = new Dictionary <CaseKey, TestValue[]>(); wrong = new Dictionary <CaseKey, TestValue[]>(); List <DataRecord> list = MysqlUtil.SelectRecords("select * from " + TableCorrect, FreeRuleConfig.MysqlConnection); foreach (DataRecord dr in list) { CaseKey ck = new CaseKey(); ck.rule = dr.GetValue("rule"); ck.suit = dr.GetValue("suit"); ck.caseName = dr.GetValue("case"); ck.field = dr.GetValue("field"); if (!correct.ContainsKey(ck)) { correct.Add(ck, TestValue.RecordsFromString(dr.GetValue("value"))); } } list = MysqlUtil.SelectRecords("select * from " + TableWrong, FreeRuleConfig.MysqlConnection); foreach (DataRecord dr in list) { CaseKey ck = new CaseKey(); ck.rule = dr.GetValue("rule"); ck.suit = dr.GetValue("suit"); ck.caseName = dr.GetValue("case"); ck.field = dr.GetValue("field"); if (!correct.ContainsKey(ck)) { wrong.Add(ck, TestValue.RecordsFromString(dr.GetValue("value"))); } } } }
private void setStuById() { //初始化课程信息下拉列表 SetComboCourse(); string sql = string.Format("select * from t_students where sid={0}", commodityID); DataRow reader = MysqlUtil.GetDataRow(sql); this.stu_id.Text = reader["sid"].ToString(); this.stu_name.Text = reader["sname"].ToString(); //判断性别单选框是否选中 if (reader["sex"].ToString() == "男") { this.radio_boy.Checked = true; } else { this.radio_girl.Checked = true; } this.stu_major.Text = reader["major"].ToString(); this.stu_age.Value = Convert.ToDecimal(reader["age"]); //18 this.stu_course.SelectedValue = reader["cid"].ToString(); this.stu_class.Value = Convert.ToDecimal(reader["class_id"]); }
public override void DoAction(IEventArgs args) { List <DataRecord> list = MysqlUtil.SelectRecords("select * from realtime_rule where `rule` = '" + args.Rule.FreeType + "'", FreeRuleConfig.MysqlConnection); if (list.Count > 0) { string config = list[0].GetValue("config"); if (!string.IsNullOrEmpty(config)) { object obj = FreeRuleConfig.XmlToObject(config); if (obj is IGameAction) { if (obj is OrderAiAction) { ((IGameAction)obj).Reset(args); } else { ((IGameAction)obj).Act(args); } } } } }
private List <DataRecord> GetRecords() { List <DataRecord> records = MysqlUtil.SelectRecords(string.Format(SQL, map, type), FreeRuleConfig.MysqlConnection); return(records); }
public static List <DataRecord> GetAllDataRecord() { List <DataRecord> list = MysqlUtil.SelectRecords(MYSQL_GET_ALL, MysqlConnection); return(list); }
private void OpenDbSource(string connectionStr, bool addToList = true) { ConnectionModel connectionModel = ConnectionUtils.GetConnectionModel(connectionStr); if (null == connectionModel) { MessageBox.Show("打开数据库失败,连接为:" + connectionStr); return; } DatabaseListBox.ItemsSource = null; TableListBox.ItemsSource = null; MessageTxtBox.Text = null; try { string connectIp = connectionModel.RemoteIp; int connectPort = connectionModel.Port; string userName = connectionModel.UserName; string userPass = connectionModel.UserPass; string dbSourceStr = $"Data Source={connectIp};User Id={userName};Password={userPass};pooling=false;CharSet=utf8;port={connectPort}"; List <string> databaseNames = new List <string>(); // 打开之前先关闭已经打开的连接 CloseMysqlConnection(); _mySqlConnection = MysqlUtil.GetMySqlConnection(dbSourceStr); var sqlCmd = MysqlUtil.GetSqlCommand("show databases;", _mySqlConnection); _mySqlConnection.Open(); try { using (MySqlDataReader mySqlDataReader = sqlCmd.ExecuteReader()) { while (mySqlDataReader.Read()) { if (mySqlDataReader.HasRows) { string tableName = mySqlDataReader.GetString(0); databaseNames.Add(tableName); } } } } catch (Exception e) { MessageBox.Show("打开数据库失败," + e.Message); return; } _tableList = databaseNames; DatabaseListBox.ItemsSource = _tableList; // 显示数据库列表 } catch (Exception e) { MessageBox.Show("连接数据库失败,错误信息:" + e.Message); return; } // 添加进列表(使用打开功能的话就加,listbox的selectionChanged就不加) if (addToList) { ConnectionUtils.AddConnection(connectionStr); LoadConnectionList(); } }
public static int IniTable(int mapId, string type) { gRecordMap.Clear(); gTestPositions.Clear(); Type = type; MapId = mapId; int result = -1; try { result = MysqlUtil.Execute(MYSQL_CREATE_TABLE, MysqlConnection); } catch { Logger.DebugFormat("CreateTable failed and result is {0} !", result); } List <DataRecord> list = GetAllDataRecord(); foreach (DataRecord record in list) { TestPosition testPosition = new TestPosition(); if (record.Contains(FIELD_MAP_ID)) { testPosition.mapId = record.GetValue(FIELD_MAP_ID); } if (record.Contains(FIELD_POSITION_TYPE)) { testPosition.type = record.GetValue(FIELD_POSITION_TYPE); } if (record.Contains(FIELD_X)) { testPosition.x = float.Parse(record.GetValue(FIELD_X)); } if (record.Contains(FIELD_Y)) { testPosition.y = float.Parse(record.GetValue(FIELD_Y)); } if (record.Contains(FIELD_Z)) { testPosition.z = float.Parse(record.GetValue(FIELD_Z)); } if (record.Contains(FIELD_ROTATION)) { testPosition.rotation = float.Parse(record.GetValue(FIELD_ROTATION)); } if (record.Contains(FIELD_TIME)) { testPosition.time = record.GetValue(FIELD_TIME); } Dictionary <string, List <TestPosition> > typeDict = null; List <TestPosition> testPositions = null; if (!gRecordMap.TryGetValue(testPosition.mapId, out typeDict)) { typeDict = new Dictionary <string, List <TestPosition> >(); gRecordMap[testPosition.mapId] = typeDict; } if (!typeDict.TryGetValue(testPosition.type, out testPositions)) { testPositions = new List <TestPosition>(); typeDict[testPosition.type] = testPositions; } if (mapId.ToString().Equals(testPosition.mapId) && type.Equals(testPosition.type)) { gTestPositions = testPositions; } testPositions.Add(testPosition); } return(result); }
public static void Initial() { if (dropDic == null) { dropDic = new MyDictionary <int, CatPriority>(); catDic = new MyDictionary <string, ItemPriority>(); extraDic = new MyDictionary <int, MyDictionary <int, CatPriority> >(); rangeDic = new MyDictionary <int, DropRange>(); dropCache = new Dictionary <int, List <ItemDrop> >(); List <DataRecord> dropList = MysqlUtil.SelectRecords("select * from new_item_drop", FreeRuleConfig.MysqlConnection); foreach (DataRecord dr in dropList) { int id = int.Parse(dr.GetValue("id")); string range = dr.GetValue("range"); string drop = dr.GetValue("drop"); string count = dr.GetValue("count"); rangeDic[id] = new DropRange(range, count); dropDic[id] = new CatPriority(drop); } List <DataRecord> catList = MysqlUtil.SelectRecords("select * from new_drop_cat", FreeRuleConfig.MysqlConnection); MyDictionary <string, List <DataRecord> > catMap = new MyDictionary <string, List <DataRecord> >(); foreach (DataRecord dr in catList) { string cat = dr.GetValue("cat"); if (!catMap.ContainsKey(cat)) { catMap[cat] = new List <DataRecord>(); } catMap[cat].Add(dr); } foreach (string key in catMap.Keys) { List <DataRecord> list = catMap[key]; int[] cats = new int[list.Count]; int[] ids = new int[list.Count]; int[] ps = new int[list.Count]; int[] cs = new int[list.Count]; for (int i = 0; i < list.Count; i++) { cats[i] = int.Parse(list[i].GetValue("itemCat")); ids[i] = int.Parse(list[i].GetValue("itemId")); ps[i] = int.Parse(list[i].GetValue("priority")); cs[i] = int.Parse(list[i].GetValue("count")); } catDic[key] = new ItemPriority(cats, ids, ps, cs); } List <DataRecord> extraList = MysqlUtil.SelectRecords("select * from new_item_extra", FreeRuleConfig.MysqlConnection); foreach (DataRecord dr in extraList) { int item = int.Parse(dr.GetValue("item")); int cat = int.Parse(dr.GetValue("cat")); string drop = dr.GetValue("extraDrop"); if (!extraDic.ContainsKey(cat)) { extraDic.Add(cat, new MyDictionary <int, CatPriority>()); } extraDic[cat][item] = new CatPriority(drop); } List <DataRecord> itemList = MysqlUtil.SelectRecords("select * from new_item", FreeRuleConfig.MysqlConnection); foreach (DataRecord dr in itemList) { string item = dr.GetValue("item"); int id = int.Parse(dr.GetValue("id")); } InitialPoints(); } }