public void Did_JSON_Deserialize_Successfully() { string jsonString = JSONHelper.DownloadJSON().Result; modelLocator.ViewModel.AllPlayers = JSONHelper.DeserializeJSON(jsonString); Assert.IsNotNull(modelLocator.ViewModel.AllPlayers); }
public void Did_Two_Selectable_Players_Populate() { string jsonString = JSONHelper.DownloadJSON().Result; modelLocator.ViewModel.AllPlayers = JSONHelper.DeserializeJSON(jsonString); modelLocator.ViewModel.RandomizeSelectablePlayers(); Assert.IsNotNull(modelLocator.ViewModel.SelectablePlayers); }
protected void upload_Click(object sender, EventArgs e) { var message = TextArea1.InnerText; if (ProjectName.Text.Trim() != "") { if (message.Length < 500) { if (FileUpload1.HasFile) { try { string datetime = "" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second; string filePath = Server.MapPath("UploadFile/") + datetime + FileUpload1.FileName; FileUpload1.SaveAs(filePath); string JSONString = fileHelper.FileStreamReader(filePath); string sqlInsert; //JSON反序列化 JArray ja = JSONHelper.DeserializeJSON(JSONString); if (ja != null) { //string s = ""; //以时间+项目名作为projectId sqlInsert = $"insert into projectinfo(projectId,projectname,username,createtime,message) values('{datetime + ProjectName.Text}','{ProjectName.Text}','{username}','{DateTime.Now.Year}-{DateTime.Now.Month}-{DateTime.Now.Day} {DateTime.Now.Hour}:{DateTime.Now.Minute}:{DateTime.Now.Second}','{message}')"; SQLHelper.GetExecuteNonQuery(sqlInsert); for (int i = 0; i < ja.Count; i++) { JObject o = (JObject)ja[i]; //以时间+key+顺序i作为textId sqlInsert = $"insert into textinfo(textId,[key],text,projectId) values('{datetime + o["key"].ToString() + i}','{o["key"].ToString()}','{ o["text"].ToString()}','{datetime + ProjectName.Text}')"; SQLHelper.GetExecuteNonQuery(sqlInsert); // s += "KEY:" + o["key"].ToString(); //s += "TEXT:" + o["text"].ToString(); } // usermsg.Text = s; Response.AddHeader("Refresh", "0"); } else { usermsg.Text = "文件格式错误,请检查上传的文件"; } } catch (Exception) { usermsg.Text = "文件格式错误,请检查上传的文件"; } } else { usermsg.Text = "请选择要上传的文件"; } } else { usermsg.Text = "项目介绍应小于500字"; } } else { usermsg.Text = "请输入项目名"; } }