public AgentUserInfo[] GetAllAgentUsers() { MySqlConnection myconn = null; MySqlCommand mycmd = null; try { myconn = MyDBHelper.Instance.CreateConnection(); string sqlTextA = "select * from agentuserinfo; "; mycmd = myconn.CreateCommand(); mycmd.CommandText = sqlTextA; myconn.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd); DataTable tableAgents = new DataTable(); adapter.Fill(tableAgents); if (tableAgents.Rows.Count == 0) { return(null); } DataTable tablePlayers = new DataTable(); string sqlTextB = "select a.*, c.UserName as ReferrerUserName, b.* , g.Gravel, g.FirstGetGravelTime from playersimpleinfo a left join playersimpleinfo c on a.ReferrerUserID = c.id left join playerfortuneinfo b on a.id = b.userId left join playergravelinfo g on a.id = g.UserID where a.GroupType = @GroupType"; mycmd = new MySqlCommand(sqlTextB, myconn); mycmd.Parameters.AddWithValue("@GroupType", (int)PlayerGroupType.AgentPlayer); adapter = new MySqlDataAdapter(mycmd); adapter.Fill(tablePlayers); var players = MetaDBAdapter <PlayerInfo> .GetPlayerInfoFromDataTable(tablePlayers); if (players == null) { return(null); } var lists = MetaDBAdapter <AgentUserInfo> .GetAgentUserInfoFromDataTable(tableAgents, players); tablePlayers.Clear(); tablePlayers.Dispose(); adapter.Dispose(); return(lists); } finally { if (mycmd != null) { mycmd.Dispose(); } if (myconn != null) { myconn.Close(); myconn.Dispose(); } } }
//public void AddDeletedPlayer(List<PlayerInfo> players) //{ // MySqlConnection myconn = null; // MySqlCommand mycmd = null; // try // { // myconn = MyDBHelper.Instance.CreateConnection(); // myconn.Open(); // mycmd = myconn.CreateCommand(); // StringBuilder builder = new StringBuilder(); // builder.Append("insert into deletedplayerinfo values "); // for (int i = 0; i < players.Count; i++) // { // builder.Append("("); // builder.Append(")"); // if (i != players.Count) // { // builder.Append(" , "); // } // } // mycmd.CommandText = builder.ToString(); // mycmd.ExecuteNonQuery(); // } // finally // { // if (mycmd != null) // { // mycmd.Dispose(); // } // if (myconn != null) // { // myconn.Close(); // myconn.Dispose(); // } // } //} public PlayerInfo[] GetDeletedPlayers() { MySqlConnection myconn = null; MySqlCommand mycmd = null; try { myconn = MyDBHelper.Instance.CreateConnection(); myconn.Open(); mycmd = myconn.CreateCommand(); string sqlText = "select * from deletedplayerinfo "; mycmd.CommandText = sqlText; DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd); adapter.Fill(table); var lists = MetaDBAdapter <PlayerInfo> .GetPlayerInfoFromDataTable(table); table.Clear(); table.Dispose(); adapter.Dispose(); return(lists); } finally { if (mycmd != null) { mycmd.Dispose(); } if (myconn != null) { myconn.Close(); myconn.Dispose(); } } }