Exemple #1
0
 /// <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());
        }