/// <summary> /// 新增 /// </summary> /// <param name="flowAuthRoleEntity"></param> /// <returns></returns> public bool AddFlowAuthRole(FlowAuthRoleEntity flowAuthRoleEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @ActionID"); sqlCommandText.Append(", @RoleID"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.FlowAuthRole ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, flowAuthRoleEntity.JournalID); db.AddInParameter(cmd, "@ActionID", DbType.Int64, flowAuthRoleEntity.ActionID); db.AddInParameter(cmd, "@RoleID", DbType.Int64, flowAuthRoleEntity.RoleID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
/// <summary> /// 新增审稿单项 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddReviewBill(ReviewBillEntity model) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @Title"); sqlCommandText.Append(", @ItemType"); sqlCommandText.Append(", @PItemID"); sqlCommandText.Append(", @SortID"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.ReviewBill ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID); db.AddInParameter(cmd, "@Title", DbType.AnsiString, model.Title.TextFilter()); db.AddInParameter(cmd, "@ItemType", DbType.Byte, model.ItemType); db.AddInParameter(cmd, "@PItemID", DbType.Int64, model.PItemID); db.AddInParameter(cmd, "@SortID", DbType.Int32, model.SortID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
/// <summary> /// 得到投稿自动分配配置 /// </summary> /// <param name="autoAllotQuery"></param> /// <returns></returns> public EditorAutoAllotEntity GetEditorAutoAllot(EditorAutoAllotQuery autoAllotQuery) { EditorAutoAllotEntity editorAutoAllotEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 PKID,JournalID,AllotPattern,AuthorID,OddAuthorID,AddDate FROM dbo.EditorAutoAllot WITH(NOLOCK)"); sqlCommandText.Append(" WHERE JournalID=@JournalID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@JournalID", DbType.Int64, autoAllotQuery.JournalID); using (IDataReader dr = db.ExecuteReader(cmd)) { editorAutoAllotEntity = MakeEditorAutoAllot(dr); if (editorAutoAllotEntity != null) { // 如果是按照学科分类设置,则取学科分类的明细 if (editorAutoAllotEntity.AllotPattern == 1) { editorAutoAllotEntity.SubjectAuthorMap = new List <SubjectAuthorMapEntity>(); StringBuilder sqlGetSubjectCategoryText = new StringBuilder(); sqlGetSubjectCategoryText.Append("SELECT SubjectCategoryID,AuthorID FROM dbo.SubjectAuthorMap WITH(NOLOCK)"); sqlGetSubjectCategoryText.Append(" WHERE JournalID=@JournalID"); DbCommand cmdGetSubjectCategory = db.GetSqlStringCommand(sqlGetSubjectCategoryText.ToString()); db.AddInParameter(cmdGetSubjectCategory, "@JournalID", DbType.Int64, autoAllotQuery.JournalID); using (IDataReader drSubject = db.ExecuteReader(cmdGetSubjectCategory)) { SubjectAuthorMapEntity subjectMap = null; while (drSubject.Read()) { subjectMap = new SubjectAuthorMapEntity(); subjectMap.SubjectCategoryID = TypeParse.ToInt(drSubject["SubjectCategoryID"]); subjectMap.AuthorID = TypeParse.ToInt(drSubject["AuthorID"]); subjectMap.JournalID = autoAllotQuery.JournalID; editorAutoAllotEntity.SubjectAuthorMap.Add(subjectMap); } drSubject.Close(); } } } dr.Close(); } return(editorAutoAllotEntity); }
/// <summary> /// 获取令牌 /// </summary> /// <param name="tokenID"></param> /// <returns></returns> public TokenEntity GetToken(TokenQuery tokenQuery) { TokenEntity tokenEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 TokenID,AuthorID,Token,Type,AddDate FROM dbo.Token WITH(NOLOCK)"); sqlCommandText.Append(" WHERE JournalID=@JournalID AND AuthorID=@AuthorID AND AddDate>=@ExpireDate"); if (!string.IsNullOrEmpty(tokenQuery.Token)) { sqlCommandText.Append(" AND Token=@Token"); } if (tokenQuery.Type > 0) { sqlCommandText.Append(" AND Type=@Type"); } DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@JournalID", DbType.Int64, tokenQuery.JournalID); db.AddInParameter(cmd, "@AuthorID", DbType.Int64, tokenQuery.AuthorID); if (!string.IsNullOrEmpty(tokenQuery.Token)) { db.AddInParameter(cmd, "@Token", DbType.String, tokenQuery.Token); } if (tokenQuery.Type > 0) { db.AddInParameter(cmd, "@Type", DbType.Int16, tokenQuery.Type); } db.AddInParameter(cmd, "@ExpireDate", DbType.DateTime, tokenQuery.ExpireDate); using (IDataReader dr = db.ExecuteReader(cmd)) { if (dr.Read()) { tokenEntity = new TokenEntity(); tokenEntity.TokenID = (Int64)dr["TokenID"]; tokenEntity.AuthorID = (Int64)dr["AuthorID"]; tokenEntity.Token = (String)dr["Token"]; tokenEntity.Type = (Byte)dr["Type"]; tokenEntity.AddDate = (DateTime)dr["AddDate"]; } dr.Close(); } return(tokenEntity); }
public NoticeContentEntity GetNoticeContent(string dicKey) { NoticeContentEntity dictEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 DicID,DicKey,Content,AddTime,UpdateTime FROM dbo.NoticeContent WITH(NOLOCK)"); sqlCommandText.Append(" WHERE DicKey=@DicKey"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@DicKey", DbType.String, dicKey); using (IDataReader dr = db.ExecuteReader(cmd)) { dictEntity = MakeDict(dr); } return(dictEntity); }
public IssueViewLogEntity GetIssueViewLog(Int64 viewLogID) { IssueViewLogEntity issueViewLogEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 ViewLogID,JournalID,ContentID,AuthorID,Daytime,Year,Month,IP,AddDate FROM dbo.IssueViewLog WITH(NOLOCK)"); sqlCommandText.Append(" WHERE ViewLogID=@ViewLogID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@ViewLogID", DbType.Int64, viewLogID); using (IDataReader dr = db.ExecuteReader(cmd)) { issueViewLogEntity = MakeIssueViewLog(dr); } return(issueViewLogEntity); }
/// <summary> /// 添加审稿单 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddReviewBillContent(ReviewBillContentEntity model, DbTransaction trans = null) { StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @CID"); sqlCommandText.Append(", @JournalID"); sqlCommandText.Append(", @ItemID"); sqlCommandText.Append(", @ContentValue"); sqlCommandText.Append(", @IsChecked"); sqlCommandText.Append(", @AddUser"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.ReviewBillContent ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@ItemContentID", DbType.Int64, model.ItemContentID); db.AddInParameter(cmd, "@CID", DbType.Int64, model.CID); db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID); db.AddInParameter(cmd, "@ItemID", DbType.AnsiString, model.ItemID); db.AddInParameter(cmd, "@ContentValue", DbType.AnsiString, model.ContentValue); db.AddInParameter(cmd, "@IsChecked", DbType.Boolean, model.IsChecked); db.AddInParameter(cmd, "@AddUser", DbType.Int64, model.AddUser); try { bool result = false; if (trans == null) { result = db.ExecuteNonQuery(cmd) > 0; } else { result = db.ExecuteNonQuery(cmd, trans) > 0; } if (!result) { throw new Exception("新增审稿单失败!"); } return(result); } catch (Exception ex) { throw ex; } }
public MessageTemplateEntity GetMessageTemplate(Int64 templateID) { MessageTemplateEntity messageTemplateEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 TemplateID,JournalID,TType,Title,TContent,TCategory,EditUser,EditDate,InUser,AddDate FROM dbo.MessageTemplate WITH(NOLOCK)"); sqlCommandText.Append(" WHERE TemplateID=@TemplateID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@TemplateID", DbType.Int64, templateID); using (IDataReader dr = db.ExecuteReader(cmd)) { messageTemplateEntity = MakeMessageTemplate(dr); } return(messageTemplateEntity); }
public ContactWayEntity GetContactWay(Int64 contactID) { ContactWayEntity contactWayEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 ContactID,JournalID,ChannelID,Company,LinkMan,Address,ZipCode,Tel,Fax,AddDate FROM dbo.ContactWay WITH(NOLOCK)"); sqlCommandText.Append(" WHERE ContactID=@ContactID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@ContactID", DbType.Int64, contactID); using (IDataReader dr = db.ExecuteReader(cmd)) { contactWayEntity = MakeContactWay(dr); } return(contactWayEntity); }
public DBServerInfoEntity GetDBServerInfo(Int32 dBServerID) { DBServerInfoEntity dBServerInfoEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 DBServerID,ServerIP,Port,Account,Pwd,Note,Status,AddDate FROM dbo.DBServerInfo WITH(NOLOCK)"); sqlCommandText.Append(" WHERE DBServerID=@DBServerID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@DBServerID", DbType.Int32, dBServerID); using (IDataReader dr = db.ExecuteReader(cmd)) { dBServerInfoEntity = MakeDBServerInfo(dr); } return(dBServerInfoEntity); }
public ApiServerInfoEntity GetApiServerInfo(Int32 apiServerID) { ApiServerInfoEntity apiServerInfoEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 ApiServerID,SiteName,SiteUrl,Status,Note,AddDate FROM dbo.ApiServerInfo WITH(NOLOCK)"); sqlCommandText.Append(" WHERE ApiServerID=@ApiServerID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@ApiServerID", DbType.Int32, apiServerID); using (IDataReader dr = db.ExecuteReader(cmd)) { apiServerInfoEntity = MakeApiServerInfo(dr); } return(apiServerInfoEntity); }
public GuestbookEntity GetGuestbook(Int64 messageID) { GuestbookEntity guestbookEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 MessageID,JournalID,PMessageID,UserName,Email,Tel,Title,MessageContent,IP,AddDate FROM dbo.Guestbook WITH(NOLOCK)"); sqlCommandText.Append(" WHERE MessageID=@MessageID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@MessageID", DbType.Int64, messageID); using (IDataReader dr = db.ExecuteReader(cmd)) { guestbookEntity = MakeGuestbook(dr); } return(guestbookEntity); }
public FinancePayDetailEntity GetFinancePayDetail(Int64 billID) { FinancePayDetailEntity financePayDetailEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 BillID,JournalID,AuthorID,EBankType,TransactionID,TotalFee,Currency,IsInCome,PayType,PayStatus,PayDate,ProductTable,ProductID,ProductDes,UserAccount,BankID,BankNo,AddDate FROM dbo.FinancePayDetail WITH(NOLOCK)"); sqlCommandText.Append(" WHERE BillID=@BillID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@BillID", DbType.Int64, billID); using (IDataReader dr = db.ExecuteReader(cmd)) { financePayDetailEntity = MakeFinancePayDetail(dr); } return(financePayDetailEntity); }
public DictEntity GetDict(Int64 dictID) { DictEntity dictEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 DictID,JournalID,DictKey,Note,InUserID,EditUserID,EditDate,AddDate FROM dbo.Dict WITH(NOLOCK)"); sqlCommandText.Append(" WHERE DictID=@DictID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@DictID", DbType.Int64, dictID); using (IDataReader dr = db.ExecuteReader(cmd)) { dictEntity = MakeDict(dr); } return(dictEntity); }
public RoleInfoEntity GetRoleInfo(Int64 roleID) { RoleInfoEntity roleInfoEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 RoleID,JournalID,RoleName,Note,GroupID,AddDate FROM dbo.RoleInfo WITH(NOLOCK)"); sqlCommandText.Append(" WHERE RoleID=@RoleID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@RoleID", DbType.Int64, roleID); using (IDataReader dr = db.ExecuteReader(cmd)) { roleInfoEntity = MakeRoleInfo(dr); } return(roleInfoEntity); }
/// <summary> /// 新增内容块 /// </summary> /// <param name="SiteResourceEntity"></param> /// <returns></returns> public bool AddSiteBlock(SiteBlockEntity model) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @ChannelID"); sqlCommandText.Append(", @Title"); sqlCommandText.Append(", @Linkurl"); sqlCommandText.Append(", @TitlePhoto"); sqlCommandText.Append(", @Note"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.SiteBlock ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID); db.AddInParameter(cmd, "@ChannelID", DbType.Int64, model.ChannelID); db.AddInParameter(cmd, "@Title", DbType.AnsiString, model.Title); db.AddInParameter(cmd, "@Linkurl", DbType.AnsiString, model.Linkurl); db.AddInParameter(cmd, "@TitlePhoto", DbType.AnsiString, model.TitlePhoto); db.AddInParameter(cmd, "@Note", DbType.AnsiString, model.Note); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public FlowNodeConditionEntity GetFlowNodeCondition(Int64 flowConditionID) { FlowNodeConditionEntity flowNodeConditionEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 FlowConditionID,JournalID,OperationID,ConditionType,ConditionExp,AddDate FROM dbo.FlowNodeCondition WITH(NOLOCK)"); sqlCommandText.Append(" WHERE FlowConditionID=@FlowConditionID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@FlowConditionID", DbType.Int64, flowConditionID); using (IDataReader dr = db.ExecuteReader(cmd)) { flowNodeConditionEntity = MakeFlowNodeCondition(dr); } return(flowNodeConditionEntity); }
/// <summary> /// 获取资源实体 /// </summary> /// <param name="ResourceID"></param> /// <returns></returns> public SiteResourceEntity GetSiteResourceModel(SiteResourceQuery query) { SiteResourceEntity item = null; string strSql = string.Format("SELECT TOP 1 * FROM dbo.SiteResource with(nolock) WHERE ResourceID=@ResourceID AND JournalID=@JournalID"); DbCommand cmd = db.GetSqlStringCommand(strSql); db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID); db.AddInParameter(cmd, "@ResourceID", DbType.Int64, query.ResourceID); using (IDataReader dr = db.ExecuteReader(cmd)) { if (dr.Read()) { item = MakeSiteResourceModel(dr); } } return(item); }
public SiteConfigEntity GetSiteConfig(Int64 siteConfigID) { SiteConfigEntity siteConfigEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 * FROM dbo.SiteConfig WITH(NOLOCK)"); sqlCommandText.Append(" WHERE SiteConfigID=@SiteConfigID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@SiteConfigID", DbType.Int64, siteConfigID); using (IDataReader dr = db.ExecuteReader(cmd)) { siteConfigEntity = MakeSiteConfig(dr); } return(siteConfigEntity); }
public MenuEntity GetMenu(Int64 menuID) { MenuEntity menuEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 MenuID,JournalID,PMenuID,MenuName,MenuUrl,IconUrl,SortID,MenuType,GroupID,Status,IsContentMenu,AddDate FROM dbo.Menu WITH(NOLOCK)"); sqlCommandText.Append(" WHERE MenuID=@MenuID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@MenuID", DbType.Int64, menuID); using (IDataReader dr = db.ExecuteReader(cmd)) { menuEntity = MakeMenu(dr); } return(menuEntity); }
public PayNoticeEntity GetPayNotice(Int64 noticeID) { PayNoticeEntity payNoticeEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT top 1 a.*,b.Title as CTitle,b.CNumber FROM dbo.PayNotice a with(nolock) INNER JOIN dbo.ContributionInfo b with(nolock) ON a.JournalID=b.JournalID and a.CID=b.CID"); sqlCommandText.Append(" WHERE a.NoticeID=@NoticeID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@NoticeID", DbType.Int64, noticeID); using (IDataReader dr = db.ExecuteReader(cmd)) { payNoticeEntity = MakePayNotice(dr); } return(payNoticeEntity); }
public JournalInfoEntity GetJournalInfo(Int64 journalID) { JournalInfoEntity journalInfoEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 JournalID,JournalName,SiteUrl,ServiceStartDate,ServiceEndDate,Linkman,LinkTel,Fax,Email,Mobile,Address,ZipCode,AuthorizationCode,Status,Note,AddDate FROM dbo.JournalInfo WITH(NOLOCK)"); sqlCommandText.Append(" WHERE JournalID=@JournalID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@JournalID", DbType.Int64, journalID); using (IDataReader dr = db.ExecuteReader(cmd)) { journalInfoEntity = MakeJournalInfo(dr); } return(journalInfoEntity); }
/// <summary> /// 新增友情链接 /// </summary> /// <param name="siteNoticeEntity"></param> /// <returns></returns> public bool AddFriendlyLink(FriendlyLinkEntity model) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @ChannelID"); sqlCommandText.Append(", @SiteName"); sqlCommandText.Append(", @SiteUrl"); sqlCommandText.Append(", @LogoUrl"); sqlCommandText.Append(", @LinkType"); sqlCommandText.Append(", @SortID"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.FriendlyLink ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID); db.AddInParameter(cmd, "@ChannelID", DbType.Int64, model.ChannelID); db.AddInParameter(cmd, "@SiteName", DbType.AnsiString, model.SiteName); db.AddInParameter(cmd, "@SiteUrl", DbType.AnsiString, model.SiteUrl); db.AddInParameter(cmd, "@LogoUrl", DbType.AnsiString, model.LogoUrl); db.AddInParameter(cmd, "@LinkType", DbType.Byte, model.LinkType); db.AddInParameter(cmd, "@SortID", DbType.Int32, model.SortID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public RoleAuthorEntity GetRoleAuthor(Int64 mapID) { RoleAuthorEntity roleAuthorEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 MapID,JournalID,RoleID,AuthorID,AddDate FROM dbo.RoleAuthor WITH(NOLOCK)"); sqlCommandText.Append(" WHERE MapID=@MapID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@MapID", DbType.Int64, mapID); using (IDataReader dr = db.ExecuteReader(cmd)) { roleAuthorEntity = MakeRoleAuthor(dr); } return(roleAuthorEntity); }
/// <summary> /// 新增资讯 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddSiteContent(SiteContentEntity model) { StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @ChannelID"); sqlCommandText.Append(", @Title"); sqlCommandText.Append(", @Linkurl"); sqlCommandText.Append(", @TitleColor"); sqlCommandText.Append(", @IsBold"); sqlCommandText.Append(", @IsItalic"); sqlCommandText.Append(", @Source"); sqlCommandText.Append(", @Author"); sqlCommandText.Append(", @Tags"); sqlCommandText.Append(", @Abstruct"); sqlCommandText.Append(", @TitlePhoto"); sqlCommandText.Append(", @FJPath"); sqlCommandText.Append(", @SortID"); sqlCommandText.Append(", @InAuthor"); using (DbConnection conn = db.CreateConnection()) { if (conn.State != ConnectionState.Open) { conn.Open(); } DbTransaction trans = conn.BeginTransaction(); try { DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.SiteContent ({0},AddDate) VALUES ({1},getdate());select SCOPE_IDENTITY();", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID); db.AddInParameter(cmd, "@ChannelID", DbType.Int64, model.ChannelID); db.AddInParameter(cmd, "@Title", DbType.AnsiString, model.Title); db.AddInParameter(cmd, "@Linkurl", DbType.AnsiString, model.Linkurl); db.AddInParameter(cmd, "@TitleColor", DbType.AnsiString, model.TitleColor); db.AddInParameter(cmd, "@IsBold", DbType.Boolean, model.IsBold); db.AddInParameter(cmd, "@IsItalic", DbType.Boolean, model.IsItalic); db.AddInParameter(cmd, "@Source", DbType.AnsiString, model.Source); db.AddInParameter(cmd, "@Author", DbType.AnsiString, model.Author); db.AddInParameter(cmd, "@Tags", DbType.AnsiString, model.Tags); db.AddInParameter(cmd, "@Abstruct", DbType.AnsiString, model.Abstruct); db.AddInParameter(cmd, "@TitlePhoto", DbType.AnsiString, model.TitlePhoto); db.AddInParameter(cmd, "@FJPath", DbType.AnsiString, model.FJPath); db.AddInParameter(cmd, "@SortID", DbType.Int32, model.SortID); db.AddInParameter(cmd, "@InAuthor", DbType.AnsiString, model.InAuthor); Int64 ContentID = db.ExecuteScalar(cmd, trans).TryParse <Int64>(); if (ContentID == 0) { trans.Rollback(); return(false); } cmd = db.GetSqlStringCommand("INSERT INTO dbo.SiteContentAtt(ContentID,Content) VALUES(@ContentID,@Content)"); db.AddInParameter(cmd, "@ContentID", DbType.Int64, ContentID); db.AddInParameter(cmd, "@Content", DbType.String, model.Content); if (db.ExecuteNonQuery(cmd, trans) < 1) { trans.Rollback(); return(false); } trans.Commit(); conn.Close(); return(true); } catch (SqlException sqlEx) { trans.Rollback(); throw sqlEx; } } }
public MessageRecodeEntity GetMessageRecode(MessageRecodeQuery query) { MessageRecodeEntity messageRecodeEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 * FROM dbo.MessageRecode WITH(NOLOCK)"); sqlCommandText.Append(" WHERE RecodeID=@RecodeID AND JournalID=@JournalID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@RecodeID", DbType.Int64, query.RecodeID); db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID); using (IDataReader dr = db.ExecuteReader(cmd)) { messageRecodeEntity = MakeMessageRecode(dr); } return(messageRecodeEntity); }
public JournalSetInfoEntity GetJournalSetInfo(Int32 setID) { JournalSetInfoEntity journalSetInfoEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 SetID,JournalID,ApiSiteID,DBServerID,AddDate FROM dbo.JournalSetInfo WITH(NOLOCK)"); sqlCommandText.Append(" WHERE SetID=@SetID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@SetID", DbType.Int32, setID); using (IDataReader dr = db.ExecuteReader(cmd)) { journalSetInfoEntity = MakeJournalSetInfo(dr); } return(journalSetInfoEntity); }
public SiteNoticeEntity GetSiteNotice(Int64 noticeID) { SiteNoticeEntity siteNoticeEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 DesID,JournalID,ChannelID,Title,Keywords,Description,Content,FjPath,AddDate FROM dbo.SiteDescribe WITH(NOLOCK)"); sqlCommandText.Append(" WHERE DesID=@DesID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@DesID", DbType.Int64, noticeID); using (IDataReader dr = db.ExecuteReader(cmd)) { siteNoticeEntity = MakeSiteNotice(dr); } return(siteNoticeEntity); }
public SysAccountInfoEntity GetSysAccountInfo(Int32 adminID) { SysAccountInfoEntity sysAccountInfoEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 AdminID,UserName,LoginName,Pwd,Gender,Email,Mobile,Status,LastIP,LoginDate,LogOnTimes,AddDate FROM dbo.SysAccountInfo WITH(NOLOCK)"); sqlCommandText.Append(" WHERE AdminID=@AdminID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@AdminID", DbType.Int32, adminID); using (IDataReader dr = db.ExecuteReader(cmd)) { sysAccountInfoEntity = MakeSysAccountInfo(dr); } return(sysAccountInfoEntity); }
public bool AddSiteChannel(SiteChannelEntity siteChannelEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @PChannelID"); sqlCommandText.Append(", @ContentType"); sqlCommandText.Append(", @IsNav"); sqlCommandText.Append(", @Keywords"); sqlCommandText.Append(", @Description"); sqlCommandText.Append(", @ChannelUrl"); sqlCommandText.Append(", @SortID"); sqlCommandText.Append(", @Status"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.SiteChannel ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, siteChannelEntity.JournalID); db.AddInParameter(cmd, "@PChannelID", DbType.Int64, siteChannelEntity.PChannelID); db.AddInParameter(cmd, "@ContentType", DbType.Byte, siteChannelEntity.ContentType); db.AddInParameter(cmd, "@IsNav", DbType.Byte, siteChannelEntity.IsNav); db.AddInParameter(cmd, "@Keywords", DbType.AnsiString, siteChannelEntity.Keywords); db.AddInParameter(cmd, "@Description", DbType.AnsiString, siteChannelEntity.Description); db.AddInParameter(cmd, "@ChannelUrl", DbType.AnsiString, siteChannelEntity.ChannelUrl); db.AddInParameter(cmd, "@SortID", DbType.Int32, siteChannelEntity.SortID); db.AddInParameter(cmd, "@Status", DbType.Byte, siteChannelEntity.Status); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }