////初始化时
//public override void OnInit()
//{
// numText = GameObject.Find("NumText").GetComponent<Text>();
// msgText = GameObject.Find("MsgText").GetComponent<Text>();
//}
public override void OnShow(params object[] para)
{
//文本组件
numText.text = para[0].ToString();
msgText.text = para[1].ToString();
qd = DBManager.GetQueDataByQueID(numText.text);
}
//根据取得的本账户所有收藏问题集合的问题ID来获取问题的数据
public static List <QueData> GetAllColQues()
{
//CheckAndReconnect();
List <QueData> myColQuesDatas = new List <QueData>();
StringBuilder allQueID = new StringBuilder();
try
{
for (int i = 0; i < colDatas.Count; i++)
{
allQueID.Append(colDatas[i].question_id).Append(",");
}
if (allQueID.Length <= 0)
{
return(myColQuesDatas);
}
allQueID.Remove(allQueID.Length - 1, 1);
string sql = $"select * from t_question where id in (" + allQueID + ");";
//查询
MySqlCommand cmd = new MySqlCommand(sql, mysql);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
//读取
if (!dataReader.HasRows)
{
dataReader.Close();
}
QueData qd = new QueData();
qd.id = dataReader.GetString("id");
qd.title = dataReader.GetString("title");
qd.content = dataReader.GetString("content");
qd.user_id = dataReader.GetString("user_id");
qd.collectcount = dataReader.GetString("collectcount");
qd.publishtime = dataReader.GetString("publishtime");
myColQuesDatas.Add(qd);
}
dataReader.Close();
return(myColQuesDatas);
}
catch (Exception e)
{
PanelManager.Open <TipPanel>
("[DBManager.GetAllColQues()]获取本账户所有的收藏问题数据失败，异常为" + e.Message);
return(null);
}
}
//取得所有本账号发布的问题信息
public static List <QueData> GetAllMyQues()
{
CheckAndReconnect();
MySqlDataReader dataReader;
MySqlCommand cmd;
List <QueData> myQue = new List <QueData>();
try
{
string sql = $"select * from t_question where user_id= {currentUser.id};";
//查询
cmd = new MySqlCommand(sql, mysql);
dataReader = cmd.ExecuteReader();
while (dataReader.HasRows)
{
//读取
dataReader.Read();
QueData qd = new QueData
{
id = dataReader.GetString("id"),
title = dataReader.GetString("title"),
content = dataReader.GetString("content"),
user_id = dataReader.GetString("user_id"),
collectcount = dataReader.GetString("collectcount"),
publishtime = dataReader.GetString("publishtime")
};
myQue.Add(qd);
dataReader.Close();
}
return(myQue);
}
catch (Exception e)
{
Debug.Log
("[DBManager.GetUserData()]获取本账户所有发布的问题数据失败，异常为" + e.Message);
return(null);
}
}
//通过关键字检索所有问题
public static List <QueData> GetAllKeyQues(string keyStr)
{
CheckAndReconnect();
List <QueData> QueDatas = new List <QueData>();
string sql = $"select * from t_question where title like'%{keyStr}%' ;";
try
{
//查询
MySqlCommand cmd = new MySqlCommand(sql, mysql);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
//读取
if (!dataReader.HasRows)
{
dataReader.Close();
}
Debug.Log(dataReader.GetString("id"));
QueData qd = new QueData();
qd.id = dataReader.GetString("id");
qd.title = dataReader.GetString("title");
qd.content = dataReader.GetString("content");
qd.user_id = dataReader.GetString("user_id");
qd.collectcount = dataReader.GetString("collectcount");
qd.publishtime = dataReader.GetString("publishtime");
QueDatas.Add(qd);
}
dataReader.Close();
return(QueDatas);
}
catch (Exception e)
{
Debug.Log
("[DBManager.GetUserData()]获取所有所带关键词的问题失败，异常为" + e.Message);
return(null);
}
}
public override void OnShow(params object[] para)
{
currentQue = para[0] as QueData;
//当前问题的所有回复
allReplyInServer = DBManager.GetAllRepliesByQueID(currentQue.id);
//文本组件
titleText = prefabIns.transform.Find("TitleText").GetComponent <Text>();
contentText = prefabIns.transform.Find("ContentText").GetComponent <Text>();
string title = currentQue.title;
if (title.Length <= 8)
{
titleText.text = title;
}
else
{
titleText.text = title.Substring(0, 8) + "......";
}
contentText.text = currentQue.content;
//输入框组件
replyIF = prefabIns.transform.Find("Bottom/ReplyIF").GetComponent <InputField>();
//按钮组件
closeBtn = prefabIns.transform.Find("CloseBtn").GetComponent <Button>();
collectBtn = prefabIns.transform.Find("CollectBtn").GetComponent <Button>();
goodBtn = prefabIns.transform.Find("GoodBtn").GetComponent <Button>();
sendBtn = prefabIns.transform.Find("Bottom/SendBtn").GetComponent <Button>();
//监听
closeBtn.onClick.AddListener(OnCloseBtnClick);
collectBtn.onClick.AddListener(OnCollectBtnClick);
goodBtn.onClick.AddListener(OnGoodBtnClick);
sendBtn.onClick.AddListener(OnSendBtnClick);
//Content部分的Toggler列表
foreach (var replyItem in allReplyInServer)
{
MsgTogglerHelper.AddToggler <SmallMsgToggler>
(replyItem.content, replyItem.goodcount, replyItem.id, replyItem.user_id, replyItem.question_id);
}
}
//取得该问题ID对应的问题描述
public static QueData GetQueDataByQueID(string question_id)
{
CheckAndReconnect();
string sql = $"select * from t_question where id='{question_id}';";
try
{
//查询
MySqlCommand cmd = new MySqlCommand(sql, mysql);
MySqlDataReader dataReader = cmd.ExecuteReader();
if (!dataReader.HasRows)
{
dataReader.Close();
}
dataReader.Read();
QueData qd = new QueData();
qd.id = dataReader.GetString("id");
qd.title = dataReader.GetString("title");
qd.content = dataReader.GetString("content");
qd.user_id = dataReader.GetString("user_id");
qd.collectcount = dataReader.GetString("collectcount");
qd.publishtime = dataReader.GetString("publishtime");
dataReader.Close();
return(qd);
}
catch (Exception e)
{
Debug.Log
("[DBManager.GetQueDataByQueID()]获取当前问题描述失败，异常为" + e.Message);
return(null);
}
}
