////初始化时 //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); } }