photo.cs

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

            param[0] = new SqlParameter("@PhotoalbumName", SqlDbType.NVarChar, 200);
            param[0].Value = PhotoalbumName;
            param[1] = new SqlParameter("@PhotoalbumJurisdiction", SqlDbType.NVarChar, 50);
            param[1].Value = PhotoalbumJurisdiction;
            param[2] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 18);
            param[2].Value = ClassID;
            param[3] = new SqlParameter("@Creatime", SqlDbType.NVarChar, 200);
            param[3].Value = Creatime;
            param[4] = new SqlParameter("@PhotoalbumIDs", SqlDbType.NVarChar, 18);
            param[4].Value = PhotoalbumIDs;
            string Sql = "update " + Pre + "user_Photoalbum set PhotoalbumName=@PhotoalbumName,Creatime=@Creatime,PhotoalbumJurisdiction=@PhotoalbumJurisdiction,ClassID=@ClassID where PhotoalbumID=@PhotoalbumIDs";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public string sel_getPhotoalBum()
        {
            string Sql = "select pwd from " + Pre + "user_Photoalbum";
            return DbHelper.ExecuteScalar(CommandType.Text, Sql, null).ToString();
        }
        public int update_photoalBumPwd(string newpwds, string PhotoalbumIDs)
        {
            SqlParameter[] param = new SqlParameter[2];
            param[0] = new SqlParameter("@newpwds", SqlDbType.NVarChar, 18);
            param[0].Value = newpwds;
            param[1] = new SqlParameter("@PhotoalbumIDs", SqlDbType.NVarChar, 18);
            param[1].Value = PhotoalbumIDs;
            string Sql = "update " + Pre + "user_Photoalbum set pwd=@newpwds where PhotoalbumID=@PhotoalbumIDs";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        #endregion

        #region Photoalbumlist.aspx
        public int del_photoalBumById(string ID)
        {
            SqlParameter param = new SqlParameter("@PhotoalbumID", ID);
            string Sql = "delete " + Pre + "User_Photoalbum where PhotoalbumID=@PhotoalbumID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public int del_photoById(string ID)
        {
            SqlParameter param = new SqlParameter("@PhotoalbumID", ID);
            string Sql = "delete " + Pre + "User_Photo where PhotoalbumID=@PhotoalbumID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public string sel_sysUser(string UserNum)
        {
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = "select UserName from " + Pre + "sys_user where UserNum=@UserNum";
            return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
        }
        public int sel_userPhoCount(string ID)
        {
            SqlParameter param = new SqlParameter("@PhotoalbumID", ID);
            string Sql = "select count(*) from " + Pre + "User_Photo where PhotoalbumID=@PhotoalbumID";
            return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
        }
        public DataTable GetPage(string UserNum, string ClassID, int PageIndex, int PageSize, out int RecordCount, out int PageCount, params SQLConditionInfo[] SqlCondition)
        {
            string Sql = "";
            if (UserNum != null && UserNum != "")
            {
                Sql = " and UserName='" + UserNum + "'";
            }
            if (ClassID != "" && ClassID != null)
            {
                Sql += "and ClassID='" + ClassID + "'";
            }
            SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserName", UserNum), new SqlParameter("@ClassID", ClassID) };
            string AllFields = "PhotoalbumName,PhotoalbumID,UserName,Creatime,pwd";
            string Condition = "" + Pre + "User_Photoalbum where isDisPhotoalbum=0 " + Sql + "";
            string IndexField = "id";
            string OrderFields = "order by ID desc";
            return DbHelper.ExecutePage(AllFields, Condition, IndexField, OrderFields, PageIndex, PageSize, out RecordCount, out PageCount, param);
        }
        #endregion

        #region photoclass.aspx
        public int del_phoBumById(string ID)
        {
            SqlParameter param = new SqlParameter("@ClassID", ID);
            string Sql = "delete " + Pre + "user_PhotoalbumClass where ClassID=@ClassID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public int del_photoalBum(string ID)
        {
            SqlParameter param = new SqlParameter("@ClassID", ID);
            string Sql = "delete " + Pre + "User_Photoalbum  where ClassID=@ClassID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public DataTable sel_getPhotoById(string ID)
        {
            SqlParameter param = new SqlParameter("@ClassID", ID);
            string Sql = "select PhotoalbumName,PhotoalbumUrl  from " + Pre + "User_Photoalbum where ClassID=@ClassID";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
        }
        public DataTable sel_disActive()
        {
            string Sql = "select AId,UserNum from " + Pre + "user_DiscussActiveMember";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
        }
        #endregion

        #region  photoclass_add.aspx
        public int add_photoalBumClass(string ClassName, string ClassID, DateTime Creatime, string UserNum, int isDisclass, string DisID)
        {
            SqlParameter[] param = new SqlParameter[6];
            param[0] = new SqlParameter("@ClassName", SqlDbType.NVarChar, 50);
            param[0].Value = ClassName;
            param[1] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 18);
            param[1].Value = ClassID;
            param[2] = new SqlParameter("@Creatime", SqlDbType.DateTime, 8);
            param[2].Value = Creatime;
            param[3] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 18);
            param[3].Value = UserNum;
            param[4] = new SqlParameter("@isDisclass", SqlDbType.Int, 4);
            param[4].Value = isDisclass;
            param[5] = new SqlParameter("@DisID", SqlDbType.NVarChar, 18);
            param[5].Value = DisID;
            string Sql = "insert into " + Pre + "user_PhotoalbumClass(ClassName,ClassID,Creatime,UserName,isDisclass,DisID) values(@ClassName,@ClassID,@Creatime,@UserNum,@isDisclass,@DisID)";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        #endregion

        #region photoclass_up.aspx
        public string sel_phoClassName(string ClassID)
        {
            SqlParameter param = new SqlParameter("@ClassID", ClassID);
            string Sql = "select  ClassName  from  " + Pre + "user_PhotoalbumClass where ClassID=@ClassID";
            return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
        }
        public int update_phoBumClass(string ClassName, DateTime Creatime, string ClassIDs)
        {
            SqlParameter[] param = new SqlParameter[3];
            param[0] = new SqlParameter("@ClassName", SqlDbType.NVarChar, 50);
            param[0].Value = ClassName;
            param[1] = new SqlParameter("@Creatime", SqlDbType.DateTime, 8);
            param[1].Value = Creatime;
            param[2] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 18);
            param[2].Value = ClassIDs;
            string Sql = "update  " + Pre + "user_PhotoalbumClass set ClassName=@ClassName,Creatime=@Creatime where ClassID=@ClassID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        #endregion

        public DataTable sel_photoUrl(string PhotoalbumID)
        {
            SqlParameter param = new SqlParameter("@PhotoalbumID", PhotoalbumID);
            string Sql = "Select PhotoUrl From " + Pre + "user_photo where PhotoalbumID=@PhotoalbumID";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
        }

    }
}