using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
namespace SysDataLibs.TableClass
{
    #region      MajorSpecials
    public class MajorSpecials_info : ITableInfo
    {
        #region      MajorSpecials表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： (N'N');
        /// 描述： 删除;
        /// </summary>
        public const string cIsLock = "IsLock";

        /// <summary> 
        /// 为关键字段： Y --- PrimaryKey;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 20;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 主要商品编号;
        /// </summary>
        public const string cMajorSpecialID = "MajorSpecialID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 50;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 主要商品名;
        /// </summary>
        public const string cMajorSpecialName = "MajorSpecialName";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： smallint;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： ((0));
        /// 描述： 序号;
        /// </summary>
        public const string cSortNumber = "SortNumber";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 20;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 商品编号;
        /// </summary>
        public const string cSpecialsID = "SpecialsID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 50;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 别名;
        /// </summary>
        public const string cToname = "Toname";

        #endregion
        public MajorSpecials_info() { }

        public MajorSpecials_info(DataRow poRow)
        {
            CreateTableInfo(poRow);
        }

        public void CreateTableInfo(DataRow poRow)
        {
            _IsLock = UtilStr.StrFromObj(poRow[cIsLock]);
            _MajorSpecialID = UtilStr.StrFromObj(poRow[cMajorSpecialID]);
            _MajorSpecialName = UtilStr.StrFromObj(poRow[cMajorSpecialName]);
            _SortNumber = UtilStr.StrFromObj(poRow[cSortNumber]);
            _SpecialsID = UtilStr.StrFromObj(poRow[cSpecialsID]);
            _Toname = UtilStr.StrFromObj(poRow[cToname]);
        }

        public MajorSpecials_info(string pcMajorSpecialID, DBConnSql poDBConn)
        {
            if (pcMajorSpecialID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.MajorSpecials + " where MajorSpecialID='" + pcMajorSpecialID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _IsLock = "";
        public string IsLock
        {
            get { return _IsLock; }
            set { _IsLock = value; }
        }

        private string _MajorSpecialID = "";
        public string MajorSpecialID
        {
            get { return _MajorSpecialID; }
            set { _MajorSpecialID = value; }
        }

        private string _MajorSpecialName = "";
        public string MajorSpecialName
        {
            get { return _MajorSpecialName; }
            set { _MajorSpecialName = value; }
        }

        private string _SortNumber = "";
        public string SortNumber
        {
            get { return _SortNumber; }
            set { _SortNumber = value; }
        }

        private string _SpecialsID = "";
        public string SpecialsID
        {
            get { return _SpecialsID; }
            set { _SpecialsID = value; }
        }

        private string _Toname = "";
        public string Toname
        {
            get { return _Toname; }
            set { _Toname = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("MajorSpecialsRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cIsLock, IsLock);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMajorSpecialID, MajorSpecialID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMajorSpecialName, MajorSpecialName);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSortNumber, SortNumber);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSpecialsID, SpecialsID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cToname, Toname);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.MajorSpecials + " " +
                        " (" + cIsLock + "," + cMajorSpecialID + "," + cMajorSpecialName + "," + cSortNumber + "," + cSpecialsID + "," + cToname + ") " +
                        " values ('" + _IsLock + "','" + _MajorSpecialID + "','" + _MajorSpecialName + "','" + _SortNumber + "','" + _SpecialsID + "','" + _Toname + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.MajorSpecials + " " +
                        " set " + cIsLock + "='" + _IsLock + "'," + cMajorSpecialName + "='" + _MajorSpecialName + "'," + cSortNumber + "='" + _SortNumber + "'," + cSpecialsID + "='" + _SpecialsID + "'," + cToname + "='" + _Toname + "' " +
                        " where  " + cMajorSpecialID + "='" + _MajorSpecialID + "'";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.MajorSpecials + " where " + cMajorSpecialID + "='" + _MajorSpecialID + "'";
        }

        public static bool undelete(string pcID, DBConnSql poConn)
        {
            string lcSql = " update " + Tn.MajorSpecials + " set " + cIsLock + "='N' " + " where  " + cMajorSpecialID + "='" + pcID + "'";

            return poConn.ExcuteSqlTran(lcSql);
        }

        public static bool delete(string pcID, DBConnSql poConn)
        {
            string lcSql = " update " + Tn.MajorSpecials + " set " + cIsLock + "='Y' " + " where  " + cMajorSpecialID  + "='" + pcID + "'";

            return poConn.ExcuteSqlTran(lcSql);
        }
    }
    #endregion

    #region

    public class MajorSpecials_Qry : rsQuery
    {
        public Boolean IsLock
        {
            get { return GetBool(MajorSpecials_info.cIsLock); }
            //    set { SetField(MajorSpecials_info.cIsLock, value); } 
        }

        public String MajorSpecialID
        {
            get { return GetString(MajorSpecials_info.cMajorSpecialID); }
            //    set { SetField(MajorSpecials_info.cMajorSpecialID, value); } 
        }

        public String MajorSpecialName
        {
            get { return GetString(MajorSpecials_info.cMajorSpecialName); }
            //    set { SetField(MajorSpecials_info.cMajorSpecialName, value); } 
        }

        public Int64 SortNumber
        {
            get { return GetInt(MajorSpecials_info.cSortNumber); }
            //    set { SetField(MajorSpecials_info.cSortNumber, value); } 
        }

        public String SpecialsID
        {
            get { return GetString(MajorSpecials_info.cSpecialsID); }
            //    set { SetField(MajorSpecials_info.cSpecialsID, value); } 
        }

        public String Toname
        {
            get { return GetString(MajorSpecials_info.cToname); }
            //    set { SetField(MajorSpecials_info.cToname, value); } 
        }

    }
    #endregion

}