dynamictrans.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.Data;
using System.Data.SqlClient;
using NetCMS.Model;
using NetCMS.DALFactory;
using NetCMS.DALProfile;
using NetCMS.Config;

namespace NetCMS.DALSQLServer
{
    public class DynamicTrans : DbBase, IDynamicTrans
    {
        /// <summary>
        /// 得到新闻内容
        /// </summary>
        /// <param name="NewsID"></param>
        /// <returns></returns>
        public IDataReader GetNewsInfo(string ID, int Num, int ChID, string DTable)
        {
            SqlParameter[] param = new SqlParameter[2];
            if (ChID != 0)
            {
                param[0] = new SqlParameter("@ID", SqlDbType.Int, 4);
                param[0].Value = int.Parse(ID);
            }
            else
            {
                param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 12);
                param[0].Value = ID;
            }
            param[1] = new SqlParameter("@ChID", SqlDbType.Int, 4);
            param[1].Value = ChID;
            string sql = string.Empty;
            if (ChID != 0)
            {
                if (Num == 0)
                {
                    sql = "select id,isDelPoint,Templet,Gpoint,iPoint,GroupNumber from " + DTable + " where ID=@ID and isLock=0";
                }
                else
                {
                    sql = "select id,isDelPoint,Gpoint,iPoint,GroupNumber from " + Pre + "sys_channelclass where ClassID=@ID and isLock=0";
                }
            }
            else
            {
                if (Num == 0)
                {
                    sql = "select NewsID,isDelPoint,Templet,Gpoint,iPoint,GroupNumber from " + Pre + "news where NewsID=@ID and isLock=0 and isRecyle=0 and NewsType!=2";
                }
                else
                {
                    sql = "select ClassID,isDelPoint,Gpoint,iPoint,GroupNumber from " + Pre + "news_Class where ClassID=@ID and isLock=0 and isRecyle=0 and isURL!=1";
                }
            }
            return DbHelper.ExecuteReader(CommandType.Text, sql, param);
        }

        public IDataReader getUserInfo(string UserNum)
        {
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string sql = "select isAdmin,UserGroupNumber,iPoint,gPoint from " + Pre + "sys_user where UserNum=@UserNum";
            return DbHelper.ExecuteReader(CommandType.Text, sql, param);
        }

        public int UpdateHistory(int infoType, string infoID, int iPoint, int Gpoint, string UserNum,string IP)
        {
            SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserNum", UserNum), new SqlParameter("@infoID", infoID), new SqlParameter("@IP", IP), new SqlParameter("@infoType", infoType) };
            string uSql = "insert into " + Pre + "user_note(infoType,infoID,logTime,IP,UserNum) values(@infoType,@infoID,'" + DateTime.Now + "',@IP,@UserNum)";
            DbHelper.ExecuteNonQuery(CommandType.Text, uSql, param);

            string Sql = "update " + Pre + "sys_User set iPoint=iPoint-" + iPoint + ",Gpoint=Gpoint-" + Gpoint + " where UserNum=@UserNum";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }

        public bool getUserNote(string UserNum, string infoID,int Num)
        {
            bool bltf = false;
            SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserNum", UserNum), new SqlParameter("@infoID", infoID), new SqlParameter("@infoType", Num) };
            string sql = "select count(id) from " + Pre + "user_note where UserNum=@UserNum and infoID=@infoID and infoType=@infoType";
            int i = Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
            if (i > 0)
            {
                bltf = true;
            }
            return bltf;
        }
    }
}