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