erp/BizCom/Dao/CeErpInvoicingInfo.cs

using Castle.ActiveRecord;
using System.Text;

namespace BizCom
{
    [ActiveRecord("CE_ErpInvoicingInfo")]
    public class CeErpInvoicingInfo : ComBase<CeErpInvoicingInfo>
    {

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

        private string _comName = "";
        /// <summary>
        ///公司全名
        /// </summary>
        [Property]
        public string ComName
        {
            get { return _comName; }
            set { _comName = value; }
        }

        private string _cName = "";
        /// <summary>
        ///公司简称
        /// </summary>
        [Property]
        public string CName
        {
            get { return _cName; }
            set { _cName = value; }
        }

        private string _tax = "";
        /// <summary>
        ///税号
        /// </summary>
        [Property]
        public string Tax
        {
            get { return _tax; }
            set { _tax = value; }
        }

        private string _address = "";
        /// <summary>
        ///注册地址
        /// </summary>
        [Property]
        public string Address
        {
            get { return _address; }
            set { _address = value; }
        }

        private string _phone = "";
        /// <summary>
        ///注册电话
        /// </summary>
        [Property]
        public string Phone
        {
            get { return _phone; }
            set { _phone = value; }
        }

        private string _bank = "";
        /// <summary>
        ///开户行
        /// </summary>
        [Property]
        public string Bank
        {
            get { return _bank; }
            set { _bank = value; }
        }

        private string _bankAcc = "";
        /// <summary>
        ///开户账号
        /// </summary>
        [Property]
        public string BankAcc
        {
            get { return _bankAcc; }
            set { _bankAcc = value; }
        }

        private string _billKey = "";
        /// <summary>
        ///开票身份认证
        /// </summary>
        [Property]
        public string BillKey
        {
            get { return _billKey; }
            set { _billKey = value; }
        }

        private string _legal = "";
        /// <summary>
        ///法人
        /// </summary>
        [Property]
        public string legal
        {
            get { return _legal; }
            set { _legal = value; }
        }

        private string _taxrate = "";
        /// <summary>
        ///税率
        /// </summary>
        [Property]
        public string taxrate
        {
            get { return _taxrate; }
            set { _taxrate = value; }
        }

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


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