Gsmarket/Sources/GS-MarketMG-2018/SysDataLibs/TableClass/UserHasMarket_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      UserHasMarket
    public partial class UserHasMarket_info : ITableInfo
    {
        #region      UserHasMarket表 字段信息
        /// <summary> 
        /// 为关键字段： Y --- PrimaryKey;
        /// 自动增长： N;
        /// 数据类型： char;
        /// 数据长度： 10;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 市场编号;
        /// </summary>
        public const string cMarketID = "MarketID";

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

        #endregion
        public UserHasMarket_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _MarketID = UtilStr.StrFromObj(poRow[cMarketID]);
            _UserID = UtilStr.StrFromObj(poRow[cUserID]);
        }

        public UserHasMarket_info(string pcMarketID, string pcUserID, DBConnSql poDBConn)
        {
            if (pcMarketID.Trim().Length > 0 && pcUserID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.UserHasMarket + " where MarketID='" + pcMarketID + "' and UserID='" + pcUserID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _MarketID = "";
        public string MarketID
        {
            get { return _MarketID; }
            set { _MarketID = value; }
        }

        private string _UserID = "";
        public string UserID
        {
            get { return _UserID; }
            set { _UserID = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("UserHasMarketRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cMarketID, MarketID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUserID, UserID);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.UserHasMarket + " " +
                        " (" + cMarketID + "," + cUserID + ") " +
                        " values ('" + _MarketID + "','" + _UserID + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.UserHasMarket + " " +
                    " set  " +
                    " where  " + cMarketID + "='" + _MarketID + "' and " + cUserID + "='" + _UserID + "'";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.UserHasMarket + " where " + cMarketID + "='" + _MarketID + "' and " + cUserID + "='" + _UserID + "'";
        }

        public static string GetMarketIdsByUserId(string pcUserId, DBConnSql poConn)
        {
            string lcRetVal = "";
            string lcSql = "select * from UserHasMarket where UserID ='" + pcUserId + "'";
            rsQuery loQuery = poConn.OpenQuery(lcSql);
            if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
            {
                loQuery.MoveFirst();
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    lcRetVal += (lcRetVal == "" ? "" : ",") + "'" + loQuery.GetString("MarketID") + "'";
                    loQuery.MoveNext();
                }
            }
            return lcRetVal;
        }

        public static bool UpdateMarketsOfUser(string pcUserId, string pcMarketList, DBConnSql poConn)
        {
            bool lbRetVal = false;
            string lcSql = " Delete UserHasMarket where " + UserHasMarket_info.cUserID + "='" + pcUserId + "'   \r\n ";
            if (pcMarketList.Trim().Length > 0)
            {

                Array loArr = UtilStr.StrToArrayEx(pcMarketList, ",");
                if (loArr != null && loArr.Length > 0)
                {
                    foreach (string lcMarketId in loArr)
                    {
                        string MarketId = UtilStr.FormatStr(lcMarketId);
                        if (MarketId.Trim().Length > 0)
                            lcSql += " insert into UserHasMarket (MarketID,UserID) values ('" + MarketId + "','" + pcUserId + "')  \r\n ";
                    }
                }
            }
            if (poConn != null)
            {
                lbRetVal = poConn.ExcuteSqlTran(lcSql);
            }
            return lbRetVal;
        }

        public static string GetUserListByMarketId(string pcMarketId, DBConnSql poDBConn)
        {
            string lcRetVal = "";
            string lcSql = " select * from  UserHasMarket where  MarketID=" + pcMarketId;
            rsQuery loQuery = poDBConn.OpenQuery(lcSql);
            if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
            {
                loQuery.MoveFirst();
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    lcRetVal += (lcRetVal == "" ? "" : ",") + "'" + loQuery.GetString("UserID") + "'";
                    loQuery.MoveNext();
                }
            }

            return lcRetVal;
        }
    }
    #endregion

    #region

    public class UserHasMarket_Qry : rsQuery
    {
        public String MarketID
        {
            get { return GetString(UserHasMarket_info.cMarketID); }
            //    set { SetField(UserHasMarket_info.cMarketID, value); } 
        }

        public String UserID
        {
            get { return GetString(UserHasMarket_info.cUserID); }
            //    set { SetField(UserHasMarket_info.cUserID, value); } 
        }

    }
    #endregion

}