//反馈列表流加载(未回复)
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);
}
