erp/BizCom/Dao/SZcItem.cs

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

namespace BizCom
{
    [ActiveRecord("S_ZcItem")]
    public class SZcItem : ComBase<SZcItem>
    {

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

        private int _userID = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public int UserID
        {
            get { return _userID; }
            set { _userID = value; }
        }

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

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

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

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

        /// <summary>
        ///
        /// </summary>
        [Property]
        public DateTime? GetTime { get; set; }

        /// <summary>
        ///
        /// </summary>
        [Property]
        public DateTime? LastTerm { get; set; }

        private int _state = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public int State
        {
            get { return _state; }
            set { _state = value; }
        }

        /// <summary>
        ///
        /// </summary>
        [Property]
        public DateTime? AddTime { get; set; }


        private double _amount = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public double Amount
        {
            get { return _amount; }
            set { _amount = value; }
        }

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