erp/BizCom/Dao/CeErpBill.cs

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

namespace BizCom
{
    [ActiveRecord("CE_ErpBill")]
    public class CeErpBill : ComBase<CeErpBill>
    {

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

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

        private string _title = "";
        /// <summary>
        ///发票抬头
        /// </summary>
        [Property]
        public string title
        {
            get { return _title; }
            set { _title = value; }
        }

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

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

        private string _bankac = "";
        /// <summary>
        ///账号
        /// </summary>
        [Property]
        public string bankac
        {
            get { return _bankac; }
            set { _bankac = 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 _price = "";
        /// <summary>
        ///总价
        /// </summary>
        [Property]
        public string price
        {
            get { return _price; }
            set { _price = value; }
        }

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

        private int _num = 0;
        /// <summary>
        ///数量
        /// </summary>
        [Property]
        public int num
        {
            get { return _num; }
            set { _num = value; }
        }

        private string _type = "";
        /// <summary>
        ///发票规格类型
        /// </summary>
        [Property]
        public string type
        {
            get { return _type; }
            set { _type = value; }
        }

        private string _sendType = "";
        /// <summary>
        ///寄送类型
        /// </summary>
        [Property]
        public string sendType
        {
            get { return _sendType; }
            set { _sendType = value; }
        }

        private string _email = "";
        /// <summary>
        ///邮箱地址
        /// </summary>
        [Property]
        public string email
        {
            get { return _email; }
            set { _email = value; }
        }

        private string _shopName = "";
        /// <summary>
        ///店铺
        /// </summary>
        [Property]
        public string shopName
        {
            get { return _shopName; }
            set { _shopName = value; }
        }

        private string _buyer_nick = "";
        /// <summary>
        ///买家旺旺
        /// </summary>
        [Property]
        public string buyer_nick
        {
            get { return _buyer_nick; }
            set { _buyer_nick = value; }
        }

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

        /// <summary>
        ///开具时间
        /// </summary>
        [Property]
        public DateTime? executeTime { get; set; }

        private int _state = 0;
        /// <summary>
        ///当前状态
        /// </summary>
        [Property]
        public int state
        {
            get { return _state; }
            set { _state = value; }
        }

        private int _userId = 0;
        /// <summary>
        ///申请人
        /// </summary>
        [Property]
        public int userId
        {
            get { return _userId; }
            set { _userId = value; }
        }

        private string _returnReason = "";
        /// <summary>
        ///驳回原因
        /// </summary>
        [Property]
        public string returnReason
        {
            get { return _returnReason; }
            set { _returnReason = value; }
        }

        /// <summary>
        ///修改时间
        /// </summary>
        [Property]
        public DateTime? modifyTime { get; set; }

        private int _comId = 0;
        /// <summary>
        ///开票公司ID
        /// </summary>
        [Property]
        public int comId
        {
            get { return _comId; }
            set { _comId = value; }
        }

        private string _fplsh = "";
        /// <summary>
        ///发票流水号
        /// </summary>
        [Property]
        public string fplsh
        {
            get { return _fplsh; }
            set { _fplsh = value; }
        }

        private string _fpdm = "";
        /// <summary>
        ///发票代码
        /// </summary>
        [Property]
        public string fpdm
        {
            get { return _fpdm; }
            set { _fpdm = value; }
        }

        private string _fphm = "";
        /// <summary>
        ///发票号码
        /// </summary>
        [Property]
        public string fphm
        {
            get { return _fphm; }
            set { _fphm = value; }
        }

        private string _failerror = "";
        /// <summary>
        ///开票失败错误解释
        /// </summary>
        [Property]
        public string failerror
        {
            get { return _failerror; }
            set { _failerror = value; }
        }

        private string _img = "";
        /// <summary>
        ///纸质发票图片
        /// </summary>
        [Property]
        public string img
        {
            get { return _img; }
            set { _img = value; }
        }

        private string _applymemo = "";
        /// <summary>
        ///客服申请时备注
        /// </summary>
        [Property]
        public string applymemo
        {
            get { return _applymemo; }
            set { _applymemo = value; }
        }

        private string _executeUser = "";
        /// <summary>
        ///开具发票的人
        /// </summary>
        [Property]
        public string executeUser
        {
            get { return _executeUser; }
            set { _executeUser = value; }
        }

        private string _billOrderId = "";
        /// <summary>
        ///发票的订单编号
        /// </summary>
        [Property]
        public string billOrderId
        {
            get { return _billOrderId; }
            set { _billOrderId = value; }
        }

        private string _unit = "";
        /// <summary>
        ///单位
        /// </summary>
        [Property]
        public string unit
        {
            get { return _unit; }
            set { _unit = value; }
        }

        public static CeErpBill GetByTid(string tid)
        {
            return FindFirst(Expression.Eq("tid", tid));
        }

        public static void DelByTid(object tid)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("delete from CE_ErpBill where tid='" + tid + "'");
            ExecuteNonQuery(sql.ToString());

        }

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