Example #1
0
 /// <summary>
 /// 增加一条回复
 /// </summary>
 public bool AddNoticeReply(Model.GovStructure.MGovNoticeReply model)
 {
     if (model != null && !string.IsNullOrEmpty(model.NoticeId) && !string.IsNullOrEmpty(model.OperatorId))
     {
         model.ItemId = Guid.NewGuid().ToString();
         bool result = dal.AddNoticeReply(model);
         if (result)
         {
             SysStructure.BSysLogHandle.Insert("增加一条回复信息:编号为:" + model.NoticeId);
         }
         return(result);
     }
     return(false);
 }
Example #2
0
        /// <summary>
        /// 增加一条回复
        /// </summary>
        public bool AddNoticeReply(Model.GovStructure.MGovNoticeReply model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into tbl_GovNoticeReply(");
            strSql.Append("ItemId,NoticeId,OperatorId,OperatorName,ReplyInfo,IssueTime)");
            strSql.Append(" values (");
            strSql.Append("@ItemId,@NoticeId,@OperatorId,@OperatorName,@ReplyInfo,@IssueTime)");

            DbCommand dc = this._db.GetSqlStringCommand(strSql.ToString());

            this._db.AddInParameter(dc, "ItemId", DbType.AnsiStringFixedLength, model.ItemId);
            this._db.AddInParameter(dc, "NoticeId", DbType.AnsiStringFixedLength, model.NoticeId);
            this._db.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId);
            this._db.AddInParameter(dc, "OperatorName", DbType.String, model.OperatorName);
            this._db.AddInParameter(dc, "ReplyInfo", DbType.String, model.ReplyInfo);
            this._db.AddInParameter(dc, "IssueTime", DbType.DateTime, model.IssueTime);
            return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false);
        }