Gsmarket/Sources/GS-MarketMG-2018/SysDataLibs/TableClass/vwMarketBaseInfo_info.cs

using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
namespace SysDataLibs.TableClass
{
    #region      vwMarketBaseInfo
    public class vwMarketBaseInfo_info : ITableInfo
    {
        #region      vwMarketBaseInfo表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： float;
        /// 数据长度： 8;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： Area;
        /// </summary>
        public const string cArea = "Area";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 100;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： LinkMan;
        /// </summary>
        public const string cLinkMan = "LinkMan";

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： MktSellerCnt;
        /// </summary>
        public const string cMktSellerCnt = "MktSellerCnt";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： MktStallCnt;
        /// </summary>
        public const string cMktStallCnt = "MktStallCnt";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 400;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： Names;
        /// </summary>
        public const string cNames = "Names";

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

        /// <summary> 
        /// 为关键字段： N
        /// 自动增长： Y;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 市场类型编号;
        /// </summary>
        public const string cMarketTypeID = "MarketTypeID";

        #endregion
        public vwMarketBaseInfo_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _Area = UtilStr.StrFromObj(poRow[cArea]);
            _LinkMan = UtilStr.StrFromObj(poRow[cLinkMan]);
            _MarketId = UtilStr.StrFromObj(poRow[cMarketId]);
            _MktSellerCnt = UtilStr.StrFromObj(poRow[cMktSellerCnt]);
            _MktStallCnt = UtilStr.StrFromObj(poRow[cMktStallCnt]);
            _Names = UtilStr.StrFromObj(poRow[cNames]);
            _Telephone = UtilStr.StrFromObj(poRow[cTelephone]);
            _MarketTypeID = UtilStr.StrFromObj(poRow[cMarketTypeID]);
        }

        private string _Area = "";
        public string Area
        {
            get { return _Area; }
            set { _Area = value; }
        }

        private string _LinkMan = "";
        public string LinkMan
        {
            get { return _LinkMan; }
            set { _LinkMan = value; }
        }

        private string _MarketId = "";
        public string MarketId
        {
            get { return _MarketId; }
            set { _MarketId = value; }
        }

        private string _MktSellerCnt = "";
        public string MktSellerCnt
        {
            get { return _MktSellerCnt; }
            set { _MktSellerCnt = value; }
        }

        private string _MktStallCnt = "";
        public string MktStallCnt
        {
            get { return _MktStallCnt; }
            set { _MktStallCnt = value; }
        }

        private string _Names = "";
        public string Names
        {
            get { return _Names; }
            set { _Names = value; }
        }

        private string _Telephone = "";
        public string Telephone
        {
            get { return _Telephone; }
            set { _Telephone = value; }
        }

        private string _MarketTypeID = "";
        public string MarketTypeID
        {
            get { return _MarketTypeID; }
            set { _MarketTypeID = value; }
        } 

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("vwMarketBaseInfoRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cArea, Area);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cLinkMan, LinkMan);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketId, MarketId);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMktSellerCnt, MktSellerCnt);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMktStallCnt, MktStallCnt);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cNames, Names);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTelephone, Telephone);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketTypeID, MarketTypeID);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return "";/* " insert into " + Tn.vwMarketBaseInfo + " " +
                         " (" + cArea + "," + cLinkMan + "," + cMarketId + "," + cMktSellerCnt + "," + cMktStallCnt + "," + cNames + "," + cTelephone + ") " +
                         " values ('" + _Area + "','" + _LinkMan + "','" + _MarketId + "'," + _MktSellerCnt + "," + _MktStallCnt + ",'" + _Names + "','" + _Telephone + "') ";*/
        }

        public string UpdateSql()
        {
            return ""; /*" update " + Tn.vwMarketBaseInfo + " " +
                    " set " + cArea + "='" + _Area + "'," + cLinkMan + "='" + _LinkMan + "'," + cMarketId + "='" + _MarketId + "'," + cMktSellerCnt + "=" + _MktSellerCnt + "," + cMktStallCnt + "=" + _MktStallCnt + "," + cNames + "='" + _Names + "'," + cTelephone + "='" + _Telephone + "' " +
                    " where  ";*/
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.vwMarketBaseInfo + " where ";
        }
    }
    #endregion

    #region

    public class vwMarketBaseInfo_Qry : rsQuery
    {
        public String Area
        {
            get { return GetString(vwMarketBaseInfo_info.cArea); }
            //    set { SetField(vwMarketBaseInfo_info.cArea, value); } 
        }

        public String LinkMan
        {
            get { return GetString(vwMarketBaseInfo_info.cLinkMan); }
            //    set { SetField(vwMarketBaseInfo_info.cLinkMan, value); } 
        }

        public String MarketId
        {
            get { return GetString(vwMarketBaseInfo_info.cMarketId); }
            //    set { SetField(vwMarketBaseInfo_info.cMarketId, value); } 
        }

        public Int64 MktSellerCnt
        {
            get { return GetInt(vwMarketBaseInfo_info.cMktSellerCnt); }
            //    set { SetField(vwMarketBaseInfo_info.cMktSellerCnt, value); } 
        }

        public Int64 MktStallCnt
        {
            get { return GetInt(vwMarketBaseInfo_info.cMktStallCnt); }
            //    set { SetField(vwMarketBaseInfo_info.cMktStallCnt, value); } 
        }

        public String Names
        {
            get { return GetString(vwMarketBaseInfo_info.cNames); }
            //    set { SetField(vwMarketBaseInfo_info.cNames, value); } 
        }

        public String Telephone
        {
            get { return GetString(vwMarketBaseInfo_info.cTelephone); }
            //    set { SetField(vwMarketBaseInfo_info.cTelephone, value); } 
        }

        public Int64 MarketTypeID
        {
            get { return GetInt(MarketType_info.cMarketTypeID); }
            //    set { SetField(MarketType_info.cMarketTypeID, value); } 
        } 
    }
    #endregion

}