private void Start()
{
startTime = Time.time;
timestamps = new List <float>();
messageDict = new MessageBoardData();
textmp = GetComponent <TextMeshProUGUI>();
LoadMessages();
string path = Application.persistentDataPath + "/messageBoard.txt";
if (File.Exists(path))
{
StreamReader sr = new StreamReader(path);
var fileContents = sr.ReadToEnd();
sr.Close();
var lines = fileContents.Split("\n"[0]);
foreach (var line in lines)
{
var sects = line.Split("\t"[0]);
messageDict.messageDict.Add(float.Parse(sects[0]), sects[1]);
timestamps.Add(float.Parse(sects[0]));
}
//textmp.text += "\n" + messageDict.ToString();
}
else
{
Debug.LogError("Message Board file not found in " + path);
}
}
private void GetMessageBoardData()
{
string aStr = "SELECT Account, Count(Account) AS MessageCount FROM MessageBoard GROUP BY Account";
using (SqlConnection aCon = new SqlConnection("Data Source=184.168.47.10;Integrated Security=False;User ID=MobileDaddy;PASSWORD=Aa54380438!;Connect Timeout=15;Encrypt=False;Packet Size=4096"))
{
aCon.Open();
List <MessageBoardData> ListData = new List <MessageBoardData>();
using (SqlCommand aCmd = new SqlCommand(aStr, aCon))
{
SqlDataReader aReader = aCmd.ExecuteReader();
while (aReader.Read())
{
MessageBoardData aData = new MessageBoardData();
aData.Account = aReader["Account"].ToString();
aData.MessageCount = aReader["MessageCount"].ToString();
ListData.Add(aData);
}
}
string zStr = string.Format("總共有{0}人留言過</br>", ListData.Count);
int aTotalCount = 0;
for (int i = 0; i < ListData.Count; i++)
{
zStr += string.Format("{0}總共留言過[{1}]次</br>", ListData[i].Account, ListData[i].MessageCount);
aTotalCount += int.Parse(ListData[i].MessageCount);
}
zStr += string.Format("總共有{0}則留言</br>", aTotalCount);
Response.Write(zStr);
}
}
protected void DisplayUnApprovedMessage(long messageId, long objectId, string objType)
{
paging.CurrentPage = _currentPageNumber;
paging.RecordsPerPage = _ContentAPI.RequestInformationRef.PagingSize;
Ektron.Cms.Common.EkEnumeration.MessageBoardObjectType Type = new Ektron.Cms.Common.EkEnumeration.MessageBoardObjectType();
MessageBoardData _MessageById = new MessageBoardData();
MessageBoardData _ParentMessage = new MessageBoardData();
switch (objType)
{
case "Content":
Type = Ektron.Cms.Common.EkEnumeration.MessageBoardObjectType.Content;
break;
case "CommunityGroup":
Type = Ektron.Cms.Common.EkEnumeration.MessageBoardObjectType.CommunityGroup;
break;
case "User":
Type = Ektron.Cms.Common.EkEnumeration.MessageBoardObjectType.User;
break;
case "MessageReply":
Type = Ektron.Cms.Common.EkEnumeration.MessageBoardObjectType.MessageReply;
break;
}
_MessageById = _MessageBoard.GetMessageBoardEntry(messageId, objectId, Type, true, _ContentAPI.UserId);
ltrMessage.Text += "<div class='commentWrapper'>";
ltrMessage.Text += " <blockquote>";
ltrMessage.Text += " <span class='bqStart'>“</span>";
ltrMessage.Text += _MessageById.MessageText;
ltrMessage.Text += " <span class='bqEnd'>”</span>";
ltrMessage.Text += " </blockquote>";
if (Type == Ektron.Cms.Common.EkEnumeration.MessageBoardObjectType.MessageReply)
{
ltrMessage.Text += " <label class='replyTo'>" + _msgRef.GetMessage("lbl reply to message") + ":</label>";
_ParentMessage = _MessageBoard.GetMessageBoardEntry(objectId, true, _ContentAPI.UserId);
ltrMessage.Text += " <blockquote>";
ltrMessage.Text += " <span class='bqStart'>“</span>";
ltrMessage.Text += _ParentMessage.MessageText;
ltrMessage.Text += " <span class='bqEnd'>”</span>";
ltrMessage.Text += " </blockquote>";
}
ltrMessage.Text += "</div>";
ViewUnApprovedMessages.Visible = false;
ViewUnApprovedMessage.Visible = true;
hdnMessageInfo.Value = _MessageById.MessageId.ToString();
ViewMessageBoardToolBar();
SetPaging();
}
