/// <summary> /// 查询语句。 /// </summary> /// <param name="cmdText">指定SQL查询语句</param> /// <returns>返回整型。-1表示语句有问题,0表示查询成功</returns> public static void ExecuteReader(String cmdText, CommandType cmdType, readData callback, params MySqlParameter[] parameters) { using (MySqlConnection conn = new MySqlConnection(strDataBaseCon)) { using (MySqlCommand cmd = new MySqlCommand(cmdText, conn)) { cmd.CommandType = cmdType; cmd.Parameters.AddRange(parameters); conn.Open(); MySqlDataReader sqlReader = cmd.ExecuteReader(); callback(sqlReader); } } }
public Post Get(int id) { iGetPost realObject = new readData(); return(realObject.GetPost(id)); }
public List <cart> Get() { iReadAllData readObject = new readData(); return(readObject.GetAllItems()); }