protected void btnSave_Click(object sender, EventArgs e) { NoName.NetShop.IMMessage.MessageBll mbll = new NoName.NetShop.IMMessage.MessageBll(); List<string> users = new List<string>(); string content = txtContent.Text.Trim(); string subject = txtSubject.Text.Trim(); foreach (ListItem item in cblUsers.Items) { if (item.Selected) { MessageModel model = new MessageModel(); model.MsgId = 0; model.MsgType = int.Parse(rblMsgType.SelectedValue); model.UserId = item.Value; model.SenderId = Context.User.Identity.Name; model.Subject = subject; model.Content = content; model.UserType = int.Parse(rblUserType.SelectedValue); mbll.Add(model); item.Selected = false; } txtContent.Text = ""; txtSubject.Text = ""; txtExpireTime.Text = ""; } lblResult.Text = "消息发送成功"; }
public static void SendMessage(string to, string subject, string content) { MessageBll mbll = new MessageBll(); MessageModel model = new MessageModel(); model.MsgId = 0; model.MsgType = 0; model.UserId = to; model.SenderId = "鼎鼎商城"; model.Subject = subject; model.Content = content; model.UserType = 0; // 默认为前台用户 mbll.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Add(MessageModel model) { Database db = NoName.NetShop.Common.CommDataAccess.DbReader; DbCommand dbCommand = db.GetStoredProcCommand("UP_imMessage_ADD"); if (model.MsgId == 0) model.MsgId = NoName.NetShop.Common.CommDataHelper.GetNewSerialNum(AppType.Message); db.AddInParameter(dbCommand, "UserId", DbType.String, model.UserId); db.AddInParameter(dbCommand, "MsgId", DbType.Int32, model.MsgId); db.AddInParameter(dbCommand, "MsgType", DbType.Byte, model.MsgType); db.AddInParameter(dbCommand, "Subject", DbType.AnsiString, model.Subject); db.AddInParameter(dbCommand, "Content", DbType.AnsiString, model.Content); db.AddInParameter(dbCommand, "SenderId", DbType.AnsiString, model.SenderId); db.AddInParameter(dbCommand, "UserType", DbType.Int32, model.UserType); db.AddInParameter(dbCommand, "ExpireTime", DbType.DateTime, model.ExpireTime); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// ����ʵ������� /// </summary> public MessageModel ReaderBind(IDataReader dataReader) { MessageModel model=new MessageModel(); object ojb; model.UserId = dataReader["UserId"].ToString(); ojb = dataReader["MsgId"]; if(ojb != null && ojb != DBNull.Value) { model.MsgId=(int)ojb; } ojb = dataReader["MsgType"]; if(ojb != null && ojb != DBNull.Value) { model.MsgType=Convert.ToInt32(ojb); } ojb = dataReader["usertype"]; if (ojb != null && ojb != DBNull.Value) { model.UserType = Convert.ToInt32(ojb); } model.Subject=dataReader["Subject"].ToString(); model.Content=dataReader["Content"].ToString(); model.SenderId = dataReader["SenderId"].ToString(); ojb = dataReader["InsertTime"]; if(ojb != null && ojb != DBNull.Value) { model.InsertTime=(DateTime)ojb; } ojb = dataReader["ReadTime"]; if(ojb != null && ojb != DBNull.Value) { model.ReadTime=(DateTime)ojb; } ojb = dataReader["Status"]; if(ojb != null && ojb != DBNull.Value) { model.Status=(bool)ojb; } ojb = dataReader["expireTime"]; if (ojb != null && ojb != DBNull.Value) { model.ExpireTime = Convert.ToDateTime(ojb); } return model; }
/// <summary> /// ����һ������ /// </summary> public void Add(MessageModel model) { dal.Add(model); }