public bool SaveMessage(Model.Message message) { _contextProvider.Messages.Add(message); var savedCount = _contextProvider.SaveChanges(); return(savedCount > 0); }
public void WhenSubscribeAsync_ThenInvokeAsyncMethodGetsCalled() { var topic = "topic"; var message = new Model.Message() { Topic = topic, Content = "content message" }; // Arrange var loggerMock = new Mock <ILogger <PublishSubscribeHub> >(); var clientProxyMock = new Mock <IClientProxy>(); clientProxyMock.Setup(m => m.InvokeAsync("Publish", It.IsAny <object[]>())).Returns(Task.CompletedTask); var clientsMock = new Mock <IHubConnectionContext <IClientProxy> >(); clientsMock.Setup(m => m.Group(topic)).Returns(clientProxyMock.Object); var hub = new PublishSubscribeHub(loggerMock.Object); hub.Clients = clientsMock.Object; // Act hub.SendMessageAsync(message).Wait(); // Assert clientsMock.VerifyAll(); clientProxyMock.VerifyAll(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Message("); strSql.Append("MeContent,Datetime,AdminID,Status,ModefyAID)"); strSql.Append(" values ("); strSql.Append("@MeContent,@Datetime,@AdminID,@Status,@ModefyAID)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MeContent", DbType.String, model.MeContent); db.AddInParameter(dbCommand, "Datetime", DbType.DateTime, model.Datetime); db.AddInParameter(dbCommand, "AdminID", DbType.Int32, model.AdminID); db.AddInParameter(dbCommand, "Status", DbType.Int16, model.Status); db.AddInParameter(dbCommand, "ModefyAID", DbType.Int32, model.ModefyAID); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
public HttpResponseMessage Post(Model.Message message) { HttpResponseMessage response; try { var emailSendResult = _emailSender.Send(message); if (emailSendResult.Success) { response = Request.CreateResponse(HttpStatusCode.OK); } else { response = Request.CreateResponse(HttpStatusCode.InternalServerError, emailSendResult.Message); } _repository.SaveMessage(message); } catch (Exception ex) { response = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message); } return(response); }
/// <summary> /// Delete Competiton /// </summary> /// <returns></returns> public JsonResult Delete(int uid) { BLL.T_Match_Competition bll = new BLL.T_Match_Competition(); bool result = bll.Delete(uid); if (result) { Model.Message message = new Model.Message(); message.statusCode = "200"; message.message = "删除比赛成功!"; message.navTabId = "CompetitonList"; message.rel = "CompetitonList"; message.forwardUrl = "CompetitonList"; message.callbackType = ""; return(Json(message)); } ///删除比赛成功返回 else { Model.Message message = new Model.Message(); message.statusCode = "300"; message.message = "删除比赛失败!"; message.navTabId = "CompetitonList"; message.rel = "CompetitonList"; message.forwardUrl = "CompetitonList"; message.callbackType = ""; return(Json(message)); } ///删除比赛失败返回 }
/// <summary> /// 对象实体绑定数据 /// </summary> public Model.Message ReaderBind(IDataReader dataReader) { Model.Message model = new Model.Message(); object ojb; ojb = dataReader["MID"]; if (ojb != null && ojb != DBNull.Value) { model.MID = Convert.ToInt32(ojb); } model.MeContent = dataReader["MeContent"].ToString(); ojb = dataReader["Datetime"]; if (ojb != null && ojb != DBNull.Value) { model.Datetime = Convert.ToDateTime(ojb); } ojb = dataReader["AdminID"]; if (ojb != null && ojb != DBNull.Value) { model.AdminID = Convert.ToInt32(ojb); } ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = Convert.ToInt32(ojb); } ojb = dataReader["ModefyAID"]; if (ojb != null && ojb != DBNull.Value) { model.ModefyAID = Convert.ToInt32(ojb); } return(model); }
public MessageVM(IList <CgbAppInstanceVM> listOfInstances, InvocationParams config, Model.Message model) { _config = config; _instanceGetter = () => listOfInstances.GetInstance(_config.ExecutablePath); _fallbackInstNameGetter = () => new FileInfo(_config.ExecutablePath).Name; _model = model; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Message set "); strSql.Append("MeContent=@MeContent,"); strSql.Append("Datetime=@Datetime,"); strSql.Append("AdminID=@AdminID,"); strSql.Append("Status=@Status,"); strSql.Append("ModefyAID=@ModefyAID"); strSql.Append(" where MID=@MID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MID", DbType.Int32, model.MID); db.AddInParameter(dbCommand, "MeContent", DbType.String, model.MeContent); db.AddInParameter(dbCommand, "Datetime", DbType.DateTime, model.Datetime); db.AddInParameter(dbCommand, "AdminID", DbType.Int32, model.AdminID); db.AddInParameter(dbCommand, "Status", DbType.Int16, model.Status); db.AddInParameter(dbCommand, "ModefyAID", DbType.Int32, model.ModefyAID); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }
private void AddMessageToForm(Model.Message message) { var labelText = Client.CreateLabel(message.Text, LabelSizeY, chatTable.Width); labelText.ContextMenuStrip = contextMenuStrip1; labelText.BackColor = Color.White; labelText.Margin = new Padding(0, 0, 0, 20); labelText.Name = message.Id.ToString(); var labelDate = Client.CreateLabel(message.Date.ToString(), LabelSizeY, chatTable.Width); labelDate.BackColor = Color.White; labelDate.Font = new Font("Segoe UI", 8F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(204))); labelDate.Margin = new Padding(0, 0, 0, 20); var control = new NameUserControl(ChatOnForm.Members.First(x => x.Id == message.UserId)); chatTable.RowCount++; chatTable.RowStyles.Add(new RowStyle(SizeType.AutoSize, LabelSizeY)); chatTable.Controls.Add(control, 0, chatTable.RowCount - 1); chatTable.Controls.Add(labelText, 1, chatTable.RowCount - 1); if (message.FileName != "") { var controlAttach = new AttachFile(message.FileName); controlAttach.Name = message.Id.ToString(); controlAttach.Cursor = Cursors.Hand; controlAttach.Click += new EventHandler(SaveAttachOnClick); chatTable.Controls.Add(controlAttach, 2, chatTable.RowCount - 1); } chatTable.Controls.Add(labelDate, 3, chatTable.RowCount - 1); chatTable.RowCount++; }
public async virtual Task <Message> List(Message message) { try { var resultMessage = new Model.Message(); var model = message.DeSerializeObject <Model.Medical_Service>(); using (var repository = new Medical_Service_Repository(message.Connection)) { var returnObject = await repository.List(model); resultMessage.Status = Status.Success; resultMessage.Result = "Proceso efectuado satisfactoriamente..."; resultMessage.MessageInfo = returnObject.SerializeObject(); return(resultMessage); } } catch (Exception ex) { var resultMessage = new Model.Message(); resultMessage.Status = Status.Failed; resultMessage.Result = string.Format("{0}", ex.Message); resultMessage.MessageInfo = string.Empty; return(resultMessage); } }
public JsonResult AddAdminSave(Model.T_Match_Admin model) { BLL.T_Match_Admin bll = new BLL.T_Match_Admin(); int result = bll.Add(model); //提示添加管理员状态 #region if (result > 0) { Model.Message message = new Model.Message(); message.statusCode = "200"; message.message = "添加管理员成功!"; message.navTabId = ""; message.rel = ""; message.forwardUrl = ""; message.callbackType = "closeCurrent"; return(Json(message)); } ///添加管理员成功返回 else { Model.Message message = new Model.Message(); message.statusCode = "300"; message.message = "添加管理员失败!"; message.navTabId = ""; message.rel = ""; message.forwardUrl = ""; message.callbackType = "closeCurrent"; return(Json(message)); } #endregion }
public void SendMessage(Model.Message data) { try { WebRequest tRequest = WebRequest.Create("https://fcm.googleapis.com/fcm/send"); tRequest.Method = "post"; tRequest.ContentType = "application/json"; var json = JsonConvert.SerializeObject(data); Byte[] byteArray = System.Text.Encoding.UTF8.GetBytes(json); tRequest.Headers.Add(string.Format("Authorization: key={0}", applicationID)); tRequest.Headers.Add(string.Format("Sender: id={0}", senderId)); tRequest.ContentLength = byteArray.Length; using (System.IO.Stream dataStream = tRequest.GetRequestStream()) { dataStream.Write(byteArray, 0, byteArray.Length); using (WebResponse tResponse = tRequest.GetResponse()) { using (System.IO.Stream dataStreamResponse = tResponse.GetResponseStream()) { using (StreamReader tReader = new StreamReader(dataStreamResponse)) { String sResponseFromServer = tReader.ReadToEnd(); string str = sResponseFromServer; } } } } } catch (Exception ex) { // } }
public async Task <AppCore.Result <long> > GetMessageStatus(Model.Message msg, Model.Account account) { int statusResults = (await _sms.getMessageStatusesAsync( userName: account.UserName , password: account.Password , domain: account.Domain , useProxy: false , proxyAddress: string.Empty , proxyUsername: string.Empty , proxyPassword: string.Empty , messageIds: new long[] { msg.CheckId }))[0]; string statusResultFinal; if (statusResults <= -1) { statusResultFinal = "Error. code: " + statusResults + ", " + ErrorCodes.getDescriptionForCode(statusResults); } else { statusResultFinal = "Results: " + statusResults; } return(AppCore.Result <long> .Set(true, data : statusResults, message : statusResultFinal)); }
public bool insert(Model.Message mes) { string sql; if (!isExitence(mes)) { sql = "insert into student(id,name,sex,college,grade,email,phone,major,class,introduction) values(@id,@name,@sex,@college,@grade,@email,@phone,@major,@class,@introduction)"; } else { sql = "update student set name=@name,sex=@sex,college=@college,grade=@grade,email=@email,phone=@phone,major=@major,class=@class,introduction=@introduction where id=@id"; } SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@id", mes.Id), new SqlParameter("@name", mes.Name), new SqlParameter("@sex", mes.Sex), new SqlParameter("@college", mes.College), new SqlParameter("@grade", mes.Grade), new SqlParameter("@email", mes.Email), new SqlParameter("@phone", mes.Phone), new SqlParameter("@major", mes.Major), new SqlParameter("@class", mes.Class), new SqlParameter("@introduction", mes.Introduction) }; int count = SqlDbHelper.ExecuteNonQuery(sql.ToString(), CommandType.Text, paras); if (count == 1) { return(true); } return(false); }
public BranchViewModel(Model.MapStory pMapStory, Model.Branch pBranch) { this.SelectedMapStory = pMapStory; this.CurrentBranch = pBranch; var message = new Model.Message(); this.MessageList = new ObservableCollection <Model.Message>(); if (CurrentBranch.Messages == null) { CurrentBranch.Messages = new List <Model.Message>(); } foreach (var m in CurrentBranch.Messages) { if (m.GetType() == typeof(Model.Message)) { message = m as Model.Message; MessageList.Add(message); } else if (m.GetType() == typeof(Model.Question)) { message = m as Model.Question; MessageList.Add(message); } else { var dialog = new Windows.UI.Popups.MessageDialog("Error, unsupported Message type is tried to be added into the MessageList."); } } }
public MessageVM(CgbAppInstanceVM instance, Model.Message model) { _config = instance?.Config; _instanceGetter = () => instance; _fallbackInstNameGetter = () => instance?.ShortPath ?? "?"; _model = model; }
public ActionResult AddSave() { Model.T_Match_DetailBody body = new Model.T_Match_DetailBody(); body.HeaderID = Convert.ToInt32(Request.Form["OrderNumber"]); body.StudentID = Convert.ToString(Request.Form["Person.ID"]); body.StudentID = Convert.ToString(Request.Form["Person.Phone"]); body.StudentID = Convert.ToString(Request.Form["Person.Mail"]); body.StudentID = Convert.ToString(Request.Form["Person.Comments"]); BLL.T_Match_DetailBody bll = new BLL.T_Match_DetailBody(); int result = bll.Add(body); if (result > 0) { Model.Message message = new Model.Message(); message.statusCode = "200"; message.message = "增加条目成功!"; message.navTabId = "UserList"; message.rel = "UserList"; message.forwardUrl = ""; message.callbackType = "closeCurrent"; return(Json(message)); } else { Model.Message message = new Model.Message(); message.statusCode = "300"; message.message = "增加条目失败!"; message.navTabId = "UserList"; message.rel = "UserList"; message.forwardUrl = ""; message.callbackType = "closeCurrent"; return(Json(message)); } }
public async Task <AppCore.Result <Model.Message> > CreateAsync(Model.Message model) { try { var result = (await _dbMessage.AddMessageAsync( _id: model.ID, _sourceAccountID: Model.SmsServiceDic.Instance[model.SourceAccount], _priority: (byte)model.Priority, _sendType: (byte)model.SendType, _encodingType: (byte)model.Encoding, _status: (short)model.Status, _sendDate: DateTime.Now, _externalMessageID: model.ExternalMessageID, _uDH: model.UDH, _content: model.Content, _receiverNumbers: Newtonsoft.Json.JsonConvert.SerializeObject(model.ReceiverNumbers) )).ToActionResult <Model.Message>(); return(result); } catch (Exception e) { throw e; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Message DataRowToModel(DataRow row) { Model.Message model = new Model.Message(); if (row != null) { if (row["MID"] != null && row["MID"].ToString() != "") { model.MID = Convert.ToInt32(row["MID"].ToString()); } if (row["MeContent"] != null) { model.MeContent = row["MeContent"].ToString(); } if (row["Datetime"] != null && row["Datetime"].ToString() != "") { model.Datetime = Convert.ToDateTime(row["Datetime"].ToString()); } if (row["AdminID"] != null && row["AdminID"].ToString() != "") { model.AdminID = Convert.ToInt32(row["AdminID"].ToString()); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = Convert.ToInt32(row["Status"].ToString()); } if (row["ModefyAID"] != null && row["ModefyAID"].ToString() != "") { model.ModefyAID = Convert.ToInt32(row["ModefyAID"].ToString()); } } return(model); }
public JsonResult AddSave(Model.T_Match_Competition model) { BLL.T_Match_Competition bll = new BLL.T_Match_Competition(); int result = bll.Add(model); //提示发布状态 #region if (result > 0) { Model.Message message = new Model.Message(); message.statusCode = "200"; message.message = "发布比赛成功!"; message.navTabId = "CompetitonList"; message.rel = "CompetitonList"; message.forwardUrl = "CompetitonList"; message.callbackType = "closeCurrent"; return(Json(message)); } ///删除比赛成功返回 else { Model.Message message = new Model.Message(); message.statusCode = "300"; message.message = "发布比赛失败!"; message.navTabId = "CompetitonList"; message.rel = "CompetitonList"; message.forwardUrl = "CompetitonList"; message.callbackType = "closeCurrent"; return(Json(message)); } #endregion }
protected void Page_Load(object sender, EventArgs e) { if ("POST".Equals(Request.RequestType.ToUpper())) { var msg = new Model.Message(); var titleSvr = unity.GetInstance <IMessageService>(); msg.message = Request.Form["message"]; msg.Mobile = Request.Form["mobile"]; msg.Msgtitle = Request.Form["message"]; msg.Mail = Request.Form["mail"]; msg.Qq = Request.Form["qq"]; msg.Name = Request.Form["name"]; msg.Type = 3; msg.Status = 0; msg.Time = DateTime.Now.ToUnixTimestamp(); try { titleSvr.Add(msg); object json = new { status = 1 }; Response.Write(json.SerializeToJson()); Response.End(); } catch (ApplicationException ex) { object json = new { status = 0, msg = ex.Message }; Response.Write(json.SerializeToJson()); Response.End(); } } }
private void HandleReceivedMessage(Model.Message receivedMessage) { _logger.LogInformation("Message Received from topic '{0}', serialized content: {0}", receivedMessage.Topic, receivedMessage.Content); try { if (_handlers.TryGetValue(receivedMessage.Topic, out Tuple <Type, Action <object> > tuple)) { // TODO: Improve readability with super cool c#7 tuples var content = JsonConvert.DeserializeObject(receivedMessage.Content, tuple.Item1); tuple.Item2.Invoke(content); } } catch (JsonReaderException ex) { _logger.LogError(ex, "Exception trying to deserialize received content into handle method parameter on topic {0} from service {1}", receivedMessage.Topic, _hubUrl); // TODO: Log and throw library expecific exception for known exception types, other, log and throw //throw; Cannot do anything except log it } catch (Exception ex) { _logger.LogError(ex, "Unknown exception trying to handle a received message on topic {0} from service {1}", receivedMessage.Topic, _hubUrl); // TODO: Log and throw library expecific exception for known exception types, other, log and throw //throw; Cannot do anything except log it } }
/// <summary> /// Send a message with the indicated content to the indicated topic /// </summary> /// <typeparam name="T">Content type</typeparam> /// <param name="topic">Topic</param> /// <param name="content">Content</param> /// <returns></returns> public async Task SendAsync <T>(string topic, T content) { try { var message = new Model.Message() { Topic = topic, Content = JsonConvert.SerializeObject(content) }; await _hubConnection.Invoke <object>(_methodSendMessageName, _cancellationTokenSource.Token, message); } catch (AggregateException aex) when(aex.InnerExceptions.All(e => e is OperationCanceledException)) { _logger.LogInformation("SendAsync, operation cancelled for topic {0}", topic); } catch (OperationCanceledException) { _logger.LogInformation("SendAsync, operation cancelled for topic {0}", topic); } catch (Exception ex) { _logger.LogError(ex, "SendAsync, Unknown exception trying to send a message to {0}", _hubUrl); // TODO: Log and throw library expecific exception for known exception types, other, log and throw throw; } }
/// <summary> /// Formats a description based on feed and latest message /// </summary> /// <param name="feed">feed object</param> /// <param name="latestMessage">latest message</param> /// <returns>markdown-formatted description of feed and latest message</returns> private static string FormatDescription(Model.Feed feed, Model.Message latestMessage) { return($"FindMeSpot feed for {feed.Name}\n" + $"Current coordinates: Latitude: {latestMessage.Latitude}\n" + $"Longitude: {latestMessage.Longitude}\n" + $"Altitude: {latestMessage.Altitude}\n" + $"Date/time: {latestMessage.DateTime}\n"); }
/// <summary> /// 添加一个消息 /// </summary> /// <param name="message"></param> /// <returns></returns> public int Add(Model.Message message) { using (var db = new DataContext()) { db.Add(message); return(db.SaveChanges()); } }
private void AddRow(Model.Message msg) { var rowIndex = dataGridView1.Rows.Add(); var row = dataGridView1.Rows[rowIndex]; row.Cells["Content"].Value = msg.Content; dataGridView1.CurrentCell = row.Cells[0]; dataGridView1.BeginEdit(false); }
private void Messages_SelectionChanged(object sender, SelectionChangedEventArgs e) { Model.Message choosed = (Model.Message)Messages.SelectedItem; if (choosed != null && choosed.Subject == "Load more...") { new ListMessages().LoadMore(choosed, Window, Config, UserData); Model.Message.Mails.Remove(choosed); } }
private void AddMessageToDictionary(Model.Message entity) { entity.AddMessageAudit -= entity_AddMessageAudit; if (!messages.ContainsKey(entity.ID)) { messages.Add(entity.ID, entity); } entity.AddMessageAudit += new AddMessageAuditHandler(entity_AddMessageAudit); }
/// <summary> /// 添加一批消息 /// </summary> /// <param name="message">消息实体</param> /// <param name="messageUsers">阅读人员</param> /// <returns></returns> public int Add(Model.Message message, Model.MessageUser[] messageUsers) { using (var db = new DataContext()) { db.Add(message); db.AddRange(messageUsers); return(db.SaveChanges()); } }
public bool SaveMessage(string message, int receiverId, int senderId) { Model.Message modelMessage = new Model.Message(); modelMessage.Messages = message; modelMessage.ReceiverId = receiverId; modelMessage.SenderId = senderId; modelMessage.Seen = false; modelMessage.SendReceive = MessageHelper.MESSAGE_SEND; return(_messageService.SaveMessage(MessageMapper.ConvertToEntity(modelMessage))); }
public void SaveData() { var list = new List<Model.Message>(); foreach (DataGridViewRow row in dataGridView1.Rows) { var content = row.Cells["Content"]; if (content.Value != null) { var msg = new Model.Message { Content = content.Value.ToString() }; list.Add(msg); } } DataManager.Save(list); }
public void MessageRepositoryDataModel_AddMessageAudit_Success_Test() { MVoxAuditingEntities.AllInstances.MessagesGet = (c) => { return new FakeObjectSet<DataModel.Message>(); }; MVoxAuditingEntities.AllInstances.MessageAuditsGet = (c) => { return new FakeObjectSet<DataModel.MessageAudit>(); }; MVoxAuditingEntities.AllInstances.SaveChanges = (c) => { return 1; }; Model.Message message = new Model.Message(0, "Test") { BatchID = 1, ClientID = 1 }; bool result = repository.Add(message); Assert.IsTrue(result); result = message.AddAudit(Guid.NewGuid(), "Test"); Assert.IsTrue(result); }
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) return; var row = dataGridView1.Rows[e.RowIndex]; var id = StringHelper.ToInt(row.Cells["ID"].Value == null ? null : row.Cells["ID"].Value.ToString(), 0); var content = row.Cells["Content"].Value == null ? null : row.Cells["Content"].Value.ToString(); if (string.IsNullOrEmpty(content)) { return; } var duration = StringHelper.ToInt(row.Cells["Duration"].Value == null ? null : row.Cells["Duration"].Value.ToString(), 10); var model = new Model.Message { ID = id, Content = content, Duration = duration }; MessageManager.Save(model); if (id == 0) { row.Cells["ID"].Value = model.ID; } }
protected void RbtnSubmit_Click(object sender, EventArgs e) { string msgType = RCB_Type.SelectedValue; string closeBy = ""; if (msgType.Equals("Popup")) { closeBy = RCB_DisType.SelectedValue; } else if (msgType.Equals("Roll")) { if (!RadButton2.Checked && RTB_RollTimes.Text.Trim().Equals("")) { RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('滚动次数不能为空!');", true); return; } closeBy = RadButton2.Checked ? "-1" : RTB_RollTimes.Text; } if (RadDatePicker1.DbSelectedDate == null) { RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c", "OpenAlert('抱歉,有效期限不能为空!');", true); return; } DateTime availableTime = (DateTime)RadDatePicker1.DbSelectedDate; DateTime expiredTime = RadDatePicker2.DbSelectedDate==null? new DateTime(2050,12,31) : (DateTime)RadDatePicker2.DbSelectedDate; string content = TabStrip1.SelectedTab.Value.Equals("2") ? (RadButton1.Checked ? CheckStr(ContentEditor.Content) : ContentEditor.Content) : ContentText.Text; if (content.Trim().Equals("")) { RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('抱歉,公告内容不能为空!');", true); return; } RadTreeView regionTreeView = RadDropDownTree1.Controls[0] as RadTreeView; if (!RadButton5.Checked && RadListBox1.CheckedItems.Count == 0 && regionTreeView.SelectedNodes.Count == 0 && RTB_SIM.Text.Trim().Equals("")) { RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('抱歉,请设置对象发送条件!!');", true); return; } if (!RadButton5.Checked && !RadButton3.Checked && !RadButton4.Checked) { RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('抱歉,请选择对象条件关系!!');", true); return; } Model.Message msgModel = new Model.Message(); msgModel.Contents = content; msgModel.MessageType = msgType; msgModel.DataType = TabStrip1.SelectedTab.Value.Equals("2") ? "DataType_Html" : "DataType_Text"; msgModel.AndOr = RadButton3.Checked; msgModel.AvailableTime = availableTime; msgModel.DisappearType = closeBy; msgModel.ExpiredTime = expiredTime; msgModel.IsValid = true; msgModel.LastModifyTime = DateTime.Now; msgModel.Memo = ""; msgModel.Orders = 0; msgModel.Publisher = user.UserInfo.UserID; long msgId = 0; bool isAdd = false; Model.Log logModel = new Model.Log(); try { logModel.OperationItem = "添加公告"; logModel.Operator = user.UserInfo.UserID; logModel.OperationTime = DateTime.Now; logModel.OperationDetail = "类型:"+msgType ; msgId =msg.Add(msgModel); if (msgId > 0) { if (RadButton5.Checked) { Model.MessageToObject mtoModel = new Model.MessageToObject(); mtoModel.MsgID = msgId; mtoModel.ObjType = "2"; mtoModel.ObjValue = ""; isAdd = mto.Add(mtoModel); } else { //身份 isAdd = true; foreach (RadListBoxItem rbi in RadListBox1.CheckedItems) { isAdd = false; Model.MessageToObject mtoModel = new Model.MessageToObject(); mtoModel.MsgID = msgId; mtoModel.ObjType = "0"; mtoModel.ObjValue = rbi.Value; isAdd = mto.Add(mtoModel); if (!isAdd) { break; } } //区域 if (isAdd) { isAdd = true; if (!regionTreeView.SelectedValue.Equals("Area_Jfs")) { isAdd = false; Model.MessageToObject mtoModel = new Model.MessageToObject(); mtoModel.MsgID = msgId; mtoModel.ObjType = "0"; mtoModel.ObjValue = regionTreeView.SelectedValue; isAdd = mto.Add(mtoModel); } } //用户 if (isAdd) { isAdd = true; if (RTB_SIM.Text.Trim() != "") { string[] SimNoArr = RTB_SIM.Text.Split(','); foreach (string simNo in SimNoArr) { if (!simNo.Trim().Equals("")) { isAdd = false; Model.MessageToObject mtoModel = new Model.MessageToObject(); mtoModel.MsgID = msgId; mtoModel.ObjType = "1"; mtoModel.ObjValue = simNo.Trim(); isAdd = mto.Add(mtoModel); if (!isAdd) { break; } } } } } } } if (msgId != 0 && isAdd) { logModel.Memo = "成功"; } else { logModel.Memo = "失败!"; } } catch (Exception ex) { logModel.Memo = "异常:" + ex.Message; } finally { log.Add(logModel); if (msgId != 0 && isAdd) { RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c", "OpenAlert('恭喜!编辑成功!');", true); } else { RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c3", "OpenAlert('抱歉!编辑失败!');", true); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Message GetModel(long AutoID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AutoID,Title,Contents,Orders,MessageType,DisappearType,AvailableTime,ExpiredTime,LastModifyTime,Publisher,IsValid,AndOr,Memo,DataType from Message"); strSql.Append(" where AutoID=@AutoID limit 1"); MySqlParameter[] parameters = { new MySqlParameter("@AutoID", MySqlDbType.Int64) }; parameters[0].Value = AutoID; Model.Message model = new Model.Message(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Message DataRowToModel(DataRow row) { Model.Message model = new Model.Message(); if (row != null) { if (row["AutoID"] != null && row["AutoID"].ToString() != "") { model.AutoID = long.Parse(row["AutoID"].ToString()); } if (row["Title"] != null) { model.Title = row["Title"].ToString(); } if (row["Contents"] != null) { model.Contents = row["Contents"].ToString(); } if (row["Orders"] != null) { model.Orders =Int32.Parse( row["Orders"].ToString()); } if (row["MessageType"] != null) { model.MessageType = row["MessageType"].ToString(); } if (row["DisappearType"] != null) { model.DisappearType = row["DisappearType"].ToString(); } if (row["AvailableTime"] != null && row["AvailableTime"].ToString() != "") { model.AvailableTime = DateTime.Parse(row["AvailableTime"].ToString()); } if (row["ExpiredTime"] != null && row["ExpiredTime"].ToString() != "") { model.ExpiredTime = DateTime.Parse(row["ExpiredTime"].ToString()); } if (row["LastModifyTime"] != null && row["LastModifyTime"].ToString() != "") { model.LastModifyTime = DateTime.Parse(row["LastModifyTime"].ToString()); } if (row["Publisher"] != null) { model.Publisher = row["Publisher"].ToString(); } if (row["IsValid"] != null && row["IsValid"].ToString() != "") { if ((row["IsValid"].ToString() == "1") || (row["IsValid"].ToString().ToLower() == "true")) { model.IsValid = true; } else { model.IsValid = false; } } if (row["AndOr"] != null && row["AndOr"].ToString() != "") { if ((row["AndOr"].ToString() == "1") || (row["AndOr"].ToString().ToLower() == "true")) { model.AndOr = true; } else { model.AndOr = false; } } if (row["Memo"] != null) { model.Memo = row["Memo"].ToString(); } if (row["DataType"] != null) { model.DataType = row["DataType"].ToString(); } } return model; }