<connectionStrings>

    <add name="sqlconnectionString" connectionString="server=127.0.0.1;database=MyDataBase;User=sa;password=123456;Connect Timeout=1000000"/>

    <add name="mysqlconnectionString" connectionString="Database=zyzs_terminal_info;Data Source=192.168.1.220;User Id=root;Password=root;CharSet=utf8;port=3306"/>

  </connectionStrings>

 string mysqlconnectionString = ConfigurationManager.ConnectionStrings["mysqlconnectionString"].ToString();

        #region 向数据库中添加多条记录 +int Insert(Model.Contacts model)

        public int InsertBaseList(List<BaseTable> model)

        {

        #region SQL语句

        const string sql = @"

           INSERT INTO zyzs_terminal_base (license_number,shop_name,user_name,phone_number,shop_address)

            VALUES (

 @license_number

,@shop_name

,@user_name

,@phone_number

,@shop_address

            );select @@IDENTITY";

            using (var connection = new MySqlConnection(mysqlconnectionString))

            {

                connection.Open();

                return connection.Execute(sql, model);

            }

            #endregion

        }

        /// <summary>

        /// 向数据库中添加一条记录

        /// </summary>

        /// <param name = "model" > 要添加的实体 </ param >

        /// < returns > 插入数据的ID </ returns >

        public int InsertBase(BaseTable model)

        {

            #region SQL语句

            const string sql = @"

                   INSERT INTO zyzs_terminal_base (license_number,shop_name,user_name,phone_number,shop_address)

            VALUES (

 @license_number

,@shop_name

,@user_name

,@phone_number

,@shop_address

            );select @@IDENTITY";

            #endregion

            using (var connection = new MySqlConnection(mysqlconnectionString))

            {

                connection.Open();

                return connection.Execute(sql, model);

            }

        }

        #endregion