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 算力,解读结果公开显示在下面。
还没有人解读过这个文件。