/// <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); }
/// <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); }