public static void WriteLog(int iAccountID, Enums.LogMainType eMainType, Enums.LogSubType eSubType, string sIDParam = "", string sBeforeValue = "", string sNextValue = "") { MySqlCommand cCommand = new MySqlCommand(); cCommand.Connection = Connection; if (null == _cConnection) { return; } cCommand.CommandText = "INSERT INTO *(*, *, *, *, *, *, *, *) VALUES (@*, @*, @*, @*, @*, @*, @*, @*);"; cCommand.Parameters.Add("@*", MySqlDbType.Int32, 10); cCommand.Parameters.Add("@*", MySqlDbType.VarChar); cCommand.Parameters.Add("@*", MySqlDbType.VarChar); cCommand.Parameters.Add("@*", MySqlDbType.VarChar); cCommand.Parameters.Add("@*", MySqlDbType.VarChar); cCommand.Parameters.Add("@*", MySqlDbType.VarChar); cCommand.Parameters.Add("@*", MySqlDbType.Date); cCommand.Parameters.Add("@*", MySqlDbType.Time); cCommand.Parameters[0].Value = iAccountID; cCommand.Parameters[1].Value = eMainType.ToString(); cCommand.Parameters[2].Value = eSubType.ToString(); cCommand.Parameters[3].Value = sIDParam; cCommand.Parameters[4].Value = sBeforeValue; cCommand.Parameters[5].Value = sNextValue; cCommand.Parameters[6].Value = DateTimeUtil.ToSqlDate(DateTime.Now); cCommand.Parameters[7].Value = DateTimeUtil.ToSqlTime(DateTime.Now); try { //Debug.Log(" - [MySqlUtil : WriteLog] open : " + iAccountID.ToString()); cCommand.ExecuteNonQuery(); } catch (Exception ce) { FileLogUtil.Log("[MySqlUtil : WriteLog] Exception : " + ce.ToString()); cCommand.Dispose(); //Debug.Log(" - [MySqlUtil : WriteLog] close : " + iAccountID.ToString()); return; } cCommand.Dispose(); //Debug.Log(" - [MySqlUtil : WriteLog] close : " + iAccountID.ToString()); }
public static Enums.ErrorCode GetRankingData(out DataSet cDataSet) { Shik.LastUpdate(); string sCommand = "select " + _sTableName + ".*, " + _sTableName + ".*, " + _sTableName + ".*, " + _sTableName + ".*, " + _sTableName + ".*, " + _sTableName + ".* from " + _sTableName + " where not disable=1;"; MySqlDataAdapter cAdapter = new MySqlDataAdapter(sCommand, Connection); cDataSet = new DataSet(); try { cAdapter.Fill(cDataSet); } catch (Exception ce) { FileLogUtil.Log("ERROR - GetRankingData" + ce.Message); cAdapter.Dispose(); return(Enums.ErrorCode.eDB_ExecuteError); } cAdapter.Dispose(); return(Enums.ErrorCode.eNone); }
public static MySqlUtilResult ConnectToDB(ref string sError) { _sTableName = "G"; if (Enums.DBTableType.eTestGame == ServerState.Manager.DBTableType) { _sTableName = "T"; } string sConnectionString = ""; switch ((Enums.DBServerType)ServerState.Manager.DBType) { case Enums.DBServerType.A: sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; break; case Enums.DBServerType.B: sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; break; case Enums.DBServerType.C: sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; sConnectionString += @"*"; break; } _cConnection = new MySqlConnection(sConnectionString); try { _cConnection.Open(); } catch (Exception c) { _sListConnectionFailError.Add(c.ToString()); _cConnection = null; sError = c.ToString(); return(MySqlUtilResult.eConnectionError); } FileLogUtil.Log("Reconnection DB - DBType : " + ServerState.Manager.DBType.ToString() + ", DBTableType : " + _sTableName); return(MySqlUtilResult.eOK); }