/// <summary>
        /// 得到一个对象实体
        /// </summary>
        public XHD.Model.shop_base_code GetModel(string type_no, string code_id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select type_no,code_id,code_name,english_name,is_display,code_type,memo from shop_base_code ");
            strSql.Append(" where type_no=@type_no and code_id=@code_id ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@type_no", MySqlDbType.VarChar, 2),
                new MySqlParameter("@code_id", MySqlDbType.VarChar, 30)
            };
            parameters[0].Value = type_no;
            parameters[1].Value = code_id;

            XHD.Model.shop_base_code model = new XHD.Model.shop_base_code();
            DataSet ds = Shop_DbHelperMySQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(XHD.Model.shop_base_code model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update shop_base_code set ");
            strSql.Append("code_name=@code_name,");
            strSql.Append("english_name=@english_name,");
            strSql.Append("is_display=@is_display,");
            strSql.Append("code_type=@code_type,");
            strSql.Append("memo=@memo");
            strSql.Append(" where type_no=@type_no and code_id=@code_id ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@code_name",    MySqlDbType.VarChar,  30),
                new MySqlParameter("@english_name", MySqlDbType.VarChar,  30),
                new MySqlParameter("@is_display",   MySqlDbType.Int32,     4),
                new MySqlParameter("@code_type",    MySqlDbType.VarChar,  20),
                new MySqlParameter("@memo",         MySqlDbType.VarChar, 255),
                new MySqlParameter("@type_no",      MySqlDbType.VarChar,   2),
                new MySqlParameter("@code_id",      MySqlDbType.VarChar, 30)
            };
            parameters[0].Value = model.code_name;
            parameters[1].Value = model.english_name;
            parameters[2].Value = model.is_display;
            parameters[3].Value = model.code_type;
            parameters[4].Value = model.memo;
            parameters[5].Value = model.type_no;
            parameters[6].Value = model.code_id;

            int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(XHD.Model.shop_base_code model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into shop_base_code(");
            strSql.Append("type_no,code_id,code_name,english_name,is_display,code_type,memo)");
            strSql.Append(" values (");
            strSql.Append("@type_no,@code_id,@code_name,@english_name,@is_display,@code_type,@memo)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@type_no",      MySqlDbType.VarChar,  2),
                new MySqlParameter("@code_id",      MySqlDbType.VarChar, 30),
                new MySqlParameter("@code_name",    MySqlDbType.VarChar, 30),
                new MySqlParameter("@english_name", MySqlDbType.VarChar, 30),
                new MySqlParameter("@is_display",   MySqlDbType.Int32,    4),
                new MySqlParameter("@code_type",    MySqlDbType.VarChar, 20),
                new MySqlParameter("@memo",         MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = model.type_no;
            parameters[1].Value = model.code_id;
            parameters[2].Value = model.code_name;
            parameters[3].Value = model.english_name;
            parameters[4].Value = model.is_display;
            parameters[5].Value = model.code_type;
            parameters[6].Value = model.memo;

            int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public XHD.Model.shop_base_code DataRowToModel(DataRow row)
 {
     XHD.Model.shop_base_code model = new XHD.Model.shop_base_code();
     if (row != null)
     {
         if (row["type_no"] != null)
         {
             model.type_no = row["type_no"].ToString();
         }
         if (row["code_id"] != null)
         {
             model.code_id = row["code_id"].ToString();
         }
         if (row["code_name"] != null)
         {
             model.code_name = row["code_name"].ToString();
         }
         if (row["english_name"] != null)
         {
             model.english_name = row["english_name"].ToString();
         }
         if (row["is_display"] != null && row["is_display"].ToString() != "")
         {
             model.is_display = int.Parse(row["is_display"].ToString());
         }
         if (row["code_type"] != null)
         {
             model.code_type = row["code_type"].ToString();
         }
         if (row["memo"] != null)
         {
             model.memo = row["memo"].ToString();
         }
     }
     return(model);
 }