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