photo.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 Photo : DbBase, IPhoto
    {
        #region photo.aspx
        public DataTable sel_getUserInfo(string PhotoalbumID)
        {
            SqlParameter param = new SqlParameter("@PhotoalbumID", PhotoalbumID);
            string Sql = "select pwd,UserName,PhotoalbumName,PhotoalbumJurisdiction,ClassID,PhotoalbumUrl from " + Pre + "User_Photoalbum where PhotoalbumID=@PhotoalbumID";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
        }
        #endregion

        #region photo_add.aspx
        public DataTable sel_getPhotoInfo(string UserNum)
        {
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = "Select PhotoalbumName,PhotoalbumID From " + Pre + "User_Photoalbum where isDisPhotoalbum=0 and UserName=@UserNum";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
        }
        public DataTable sel_getPhotoId()
        {
            string Sql = "select PhotoID from " + Pre + "User_Photo";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
        }
        public int Add(PhotoInfo Pho, string UserNum, string PhotoalbumID, string PhotoUrl, string PhotoID)
        {
            string Sql = "insert into " + Pre + "User_Photo(PhotoID,PhotoName,PhotoTime,UserNum,PhotoalbumID,PhotoContent,PhotoUrl) values(@PhotoID,@PhotoName,@PhotoTime,@UserNum,@PhotoalbumID,@PhotoContent,@PhotoUrl)";
            SqlParameter[] parm = GetPhoto(Pho);
            int i_length = parm.Length;
            Array.Resize<SqlParameter>(ref parm, i_length + 4);
            parm[i_length] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 18);
            parm[i_length].Value = UserNum;
            parm[i_length + 1] = new SqlParameter("@PhotoalbumID", SqlDbType.NVarChar, 18);
            parm[i_length + 1].Value = PhotoalbumID;
            parm[i_length + 2] = new SqlParameter("@PhotoUrl", SqlDbType.NVarChar, 200);
            parm[i_length + 2].Value = PhotoUrl;
            parm[i_length + 3] = new SqlParameter("@PhotoID", SqlDbType.NVarChar, 18);
            parm[i_length + 3].Value = PhotoID;
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }
        private SqlParameter[] GetPhoto(PhotoInfo Pho)
        {
            SqlParameter[] parm = new SqlParameter[3];
            parm[0] = new SqlParameter("@PhotoName", SqlDbType.NVarChar, 18);
            parm[0].Value = Pho.PhotoName;
            parm[1] = new SqlParameter("@PhotoContent", SqlDbType.NVarChar, 200);
            parm[1].Value = Pho.PhotoContent;
            parm[2] = new SqlParameter("@PhotoTime", SqlDbType.DateTime);
            parm[2].Value = DateTime.Now;
            return parm;
        }
        #endregion

        #region photo_del.aspx
        public int Delete(string PhotoID)
        {
            SqlParameter param = new SqlParameter("@PhotoID", PhotoID);
            string Sql = "delete " + Pre + "User_Photo  where PhotoID=@PhotoID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        #endregion

        #region photo_up.aspx
        public DataTable sel_getUserPhoto(string PhotoID)
        {
            SqlParameter param = new SqlParameter("@PhotoID", PhotoID);
            string Sql = "select PhotoName,PhotoalbumID,PhotoContent,PhotoUrl from " + Pre + "User_Photo where PhotoID=@PhotoID";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
        }
        public int Update(string PhotoName, DateTime PhotoTime, string PhotoalbumID, string PhotoContent, string PhotoUrl1, string PhotoIDs)
        {
            SqlParameter[] param = new SqlParameter[6];
            param[0] = new SqlParameter("@PhotoName", SqlDbType.NVarChar, 18);
            param[0].Value = PhotoName;
            param[1] = new SqlParameter("@PhotoTime", SqlDbType.DateTime, 8);
            param[1].Value = PhotoTime;
            param[2] = new SqlParameter("@PhotoalbumID", SqlDbType.NVarChar, 18);
            param[2].Value = PhotoalbumID;
            param[3] = new SqlParameter("@PhotoContent", SqlDbType.NVarChar, 200);
            param[3].Value = PhotoContent;
            param[4] = new SqlParameter("@PhotoUrl", SqlDbType.NVarChar, 200);
            param[4].Value = PhotoUrl1;
            param[5] = new SqlParameter("@PhotoID", SqlDbType.NVarChar, 200);
            param[5].Value = PhotoIDs;
            string Sql = "update " + Pre + "User_Photo set PhotoName=@PhotoName,PhotoTime=@PhotoTime,PhotoalbumID=@PhotoalbumID,PhotoContent=@PhotoContent,PhotoUrl=@PhotoUrl where PhotoID=@PhotoID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        #endregion

        #region Photoalbum.aspx
        public DataTable sel_getPhotoClass(string UserNum)
        {
            string Sql = "Select ClassName,ClassID From " + Pre + "user_PhotoalbumClass where UserName='" + UserNum + "' and isDisclass=0";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
        }
        public int add_photoalBum(PhotoAlbumInfo Pb, string UserNum)
        {
            string Sql = "insert into " + Pre + "user_Photoalbum(PhotoalbumName,PhotoalbumID,Creatime,UserName,PhotoalbumJurisdiction,isDisPhotoalbum,pwd,PhotoalbumUrl,DisID,ClassID) values(@PhotoalbumName,@PhotoalbumID,@Creatime,@UserNum,@PhotoalbumJurisdiction,@isDisPhotoalbum,@pwd,@PhotoalbumUrl,@DisID,@ClassID)";
            SqlParameter[] parm = GetPhotoalbum(Pb);
            int i_length = parm.Length;
            Array.Resize<SqlParameter>(ref parm, i_length + 1);
            parm[i_length] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 18);
            parm[i_length].Value = UserNum;
            return (int)DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }
        private SqlParameter[] GetPhotoalbum(PhotoAlbumInfo Pb)
        {
            SqlParameter[] parm = new SqlParameter[9];
            parm[0] = new SqlParameter("@PhotoalbumName", SqlDbType.NVarChar, 18);
            parm[0].Value = Pb.PhotoalbumName;
            parm[1] = new SqlParameter("@PhotoalbumID", SqlDbType.NVarChar, 200);
            parm[1].Value = Rand.Number(12);
            parm[2] = new SqlParameter("@Creatime", SqlDbType.DateTime);
            parm[2].Value = DateTime.Now;
            parm[3] = new SqlParameter("@PhotoalbumJurisdiction", SqlDbType.NVarChar, 200);
            parm[3].Value = Pb.PhotoalbumJurisdiction;
            parm[4] = new SqlParameter("@isDisPhotoalbum", SqlDbType.NVarChar, 200);
            parm[4].Value = Pb.isDisPhotoalbum;
            parm[5] = new SqlParameter("@pwd", SqlDbType.NVarChar, 200);
            parm[5].Value = Pb.pwd;
            parm[6] = new SqlParameter("@PhotoalbumUrl", SqlDbType.NVarChar, 200);
            parm[6].Value = Pb.PhotoalbumUrl;
            parm[7] = new SqlParameter("@DisID", SqlDbType.NVarChar, 200);
            parm[7].Value = Pb.DisID;
            parm[8] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 200);
            parm[8].Value = Pb.ClassID;
            return parm;
        }
        #endregion

        #region Photoalbum_up.aspx
        public int update_photoalBum(string PhotoalbumName, string PhotoalbumJurisdiction, string ClassID, DateTime Creatime, string PhotoalbumIDs)
        {
            SqlParameter[] param = new SqlParameter[5];