BBSDAL/F_Bbs.cs

(开头部分) 36KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using BBS.Model;
using BaseDBUtility;

namespace BBS.DAL
{
    /// <summary>
    /// 数据访问类:F_Bbs
    /// </summary>
    public partial class F_Bbs
    {
        public F_Bbs()
        { }
        #region  Method

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(BBS.Model.F_Bbs model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into F_Bbs(");
            strSql.Append("forumTitle,forumInfo,isInUse,orders,postCount,repliedCount,needReplyCount,createUserId,createUser,createDepartId,createDepart,createTime,parentForumId,lastViewUserId,lastViewUser,lastViewDepartId,lastViewDepart,lastViewIp,lastViewTime,lastViewTopicId,lastViewTopicTitle,lastPostUserId,lastPostUser,lastPostDepartId,lastPostDepart,lastPostTime,lastPostIp,lastPostTopicId,lastPostTopicTitle,lastReplyUserId,lastReplyUser,lastReplyDepartId,lastReplyDepart,lastReplyTime,lastReplyIp,lastReplyTopicId,lastReplyTopicTitle,lastVerifyUserId,lastVerifyUser,lastVerifyDepartId,lastVerifyDepart,lastVerifyTime,lastVerifyIp,lastVerifyTopicId,lastVerifyTopicTitle,canUserIds,canUserNames)");
            strSql.Append(" values (");
            strSql.Append("@forumTitle,@forumInfo,@isInUse,@orders,@postCount,@repliedCount,@needReplyCount,@createUserId,@createUser,@createDepartId,@createDepart,@createTime,@parentForumId,@lastViewUserId,@lastViewUser,@lastViewDepartId,@lastViewDepart,@lastViewIp,@lastViewTime,@lastViewTopicId,@lastViewTopicTitle,@lastPostUserId,@lastPostUser,@lastPostDepartId,@lastPostDepart,@lastPostTime,@lastPostIp,@lastPostTopicId,@lastPostTopicTitle,@lastReplyUserId,@lastReplyUser,@lastReplyDepartId,@lastReplyDepart,@lastReplyTime,@lastReplyIp,@lastReplyTopicId,@lastReplyTopicTitle,@lastVerifyUserId,@lastVerifyUser,@lastVerifyDepartId,@lastVerifyDepart,@lastVerifyTime,@lastVerifyIp,@lastVerifyTopicId,@lastVerifyTopicTitle,@canUserIds,@canUserNames)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@forumTitle", SqlDbType.NVarChar,64),
					new SqlParameter("@forumInfo", SqlDbType.NVarChar,4000),
					new SqlParameter("@isInUse", SqlDbType.Bit,1),
					new SqlParameter("@orders", SqlDbType.Int,4),
					new SqlParameter("@postCount", SqlDbType.Int,4),
					new SqlParameter("@repliedCount", SqlDbType.Int,4),
					new SqlParameter("@needReplyCount", SqlDbType.Int,4),
					new SqlParameter("@createUserId", SqlDbType.Int,4),
					new SqlParameter("@createUser", SqlDbType.NVarChar,64),
					new SqlParameter("@createDepartId", SqlDbType.Int,4),
					new SqlParameter("@createDepart", SqlDbType.NVarChar,64),
					new SqlParameter("@createTime", SqlDbType.DateTime),
					new SqlParameter("@parentForumId", SqlDbType.Int,4),
					new SqlParameter("@lastViewUserId", SqlDbType.Int,4),
					new SqlParameter("@lastViewUser", SqlDbType.NVarChar,64),
					new SqlParameter("@lastViewDepartId", SqlDbType.Int,4),
					new SqlParameter("@lastViewDepart", SqlDbType.NVarChar,64),
					new SqlParameter("@lastViewIp", SqlDbType.NVarChar,32),
					new SqlParameter("@lastViewTime", SqlDbType.DateTime),
					new SqlParameter("@lastViewTopicId", SqlDbType.Int,4),
					new SqlParameter("@lastViewTopicTitle", SqlDbType.NVarChar,256),
					new SqlParameter("@lastPostUserId", SqlDbType.Int,4),
					new SqlParameter("@lastPostUser", SqlDbType.NVarChar,64),
					new SqlParameter("@lastPostDepartId", SqlDbType.Int,4),
					new SqlParameter("@lastPostDepart", SqlDbType.NVarChar,64),
					new SqlParameter("@lastPostTime", SqlDbType.DateTime),
					new SqlParameter("@lastPostIp", SqlDbType.NVarChar,32),
					new SqlParameter("@lastPostTopicId", SqlDbType.Int,4),
					new SqlParameter("@lastPostTopicTitle", SqlDbType.NVarChar,256),
后面还有 594 行代码,购买后查看完整代码

24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用,每次 10 算力,解读结果公开显示在下面。

还没有人解读过这个文件。