using MC.ORM;
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CP.Model
{
    [TableName("kjhurl"), PrimaryKey("id")]
    public class KjhurlInfo
    {
        /// <summary>
        /// id
        /// </summary>
        public int id { get; set; }
        /// <summary>
        /// 地址
        /// </summary>
        public string url { get; set; }
        /// <summary>
        /// 跳转地址
        /// </summary>
        public string newurl { get; set; }
    }
    /// <summary>
    /// 数据库操作
    /// </summary>
    public class KjhurlData : DataConnect
    {
        /// <summary>
        /// 返回所有
        /// </summary>
        /// <returns></returns>
        public static List<KjhurlInfo> GetList()
        {
            List<KjhurlInfo> list = new List<KjhurlInfo>();
            using (Database db = new Database(mysql, MySqlClientFactory.Instance))
            {
                return db.Fetch<KjhurlInfo>("");
            }
        }
    }
}