/// <summary>
/// 添加UserInfo
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static int AddUser(UserInfo user)
{
string sql = @"INSERT INTO [User]
([Name],[NickName],[Password],[RoleId],[OnLineTime],[ActionTime],[CreateTime],[Avatar],[Sex],[Email],[EmailStatus],[Score],[ArticleNum],[CommentNum],[Disable],[DisableReason],[QQ])
VALUES
(@Name,@NickName,@Password,@RoleId,@OnLineTime,@ActionTime,@CreateTime,@Avatar,@Sex,@Email,@EmailStatus,@Score,@ArticleNum,@CommentNum,@Disable,@DisableReason,@QQ)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Name", user.Name, DbType.String);
par.Add("@NickName", user.NickName, DbType.String);
par.Add("@Password", user.Password, DbType.AnsiString);
par.Add("@RoleId", user.RoleId, DbType.Int32);
par.Add("@OnLineTime", user.OnLineTime, DbType.DateTime);
par.Add("@ActionTime", user.ActionTime, DbType.DateTime);
par.Add("@CreateTime", user.CreateTime, DbType.DateTime);
par.Add("@Avatar", user.Avatar, DbType.AnsiString);
par.Add("@Sex", user.Sex, DbType.Int16);
par.Add("@Email", user.Email, DbType.AnsiString);
par.Add("@EmailStatus", user.EmailStatus, DbType.Boolean);
par.Add("@Score", user.Score, DbType.Int64);
par.Add("@ArticleNum", user.ArticleNum, DbType.Int32);
par.Add("@CommentNum", user.CommentNum, DbType.Int32);
par.Add("@Disable", user.Disable, DbType.Boolean);
par.Add("@DisableReason", user.DisableReason, DbType.String);
par.Add("@QQ", user.QQ, DbType.AnsiString);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加CommentInfo
/// </summary>
/// <param name="comment"></param>
/// <returns></returns>
public static long AddComment(CommentInfo comment)
{
string sql = @"INSERT INTO [Comment]
([AId],[UserId],[CreateTime],[Content],[IP],[UserAgent],[State],[RefuseReason],[IsDelete],[LastEditUserId],[LastEditTime],[IsStick],[DianZanNum])
VALUES
(@AId,@UserId,@CreateTime,@Content,@IP,@UserAgent,@State,@RefuseReason,@IsDelete,@LastEditUserId,@LastEditTime,@IsStick,@DianZanNum)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@AId", comment.AId, DbType.Int64);
par.Add("@UserId", comment.UserId, DbType.Int32);
par.Add("@CreateTime", comment.CreateTime, DbType.DateTime);
par.Add("@Content", comment.Content, DbType.AnsiString);
par.Add("@IP", comment.IP, DbType.AnsiString);
par.Add("@UserAgent", comment.UserAgent, DbType.AnsiString);
par.Add("@State", comment.State, DbType.Int16);
par.Add("@RefuseReason", comment.RefuseReason, DbType.String);
par.Add("@IsDelete", comment.IsDelete, DbType.Boolean);
par.Add("@LastEditUserId", comment.LastEditUserId, DbType.Int32);
par.Add("@LastEditTime", comment.LastEditTime, DbType.DateTime);
par.Add("@IsStick", comment.IsStick, DbType.Boolean);
par.Add("@DianZanNum", comment.DianZanNum, DbType.Int32);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加AttachmentInfo
/// </summary>
/// <param name="attachment"></param>
/// <returns></returns>
public static long AddAttachment(AttachmentInfo attachment)
{
string sql = @"INSERT INTO [Attachment]
([FileName],[FileTitle],[Description],[Type],[Width],[Height],[FileSize],[IsShow],[AId],[Score],[State],[UserId],[InTime],[BType],[LocalPath],[VirtualPath],[Guid])
VALUES
(@FileName,@FileTitle,@Description,@Type,@Width,@Height,@FileSize,@IsShow,@AId,@Score,@State,@UserId,@InTime,@BType,@LocalPath,@VirtualPath,@Guid)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@FileName", attachment.FileName, DbType.AnsiString);
par.Add("@FileTitle", attachment.FileTitle, DbType.String);
par.Add("@Description", attachment.Description, DbType.String);
par.Add("@Type", attachment.Type, DbType.AnsiString);
par.Add("@Width", attachment.Width, DbType.Int32);
par.Add("@Height", attachment.Height, DbType.Int32);
par.Add("@FileSize", attachment.FileSize, DbType.Int64);
par.Add("@IsShow", attachment.IsShow, DbType.Boolean);
par.Add("@AId", attachment.AId, DbType.Int64);
par.Add("@Score", attachment.Score, DbType.Int32);
par.Add("@State", attachment.State, DbType.Int32);
par.Add("@UserId", attachment.UserId, DbType.Int32);
par.Add("@InTime", attachment.InTime, DbType.DateTime);
par.Add("@BType", attachment.BType, DbType.Int32);
par.Add("@LocalPath", attachment.LocalPath, DbType.AnsiString);
par.Add("@VirtualPath", attachment.VirtualPath, DbType.AnsiString);
par.Add("@Guid", attachment.Guid, DbType.Guid);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加ArticleInfo
/// </summary>
/// <param name="article"></param>
/// <returns></returns>
public static long AddArticle(ArticleInfo article)
{
string sql = @"INSERT INTO [Article]
([Title],[Content],[Type],[CommentNum],[Dot],[CreateTime],[UserId],[ImgNum],[AttachmentNum],[LastEditUserId],[LastEditTime],[Guid],[IsDelete],[State],[RefuseReason],[BType],[DianZanNum],[Score],[IsStick],[IsJiaJing],[IsCloseComment],[CloseCommentReason])
VALUES
(@Title,@Content,@Type,@CommentNum,@Dot,@CreateTime,@UserId,@ImgNum,@AttachmentNum,@LastEditUserId,@LastEditTime,@Guid,@IsDelete,@State,@RefuseReason,@BType,@DianZanNum,@Score,@IsStick,@IsJiaJing,@IsCloseComment,@CloseCommentReason)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Title", article.Title, DbType.String);
par.Add("@Content", article.Content, DbType.AnsiString);
par.Add("@Type", article.Type, DbType.Int32);
par.Add("@CommentNum", article.CommentNum, DbType.Int32);
par.Add("@Dot", article.Dot, DbType.Int32);
par.Add("@CreateTime", article.CreateTime, DbType.DateTime);
par.Add("@UserId", article.UserId, DbType.Int32);
par.Add("@ImgNum", article.ImgNum, DbType.Int32);
par.Add("@AttachmentNum", article.AttachmentNum, DbType.Int32);
par.Add("@LastEditUserId", article.LastEditUserId, DbType.Int32);
par.Add("@LastEditTime", article.LastEditTime, DbType.DateTime);
par.Add("@Guid", article.Guid, DbType.Guid);
par.Add("@IsDelete", article.IsDelete, DbType.Boolean);
par.Add("@State", article.State, DbType.Int16);
par.Add("@RefuseReason", article.RefuseReason, DbType.String);
par.Add("@BType", article.BType, DbType.Int16);
par.Add("@DianZanNum", article.DianZanNum, DbType.Int32);
par.Add("@Score", article.Score, DbType.Int32);
par.Add("@IsStick", article.IsStick, DbType.Boolean);
par.Add("@IsJiaJing", article.IsJiaJing, DbType.Boolean);
par.Add("@IsCloseComment", article.IsCloseComment, DbType.Boolean);
par.Add("@CloseCommentReason", article.CloseCommentReason, DbType.String);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加AdminLogInfo
/// </summary>
/// <param name="adminlog"></param>
/// <returns></returns>
public static int AddAdminLog(AdminLogInfo adminlog)
{
string sql = @"INSERT INTO [AdminLog]
([UserId],[Controllers],[Action],[Parameter],[ActionId],[Ip],[Url],[InTime],[Method],[IsAjax],[UserAgent],[ControllersDsc],[ActionDsc])
VALUES
(@UserId,@Controllers,@Action,@Parameter,@ActionId,@Ip,@Url,@InTime,@Method,@IsAjax,@UserAgent,@ControllersDsc,@ActionDsc)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@UserId", adminlog.UserId, DbType.Int64);
par.Add("@Controllers", adminlog.Controllers, DbType.AnsiString);
par.Add("@Action", adminlog.Action, DbType.AnsiString);
par.Add("@Parameter", adminlog.Parameter, DbType.AnsiString);
par.Add("@ActionId", adminlog.ActionId, DbType.AnsiString);
par.Add("@Ip", adminlog.Ip, DbType.AnsiString);
par.Add("@Url", adminlog.Url, DbType.AnsiString);
par.Add("@InTime", adminlog.InTime, DbType.DateTime);
par.Add("@Method", adminlog.Method, DbType.AnsiString);
par.Add("@IsAjax", adminlog.IsAjax, DbType.Int32);
par.Add("@UserAgent", adminlog.UserAgent, DbType.AnsiString);
par.Add("@ControllersDsc", adminlog.ControllersDsc, DbType.String);
par.Add("@ActionDsc", adminlog.ActionDsc, DbType.String);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 根据用户id获取当天用户操作发送邮件数量
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static int GetSendMailLogToDayCountByUserId(int userId)
{
string sql = "select COUNT(1) FROM [SendMailLog] WHERE SendUserId=@SendUserId AND DATEDIFF(DAY,CreateTime,GETDATE())=1";
var par = new DynamicParameters();
par.Add("@SendUserId", userId, DbType.Int32);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 根据Name password查找记录数
/// </summary>
/// <param name="userId"></param>
/// <param name="password"></param>
/// <returns></returns>
public static int GetCount(int userId, string password)
{
string sql = "select count(Id) from [User] where Id=@Id AND Password=@Password";
var par = new DynamicParameters();
par.Add("@Id", userId, DbType.Int32);
par.Add("@Password", password, DbType.String);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 获取UserActivateToken id
/// </summary>
/// <param name="token"></param>
/// <param name="expireTime"></param>
/// <returns></returns>
public static long GetUserActivateTokenId(string token, int expireTime)
{
string sql = @"SELECT Id FROM [UserActivateToken] WHERE Token=@Token AND Status=1 AND DATEDIFF(MINUTE,CreateTime,GETDATE())<=@Time";
var par = new DynamicParameters();
par.Add("@Token", token, DbType.String);
par.Add("@Time", expireTime, DbType.Int32);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 获取用户最后发帖时间
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static DateTime GetLastPostTime(int userId)
{
string sql = @"SELECT MAX(CreateTime)
FROM [dbo].[Article]
WHERE UserId=@UserId";
var par = new DynamicParameters();
par.Add("@UserId", userId, DbType.Int32);
return(DapWrapper.InnerQueryScalarSql <DateTime>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 根据父级生成排序值（排序值只会越来越大，越大的越靠前）
/// </summary>
/// <param name="pid">父级id</param>
/// <param name="id">编辑时可排除自身所占位置</param>
/// <returns></returns>
public static int GetOrderNumber(int pid, int?id)
{
string sql = "select ISNULL(MAX(OrderId),0) from [Modul] WHERE PId=@PId";
var par = new DynamicParameters();
par.Add("@PId", pid, DbType.Int32);
if (id.HasValue)
{
sql = sql + " AND Id!=@Id ";
par.Add("@Id", id.Value, DbType.Int32);
}
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par) + 1);
}
/// <summary>
/// Name检测
/// </summary>
/// <param name="name"></param>
/// <param name="id">需排除的自身userid</param>
/// <returns>true(含有)/false(不含有)</returns>
public static bool CheckName(string name, int?id)
{
string sql = "select count(Id) from [User] where Name=@Name";
var par = new DynamicParameters();
par.Add("@Name", name, DbType.String);
if (id.HasValue)
{
sql += " AND Id!=@Id";
par.Add("@Id", id.Value, DbType.Int32);
}
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par) > 0);
}
/// <summary>
/// 添加UserOtherInfo
/// </summary>
/// <param name="userother"></param>
/// <returns></returns>
public static int AddUserOther(UserOtherInfo userother)
{
string sql = @"INSERT INTO [UserOther]
([UserId],[PersonalityIntroduce])
VALUES
(@UserId,@PersonalityIntroduce)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@UserId", userother.UserId, DbType.Int32);
par.Add("@PersonalityIntroduce", userother.PersonalityIntroduce, DbType.String);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加RoleModulInfo
/// </summary>
/// <param name="rolemodul"></param>
/// <returns></returns>
public static int AddRoleModul(RoleModulInfo rolemodul)
{
string sql = @"INSERT INTO [Role_Modul]
([MId],[RId])
VALUES
(@MId,@RId)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@MId", rolemodul.MId, DbType.Int32);
par.Add("@RId", rolemodul.RId, DbType.Int32);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加UserPositionInfo
/// </summary>
/// <param name="userposition"></param>
/// <returns></returns>
public static int AddUserPosition(UserPositionInfo userposition)
{
string sql = @"INSERT INTO [UserPosition]
([UserId],[Code],[Type])
VALUES
(@UserId,@Code,@Type)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@UserId", userposition.UserId, DbType.Int32);
par.Add("@Code", userposition.Code, DbType.Int32);
par.Add("@Type", userposition.Type, DbType.Int16);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加UserActivateTokenInfo
/// </summary>
/// <param name="useractivatetoken"></param>
/// <returns></returns>
public static long AddUserActivateToken(UserActivateTokenInfo useractivatetoken)
{
string sql = @"INSERT INTO [UserActivateToken]
([UserId],[Email],[Token])
VALUES
(@UserId,@Email,@Token)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@UserId", useractivatetoken.UserId, DbType.Int32);
par.Add("@Email", useractivatetoken.Email, DbType.AnsiString);
par.Add("@Token", useractivatetoken.Token, DbType.AnsiString);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加UserBuyingLogInfo
/// </summary>
/// <param name="userbuyinglog"></param>
/// <returns></returns>
public static int AddUserBuyingLog(UserBuyingLogInfo userbuyinglog)
{
string sql = @"INSERT INTO [UserBuyingLog]
([AId],[Score],[UserId],[CreateTime])
VALUES
(@AId,@Score,@UserId,@CreateTime)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@AId", userbuyinglog.AId, DbType.Int64);
par.Add("@Score", userbuyinglog.Score, DbType.Int32);
par.Add("@UserId", userbuyinglog.UserId, DbType.Int32);
par.Add("@CreateTime", userbuyinglog.CreateTime, DbType.DateTime);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加RoleInfo
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public static int AddRole(RoleInfo role)
{
string sql = @"INSERT INTO [Role]
([RName],[Description],[IsSuper],[ArticleNeedVerified],[CommentNeedVerified])
VALUES
(@RName,@Description,@IsSuper,@ArticleNeedVerified,@CommentNeedVerified)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@RName", role.RName, DbType.AnsiString);
par.Add("@Description", role.Description, DbType.String);
par.Add("@IsSuper", role.IsSuper, DbType.Boolean);
par.Add("@ArticleNeedVerified", role.ArticleNeedVerified, DbType.Boolean);
par.Add("@CommentNeedVerified", role.CommentNeedVerified, DbType.Boolean);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加DianZanLogInfo
/// </summary>
/// <param name="dianzanlog"></param>
/// <returns></returns>
public static long AddDianZanLog(DianZanLogInfo dianzanlog)
{
string sql = @"INSERT INTO [DianZanLog]
([MId],[CId],[UserId],[Ip],[Type])
VALUES
(@MId,@CId,@UserId,@Ip,@Type)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@MId", dianzanlog.MId, DbType.Int64);
par.Add("@CId", dianzanlog.CId, DbType.Int64);
par.Add("@UserId", dianzanlog.UserId, DbType.Int32);
par.Add("@Ip", dianzanlog.Ip, DbType.AnsiString);
par.Add("@Type", dianzanlog.Type, DbType.Int16);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加TagInfo
/// </summary>
/// <param name="tag"></param>
/// <returns></returns>
public static long AddTag(TagInfo tag)
{
string sql = @"INSERT INTO [Tag]
([Tag],[AId],[State],[Direction],[CreateTime],[UserId])
VALUES
(@Tag,@AId,@State,@Direction,@CreateTime,@UserId)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Tag", tag.Tag, DbType.String);
par.Add("@AId", tag.AId, DbType.Int64);
par.Add("@State", tag.State, DbType.Int16);
par.Add("@Direction", tag.Direction, DbType.String);
par.Add("@CreateTime", tag.CreateTime, DbType.DateTime);
par.Add("@UserId", tag.UserId, DbType.Int32);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加AreaInfo
/// </summary>
/// <param name="area"></param>
/// <returns></returns>
public static int AddArea(AreaInfo area)
{
string sql = @"INSERT INTO [Area]
([Name],[Code],[PinYin],[SortPinYin],[Sort],[ParentCode])
VALUES
(@Name,@Code,@PinYin,@SortPinYin,@Sort,@ParentCode)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Name", area.Name, DbType.String);
par.Add("@Code", area.Code, DbType.AnsiString);
par.Add("@PinYin", area.PinYin, DbType.AnsiString);
par.Add("@SortPinYin", area.SortPinYin, DbType.AnsiString);
par.Add("@Sort", area.Sort, DbType.AnsiString);
par.Add("@ParentCode", area.ParentCode, DbType.AnsiString);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加CommentInfo
/// </summary>
/// <param name="comment"></param>
/// <returns></returns>
public static long AddComment(CommentInfo comment)
{
string sql = @"INSERT INTO [Comment]
([AId],[UserId],[Content],[IP],[UserAgent],[State])
VALUES
(@AId,@UserId,@Content,@IP,@UserAgent,@State)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@AId", comment.AId, DbType.Int64);
par.Add("@UserId", comment.UserId, DbType.Int32);
par.Add("@Content", comment.Content, DbType.String);
par.Add("@IP", comment.IP, DbType.AnsiString);
par.Add("@UserAgent", comment.UserAgent, DbType.AnsiString);
par.Add("@State", comment.State, DbType.Int16);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加UserInfo
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static int AddUser(UserInfo user)
{
string sql = @"INSERT INTO [User]
([Name],[NickName],[Password],[RoleId],[Sex],[Email])
VALUES
(@Name,@NickName,@Password,@RoleId,@Sex,@Email)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Name", user.Name, DbType.String);
par.Add("@NickName", user.NickName, DbType.String);
par.Add("@Password", user.Password, DbType.AnsiString);
par.Add("@RoleId", user.RoleId, DbType.Int32);
par.Add("@Sex", user.Sex, DbType.Int16);
par.Add("@Email", user.Email, DbType.AnsiString);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加UserScoreLogInfo
/// </summary>
/// <param name="userscorelog"></param>
/// <returns></returns>
public static long AddUserScoreLog(UserScoreLogInfo userscorelog)
{
string sql = @"INSERT INTO [UserScoreLog]
([UserId],[Score],[CreateTime],[Describe],[OldScore],[NewScore])
VALUES
(@UserId,@Score,@CreateTime,@Describe,@OldScore,@NewScore)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@UserId", userscorelog.UserId, DbType.Int32);
par.Add("@Score", userscorelog.Score, DbType.Int32);
par.Add("@CreateTime", userscorelog.CreateTime, DbType.DateTime);
par.Add("@Describe", userscorelog.Describe, DbType.String);
par.Add("@OldScore", userscorelog.OldScore, DbType.Int64);
par.Add("@NewScore", userscorelog.NewScore, DbType.Int64);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加ArticleTypeInfo
/// </summary>
/// <param name="articletype"></param>
/// <returns></returns>
public static int AddArticleType(ArticleTypeInfo articletype)
{
string sql = @"INSERT INTO [ArticleType]
([Name],[PId],[Sort],[PinYin],[IsHomeMenu],[Ico],[IsShow])
VALUES
(@Name,@PId,@Sort,@PinYin,@IsHomeMenu,@Ico,@IsShow)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Name", articletype.Name, DbType.AnsiString);
par.Add("@PId", articletype.PId, DbType.Int32);
par.Add("@Sort", articletype.Sort, DbType.Int32);
par.Add("@PinYin", articletype.PinYin, DbType.AnsiString);
par.Add("@IsHomeMenu", articletype.IsHomeMenu, DbType.Boolean);
par.Add("@Ico", articletype.Ico, DbType.AnsiString);
par.Add("@IsShow", articletype.IsShow, DbType.Boolean);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加UserAccessLogInfo
/// </summary>
/// <param name="useraccesslog"></param>
/// <returns></returns>
public static long AddUserAccessLog(UserAccessLogInfo useraccesslog)
{
string sql = @"INSERT INTO [UserAccessLog]
([Url],[Referer],[UserAgent],[UserId],[Ip],[InsertTime],[Other],[Type])
VALUES
(@Url,@Referer,@UserAgent,@UserId,@Ip,@InsertTime,@Other,@Type)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Url", useraccesslog.Url, DbType.AnsiString);
par.Add("@Referer", useraccesslog.Referer, DbType.AnsiString);
par.Add("@UserAgent", useraccesslog.UserAgent, DbType.AnsiString);
par.Add("@UserId", useraccesslog.UserId, DbType.Int32);
par.Add("@Ip", useraccesslog.Ip, DbType.AnsiString);
par.Add("@InsertTime", useraccesslog.InsertTime, DbType.DateTime);
par.Add("@Other", useraccesslog.Other, DbType.String);
par.Add("@Type", useraccesslog.Type, DbType.Int16);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加NotifyInfo
/// </summary>
/// <param name="notify"></param>
/// <returns></returns>
public static long AddNotify(NotifyInfo notify)
{
string sql = @"INSERT INTO [Notify]
([FromUserId],[ToUserId],[CreateTime],[IsDelete],[IsRead],[IsSystem],[Content],[Title])
VALUES
(@FromUserId,@ToUserId,@CreateTime,@IsDelete,@IsRead,@IsSystem,@Content,@Title)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@FromUserId", notify.FromUserId, DbType.Int32);
par.Add("@ToUserId", notify.ToUserId, DbType.Int32);
par.Add("@CreateTime", notify.CreateTime, DbType.DateTime);
par.Add("@IsDelete", notify.IsDelete, DbType.Boolean);
par.Add("@IsRead", notify.IsRead, DbType.Boolean);
par.Add("@IsSystem", notify.IsSystem, DbType.Boolean);
par.Add("@Content", notify.Content, DbType.String);
par.Add("@Title", notify.Title, DbType.String);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加ArticleInfo
/// </summary>
/// <param name="article"></param>
/// <returns></returns>
public static long AddArticle(ArticleInfo article)
{
string sql = @"INSERT INTO [Article]
([Title],[Content],[Type],[UserId],[ImgNum],[AttachmentNum],[LastEditUserId],[Guid],[State])
VALUES
(@Title,@Content,@Type,@UserId,@ImgNum,@AttachmentNum,@LastEditUserId,@Guid,@State)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Title", article.Title, DbType.String);
par.Add("@Content", article.Content, DbType.AnsiString);
par.Add("@Type", article.Type, DbType.Int32);
par.Add("@UserId", article.UserId, DbType.Int32);
par.Add("@ImgNum", article.ImgNum, DbType.Int32);
par.Add("@AttachmentNum", article.AttachmentNum, DbType.Int32);
par.Add("@LastEditUserId", article.LastEditUserId, DbType.Int32);
par.Add("@Guid", article.Guid, DbType.Guid);
par.Add("@State", article.State, DbType.Int16);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加ModulInfo
/// </summary>
/// <param name="modul"></param>
/// <returns></returns>
public static int AddModul(ModulInfo modul)
{
string sql = @"INSERT INTO Modul
([ModulName],[Controller],[Action],[Description],[PId],[OrderId],[IsShow],[Priority],[IsDisplay],[Ico])
VALUES
(@ModulName,@Controller,@Action,@Description,@PId,@OrderId,@IsShow,@Priority,@IsDisplay,@Ico)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@ModulName", modul.ModulName, DbType.String);
par.Add("@Controller", modul.Controller, DbType.AnsiString);
par.Add("@Action", modul.Action, DbType.AnsiString);
par.Add("@Description", modul.Description, DbType.String);
par.Add("@PId", modul.PId, DbType.Int32);
par.Add("@OrderId", modul.OrderId, DbType.Int32);
par.Add("@IsShow", modul.IsShow, DbType.Boolean);
par.Add("@Priority", modul.Priority, DbType.Int32);
par.Add("@IsDisplay", modul.IsDisplay, DbType.Boolean);
par.Add("@Ico", modul.Ico, DbType.AnsiString);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加EmailTemplateInfo
/// </summary>
/// <param name="emailtemplate"></param>
/// <returns></returns>
public static int AddEmailTemplate(EmailTemplateInfo emailtemplate)
{
string sql = @"INSERT INTO [EmailTemplate]
([Title],[Template],[ValueIdentifier],[Explanation],[IsSystem],[IsHtml],[CreateTime],[UserId],[LastEditUserId],[LastEditTime])
VALUES
(@Title,@Template,@ValueIdentifier,@Explanation,@IsSystem,@IsHtml,@CreateTime,@UserId,@LastEditUserId,@LastEditTime)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Title", emailtemplate.Title, DbType.String);
par.Add("@Template", emailtemplate.Template, DbType.AnsiString);
par.Add("@ValueIdentifier", emailtemplate.ValueIdentifier, DbType.String);
par.Add("@Explanation", emailtemplate.Explanation, DbType.String);
par.Add("@IsSystem", emailtemplate.IsSystem, DbType.Boolean);
par.Add("@IsHtml", emailtemplate.IsHtml, DbType.Boolean);
par.Add("@CreateTime", emailtemplate.CreateTime, DbType.DateTime);
par.Add("@UserId", emailtemplate.UserId, DbType.Int32);
par.Add("@LastEditUserId", emailtemplate.LastEditUserId, DbType.Int32);
par.Add("@LastEditTime", emailtemplate.LastEditTime, DbType.DateTime);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加SendMailLogInfo
/// </summary>
/// <param name="sendmaillog"></param>
/// <returns></returns>
public static long AddSendMailLog(SendMailLogInfo sendmaillog)
{
string sql = @"INSERT INTO [SendMailLog]
([UserId],[SendUserId],[TemplateId],[ToEmail],[FromEmail],[Status],[Title],[Body],[Ip],[IsSystem])
VALUES
(@UserId,@SendUserId,@TemplateId,@ToEmail,@FromEmail,@Status,@Title,@Body,@Ip,@IsSystem)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@UserId", sendmaillog.UserId, DbType.Int32);
par.Add("@SendUserId", sendmaillog.SendUserId, DbType.Int32);
par.Add("@TemplateId", sendmaillog.TemplateId, DbType.Int32);
par.Add("@ToEmail", sendmaillog.ToEmail, DbType.AnsiString);
par.Add("@FromEmail", sendmaillog.FromEmail, DbType.AnsiString);
par.Add("@Status", sendmaillog.Status, DbType.Int16);
par.Add("@Title", sendmaillog.Title, DbType.String);
par.Add("@Body", sendmaillog.Body, DbType.AnsiString);
par.Add("@Ip", sendmaillog.Ip, DbType.AnsiString);
par.Add("@IsSystem", sendmaillog.IsSystem, DbType.Boolean);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
