psframe.cs

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

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

namespace NetCMS.DALSQLServer
{
    public class Psframe : DbBase, IPsframe
    {
        /// <summary>
        /// 删除PSF到回收站
        /// </summary>
        /// <param name="TableName"></param>
        public void Del_PSF(string Psfid)
        {
            string Sql = "Update " + Pre + "sys_PSF Set isRecyle=1 where psfID='" + Psfid.ToString() + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 删除所有PSF到回收站
        /// </summary>
        /// <param name="TableName"></param>
        public void DelAll_PSF()
        {
            string Sql = "Update " + Pre + "sys_PSF Set isRecyle=1 where 1=1 and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 插入psf
        /// </summary>
        /// <param name="uc2"></param>
        public void InsertPSF(NetCMS.Model.PSF uc)
        {
            string Sql = "insert into " + Pre + "sys_PSF (";
            Sql += "psfID,psfName,LocalDir,RemoteDir,isSub,isRecyle,CreatTime,SiteID,isAll";
            Sql += ") values (";
            Sql += "@psfID,@psfName,@LocalDir,@RemoteDir,@isSub,@isRecyle,@CreatTime,@SiteID,@isAll)";
            SqlParameter[] parm = InsertPSFParameters(uc);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }

        /// <summary>
        /// 更新psf
        /// </summary>
        /// <param name="uc2"></param>
        public int UpdatePSF(NetCMS.Model.PSF uc)
        {
            string Sql = "Update " + Pre + "sys_PSF set psfName=@psfName,LocalDir=@LocalDir,RemoteDir=@RemoteDir,isSub=@isSub,isRecyle=@isRecyle,isAll=@isAll where psfID='" + uc.psfID.ToString() + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            SqlParameter[] parm = InsertPSFParameters1(uc);
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }

        /// <summary>
        /// 获取PSF构造
        /// </summary>
        /// <param name="uc1"></param>
        /// <returns></returns>
        private SqlParameter[] InsertPSFParameters(NetCMS.Model.PSF uc)
        {
            SqlParameter[] param = new SqlParameter[10];
            param[0] = new SqlParameter("@psfID", SqlDbType.NVarChar, 12);
            param[0].Value = uc.psfID;
            param[1] = new SqlParameter("@psfName", SqlDbType.NVarChar, 30);
            param[1].Value = uc.psfName;
            param[2] = new SqlParameter("@LocalDir", SqlDbType.NVarChar, 200);
            param[2].Value = uc.LocalDir;
            param[3] = new SqlParameter("@RemoteDir", SqlDbType.NVarChar, 200);
            param[3].Value = uc.RemoteDir;
            param[4] = new SqlParameter("@isAll", SqlDbType.TinyInt, 1);
            param[4].Value = uc.isAll;
            param[5] = new SqlParameter("@isSub", SqlDbType.TinyInt, 1);
            param[5].Value = uc.isSub;
            param[6] = new SqlParameter("@CreatTime", SqlDbType.DateTime, 8);
            param[6].Value = uc.CreatTime;
            param[7] = new SqlParameter("@isRecyle", SqlDbType.TinyInt, 1);
            param[7].Value = uc.isRecyle;
            param[8] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
            param[8].Value = uc.SiteID;
            param[9] = new SqlParameter("@ID", SqlDbType.Int, 4);
            param[9].Value = uc.Id;
            return param;
        }
        /// <summary>
        /// 获取PSF构造1
        /// </summary>
        /// <param name="uc1"></param>
        /// <returns></returns>
        private SqlParameter[] InsertPSFParameters1(NetCMS.Model.PSF uc)
        {
            SqlParameter[] param = new SqlParameter[7];
            param[0] = new SqlParameter("@psfName", SqlDbType.NVarChar, 30);
            param[0].Value = uc.psfName;
            param[1] = new SqlParameter("@LocalDir", SqlDbType.NVarChar, 200);
            param[1].Value = uc.LocalDir;
            param[2] = new SqlParameter("@RemoteDir", SqlDbType.NVarChar, 200);
            param[2].Value = uc.RemoteDir;
            param[3] = new SqlParameter("@isAll", SqlDbType.TinyInt, 1);
            param[3].Value = uc.isAll;
            param[4] = new SqlParameter("@isSub", SqlDbType.TinyInt, 1);
            param[4].Value = uc.isSub;
            param[5] = new SqlParameter("@isRecyle", SqlDbType.TinyInt, 1);
            param[5].Value = uc.isRecyle;
            param[6] = new SqlParameter("@psfID", SqlDbType.NVarChar, 12);
            param[6].Value = uc.psfID;
            return param;
        }

        public DataTable getTitleRecord(string psfName)
        {
            string Sql = "Select psfName From " + Pre + "sys_PSF Where psfName='" + psfName.ToString() + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            return rdr;
        }

        public int IsExitPSFID(string PSFID)
        {
            string Str = "Select psfID From " + Pre + "sys_PSF where psfID = '" + PSFID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return (int)DbHelper.ExecuteScalar(CommandType.Text, Str, null);
        }

        public DataTable getPSFParam(string psfID)
        {
            string Sql = "Select Id,psfID,psfName,LocalDir,RemoteDir,isSub,isAll,CreatTime,isRecyle,SiteID From " + Pre + "sys_PSF where psfID = '" + psfID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
        }



        #region 计划任务
        /// <summary>
        /// 检查计划任务ID是否重复
        /// </summary>
        /// <param name="TaskID"></param>
        /// <returns></returns>
        public DataTable getTaskParam(string TaskID)
        {
            string Sql = "Select Id,taskID From " + Pre + "sys_SiteTask where taskID = '" + TaskID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
        }
        /// <summary>
        /// 检查计划任务名称是否重复
        /// </summary>
        /// <param name="TaskID"></param>
        /// <returns></returns>
        public DataTable getTaskName(string TaskName)
        {
            SqlParameter param = new SqlParameter("@TaskName", TaskName);
            string Sql = "Select TaskName From " + Pre + "sys_SiteTask Where TaskName=@TaskNam and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
        }

        public int DelOneTask(string taskid)
        {
            string Str_DelOne_Sql = "Delete From " + Pre + "sys_SiteTask where taskID = '" + taskid + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_DelOne_Sql, null);
        }

        public void DelPTask(string boxs)
        {
            string str_sql = "Delete From " + Pre + "sys_SiteTask  where taskID in('" + boxs + "') and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, null);
        }
        public int DelAllTask()
        {
            string Str_DelAll_Sql = "Delete From " + Pre + "sys_SiteTask where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_DelAll_Sql, null);
        }

        /// <summary>
        /// 获得某一ID的Task 信息
        /// </summary>
        /// <param name="TaskID"></param>
        /// <returns></returns>
        public DataTable getTaskIDInfo(string TaskID)
        {
            string Sql = "Select Id,taskID,TaskName,isIndex,ClassID,News,Special,TimeSet,CreatTime,SiteID From " + Pre + "sys_SiteTask where taskID='" + TaskID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 插入Task
        /// </summary>
        /// <param name="uc2"></param>
        public void insertTask(NetCMS.Model.Task uc)
        {
            string Sql = "insert into " + Pre + "sys_SiteTask (";
            Sql += "taskID,TaskName,isIndex,ClassID,News,Special,TimeSet,CreatTime,SiteID";
            Sql += ") values (";
            Sql += "@taskID,@TaskName,@isIndex,@ClassID,@News,@Special,@TimeSet,@CreatTime,@SiteID)";
            SqlParameter[] parm = insertTaskParameters(uc);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }

        /// <summary>
        /// 插入Task
        /// </summary>
        /// <param name="uc2"></param>
        public void UpdateTask(NetCMS.Model.Task uc)
        {
            string Sql = "Update " + Pre + "sys_SiteTask set taskID=@taskID,TaskName=@TaskName,isIndex=@isIndex,ClassID=@ClassID,News=@News,Special=@Special,TimeSet=@TimeSet,CreatTime=@CreatTime,SiteID=@SiteID where taskID='" + uc.taskID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            SqlParameter[] parm = insertTaskParameters(uc);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }

        /// <summary>
        /// 获取PSF构造
        /// </summary>
        /// <param name="uc1"></param>
        /// <returns></returns>
        private SqlParameter[] insertTaskParameters(NetCMS.Model.Task uc)
        {
            SqlParameter[] param = new SqlParameter[10];
            param[0] = new SqlParameter("@taskID", SqlDbType.NVarChar, 12);
            param[0].Value = uc.taskID;
            param[1] = new SqlParameter("@TaskName", SqlDbType.NVarChar, 30);
            param[1].Value = uc.TaskName;
            param[2] = new SqlParameter("@isIndex", SqlDbType.TinyInt, 1);
            param[2].Value = uc.isIndex;
            param[3] = new SqlParameter("@ClassID", SqlDbType.NText);
            param[3].Value = uc.ClassID;
            param[4] = new SqlParameter("@News", SqlDbType.NText);
            param[4].Value = uc.News;
            param[5] = new SqlParameter("@Special", SqlDbType.NText);
            param[5].Value = uc.Special;
            param[6] = new SqlParameter("@TimeSet", SqlDbType.NVarChar, 100);
            param[6].Value = uc.TimeSet;
            param[7] = new SqlParameter("@CreatTime", SqlDbType.DateTime, 8);
            param[7].Value = uc.CreatTime;
            param[8] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
            param[8].Value = uc.SiteID;
            param[9] = new SqlParameter("@ID", SqlDbType.Int, 4);
            param[9].Value = uc.Id;
            return param;
        }

        #endregion
    }
}