/// <summary>
/// 得到一个对象实体
/// </summary>
public ShowShop.Model.Member.MailReceiver GetModelByID(int id)
{
ShowShop.Model.Member.MailReceiver model = new ShowShop.Model.Member.MailReceiver();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 [id],[receiverid],[receiver],[receiveTime],[stat],[isread],[title],[body],[sender] from yxs_mailreceiver ");
strSql.Append(" where [id]=@id ");
SqlParameter[] parameters = (SqlParameter[])this.ValueIDPara(id);
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.Read())
{
model.ID = reader.GetInt32(0);
model.ReceiverId = reader.GetInt32(1);
model.Receiver = reader.GetString(2);
model.ReceiveTime = reader.GetDateTime(3);
model.Stat = reader.GetInt32(4);
model.IsRead = reader.GetInt32(5);
model.Title = reader.GetString(6);
model.Body = reader.GetString(7);
model.Sender = reader.GetString(8);
}
}
return model;
}
/// <summary>
/// 发送短消息
/// </summary>
/// <param name="uid">用户自增ID</param>
/// <param name="userid">用户账号</param>
/// <param name="title">短消息标题</param>
/// <param name="content">短消息内容</param>
/// <param name="sender">发送人（管理员账号）</param>
protected void SendMessage(int uid, string userid, string title, string content, string sender)
{
ShowShop.BLL.Member.MailReceiver ReceBll = new ShowShop.BLL.Member.MailReceiver();
ShowShop.Model.Member.MailReceiver ReceModel = new ShowShop.Model.Member.MailReceiver();
ShowShop.BLL.Member.MemberAccount bll = new ShowShop.BLL.Member.MemberAccount();
if (!bll.Exists(userid))
{
this.ltlMsg.Text = "不存在用户：" + userid;
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
ReceModel.ReceiverId = uid;
ReceModel.Receiver = userid;
ReceModel.ReceiveTime = DateTime.Now;
ReceModel.Stat = 0;
ReceModel.IsRead = 0;
ReceModel.Title = title;
ReceModel.Body = content;
ReceModel.Sender = sender;
ReceBll.Add(ReceModel);
}
/// <summary>
/// 得到指定条件的所有短消息
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public List<ShowShop.Model.Member.MailReceiver> GetAll(string strWhere)
{
List<ShowShop.Model.Member.MailReceiver> list = new List<ShowShop.Model.Member.MailReceiver>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select [id],[receiverid],[receiver],[receiveTime],[stat],[isread],[title],[body],[sender] from yxs_mailreceiver ");
if (strWhere != null && strWhere != "")
{
strSql.Append("where " + strWhere + " ");
}
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString()))
{
while (reader.Read())
{
ShowShop.Model.Member.MailReceiver model = new ShowShop.Model.Member.MailReceiver();
model.ID = reader.GetInt32(0);
model.ReceiverId = reader.GetInt32(1);
model.Receiver = reader.GetString(2);
model.ReceiveTime = reader.GetDateTime(3);
model.Stat = reader.GetInt32(4);
model.IsRead = reader.GetInt32(5);
model.Title = reader.GetString(6);
model.Body = reader.GetString(7);
model.Sender = reader.GetString(8);
list.Add(model);
}
}
return list;
}