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

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

        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 _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 _f6="";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string F6
        {
             get{ return _f6; }
             set{ _f6=value; }
        }

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


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