public PlayerGravelRequsetRecordInfo[] GetLastDayPlayerGravelRequsetRecords(MyDateTime date, int userID) { MySqlConnection myconn = null; MySqlCommand mycmd = null; try { myconn = MyDBHelper.Instance.CreateConnection(); mycmd = myconn.CreateCommand(); string sqlInnerSelect = " select * from playergravelrequsetrecordinfo "; string sqlWhere = " where "; if (userID > 0) { sqlWhere += " UserID=@userID and "; } sqlWhere += " @beginDate <= RequestDate and RequestDate < @endDate "; string sqlText = "SELECT r.*, s.UserName FROM (" + sqlInnerSelect + sqlWhere + ") r left join playersimpleinfo s on r.UserID = s.id "; mycmd.CommandText = sqlText; mycmd.Parameters.AddWithValue("@beginDate", new DateTime(date.Year, date.Month, date.Day, 0, 0, 0)); mycmd.Parameters.AddWithValue("@endDate", new DateTime(date.Year, date.Month, date.Day + 1, 0, 0, 0)); mycmd.Parameters.AddWithValue("@userID", userID); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd); adapter.Fill(table); var lists = MetaDBAdapter <PlayerGravelRequsetRecordInfo> .GetPlayerGravelRequsetRecordInfoFromDataTable(table); table.Clear(); table.Dispose(); adapter.Dispose(); return(lists); } finally { if (mycmd != null) { mycmd.Dispose(); } if (myconn != null) { myconn.Close(); myconn.Dispose(); } } }
public PlayerGravelRequsetRecordInfo GetLastDayPlayerGravelRequsetRecord(int userID) { MySqlConnection myconn = null; MySqlCommand mycmd = null; try { myconn = MyDBHelper.Instance.CreateConnection(); mycmd = myconn.CreateCommand(); string sqlInnerSelect = " select * from playergravelrequsetrecordinfo where UserID=@userID order by id desc limit 1 "; string sqlText = "SELECT r.*, s.UserName FROM (" + sqlInnerSelect + ") r left join playersimpleinfo s on r.UserID = s.id "; mycmd.CommandText = sqlText; mycmd.Parameters.AddWithValue("@userID", userID); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd); adapter.Fill(table); var records = MetaDBAdapter <PlayerGravelRequsetRecordInfo> .GetPlayerGravelRequsetRecordInfoFromDataTable(table); table.Clear(); table.Dispose(); adapter.Dispose(); if (records == null || records.Length == 0) { return(null); } return(records[0]); } finally { if (mycmd != null) { mycmd.Dispose(); } if (myconn != null) { myconn.Close(); myconn.Dispose(); } } }