rootpublic.cs

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

                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 得到生成方式
        /// </summary>
        /// <returns></returns>
        public int ReadType()
        {
            int gflg = 0;
            string Sql = "Select ReadType From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = int.Parse(rdr.Rows[0]["ReadType"].ToString());
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 得到站点Email
        /// </summary>
        /// <returns></returns>
        public string SiteEmail()
        {
            string gflg = "";
            string Sql = "Select Email From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["Email"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 得到连接方式
        /// </summary>
        /// <returns></returns>
        public int LinkType()
        {
            int gflg = 0;
            string Sql = "Select LinkType From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = int.Parse(rdr.Rows[0]["LinkType"].ToString());
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 获取审核机制
        /// </summary>
        /// <returns></returns>
        public int CheckInt()
        {
            int gflg = 0;
            string Sql = "Select CheckInt From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = int.Parse(rdr.Rows[0]["CheckInt"].ToString());
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }


        public int CheckNewsTitle()
        {
            int gflg = 0;
            string Sql = "Select CheckNewsTitle From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = int.Parse(rdr.Rows[0]["CheckNewsTitle"].ToString());
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 得到会员所在组的折扣率
        /// </summary>
        /// <param name="UserNum"></param>
        /// <returns></returns>
        public double getDiscount(string UserNum)
        {
            double discout = 1;
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = "Select 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 SQL_1 = "Select Discount from " + Pre + "user_Group where GroupNumber='" + rdr.Rows[0]["UserGroupNumber"] + "'";
                    DataTable dt = DbHelper.ExecuteTable(CommandType.Text, SQL_1, null);
                    if (dt != null)
                    {
                        if (dt.Rows.Count > 0)
                        {
                            discout = double.Parse(dt.Rows[0]["Discount"].ToString());
                        }
                        dt.Clear(); dt.Dispose();
                    }
                }
                rdr.Clear(); rdr.Dispose();
            }
            return discout;
        }


        public DataTable getWaterInfo()
        {
            string Sql = "Select PrintWord,Printfontsize,Printfontfamily,Printfontcolor,PrintBTF,PintPicURL,PrintPicsize,PintPictrans,PrintPosition From " + Pre + "sys_parmPrint";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            return rdr;
        }


        /// <summary>
        /// 得到签名
        /// </summary>
        /// <param name="UserNum"></param>
        /// <returns></returns>
        public string getUserChar(string UserNum)
        {
            string _STR = "";
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = "Select Userinfo From " + Pre + "sys_user where UserNum=@UserNum";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    _STR = rdr.Rows[0]["Userinfo"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return _STR;
        }

        /// <summary>
        /// 获取栏目保存路径
        /// </summary>
        /// <returns></returns>
        public string SaveClassFilePath(string siteid)
        {
            string gflg = "/html";
            if (siteid == "0")
            {
                string Sql = "Select SaveClassFilePath From " + Pre + "sys_param";
                DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
                if (rdr != null && rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["SaveClassFilePath"].ToString();
                    rdr.Clear(); rdr.Dispose();
                }
            }
            else
            {
                SqlParameter param = new SqlParameter("@siteid", siteid);
                string sqls = "select SaveDirPath,EName from " + Pre + "news_site where ChannelID=@siteid";
                DataTable rdrs = DbHelper.ExecuteTable(CommandType.Text, sqls, param);
                if (rdrs != null && rdrs.Rows.Count > 0)
                {
                    gflg = rdrs.Rows[0]["SaveDirPath"].ToString() + "/" + rdrs.Rows[0]["EName"].ToString() + "/" + NetCMS.Config.UIConfig.dirHtml;
                    rdrs.Clear(); rdrs.Dispose();
                }
            }
            return gflg;
        }

        /// <summary>
        /// 获取索引页规则
        /// </summary>
        /// <returns></returns>
        public string SaveIndexPage()
        {
            string gflg = "{@year04}/{@month}-{@day}";
            string Sql = "Select SaveIndexPage From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["SaveIndexPage"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 生成新闻的文件保存路径
        /// </summary>
        /// <returns></returns>
        public string SaveNewsDirPath()
        {
            string gflg = "{@year04}/{@month}-{@day}";
            string Sql = "Select SaveNewsDirPath From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["SaveNewsDirPath"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 生成新闻的文件保存路径
        /// </summary>
        /// <returns></returns>
        public string SaveNewsFilePath()
        {
            string gflg = "{@year04}{@month}{@day}{@hour}{@minute}{@second}";
            string Sql = "Select SaveNewsFilePath From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["SaveNewsFilePath"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 得到会员默认注册会员组
        /// </summary>
        /// <returns></returns>
        public string GetRegGroupNumber()
        {
            string gflg = "0";
            string Sql = "Select RegGroupNumber From " + Pre + "sys_PramUser";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["RegGroupNumber"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 图片域名服务器
        /// </summary>
        /// <returns></returns>
        public string PicServerDomain()
        {
            string gflg = "";
            string Sql = "Select PicServerDomain From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["PicServerDomain"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 是否独立图片域名服务器
        /// </summary>
        /// <returns></returns>
        public int PicServerTF()
        {
            int gflg = 0;
            string Sql = "Select PicServerTF From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = int.Parse(rdr.Rows[0]["PicServerTF"].ToString());
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 是否允许投稿
        /// </summary>
        /// <returns></returns>
        public int ConstrTF()
        {
            int gflg = 0;
            string Sql = "Select ConstrTF From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = int.Parse(rdr.Rows[0]["ConstrTF"].ToString());
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 得到上传的扩展名
        /// </summary>
        /// <returns></returns>
        public string upfileType()
        {
            string gflg = "jpg,gif,bmp,ico,rar,zip,jpeg,png,swf|500";
            string Sql = "Select UpfilesType,UpFilesSize From " + Pre + "sys_param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    gflg = rdr.Rows[0]["UpfilesType"].ToString() + "|" + rdr.Rows[0]["UpFilesSize"].ToString();
                }
                rdr.Clear(); rdr.Dispose();
            }
            return gflg;
        }

        /// <summary>
        /// 保存日志入库及日志文件
        /// </summary>
        /// <param name="num">标识，0表示写入数据库，1表示写入数据同时写入日志文件</param>
        /// <param name="_num">用户标志，0表示用户，1表示管理员</param>
        /// <param name="UserNum">传入的用户编号</param>
        /// <param name="Title">日志标题</param>
        /// <param name="Content">日志描述</param>
        public void SaveUserAdminLogs(int num, int _num, string UserNum, string Title, string Content)
        {
            using (SqlConnection cn = new SqlConnection(DBConfig.CmsConString))
            {
                cn.Open();
                SaveUserAdminLogs(cn, num, _num, UserNum, Title, Content);
            }
        }
        /// <summary>
        /// 保存日志入库及日志文件
        /// </summary>
        /// <param name="cn">已打开的数据库连接对象</param>
        /// <param name="num">标识，0表示写入数据库，1表示写入数据同时写入日志文件</param>
        /// <param name="_num">用户标志，0表示用户，1表示管理员</param>
        /// <param name="UserNum">传入的用户编号</param>
        /// <param name="Title">日志标题</param>
        /// <param name="Content">日志描述</param>
        public void SaveUserAdminLogs(SqlConnection cn, int num, int _num, string UserNum, string Title, string Content)
        {
            SqlParameter[] param = new SqlParameter[5];
            param[0] = new SqlParameter("@num", SqlDbType.Int, 4);