Gsmarket/Sources/GS-MarketMG-2018/SysDataLibs/TableClass/Stalls_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      Stalls
    public class Stalls_info : ITableInfo
    {
        #region      Stalls表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： (N'N');
        /// 描述： 是否逻辑删除;
        /// </summary>
        public const string cIsLock = "IsLock";

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

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

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

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

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

        #endregion
        public Stalls_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _IsLock = UtilStr.StrFromObj(poRow[cIsLock]);
            _MarketID = UtilStr.StrFromObj(poRow[cMarketID]);
            _Name = UtilStr.StrFromObj(poRow[cName]);
            _ShortName = UtilStr.StrFromObj(poRow[cShortName]);
            _StallID = UtilStr.StrFromObj(poRow[cStallID]);
            _StallNo = UtilStr.StrFromObj(poRow[cStallNo]);
        }

        public Stalls_info(string pcStallID, DBConnSql poDBConn)
        {
            if (pcStallID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.Stalls + " where StallID='" + pcStallID + "'";
                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 _MarketID = "";
        public string MarketID
        {
            get { return _MarketID; }
            set { _MarketID = value; }
        }

        private string _Name = "";
        public string Name
        {
            get { return _Name; }
            set { _Name = value; }
        }

        private string _ShortName = "";
        public string ShortName
        {
            get { return _ShortName; }
            set { _ShortName = value; }
        }

        private string _StallID = "";
        public string StallID
        {
            get { return _StallID; }
            set { _StallID = value; }
        }

        private string _StallNo = "";
        public string StallNo
        {
            get { return _StallNo; }
            set { _StallNo = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("StallsRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cIsLock, IsLock);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketID, MarketID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cName, Name);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cShortName, ShortName);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cStallID, StallID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cStallNo, StallNo);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.Stalls + " " +
                        " (" + cIsLock + "," + cMarketID + "," + cName + "," + cShortName + "," + cStallNo + ") " +
                        " values ('" + _IsLock + "','" + _MarketID + "','" + _Name + "','" + _ShortName + "','" + _StallNo + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.Stalls + " " +
                        " set " + cIsLock + "='" + _IsLock + "'," + cMarketID + "='" + _MarketID + "'," + cName + "='" + _Name + "'," + cShortName + "='" + _ShortName + "'," + cStallNo + "='" + _StallNo + "' " +
                        " where  " + cStallID + "=" + _StallID + "";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.Stalls + " where " + cStallID + "=" + _StallID + "";
        }

        public static string GetStallIdListBySellerId(string pcSellerId, UserSession poSession)
        {
            string lcRetVal = "";
            if (poSession.DBConn != null && poSession.DBConn.IsOpened)
            {
                string lcSql = " select " + SellerHasStall_info.cStallID + " from  " + Tn.SellerHasStall + "  Where  " + SellerHasStall_info.cSellerID + " ='" + pcSellerId + "'";
                rsQuery loQuery = poSession.DBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
                {
                    loQuery.MoveFirst();
                    for (int i = 0; i < loQuery.RecCount; i++)
                    {
                        lcRetVal += (lcRetVal == "" ? "" : ",") + loQuery.GetString(SellerHasStall_info.cStallID);
                        loQuery.MoveNext();
                    }
                }
            }
            return lcRetVal;
        }

        public static string GetSellerIdListByStallId(string pcStallId, UserSession poSession)
        {
            string lcRetVal = "";

            if (poSession.DBConn != null && poSession.DBConn.IsOpened)
            {
                string lcSql = " select " + SellerHasStall_info.cSellerID + " from  " + Tn.SellerHasStall + "  Where  " + SellerHasStall_info.cStallID + " ='" + pcStallId + "'";
                rsQuery loQuery = poSession.DBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
                {
                    for (int i = 0; i < loQuery.RecCount; i++)
                    {
                        lcRetVal += (lcRetVal == "" ? "" : ",") + loQuery.GetString(SellerHasStall_info.cSellerID);
                        loQuery.MoveNext();
                    }
                }
            }
            return lcRetVal;
        }

        public static rsQuery GetAllStallsByMarketId(string pcMarketId, DBConnSql poDBConn)
        {
            string lcSql = " select * from " + Tn.Stalls + "  where  " + Stalls_info.cMarketID + " = '" + pcMarketId + "' ";
            return poDBConn.OpenQuery(lcSql);
        }

        public static rsQuery GetStallsByStallIdList(string pcStallIdList, DBConnSql poDBConn)
        {
            string lcSql = " select * from " + Tn.Stalls + "  where  ";
            if (pcStallIdList.Trim().Length > 0)
            {
                lcSql += "  StallID in (" + pcStallIdList + ")";
            }
            else
            {
                lcSql += "  1=2 ";
            }

            return poDBConn.OpenQuery(lcSql);
        }
    }
    #endregion

    #region

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

        public String MarketID
        {
            get { return GetString(Stalls_info.cMarketID); }
            //    set { SetField(Stalls_info.cMarketID, value); } 
        }

        public String Name
        {
            get { return GetString(Stalls_info.cName); }
            //    set { SetField(Stalls_info.cName, value); } 
        }

        public String ShortName
        {
            get { return GetString(Stalls_info.cShortName); }
            //    set { SetField(Stalls_info.cShortName, value); } 
        }

        public Int64 StallID
        {
            get { return GetInt(Stalls_info.cStallID); }
            //    set { SetField(Stalls_info.cStallID, value); } 
        }

        public String StallNo
        {
            get { return GetString(Stalls_info.cStallNo); }
            //    set { SetField(Stalls_info.cStallNo, value); } 
        }

    }
    #endregion

}