using Castle.ActiveRecord;

using Castle.ActiveRecord.Queries;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Models

{

    //指定数据表，Lazy为延迟加载，一旦指定为延迟加载，其属性应该加上virtual修饰。还有其他特性参数，自己慢慢琢磨

    //继承ActiveRecordBase<T> 基类中含有默认实现的方法

    [ActiveRecord("CategoryInfo", Lazy = true)]

    public class CategoryInfo : ActiveRecordBase<CategoryInfo>

    {

        // 指定数据表中的主键，指定ID是自增列
        //如果属性名和字段名一致，[Property()]中可以为空，也可以写上字段的名字。

        [PrimaryKey(PrimaryKeyType.Identity, "ID")]

        public virtual int ID { get; set; }

        // 指定数据表中的列,[Property("Title")] 中的Title是数据库中列名称

        [Property("Title")]

        public virtual string Title { get; set; }

        [Property("Description")]

        public virtual string Description { get; set; }

        [Property("CreateDate")]

        public virtual DateTime CreateDate { get; set; }

        //是否推荐  1：是  0：否

        [Property("Type")]

        public virtual int Type { get; set; }

        //多对多

        //typeof(ThemeInfo):对方表的实体类，Table:关联中间表，ColumnRef:关联中间表中与对方实体相关的列，ColumnKey：关联中间表中与本实体相关的列，

        //Lazy：延迟加载，通过本实体获取对方实体信息时，才会去数据库查询

        //Cascade：级联操作，标记何种操作会级联到子表

        [HasAndBelongsToMany(typeof(ThemeInfo), Table = "CategoryThemeMapping", ColumnRef = "ThemeID", ColumnKey = "CategoryID", Lazy = true, Cascade = ManyRelationCascadeEnum.Delete)]

        public virtual IList<ThemeInfo> ThemeInfos { get; set; }

        //查询所有推荐的分类

        public static IList<CategoryInfo> FindAllForTopCategory()

        {

            //TODO:语法研究

            SimpleQuery<CategoryInfo> query = new SimpleQuery<CategoryInfo>(@" from CategoryInfo c where c.Type=1 ");

            return query.Execute();

        }

        /// <summary>

        /// 依据主键ID查询一个实体

        /// </summary>

        /// <param name="id"></param>

        /// <returns></returns>

        public static CategoryInfo Find(int id)

        {

            return FindByPrimaryKey(id);

        }

    }

}

//多对一，对应ThemeInfo的Comments属性,Column = "ThemeID"  ThemeID是本类中的外键字段.Insert=false,Update=false:当从表单独更新的时候会出现错误，加入此句避免。

　　　　　//[BelongsTo(Column = "ThemeID", Insert = false, Update = false)]

　　　　　//public virtual ThemeInfo Theme { get; set; }

[ActiveRecord("MessageInfo")]

    public class MessageInfo : ActiveRecordBase<MessageInfo>

    {

        [PrimaryKey]

        public MyCompositeKey ID { get; set; }

    }

    [CompositeKey, Serializable]

    public class MyCompositeKey

    {

        private string _keyA;

        private string _keyB;

        [KeyProperty]

        public virtual string KeyA

        {

            get { return _keyA; }

            set { _keyA = value; }

        }

        [KeyProperty]

        public virtual string KeyB

        {

            get { return _keyB; }

            set { _keyB = value; }

        }

        public override string ToString()

        {

            return string.Join(":", new string[] { _keyA, _keyB });

        }

        public override bool Equals(object obj)

        {

            if (obj == this) return true;

            if (obj == null || obj.GetType() != this.GetType()) return false;

            MyCompositeKey test = (MyCompositeKey)obj;

            return (_keyA == test.KeyA || (_keyA != null && _keyA.Equals(test.KeyA))) &&

                (_keyB == test.KeyB || (_keyB != null && _keyB.Equals(test.KeyB)));

        }

        public override int GetHashCode()

        {

            return _keyA.GetHashCode() ^ _keyB.GetHashCode();

        }

    }

[ActiveRecord("CompanyInfo")]

    public class CompanyInfo : ActiveRecordBase<CompanyInfo>

    {

        private PostalAddress _address;

        [Nested]

        public PostalAddress Address

        {

            get { return _address; }

            set { _address = value; }

        }

    }

    public class PostalAddress

    {

        private String _address;

        private String _city;

        private String _state;

        private String _zipcode;

        public PostalAddress()

        {

        }

        public PostalAddress(String address, String city, String state, String zipcode)

        {

            _address = address;

            _city = city;

            _state = state;

            _zipcode = zipcode;

        }

        [Property]

        public String Address

        {

            get { return _address; }

            set { _address = value; }

        }

        [Property]

        public String City

        {

            get { return _city; }

            set { _city = value; }

        }

        [Property]

        public String State

        {

            get { return _state; }

            set { _state = value; }

        }

        [Property]

        public String ZipCode

        {

            get { return _zipcode; }

            set { _zipcode = value; }

        }

    }