private void SendNotice() { string RongUserId = ReStr("RongUserId", ""); if (RongUserId == "") { throw new Exception("RongUserId(发送方)不能为空!"); } decimal MerId = ReDecimal("MerId", 0); if (MerId == 0) { throw new Exception("MerId不能为0!"); } Model.NoticeModel model = new NoticeModel(); model.CreateTime = DateTime.Now; model.Extra = ReStr("Extra", "{}"); model.NoticeContent = ReStr("NoticeContent", ""); model.NoticeTitle = ReStr("NoticeTitle", ""); model.NoticeType = ReStr("NoticeType", "system"); model.RongUserId = RongUserId; BLL.CommBLL bll = new BLL.CommBLL(); string TargetIds = ReStr("TargetIds", ""); if (TargetIds.Trim() == "") { throw new Exception("TargetIds不能为空! "); } List <Model.NoticeTargetModel> TargetModelList = new List <NoticeTargetModel>(); string[] TargetArray = TargetIds.Split(','); foreach (string TargetId in TargetArray) { Model.NoticeTargetModel TargetModel = new NoticeTargetModel(); TargetModel.NoticeId = 0; TargetModel.TargetId = TargetId; TargetModel.NoticeStatus = 0; //未发送 TargetModelList.Add(TargetModel); } bll.SendNotice(model, TargetModelList, MerId); ReTrue(); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(NoticeTargetModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YYHD.dbo.NoticeTarget ("); strSql.Append("NoticeId,TargetId,NoticeStatus"); strSql.Append(") values ("); strSql.Append("@NoticeId,@TargetId,@NoticeStatus"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@NoticeId", SqlDbType.Decimal, 9), new SqlParameter("@TargetId", SqlDbType.VarChar, 50), new SqlParameter("@NoticeStatus", SqlDbType.Int, 4) }; parameters[0].Value = model.NoticeId; parameters[1].Value = model.TargetId; parameters[2].Value = model.NoticeStatus; bool result = false; try { helper.ExecSqlReInt(strSql.ToString(), parameters); result = true; } catch (Exception ex) { this.helper.Close(); throw ex; } finally { } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoticeTargetModel GetModel(decimal NoticeId, string TargetId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select NoticeId, TargetId, NoticeStatus "); strSql.Append(" from YYHD.dbo.NoticeTarget "); strSql.Append(" where NoticeId=@NoticeId and TargetId=@TargetId "); SqlParameter[] parameters = { new SqlParameter("@NoticeId", SqlDbType.Decimal, 9), new SqlParameter("@TargetId", SqlDbType.VarChar, 50) }; parameters[0].Value = NoticeId; parameters[1].Value = TargetId; NoticeTargetModel model = new NoticeTargetModel(); DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["NoticeId"].ToString() != "") { model.NoticeId = decimal.Parse(ds.Tables[0].Rows[0]["NoticeId"].ToString()); } model.TargetId = ds.Tables[0].Rows[0]["TargetId"].ToString(); if (ds.Tables[0].Rows[0]["NoticeStatus"].ToString() != "") { model.NoticeStatus = int.Parse(ds.Tables[0].Rows[0]["NoticeStatus"].ToString()); } return(model); } else { return(model); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(NoticeTargetModel model) { bool reValue = true; int reCount = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("update YYHD.dbo.NoticeTarget set "); strSql.Append(" NoticeId = @NoticeId , "); strSql.Append(" TargetId = @TargetId , "); strSql.Append(" NoticeStatus = @NoticeStatus "); strSql.Append(" where NoticeId=@NoticeId and TargetId=@TargetId "); SqlParameter[] parameters = { new SqlParameter("@NoticeId", SqlDbType.Decimal, 9), new SqlParameter("@TargetId", SqlDbType.VarChar, 50), new SqlParameter("@NoticeStatus", SqlDbType.Int, 4) }; parameters[0].Value = model.NoticeId; parameters[1].Value = model.TargetId; parameters[2].Value = model.NoticeStatus; try {//异常处理 reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters); } catch (Exception ex) { this.helper.Close(); throw ex; } if (reCount <= 0) { reValue = false; } return(reValue); }