Beispiel #1
0
        /// <summary>
        /// 更新 来访卡 状态
        /// </summary>
        /// <param name="card_no"></param>
        /// <param name="flag"></param>
        /// <returns></returns>
        public static int updateFlag(string card_no, int flag)
        {
            //1.查询出数据。
            //2. 符合条件则更新数据
            int        returnValue = 0;
            guest_card model       = GetModel(card_no);

            if (model == null)
            {
                return(-1);
            }
            //并没有建立数据库连接
            MySqlConnection conn = new MySqlConnection(connectStr);

            try
            {
                conn.Open();                                                                                                  //建立连接,打开数据库
                card_no = card_no.Replace("'", "‘");                                                                          //防一下sql注入
                string       sqlstr = "update guest_card set  card_flag ='" + flag + "'  where card_no = '" + card_no + "' "; //SQL语句
                MySqlCommand cmd    = new MySqlCommand(sqlstr, conn);
                returnValue = cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
            finally
            {
                conn.Close();   //关闭连接
            }
            return(returnValue);
        }
Beispiel #2
0
        //获取 来访卡 信息
        public static guest_card GetModel(string card_no)
        {
            guest_card model;
            //并没有建立数据库连接
            MySqlConnection conn = new MySqlConnection(connectStr);

            try
            {
                conn.Open();                                                                         //建立连接,打开数据库
                card_no = card_no.Replace("'", "‘");                                                 //防一下sql注入
                string       sqlstr = "select * from guest_card where card_no = '" + card_no + "' "; //SQL语句
                MySqlCommand cmd    = new MySqlCommand(sqlstr, conn);
                //相当于数据读出流  理解为一本书
                MySqlDataReader reader = cmd.ExecuteReader();
                if (reader.Read())   //遍历表中数据,只取第一条记录
                {
                    //Console.WriteLine(reader.GetInt32("id") + reader.GetString("name") + reader.GetString("age"));
                    //封装属性
                    model = new guest_card
                    {
                        //封装属性
                        card_id   = reader.GetInt32("card_id"),
                        card_no   = reader.GetString("card_no"),
                        card_flag = reader.GetInt32("card_flag")
                    };
                }
                else
                {
                    model = null;
                }
                if (!reader.IsClosed)
                {
                    reader.Close();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
                return(null);
            }
            finally
            {
                conn.Close();   //关闭连接
            }
            return(model);
        }