Gsmarket/Sources/GS-MarketMG-2018/SysDataLibs/TableClass/NameBrands_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      NameBrands
    public class NameBrands_info : ITableInfo
    {
        #region      NameBrands表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： ntext;
        /// 数据长度： 16;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 描述;
        /// </summary>
        public const string cDescription = "Description";

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： (N'Y');
        /// 描述： 是否绿色食品;
        /// </summary>
        public const string cGreenFood = "GreenFood";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： (N'Y');
        /// 描述： 是否无公害食品;
        /// </summary>
        public const string cInnocuityFood = "InnocuityFood";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： (N'N');
        /// 描述： 是否锁定;
        /// </summary>
        public const string cIsLock = "IsLock";

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

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

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

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

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 300;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 品牌持有人联系方式;
        /// </summary>
        public const string cNBByPersonLinks = "NBByPersonLinks";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： (N'Y');
        /// 描述： 是否有机食品;
        /// </summary>
        public const string cOrganicFood = "OrganicFood";

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： smalldatetime;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 创建时间;
        /// </summary>
        public const string cTimeCreated = "TimeCreated";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： smalldatetime;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 修改时间;
        /// </summary>
        public const string cTimeLastMod = "TimeLastMod";

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 30;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 最后一次更改人;
        /// </summary>
        public const string cUserIDLastMod = "UserIDLastMod";

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

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

        #endregion
        public NameBrands_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _Description = UtilStr.StrFromObj(poRow[cDescription]);
            _FoodName = UtilStr.StrFromObj(poRow[cFoodName]);
            _GreenFood = UtilStr.StrFromObj(poRow[cGreenFood]);
            _InnocuityFood = UtilStr.StrFromObj(poRow[cInnocuityFood]);
            _IsLock = UtilStr.StrFromObj(poRow[cIsLock]);
            _MarketId = UtilStr.StrFromObj(poRow[cMarketId]);
            _MarketManager = UtilStr.StrFromObj(poRow[cMarketManager]);
            _NameBrandID = UtilStr.StrFromObj(poRow[cNameBrandID]);
            _NameBrandName = UtilStr.StrFromObj(poRow[cNameBrandName]);
            _NBByPerson = UtilStr.StrFromObj(poRow[cNBByPerson]);
            _NBByPersonLinks = UtilStr.StrFromObj(poRow[cNBByPersonLinks]);
            _OrganicFood = UtilStr.StrFromObj(poRow[cOrganicFood]);
            _pinpaizhengshu = UtilStr.StrFromObj(poRow[cpinpaizhengshu]);
            _TimeCreated = UtilStr.StrFromObj(poRow[cTimeCreated]);
            _TimeLastMod = UtilStr.StrFromObj(poRow[cTimeLastMod]);
            _TradeTypeID = UtilStr.StrFromObj(poRow[cTradeTypeID]);
            _UserIDLastMod = UtilStr.StrFromObj(poRow[cUserIDLastMod]);
            _weishengxuke = UtilStr.StrFromObj(poRow[cweishengxuke]);
            _yjzhizhao = UtilStr.StrFromObj(poRow[cyjzhizhao]);
        }

        public NameBrands_info(string pcNameBrandID, DBConnSql poDBConn)
        {
            if (pcNameBrandID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.NameBrands + " where NameBrandID='" + pcNameBrandID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _Description = "";
        public string Description
        {
            get { return _Description; }
            set { _Description = value; }
        }

        private string _FoodName = "";
        public string FoodName
        {
            get { return _FoodName; }
            set { _FoodName = value; }
        }

        private string _GreenFood = "";
        public string GreenFood
        {
            get { return _GreenFood; }
            set { _GreenFood = value; }
        }

        private string _InnocuityFood = "";
        public string InnocuityFood
        {
            get { return _InnocuityFood; }
            set { _InnocuityFood = value; }
        }

        private string _IsLock = "";
        public string IsLock
        {
            get { return _IsLock; }
            set { _IsLock = value; }
        }

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

        private string _MarketManager = "";
        public string MarketManager
        {
            get { return _MarketManager; }
            set { _MarketManager = value; }
        }

        private string _NameBrandID = "";
        public string NameBrandID
        {
            get { return _NameBrandID; }
            set { _NameBrandID = value; }
        }

        private string _NameBrandName = "";
        public string NameBrandName
        {
            get { return _NameBrandName; }
            set { _NameBrandName = value; }
        }

        private string _NBByPerson = "";
        public string NBByPerson
        {
            get { return _NBByPerson; }
            set { _NBByPerson = value; }
        }

        private string _NBByPersonLinks = "";
        public string NBByPersonLinks
        {
            get { return _NBByPersonLinks; }
            set { _NBByPersonLinks = value; }
        }

        private string _OrganicFood = "";
        public string OrganicFood
        {
            get { return _OrganicFood; }
            set { _OrganicFood = value; }
        }

        private string _pinpaizhengshu = "";
        public string pinpaizhengshu
        {
            get { return _pinpaizhengshu; }
            set { _pinpaizhengshu = value; }
        }

        private string _TimeCreated = "";
        public string TimeCreated
        {
            get { return _TimeCreated; }
            set { _TimeCreated = value; }
        }

        private string _TimeLastMod = "";
        public string TimeLastMod
        {
            get { return _TimeLastMod; }
            set { _TimeLastMod = value; }
        }

        private string _TradeTypeID = "";
        public string TradeTypeID
        {
            get { return _TradeTypeID; }
            set { _TradeTypeID = value; }
        }

        private string _UserIDLastMod = "";
        public string UserIDLastMod
        {
            get { return _UserIDLastMod; }
            set { _UserIDLastMod = value; }
        }

        private string _weishengxuke = "";
        public string weishengxuke
        {
            get { return _weishengxuke; }
            set { _weishengxuke = value; }
        }

        private string _yjzhizhao = "";
        public string yjzhizhao
        {
            get { return _yjzhizhao; }
            set { _yjzhizhao = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("NameBrandsRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cDescription, Description);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cFoodName, FoodName);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cGreenFood, GreenFood);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cInnocuityFood, InnocuityFood);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cIsLock, IsLock);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketId, MarketId);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketManager, MarketManager);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cNameBrandID, NameBrandID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cNameBrandName, NameBrandName);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cNBByPerson, NBByPerson);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cNBByPersonLinks, NBByPersonLinks);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cOrganicFood, OrganicFood);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cpinpaizhengshu, pinpaizhengshu);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTimeCreated, TimeCreated);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTimeLastMod, TimeLastMod);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTradeTypeID, TradeTypeID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUserIDLastMod, UserIDLastMod);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cweishengxuke, weishengxuke);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cyjzhizhao, yjzhizhao);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.NameBrands + " " +
                            " (" + cDescription + "," + cFoodName + "," + cGreenFood + "," + cInnocuityFood + "," + cIsLock + "," + cMarketId + "," + cMarketManager + "," + cNameBrandName + "," + cNBByPerson + "," + cNBByPersonLinks + "," + cOrganicFood + "," + cpinpaizhengshu + "," + cTimeCreated + "," + cTimeLastMod + "," + cTradeTypeID + "," + cUserIDLastMod + "," + cweishengxuke + "," + cyjzhizhao + ") " +
                            " values ('" + _Description + "','" + _FoodName + "','" + _GreenFood + "','" + _InnocuityFood + "','" + _IsLock + "','" + _MarketId + "','" + _MarketManager + "','" + _NameBrandName + "','" + _NBByPerson + "','" + _NBByPersonLinks + "','" + _OrganicFood + "','" + _pinpaizhengshu + "','" + _TimeCreated + "','" + _TimeLastMod + "'," + _TradeTypeID + ",'" + _UserIDLastMod + "','" + _weishengxuke + "','" + _yjzhizhao + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.NameBrands + " " +
                        " set " + cDescription + "='" + _Description + "'," + cFoodName + "='" + _FoodName + "'," + cGreenFood + "='" + _GreenFood + "'," + cInnocuityFood + "='" + _InnocuityFood + "'," + cIsLock + "='" + _IsLock + "'," + cMarketId + "='" + _MarketId + "'," + cMarketManager + "='" + _MarketManager + "'," + cNameBrandName + "='" + _NameBrandName + "'," + cNBByPerson + "='" + _NBByPerson + "'," + cNBByPersonLinks + "='" + _NBByPersonLinks + "'," + cOrganicFood + "='" + _OrganicFood + "'," + cpinpaizhengshu + "='" + _pinpaizhengshu + "'," + cTimeCreated + "='" + _TimeCreated + "'," + cTimeLastMod + "='" + _TimeLastMod + "'," + cTradeTypeID + "=" + _TradeTypeID + "," + cUserIDLastMod + "='" + _UserIDLastMod + "'," + cweishengxuke + "='" + _weishengxuke + "'," + cyjzhizhao + "='" + _yjzhizhao + "' " +
                        " where  " + cNameBrandID + "=" + _NameBrandID + "";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.NameBrands + " where " + cNameBrandID + "=" + _NameBrandID + "";
        }

        public static bool DeleteByIDs(string pcDeleteLine, DBConnSql poDbConn)
        {
            if (poDbConn != null && poDbConn.IsOpened)
            {
                return poDbConn.ExcuteSqlTran(" Delete " + Tn.NameBrands + " where " + cNameBrandID + " in ( " + pcDeleteLine + " ) ");
            }
            return false;
        }
    }
    #endregion

    #region

    public class NameBrands_Qry : rsQuery
    {
        public String Description
        {
            get { return GetString(NameBrands_info.cDescription); }
            //    set { SetField(NameBrands_info.cDescription, value); } 
        }

        public String FoodName
        {
            get { return GetString(NameBrands_info.cFoodName); }
            //    set { SetField(NameBrands_info.cFoodName, value); } 
        }

        public Boolean GreenFood
        {
            get { return GetBool(NameBrands_info.cGreenFood); }
            //    set { SetField(NameBrands_info.cGreenFood, value); } 
        }

        public Boolean InnocuityFood
        {
            get { return GetBool(NameBrands_info.cInnocuityFood); }
            //    set { SetField(NameBrands_info.cInnocuityFood, value); } 
        }

        public Boolean IsLock
        {
            get { return GetBool(NameBrands_info.cIsLock); }
            //    set { SetField(NameBrands_info.cIsLock, value); } 
        }

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

        public String MarketManager
        {
            get { return GetString(NameBrands_info.cMarketManager); }
            //    set { SetField(NameBrands_info.cMarketManager, value); } 
        }

        public Int64 NameBrandID
        {
            get { return GetInt(NameBrands_info.cNameBrandID); }
            //    set { SetField(NameBrands_info.cNameBrandID, value); } 
        }

        public String NameBrandName
        {
            get { return GetString(NameBrands_info.cNameBrandName); }
            //    set { SetField(NameBrands_info.cNameBrandName, value); } 
        }

        public String NBByPerson
        {
            get { return GetString(NameBrands_info.cNBByPerson); }
            //    set { SetField(NameBrands_info.cNBByPerson, value); } 
        }

        public String NBByPersonLinks
        {
            get { return GetString(NameBrands_info.cNBByPersonLinks); }
            //    set { SetField(NameBrands_info.cNBByPersonLinks, value); } 
        }

        public Boolean OrganicFood
        {
            get { return GetBool(NameBrands_info.cOrganicFood); }
            //    set { SetField(NameBrands_info.cOrganicFood, value); } 
        }

        public String pinpaizhengshu
        {
            get { return GetString(NameBrands_info.cpinpaizhengshu); }
            //    set { SetField(NameBrands_info.cpinpaizhengshu, value); } 
        }

        public DateTime TimeCreated
        {
            get { return GetDateTime(NameBrands_info.cTimeCreated); }
            //    set { SetField(NameBrands_info.cTimeCreated, value); } 
        }

        public DateTime TimeLastMod
        {
            get { return GetDateTime(NameBrands_info.cTimeLastMod); }
            //    set { SetField(NameBrands_info.cTimeLastMod, value); } 
        }

        public Int64 TradeTypeID
        {
            get { return GetInt(NameBrands_info.cTradeTypeID); }
            //    set { SetField(NameBrands_info.cTradeTypeID, value); } 
        }

        public String UserIDLastMod
        {
            get { return GetString(NameBrands_info.cUserIDLastMod); }
            //    set { SetField(NameBrands_info.cUserIDLastMod, value); } 
        }

        public String weishengxuke
        {
            get { return GetString(NameBrands_info.cweishengxuke); }
            //    set { SetField(NameBrands_info.cweishengxuke, value); } 
        }

        public String yjzhizhao
        {
            get { return GetString(NameBrands_info.cyjzhizhao); }
            //    set { SetField(NameBrands_info.cyjzhizhao, value); } 
        }

    }
    #endregion

}