using Castle.ActiveRecord;
using NHibernate.Criterion;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BizCom
{
    [ActiveRecord("CE_ErpTradeSpu")]
    public class CeErpTradeSpu : ComBase<CeErpTradeSpu>
    {
        /// <summary>
        /// 
        /// </summary>
        [PrimaryKey(PrimaryKeyType.Native)]
        public int ID { get; set; }


        /// <summary>
        ///发货时间
        /// </summary>
        [Property]
        public DateTime? createTime { get; set; }

        private string _spuId = "";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string spuId
        {
            get { return _spuId; }
            set { _spuId = value; }
        }
        private string _tid = "";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string tid
        {
            get { return _tid; }
            set { _tid = value; }
        }
        /// <summary>
        /// 分类
        /// </summary>
        private string _category = "";

        [Property]
        public string category
        {
            get { return _category; }
            set { _category = value; }
        }
        /// <summary>
        /// 流水号
        /// </summary>
        private string _serialNumber = "";

        [Property]
        public string serialNumber
        {
            get { return _serialNumber; }
            set { _serialNumber = value; }
        }
        /// <summary>
        /// 运营
        /// </summary>
        private string _operate = "";

        [Property]
        public string operate
        {
            get { return _operate; }
            set { _operate = value; }
        }
        /// <summary>
        /// 美工
        /// </summary>
        private string _designer = "";

        [Property]
        public string designer
        {
            get { return _designer; }
            set { _designer = value; }
        }
        /// <summary>
        /// 附件
        /// </summary>
        private string _atta = "";

        [Property]
        public string atta
        {
            get { return _atta; }
            set { _atta = value; }
        }
        /// <summary>
        /// 店铺
        /// </summary>
        private int _shopId = 0;

        [Property]
        public int shopId
        {
            get { return _shopId; }
            set { _shopId = value; }
        }

        /// <summary>
        ///上架时间
        /// </summary>
        [Property]
        public DateTime? upTime { get; set; }

        /// <summary>
        /// 是否同步
        /// </summary>
        private bool _isSync = false;
        public bool isSync
        {
            get { return _isSync; }
            set { _isSync = value; }
        }
        /// <summary>
        /// 返回信息
        /// </summary>
        private string _message = "";

        public string message
        {
            get { return _message; }
            set { _message = value; }
        }
        public static CeErpTradeSpu GetBySpuId(string spuId)
        {
            return FindFirst(Expression.Eq("spuId", spuId));
        }

        public static void updateAsync(string id)
        {
            ExecuteNonQuery(string.Format("update CE_ErpTradeSpu set isSync=1 where ID='{0}'", id));
        }

        public static void updateError(string id, string message)
        {
            ExecuteNonQuery(string.Format("update CE_ErpTradeSpu set message='{1}' where ID='{0}'", id, message));
        }
    }
}