public int AddTeteUserMsg(TeteUserMsgInfo teteusermsg) { string sql = "insert TeteUserMsg values(@title,@html,@adddate,@nick,@isread,@token)"; SqlParameter[] param = CreateParameter(teteusermsg); return(DBHelper.ExecuteNonQuery(sql, param)); }
public int ModifyTeteUserMsg(TeteUserMsgInfo teteusermsg) { string sql = "update TeteUserMsg set title=@title,html=@html,adddate=@adddate,nick=@nick,isread=@isread,token=@token where id=@id"; SqlParameter[] param = CreateParameter(teteusermsg); return(DBHelper.ExecuteNonQuery(sql, param)); }
private SqlParameter[] CreateParameter(TeteUserMsgInfo teteusermsg) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@id", teteusermsg.Id), new SqlParameter("@title", teteusermsg.Title), new SqlParameter("@html", teteusermsg.Html), new SqlParameter("@adddate", teteusermsg.Adddate), new SqlParameter("@nick", teteusermsg.Nick), new SqlParameter("@isread", teteusermsg.Isread), new SqlParameter("@token", teteusermsg.Token) }; return(param); }
protected void Btn_AddAll_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(Tb_Title.Text.Trim())) { Page.RegisterStartupScript("提示", "<script>alert('请输入标题!');</script>"); return; } if (string.IsNullOrEmpty(Tt_Html.Value.Trim())) { Page.RegisterStartupScript("提示", "<script>alert('请输入信息内容!');</script>"); return; } string nick = HttpUtility.UrlDecode(Request.Cookies["nick"].Value); TeteUserTokenService tutDal = new TeteUserTokenService(); TeteUserMsgService tumDal = new TeteUserMsgService(); IList <TeteUserTokenInfo> list = tutDal.GetAllTeteUserToken(nick); IList <TeteUserMsgInfo> msgList = new List <TeteUserMsgInfo>(); DateTime now = DateTime.Now; foreach (TeteUserTokenInfo info in list) { TeteUserMsgInfo msg = new TeteUserMsgInfo(); msg.Adddate = now; msg.Html = Tt_Html.Value.Trim(); msg.Isread = 0; msg.Nick = nick; msg.Title = Tb_Title.Text.Trim(); msg.Token = info.Token; msgList.Add(msg); } foreach (TeteUserMsgInfo info in msgList) { tumDal.AddTeteUserMsg(info); } Page.RegisterStartupScript("提示", "<script>alert('推送信息成功!');</script>"); }
private IList <TeteUserMsgInfo> TeteUserMsgPropertity(string sql) { DataTable dt = DBHelper.ExecuteDataTable(sql); IList <TeteUserMsgInfo> list = new List <TeteUserMsgInfo>(); foreach (DataRow dr in dt.Rows) { TeteUserMsgInfo teteusermsg = new TeteUserMsgInfo(); teteusermsg.Id = Convert.ToInt32(dr["id"]); teteusermsg.Title = Convert.ToString(dr["title"]); teteusermsg.Html = Convert.ToString(dr["html"]); teteusermsg.Adddate = Convert.ToDateTime(dr["adddate"]); teteusermsg.Nick = Convert.ToString(dr["nick"]); teteusermsg.Isread = Convert.ToInt32(dr["isread"]); teteusermsg.Token = Convert.ToString(dr["token"]); list.Add(teteusermsg); } return(list); }