erp/BizCom/Dao/CeErpPlaceRegister.cs

using Castle.ActiveRecord;
using System;
using System.Text;

namespace BizCom
{
    [ActiveRecord("CE_ErpPlaceRegister")]
    public class CeErpPlaceRegister : ComBase<CeErpPlaceRegister>
    {

        /// <summary>
        /// 
        /// </summary>
        [PrimaryKey(PrimaryKeyType.Native)]
        public int ID { get; set; }

        /// <summary>
        ///下单时间
        /// </summary>
        [Property]
        public DateTime? PlactTime { get; set; }

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

        private int _deliveryCount = 0;
        /// <summary>
        ///发货数量
        /// </summary>
        [Property]
        public int DeliveryCount
        {
            get { return _deliveryCount; }
            set { _deliveryCount = value; }
        }

        private int _receiveCount = 0;
        /// <summary>
        ///收货数量
        /// </summary>
        [Property]
        public int ReceiveCount
        {
            get { return _receiveCount; }
            set { _receiveCount = value; }
        }

        private string _outSid = "";
        /// <summary>
        ///快递
        /// </summary>
        [Property]
        public string OutSid
        {
            get { return _outSid; }
            set { _outSid = value; }
        }

        private string _fileName = "";
        /// <summary>
        ///文件名
        /// </summary>
        [Property]
        public string FileName
        {
            get { return _fileName; }
            set { _fileName = value; }
        }

        private string _memo = "";
        /// <summary>
        ///备注
        /// </summary>
        [Property]
        public string Memo
        {
            get { return _memo; }
            set { _memo = value; }
        }

        private string _img = "";
        /// <summary>
        ///图片
        /// </summary>
        [Property]
        public string Img
        {
            get { return _img; }
            set { _img = value; }
        }

        private int _addUserId = 0;
        /// <summary>
        ///添加人
        /// </summary>
        [Property]
        public int AddUserId
        {
            get { return _addUserId; }
            set { _addUserId = value; }
        }

        /// <summary>
        ///创建时间
        /// </summary>
        [Property]
        public DateTime? CreateTime { get; set; }

        /// <summary>
        ///预计出货时间
        /// </summary>
        [Property]
        public DateTime? PreOutTime { get; set; }

        private int _supplier = 0;
        /// <summary>
        ///供应商ID
        /// </summary>
        [Property]
        public int Supplier
        {
            get { return _supplier; }
            set { _supplier = value; }
        }

        private string _did = "";
        /// <summary>
        ///编号
        /// </summary>
        [Property]
        public string Did
        {
            get { return _did; }
            set { _did = value; }
        }


        private int _outLate = 0;
        /// <summary>
        ///出货逾期
        /// </summary>
        [Property]
        public int OutLate
        {
            get { return _outLate; }
            set { _outLate = value; }
        }

        private int _surplus = 0;
        /// <summary>
        ///剩余件数
        /// </summary>
        [Property]
        public int Surplus
        {
            get { return _surplus; }
            set { _surplus = value; }
        }

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

        private string _splitTag = "";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string splitTag
        {
            get { return _splitTag; }
            set { _splitTag = value; }
        }
        private string _curState = "";
        /// <summary>
        ///已完成未完成
        /// </summary>
        [Property]
        public string CurState
        {
            get { return _curState; }
            set { _curState = value; }
        }



        public static void Del(object id)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("delete from CE_ErpPlaceRegister where id=" + id);
            ExecuteNonQuery(sql.ToString());
        }
    }
}