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

using SysBaseLibs;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SysDataLibs.TableClass
{
    public partial  class UserHasMarket_info
    {
        public static Markets_info GetOneMarketIdsByUserId(string pcUserId, DBConnSql poConn)
        {
            Markets_info lcRetVal = null;
            string lcSql = "select * from UserHasMarket where UserID ='" + pcUserId + "'";
            rsQuery loQuery = poConn.OpenQuery(lcSql);
            if (loQuery != null && loQuery.IsOpened && loQuery.RecCount ==1)
            {
                loQuery.MoveFirst();
                lcRetVal = new Markets_info(loQuery.GetString("MarketID"), poConn);
            }
            return lcRetVal; 
        }
    }
}