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

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

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

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

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

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

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

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

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

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

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


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