stat.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 Stat : DbBase, IStat
    {
        string isDataBase = NetCMS.Config.UIConfig.indeData;
      
        public DataTable sel()
        {
            string Sql = "select * from " + Pre + "stat_Param";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            return rdr;
        }
        public string sel_statInfoById(string id)
        {
            SqlParameter param = new SqlParameter("@id", id);
            string Sql = "Select classname From " + Pre + "stat_class where statid=@id and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
        }
        public bool del_statSql(string ID,int flag)
        {
            #region
            SqlParameter param = new SqlParameter("@ID", ID);
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Delete From " + Pre + "stat_class where statid=@ID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 1)
            {
                Sql = "Delete From " + Pre + "stat_Info where classid = @ID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 2)
            {
                Sql = "Delete From " + Pre + "stat_Content where classid = @ID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            int i = DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            if (i == 0)
            {
                return false;
            }
            return true;
            #endregion
        }
        public void Str_InSql(NetCMS.Model.StatParamInfo sp)
        {
            string Sql = "Update " + Pre + "stat_Param Set SystemName=@Str_SystemName,SystemNameE=@Str_SystemNameE,ipCheck=@Str_ipCheck,ipTime=@Str_ipTime,isOnlinestat=@Str_isOnlinestat,pageNum=@Str_pageNum,cookies=@Str_cookies,pointNum=@Str_pointNum,SiteID=@SiteID";
            SqlParameter[] parm = GetStatParamInfo(sp);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }

        private SqlParameter[] GetStatParamInfo(NetCMS.Model.StatParamInfo sp)
        {
            SqlParameter[] parm = new SqlParameter[9];
            parm[0] = new SqlParameter("@Str_SystemName", SqlDbType.NVarChar, 100);
            parm[0].Value = sp.SystemName;
            parm[1] = new SqlParameter("@Str_SystemNameE", SqlDbType.NVarChar, 150);
            parm[1].Value = sp.SystemNameE;
            parm[2] = new SqlParameter("@Str_ipCheck", SqlDbType.TinyInt, 1);
            parm[2].Value = sp.ipCheck;
            parm[3] = new SqlParameter("@Str_ipTime", SqlDbType.Int, 4);
            parm[3].Value = sp.ipTime;
            parm[4] = new SqlParameter("@Str_isOnlinestat", SqlDbType.TinyInt, 1);
            parm[4].Value = sp.isOnlinestat;
            parm[5] = new SqlParameter("@Str_pageNum", SqlDbType.Int, 4);
            parm[5].Value = sp.pageNum;
            parm[6] = new SqlParameter("@Str_cookies", SqlDbType.NVarChar, 30);
            parm[6].Value = sp.cookies;
            parm[7] = new SqlParameter("@Str_pointNum", SqlDbType.Int, 4);
            parm[7].Value = sp.pointNum;
            parm[8] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
            parm[8].Value = sp.SiteID;
            return parm;
        }
        public int Stat_Sql()
        {
            int intnum = 20;
            string Sql = "Select pageNum From " + Pre + "stat_Param where SiteID='" + NetCMS.Global.Current.SiteID + "'";//取得参数设置中的每页显示数
            DataTable dt = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    intnum = int.Parse(dt.Rows[0]["pageNum"].ToString());
                }
                dt.Clear(); dt.Dispose();
            }
            return intnum;
        }
        public void del_statInfoStr(string CheckboxArray,int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Delete From " + Pre + "stat_class where statid in ('" + CheckboxArray + "') and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 1)
            {
                Sql = "Delete From " + Pre + "stat_Info where classid in ('" + CheckboxArray + "') and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 2)
            {
                Sql = "Delete From " + Pre + "stat_Content where classid in ('" + CheckboxArray + "') and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
            #endregion
        }
        public bool del_statInfo(int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Delete From " + Pre + "stat_class where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 1)
            {
                Sql = "Delete From " + Pre + "stat_Info where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 2)
            {
                Sql = "Delete From " + Pre + "stat_Content where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            int i = DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
            if (i == 0)
            {
                return false;
            }
            return true;
            #endregion
        }
        public int sel_statInfo(string Str_statid,int flag)
        {
            #region
            SqlParameter param = new SqlParameter("@statid", Str_statid);
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Select count(statid) From " + Pre + "stat_class where statid = @statid and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 1)
            {
                Sql = "Select count(classname) From " + Pre + "stat_class Where classname=@statid and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            return (int)DbHelper.ExecuteScalar(CommandType.Text, Sql, param);
            #endregion
        }
        public int insert_statInfo(string Str_statid, string Str_Classname, string SiteID)
        {
            string Sql = "Insert into " + Pre + "stat_class (statid,classname,SiteID) Values('" + Str_statid + "','" + Str_Classname + "','" + SiteID + "')";
            return DbHelper.ExecuteNonQuery( CommandType.Text, Sql, null);
        }
        public int Str_UpdateSql(string Str_ClassnameE, string id)
        {
            SqlParameter[] parm = new SqlParameter[2];
            parm[0] = new SqlParameter("@Str_ClassnameE", SqlDbType.NVarChar,20);
            parm[0].Value = Str_ClassnameE;
            parm[1] = new SqlParameter("@statid", SqlDbType.NVarChar, 12);
            parm[1].Value = id;
            string Sql = "Update " + Pre + "stat_class set classname=@Str_ClassnameE  where statid=@statid and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery( CommandType.Text, Sql, parm);
        }
        public int del_Stat(int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Delete From " + Pre + "stat_Info where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 1)
            {
                Sql = "Delete From " + Pre + "stat_content where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }