erp/BizCom/Dao/test.cs

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

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

        /// <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; }
        }

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

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

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

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

        private bool _isUrgency=false;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public bool IsUrgency
        {
             get{ return _isUrgency; }
             set{ _isUrgency=value; }
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        private bool _isAutoDispatch=false;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public bool IsAutoDispatch
        {
             get{ return _isAutoDispatch; }
             set{ _isAutoDispatch=value; }
        }

        private bool _isVerifyToSupplier=false;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public bool IsVerifyToSupplier
        {
             get{ return _isVerifyToSupplier; }
             set{ _isVerifyToSupplier=value; }
        }

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

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

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

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

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

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

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

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

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

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

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

        private int _isSF=0;
        /// <summary>
        ///是否标记顺丰单
        /// </summary>
        [Property]
        public int IsSF
        {
             get{ return _isSF; }
             set{ _isSF=value; }
        }

        private int _isXianHuo=0;
        /// <summary>
        ///是否现货
        /// </summary>
        [Property]
        public int IsXianHuo
        {
             get{ return _isXianHuo; }
             set{ _isXianHuo=value; }
        }

        /// <summary>
        ///订单打回时间
        /// </summary>
        [Property]
        public DateTime? ReturnTime { get; set; }

        private string _otherMemo="";
        /// <summary>
        ///除了7要素的额外备注
        /// </summary>
        [Property]
        public string OtherMemo
        {
             get{ return _otherMemo; }
             set{ _otherMemo=value; }
        }

        private string _afterSaleBackReason="";
        /// <summary>
        ///售后打回的原因
        /// </summary>
        [Property]
        public string AfterSaleBackReason
        {
             get{ return _afterSaleBackReason; }
             set{ _afterSaleBackReason=value; }
        }

        private string _checkMemo="";
        /// <summary>
        ///售后查货备注
        /// </summary>
        [Property]
        public string CheckMemo
        {
             get{ return _checkMemo; }
             set{ _checkMemo=value; }
        }

        private int _isOldCustomer=0;
        /// <summary>
        ///是否老客户购买
        /// </summary>
        [Property]
        public int IsOldCustomer
        {
             get{ return _isOldCustomer; }
             set{ _isOldCustomer=value; }
        }

        private int _isSupplierRefund=0;
        /// <summary>
        ///售后责任供应商 财务标记是否退款
        /// </summary>
        [Property]
        public int IsSupplierRefund
        {
             get{ return _isSupplierRefund; }
             set{ _isSupplierRefund=value; }
        }

        private int _isReadTag=0;
        /// <summary>
        ///打回退款等客服是否读取处理
        /// </summary>
        [Property]
        public int IsReadTag
        {
             get{ return _isReadTag; }
             set{ _isReadTag=value; }
        }

        private string _afterSaleMemoType="";
        /// <summary>
        ///售后备注类型
        /// </summary>
        [Property]
        public string AfterSaleMemoType
        {
             get{ return _afterSaleMemoType; }
             set{ _afterSaleMemoType=value; }
        }

        /// <summary>
        ///加急时间
        /// </summary>
        [Property]
        public DateTime? UrgencyTime { get; set; }

        private int _isOffLineOrder=0;
        /// <summary>
        ///是否新增的线下单
        /// </summary>
        [Property]
        public int IsOffLineOrder
        {
             get{ return _isOffLineOrder; }
             set{ _isOffLineOrder=value; }
        }

        private string _payProofImg="";
        /// <summary>
        ///线下单付款凭证图片
        /// </summary>
        [Property]
        public string PayProofImg
        {
             get{ return _payProofImg; }
             set{ _payProofImg=value; }
        }

        private int _wechatTag=0;
        /// <summary>
        ///1微信单2推购单
        /// </summary>
        [Property]
        public int wechatTag
        {
             get{ return _wechatTag; }
             set{ _wechatTag=value; }
        }

        private string _backState="";
        /// <summary>
        ///已打回 已撤单 谁打回
        /// </summary>
        [Property]
        public string BackState
        {
             get{ return _backState; }
             set{ _backState=value; }
        }

        private string _makeSupplier="";
        /// <summary>
        ///制作产品的车间
        /// </summary>
        [Property]
        public string MakeSupplier
        {
             get{ return _makeSupplier; }
             set{ _makeSupplier=value; }
        }


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