erp/BizCom/Dao/CeErpTradeSample.cs

using Castle.ActiveRecord;
using NHibernate.Criterion;
using System;
using System.Text;

namespace BizCom
{
    [ActiveRecord("CE_ErpTradeSample")]
    public class CeErpTradeSample : ComBase<CeErpTradeSample>
    {

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

        private string _ctid = "";
        /// <summary>
        ///땐데뵀
        /// </summary>
        [Property]
        public string ctid
        {
            get { return _ctid; }
            set { _ctid = value; }
        }

        /// <summary>
        ///쌈데珂쇌
        /// </summary>
        [Property]
        public DateTime? ReceiveDate { get; set; }

        private double _advanceFee = 0;
        /// <summary>
        ///득마쏜띨
        /// </summary>
        [Property]
        public double AdvanceFee
        {
            get { return _advanceFee; }
            set { _advanceFee = value; }
        }

        private double _refund = 0;
        /// <summary>
        ///럿운쏜띨
        /// </summary>
        [Property]
        public double Refund
        {
            get { return _refund; }
            set { _refund = value; }
        }

        private double _commission = 0;
        /// <summary>
        ///澾쏜
        /// </summary>
        [Property]
        public double Commission
        {
            get { return _commission; }
            set { _commission = value; }
        }

        private double _serviceFee = 0;
        /// <summary>
        ///틱憩륩蛟롤
        /// </summary>
        [Property]
        public double ServiceFee
        {
            get { return _serviceFee; }
            set { _serviceFee = value; }
        }

        private double _logisticsFee = 0;
        /// <summary>
        ///우뒵롤
        /// </summary>
        [Property]
        public double LogisticsFee
        {
            get { return _logisticsFee; }
            set { _logisticsFee = value; }
        }

        /// <summary>
        ///깃션휑퍅
        /// </summary>
        [Property]
        public DateTime? SampleDate { get; set; }

        private int _sampleUserId = 0;
        /// <summary>
        ///깃션훙逃ID
        /// </summary>
        [Property]
        public int SampleUserId
        {
            get { return _sampleUserId; }
            set { _sampleUserId = value; }
        }

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

        public static CeErpTradeSample GetBytid(string tid)
        {
            return FindFirst(Expression.Eq("ctid", tid));
        }
    }
}