//反馈列表流加载(未回复) public void GetNotReplySuggestList(HttpContext context) { string Page = context.Request["Page"]; string AcceptUserName = context.Request["UserName"]; string SendUserName = context.Request["UserName"]; IDataParameter[] parames = new IDataParameter[6]; parames[0] = new SqlParameter("@n", Page); parames[5] = new SqlParameter("@table", "sys_UserSuggest"); parames[4] = new SqlParameter("@reply", "false"); parames[3] = new SqlParameter("@bRead", ""); parames[1] = new SqlParameter("@AcceptUserName", ""); parames[2] = new SqlParameter("@SendUserName", ""); SqlDataReader dr = DbHelperSQL.RunProcedure("GetPage", parames); List <UserSuggest> list = new List <UserSuggest>();; int page = 0; while (dr.Read()) { page++; UserSuggest userSuggest = new UserSuggest(); userSuggest.id = int.Parse(dr["id"].ToString()); userSuggest.title = dr["title"].ToString(); userSuggest.suggest = dr["suggest"].ToString(); userSuggest.files = dr["files"].ToString(); userSuggest.commitUserName = dr["commitUserName"].ToString(); userSuggest.commitDate = DateTime.Parse(dr["commitDate"].ToString()); string reply = dr["reply"].ToString(); if (reply != "") { userSuggest.reply = "已回复"; userSuggest.statusColor = "rgba(240,173,78,1)"; } else { userSuggest.reply = "未回复"; userSuggest.statusColor = "#C7C7CC"; } userSuggest.replyUserName = dr["replyUserName"].ToString(); string replyDate = dr["replyDate"].ToString(); if (replyDate != "") { userSuggest.replyDate = DateTime.Parse(replyDate); } list.Add(userSuggest); } string jsonData = JsonConvert.SerializeObject(list); context.Response.Write("{\"code\":" + page + ",\"msg\":\"\",\"count\":1000,\"data\":" + jsonData + "}"); }
public Suggest(String path, String password, String sourceN, String sourceLa, String sourceLe, String DestinitionN, String DestinitionLa, String DestinitionLe, String TravelTime, String NumSeats) { this.password = password; this.SourceName = sourceN;; this.SourceLat = sourceLa;; this.SourceLen = sourceLe;; this.DestinitionName = DestinitionN; this.DestinitionLat = DestinitionLa; this.DestinitionLen = DestinitionLe; this.TravelTime = TravelTime; this.NumSeats = NumSeats; this.UserSuggest = new User(); UserSuggest = UserSuggest.getUser(this.password, path); }
private List <Suggest> GetSuggest(string text) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("highlight", "1"); dic.Add("keyword", text); try { IJson json = BiliApi.GetJsonResult("https://app.bilibili.com/x/v2/search/suggest3", dic, true); if (json.GetValue("data").Contains("list")) { List <Suggest> suggests = new List <Suggest>(); foreach (IJson i in json.GetValue("data").GetValue("list")) { if (!i.Contains("sug_type")) { Suggest suggest = new Suggest(i); suggests.Add(suggest); } else if (i.GetValue("sug_type").ToString() == "pgc") { SeasonSuggest seasonSuggest = new SeasonSuggest(i); suggests.Add(seasonSuggest); } else if (i.GetValue("sug_type").ToString() == "user") { UserSuggest userSuggest = new UserSuggest(i); suggests.Add(userSuggest); } else { Suggest suggest = new Suggest(i); suggests.Add(suggest); } } suggests.Sort((x, y) => x.Position.CompareTo(y.Position)); return(suggests); } return(null); } catch (WebException) { return(null); } }
private async void InputBox_TextChanged(object sender, TextChangedEventArgs e) { if (this.IsInitialized && InputBox.IsFocused) { List <Suggest> suggests = null; suggests = await GetSuggestAsync(InputBox.Text, SuggestDelay); SuggestList.Items.Clear(); if (suggests != null) { SuggestList.Visibility = Visibility.Visible; foreach (Suggest suggest in suggests) { ListBoxItem listBoxItem = new ListBoxItem(); listBoxItem.VerticalAlignment = VerticalAlignment.Stretch; if (suggest.GetType() == typeof(Suggest)) { listBoxItem.Content = new SuggestItem(suggest); listBoxItem.Tag = Regex.Unescape(suggest.Keyword); } else if (suggest.GetType() == typeof(SeasonSuggest)) { SeasonSuggest seasonSuggest = (SeasonSuggest)suggest; listBoxItem.Content = new SuggestItemSeason(seasonSuggest); listBoxItem.Tag = Regex.Unescape(seasonSuggest.Keyword); } else if (suggest.GetType() == typeof(UserSuggest)) { UserSuggest userSuggest = (UserSuggest)suggest; listBoxItem.Content = new SuggestItemUser(userSuggest); listBoxItem.Tag = Regex.Unescape(userSuggest.Keyword); } SuggestList.Items.Add(listBoxItem); } } else { SuggestList.Visibility = Visibility.Hidden; } } else { SuggestList.Visibility = Visibility.Hidden; } }
//提交反馈 public void CommitSuggest(HttpContext context) { string fileNewName = string.Empty; string filePath = string.Empty; var result = new BaseDataPackage <UserSuggest>(); HttpPostedFile file = context.Request.Files["file1"]; HttpPostedFile file2 = context.Request.Files["file2"]; HttpPostedFile file3 = context.Request.Files["file3"]; string Title = context.Request["Title"]; string Suggest = context.Request["Suggest"]; string UserID = context.Request["UserID"]; string paths = context.Request["paths"]; string pathsNew = ""; if (paths != "") { string[] sArray = paths.Split(','); foreach (string pathSplit in sArray) { if (pathSplit != "") { fileNewName = DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(pathSplit); string virtualPath = String.Format("/File/{0}", fileNewName); //上传到指定文件夹 string path = virtualPath; //相对获取文件路径 pathsNew += path + ","; } } } if (file != null) { file.SaveAs(context.Server.MapPath("~/File/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(file.FileName))); } if (file2 != null) { file2.SaveAs(context.Server.MapPath("~/File/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(file2.FileName))); } if (file3 != null) { file3.SaveAs(context.Server.MapPath("~/File/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(file3.FileName))); } result.code = ApiStatusCode.OK; result.msg = ""; result.data = null; UserSuggest userSuggest = new UserSuggest(); userSuggest.commitUserID = int.Parse(UserID); userSuggest.title = Title; userSuggest.suggest = Suggest; userSuggest.commitDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); userSuggest.files = pathsNew; int num = DbHelperSQL.ExecuteSql("insert into sys_UserSuggest(commitUserID,title,suggest,commitDate,files) values('" + userSuggest.commitUserID + "','" + userSuggest.title + "','" + userSuggest.suggest + "','" + userSuggest.commitDate + "','" + userSuggest.files + "')"); if (num != 0) { result.code = ApiStatusCode.OK; result.msg = "提交成功!"; result.data = userSuggest; } else { result.code = ApiStatusCode.OK; result.msg = "提交失败!"; result.data = userSuggest; } string jsonData = JsonConvert.SerializeObject(result); context.Response.Write(jsonData); }