public static void SendMsg(string title, string content, string link, string attachFileID, string receiverIDs, string receiverNames, MsgReceiverType receiverType = MsgReceiverType.UserType, MsgType msgType = MsgType.Normal, bool isReadReceipt = false, bool isImportant = false)
{
var sendUser = UserService.GetUserInfoBySysName(UserService.GetCurrentUserLoginName());
SendMsg(title, content, link, attachFileID, receiverIDs, receiverNames, sendUser, receiverType, msgType, isReadReceipt, isImportant);
}
public void SendMsg(string title, string content, string link, string attachFileID, string receiverIDs, string receiverNames, UserInfo sendUser, MsgReceiverType receiverType = MsgReceiverType.UserType, MsgType msgType = MsgType.Normal, bool isReadReceipt = false, bool isImportant = false)
{
Config.Logic.MessageService.SendMsg(title, content, link, attachFileID, receiverIDs, receiverNames, sendUser, receiverType, msgType, isReadReceipt, isImportant);
}
public static void SendMsg(string title, string content, string link, string attachFileID, string receiverIDs, string receiverNames, UserInfo sendUser, MsgReceiverType receiverType = MsgReceiverType.UserType, MsgType msgType = MsgType.Normal, bool isReadReceipt = false, bool isImportant = false)
{
title = title.Replace("'", "''");
content = content.Replace("'", "''");
string msgBodyID = GuidHelper.CreateGuid();
string userID = "";
string userName = "******";
if (sendUser != null)
{
userID = sendUser.UserID;
userName = sendUser.UserName;
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat(msgBodySql
, msgBodyID
, title
, content
, attachFileID
, link
, 1
, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
, userID
, userName
, receiverIDs
, receiverNames
, (isReadReceipt ? "1" : "0")
, (isImportant ? "1" : "0"));
var receiverIDArr = receiverIDs.Split(',');
var receiverNameArr = receiverNames.Split(',');
for (int i = 0; i < receiverIDArr.Length; i++)
{
sb.AppendFormat(msgReceiverSql
, GuidHelper.CreateGuid()
, msgBodyID
, receiverIDArr[i]
, receiverNameArr[i]
, 0);
}
SQLHelper sqlHelper = SQLHelper.CreateSqlHelper(ConnEnum.Base);
if (Config.Constant.IsOracleDb)
{
string sql = sb.ToString();
sql = sql.Replace("\r\n", "").Replace("\n", "");
sql = "begin " + sql + " end;";
sqlHelper.ExecuteNonQuery(sql);
}
else
{
sqlHelper.ExecuteNonQuery(sb.ToString());
}
}