rootpublic.cs

最好用的站点内容管理系统 全部源代码都有

//======================================================
//==     (c)2008 aspxcms inc by NeTCMS v1.0              ==
//==          Forum:bbs.aspxcms.com                   ==
//==         Website:www.aspxcms.com                  ==
//======================================================
using System;
using System.Data;
using System.Data.SqlClient;
using NetCMS.DALFactory;
using NetCMS.Model;
using NetCMS.Common;
using System.Text.RegularExpressions;
using System.Text;
using System.Reflection;
using NetCMS.DALProfile;
using NetCMS.Config;

namespace NetCMS.DALSQLServer
{
    public class rootPublic : DbBase, IrootPublic
    {
        /// <summary>
        /// 获得站点ID是否存在
        /// </summary>
        /// <param name="SiteID"></param>
        /// <returns></returns>
        public int getSiteID(string SiteID)
        {
            int intflg = 0;
            SqlParameter param = new SqlParameter("@SiteID", SiteID);
            string Sql = "Select id From " + Pre + "news_site Where ChannelID=@SiteID and isRecyle=0 and isLock=0";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    intflg = 1;
                }
                rdr.Clear(); rdr.Dispose();
            }
            return intflg;
        }

        /// <summary>
        /// 获取会员名称
        /// </summary>
        /// <param name="UserNum">传入的会员编号</param>
        /// <returns>返回名称</returns>
        public string getUserName(string UserNum)
        {
            string uflg = "找不到用户";
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = "Select id,UserName From " + Pre + "sys_user Where UserNum=@UserNum";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    uflg = rdr.Rows[0]["UserName"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return uflg;
        }


        /// <summary>
        /// 获取会员名称
        /// </summary>
        public int getUserName_uid(string UserNum)
        {
            int uflg = 0;
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = "Select id From " + Pre + "sys_user Where UserNum=@UserNum";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    uflg = int.Parse(rdr.Rows[0]["id"].ToString());
                }
                rdr.Clear(); rdr.Dispose();
            }
            return uflg;
        }

        /// <summary>
        /// 根据ID获取会员编号
        /// </summary>
        /// <param name="UserNum">传入的会员ID</param>
        /// <returns>返回名称</returns>
        public string getUidUserNum(int Uid)
        {
            string uflg = "找不到用户";
            SqlParameter param = new SqlParameter("@Uid", Uid);
            string Sql = "Select id,UserNum From " + Pre + "sys_user Where id=@Uid";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    uflg = rdr.Rows[0]["UserNum"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return uflg;
        }

        /// <summary>
        /// 根据用户名获得用户编号
        /// </summary>
        /// <param name="UserName"></param>
        /// <returns></returns>
        public string getUserNameUserNum(string UserName)
        {
            string uflg = "0";
            SqlParameter param = new SqlParameter("@UserName", UserName);
            string Sql = "Select UserNum From " + Pre + "sys_user Where UserName=@UserName";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    uflg = rdr.Rows[0]["UserNum"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return uflg;
        }

        /// <summary>
        /// 根据会员组ID获取编号
        /// </summary>
        /// <param name="Gid"></param>
        /// <returns></returns>
        public string getGidGroupNumber(int Gid)
        {
            string uflg = "0";
            SqlParameter param = new SqlParameter("@Gid", Gid);
            string Sql = "Select GroupNumber From " + Pre + "user_Group Where Id=@Gid";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    uflg = rdr.Rows[0]["GroupNumber"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return uflg;
        }

        /// <summary>
        /// 获取会员组名称
        /// </summary>
        /// <param name="GroupNumber">传入的会员组编号</param>
        /// <returns></returns>
        public string getGroupName(string GroupNumber)
        {
            string uflg = "不属于任何组";
            SqlParameter param = new SqlParameter("@GroupNumber", GroupNumber);
            string Sql = "Select id,GroupName From " + Pre + "user_Group Where GroupNumber=@GroupNumber";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    uflg = rdr.Rows[0]["GroupName"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return uflg;
        }
        /// <summary>
        /// 根据用户编号获得用户组编号
        /// </summary>
        /// <param name="strUserNum"></param>
        /// <returns></returns>
        public string getUserGroupNumber(string strUserNum)
        {
            string USQL = "Select UserGroupNumber From " + Pre + "sys_user Where UserNum=@UserNum and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            SqlParameter Param = new SqlParameter("@UserNum", strUserNum);
            return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, USQL, Param));
        }

        /// <summary>
        /// 根据用户组获得用户标志
        /// </summary>
        /// <param name="UserNum"></param>
        /// <returns></returns>
        public string getGroupNameFlag(string UserNum)
        {
            string uflg = string.Empty;
            SqlParameter Param = new SqlParameter("@UserNum", UserNum);
            string USQL = "Select UserGroupNumber From " + Pre + "sys_user Where UserNum=@UserNum and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            DataTable dt = DbHelper.ExecuteTable(CommandType.Text, USQL, Param);
            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    string Sql = "Select UserFlag From " + Pre + "user_Group Where GroupNumber='" + dt.Rows[0]["UserGroupNumber"].ToString() + "'";
                    DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
                    if (rdr != null)
                    {
                        if (rdr.Rows.Count > 0)
                        {
                            uflg = rdr.Rows[0]["UserFlag"].ToString();
                        }
                    }
                    rdr.Dispose();
                }
                dt.Clear(); dt.Dispose();
            }
            return uflg;
        }

        /// <summary>
        /// 通过用户编号获取会员组名称
        /// </summary>
        /// <param name="UserNum">传入的会员编号</param>
        /// <returns></returns>
        public string getUserGroupName(string UserNum)
        {
            string uflg = "找不到用户";
            SqlParameter Param = new SqlParameter("@UserNum", UserNum);
            string Sql = "Select id,UserGroupNumber From " + Pre + "sys_User Where UserNum=@UserNum";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, Param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    string SQL1 = "Select id,GroupName From " + Pre + "user_Group Where GroupNumber='" + rdr.Rows[0]["UserGroupNumber"].ToString() + "'";
                    DataTable gdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
                    if (gdr != null)
                    {
                        if (gdr.Rows.Count > 0) { uflg = gdr.Rows[0]["GroupName"].ToString(); }
                        else { uflg = "找不到会员组"; }
                        gdr.Dispose();
                    }
                    else { uflg = "找不到会员组"; }
                }
                else { uflg = "找不到会员组"; }
            }
            rdr.Dispose();
            return uflg;
        }
        /// <summary>
        /// 通过用户猪编号获取会员组ID
        /// </summary>
        /// <param name="UserNum">传入的会员编号</param>
        /// <returns></returns>
        public string getIDGroupNumber(string GroupNumber)
        {
            string uflg = "0";
            SqlParameter GroupNumberParam = new SqlParameter("@GroupNumber", GroupNumber);
            string Sql = "Select id From " + Pre + "user_Group Where GroupNumber=@GroupNumber and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, GroupNumberParam);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    uflg = rdr.Rows[0]["Id"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return uflg;
        }


        /// <summary>
        /// 得到G币名称
        /// </summary>
        /// <returns></returns>
        public string getgPointName()
        {
            string gflg = "NetCMS币";
            string Sql = "Select GpointName From " + Pre + "sys_PramUser";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["GpointName"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 得到站点名称
        /// </summary>
        public string siteName()
        {
            string gflg = "NetCMS网站内容管理系统";
            string Sql = "Select SiteName From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["SiteName"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 得到前台版权信息
        /// </summary>
        /// <returns></returns>
        public string siteCopyRight()
        {
            string gflg = "(c)2008 aspxcms Inc. by NetCMS 1.0";
            string Sql = "Select CopyRight From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["CopyRight"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 得到站点域名
        /// </summary>
        /// <returns></returns>
        public string sitedomain()
        {
            string Sql = "Select SiteDomain From " + Pre + "sys_param";
            object obj = DbHelper.ExecuteScalar(CommandType.Text, Sql, null);
            if (obj != null && obj != DBNull.Value)
            {
                return obj.ToString();
            }
            else
            {
                return string.Empty;
            }
        }


        /// <summary>
        /// 得到主页模板
        /// </summary>
        /// <returns></returns>
        public string indexTempletfile()
        {
            string gflg = "/{@dirTemplet}/index.html|index.html";
            string Sql = "Select IndexTemplet,IndexFileName From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["IndexTemplet"].ToString() + "|" + rdr.Rows[0]["IndexFileName"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }



        /// <summary>
        /// 得到其他模板（栏目，内容）
        /// </summary>
        /// <returns></returns>
        public string allTemplet()
        {
            string gflg = "/{@dirTemplet}/Content/news.html|/{@dirTemplet}/Content/class.html|/{@dirTemplet}/Content/special.html|html";
            string Sql = "Select ReadNewsTemplet,ClassListTemplet,SpecialTemplet,FileEXName From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["ReadNewsTemplet"].ToString() + "|" + rdr.Rows[0]["ClassListTemplet"].ToString() + "|" + rdr.Rows[0]["SpecialTemplet"].ToString() + "|" + rdr.Rows[0]["FileEXName"].ToString();
                }