public static string PhonesToJson(Phone phone, Phone[] phones)
{
var items = new List<Phone> { phone };
items.AddRange(phones ?? new Phone[0]);
var array = new JArray();
foreach (var item in items)
{
var itm = new JArray { new JValue(item.PhoneNumber) };
if (!String.IsNullOrEmpty(item.Variables))
itm.Add(new JValue(item.Variables));
array.Add(itm);
}
return array.ToString();
}
public void FormatPropertyInJson()
{
JObject query = new JObject();
JProperty orderProp = new JProperty("order", "breadth_first");
query.Add(orderProp);
JObject returnFilter = new JObject();
returnFilter.Add("body", new JValue("position.endNode().getProperty('name').toLowerCase().contains('t')"));
returnFilter.Add("language", new JValue("javascript"));
query.Add("return_filter", new JValue(returnFilter.ToString()));
JObject pruneEval = new JObject();
pruneEval.Add("body", new JValue("position.length() > 10"));
pruneEval.Add("language", new JValue("javascript"));
query.Add("prune_evaluator", pruneEval.ToString());
query.Add("uniqueness", new JValue("node_global"));
JArray relationships = new JArray();
JObject relationShip1 = new JObject();
relationShip1.Add("direction", new JValue("all"));
relationShip1.Add("type", new JValue("knows"));
relationships.Add(relationShip1);
JObject relationShip2 = new JObject();
relationShip2.Add("direction", new JValue("all"));
relationShip2.Add("type", new JValue("loves"));
relationships.Add(relationShip2);
query.Add("relationships", relationships.ToString());
//arr.Add(
Console.WriteLine(query.ToString());
//Assert.AreEqual(@"""order"" : ""breadth_first""", jobject.ToString());
}
public static string GetPageContentByPageId(int pageId, string loginUserInfo)
{
JArray ja = new JArray();
try
{
using (venuesEntities db = new venuesEntities())
{
string strSql = string.Format("SELECT tpc.ContentSequence,tpc.ContentValue,tpc.ID,tpc.ModuleID,tpc.PageID,tpc.TemplateID ,tm.ModuleType FROM tbl_page_content AS tpc LEFT JOIN tbl_module AS tm ON tm.ID=tpc.ModuleID WHERE tpc.PageID= {0}", pageId);
ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql);
string path = System.Configuration.ConfigurationManager.AppSettings["FilePath"].ToString();
foreach (var ks in kss)
{
ja.Add(
new JObject(
new JProperty("ID", ks["ID"].ToString()),
new JProperty("ContentSequence", ks["ContentSequence"].ToString()),
new JProperty("ContentValue", ks["ContentValue"].ToString()),
new JProperty("FileNameServer", ks["ContentValue"].ToString()),
new JProperty("ModuleID", ks["ModuleID"].ToString()),
new JProperty("ModuleTypeID", ks["ModuleType"].ToString()),
new JProperty("PageID", ks["PageID"].ToString()),
new JProperty("TemplateID", ks["TemplateID"].ToString())
// new JProperty("FilePathAddress", path)
)
);
};
}
}
catch (Exception e)
{
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_PagesManager, "根据pageId获取该页面内容信息：" + e.Message, loginUserInfo);
}
return ja.ToString();
}
public void ReadAsCollection_ObjectArray()
{
JArray values = new JArray();
for (int i = 1; i <= 3; i++)
{
JObject jsonObject = new JObject
{
{ "prop1", "value1" },
{ "prop2", true },
{ "prop3", 123 }
};
values.Add(jsonObject);
}
string json = values.ToString();
byte[] bytes = Encoding.UTF8.GetBytes(json);
MemoryStream ms = new MemoryStream(bytes);
var result = FunctionBinding.ReadAsCollection(ms).ToArray();
Assert.Equal(3, result.Length);
for (int i = 0; i < 3; i++)
{
JObject jsonObject = (JObject)result[i];
Assert.Equal("value1", (string)jsonObject["prop1"]);
Assert.Equal(true, (bool)jsonObject["prop2"]);
Assert.Equal(123, (int)jsonObject["prop3"]);
}
}
/// <summary>
/// Parse the property editors from the json array
/// </summary>
/// <param name="jsonEditors"></param>
/// <returns></returns>
internal static IEnumerable<PropertyEditor> GetPropertyEditors(JArray jsonEditors)
{
return JsonConvert.DeserializeObject<IEnumerable<PropertyEditor>>(
jsonEditors.ToString(),
new PropertyEditorConverter(),
new PreValueFieldConverter());
}
public static string GetAllTheme()
{
JArray ja = new JArray();
try
{
using (venuesEntities db = new venuesEntities())
{
string strSql = "SELECT tt.ID,tt.ThemeImage,tt.ThemeName,tt.Sequence FROM tbl_theme AS tt ORDER BY tt.Sequence";
ObjectQuery<DbDataRecord> kss = db.CreateQuery<DbDataRecord>(strSql);
foreach (var ks in kss)
{
ja.Add(
new JObject(
new JProperty("ID", ks["ID"].ToString()),
new JProperty("ThemeImage", ks["ThemeImage"].ToString()),
new JProperty("Sequence", ks["Sequence"].ToString()),
new JProperty("ThemeName", ks["ThemeName"].ToString())
)
);
};
}
}
catch (Exception e)
{
// LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_SalesManager, "查询所有主题,error=" + e.Message, loginUserInfo);
}
return ja.ToString();
}
private void Save()
{
JArray array = new JArray();
foreach(Control c in Page.Form.Controls){
if(c is TextBox){
TextBox tb = (TextBox) c;
if(!tb.Text.IsNullOrEmpty()){
array.Add(JObject.Parse("{\"id\":\"" + tb.ID + "\",\"value\":\"" + tb.Text.Trim() + "\"}"));
}
}
}
if(array.Count > 0){
int did = Request["did"].ToInt32();
FormData model = service.GetFormData(did,FormType.LQHHLJL);
if(model != null){
model.formdata = array.ToString();
service.UpdateFormData(model);
}
else{
service.AddFormData(new FormData
{
dataid = did,
formtype = FormType.LQHHLJL,
formdata = array.ToString()
});
}
if(sample != null){
sample.SerialNum = TextBox2.Text.Trim();
sample.JGBW = TextBox9.Text.Trim();
sampleService.UpdateSample(sample);
}
}
}
/// <summary>
/// Begins the async batch operation
/// </summary>
/// <param name="commandDatas">The command data.</param>
/// <returns></returns>
public Task<BatchResult[]> BatchAsync(ICommandData[] commandDatas)
{
var metadata = new JObject();
AddTransactionInformation(metadata);
var req = HttpJsonRequest.CreateHttpJsonRequest(this, url + "/bulk_docs", "POST", metadata, credentials);
var jArray = new JArray(commandDatas.Select(x => x.ToJson()));
var data = Encoding.UTF8.GetBytes(jArray.ToString(Formatting.None));
return Task.Factory.FromAsync(req.BeginWrite, req.EndWrite, data, null)
.ContinueWith(writeTask => Task.Factory.FromAsync<string>(req.BeginReadResponseString, req.EndReadResponseString,null))
.Unwrap()
.ContinueWith(task =>
{
string response;
try
{
response = task.Result;
}
catch (WebException e)
{
var httpWebResponse = e.Response as HttpWebResponse;
if (httpWebResponse == null ||
httpWebResponse.StatusCode != HttpStatusCode.Conflict)
throw;
throw ThrowConcurrencyException(e);
}
return JsonConvert.DeserializeObject<BatchResult[]>(response);
});
}
public static Tuple<string, string> SplitShowsByGenre(string json, string genre)
{
JArray selectedShowsJson = new JArray();
JArray otherShowsJson = new JArray();
foreach (JObject showJson in JArray.Parse(json))
{
bool genreFound = false;
foreach (JValue genreJson in showJson.Value<JArray>("genres"))
{
if (genreJson.ToString() == genre)
{
selectedShowsJson.Add(showJson);
genreFound = true;
break;
}
}
if (!genreFound)
{
otherShowsJson.Add(showJson);
}
}
return new Tuple<string, string>(selectedShowsJson.ToString(Formatting.None), otherShowsJson.ToString(Formatting.None));
}
public async Task<string> StartAsyncRequest(string url) {
//lookup user and convert all their feed items into json
//HACK CAUTION: fragile, screen_name is last param so we can do this as long as it doesn't change
string account = url.Split('=').Last();
var items = Data.feeditems[account];
var ja = new JArray();
foreach (var i in items) {
var jo = new JObject();
jo["user"] = new JObject {["screen_name"] = i.account};;
jo["created_at"] = i.createdAt.ToString(TwitterFeedItemService.twitterDateTimeFormat);
jo["id"] = i.id;
jo["text"] = i.text;
var m = new JArray();
for (int j = 1; j <= i.mentions; j++) {
m.Add("mention");
}
jo["entities"] = new JObject {["user_mentions"] = m};
ja.Add(jo);
}
var t = new Task<string>(() => ja.ToString());
t.Start();
return await t;
}
private async void button_send_Tapped(object sender, Windows.UI.Xaml.Input.TappedRoutedEventArgs e)
{
JArray ja = new JArray();
foreach (var a in ((ListView)listView_friends).SelectedItems)
{
classes.Friend friendToSendSnapTo = (classes.Friend)(a);
ja.Add(friendToSendSnapTo.username);
}
String JSON = await a.sendSnap(main.static_user, main.static_pass, pb, ja.ToString(), snap_file, int.Parse(slider_time.Value.ToString()));
//Frame.Navigate(typeof(snap_screen));
JObject jo = JObject.Parse(JSON);
if (jo["status"].ToString() == "True")
{
h.showSingleButtonDialog("Snap uploaded", "Snap uploaded successfully!", "Dismiss");
}
else
{
h.showSingleButtonDialog("Server error [" + jo["code"] + "]", ((jo["message"] != null) ? jo["message"].ToString() : "No server message was provided"), "Dismiss");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request["odds"] != null)
{
string[] oddsArray = Request["odds"].Split('|');
DataTable dt = this.FillOddsHistory(oddsArray);//填充
DateTime stime = Convert.ToDateTime(dt.Compute("max(time)", "")).AddHours(-6);// 6小时内
dt = dt.Select("time > '" + stime.ToString() + "'").CopyToDataTable();
JArray data = new JArray();
foreach (DataRow dr in dt.Rows)
{
DataSet ds = scheduleBLL.statOddsHistory("companyid=" + oddsArray[0] + " and e_win=" + dr["odds_w"] +
" and e_draw=" + dr["odds_d"] + " and e_lost=" + dr["odds_l"]);
if (Convert.ToInt32(ds.Tables[0].Rows[0]["totalcount"]) > 0)
{
JObject obj = new JObject();
obj.Add("time", dr["time"].ToString());
obj.Add("win", Convert.ToDecimal(ds.Tables[0].Rows[0]["perwin"]) - Convert.ToDecimal(dr["per_w"]) * 100);
obj.Add("draw", Convert.ToDecimal(ds.Tables[0].Rows[0]["perdraw"]) - Convert.ToDecimal(dr["per_d"]) * 100);
obj.Add("lost", Convert.ToDecimal(ds.Tables[0].Rows[0]["perlost"]) - Convert.ToDecimal(dr["per_l"]) * 100);
obj.Add("totalcount", Convert.ToInt32(ds.Tables[0].Rows[0]["totalcount"]));
data.Add(obj);
}
}
Response.Write(data.ToString());
Response.End();
}
}
}
public RestResponse AddAdditionalResults(int monitorId, JArray jsArray, long checktime)
{
var parameters = new Dictionary<String, Object>();
parameters.Add("monitorId", monitorId);
parameters.Add("results", jsArray.ToString());
parameters.Add("checktime", checktime);
return MakePostRequest(CustomMonitoraction.addAdditionalResults, parameters);
}
public IActionResult List()
{
JArray names = new JArray(
from name in FileAccess.GetVenueNames()
select new JValue(name)
);
return Content(names.ToString());
}
public IActionResult List()
{
JArray arr = new JArray(
from name in FileAccess.GetFixtureNames()
select new JValue(name)
);
return Content(arr.ToString());
}
public void JArray_Should_Support_Complex_Types()
{
var arry = new JArray();
arry.Add(1);
arry.Add("abc");
var result = arry.ToString(Formatting.None);
Assert.AreEqual("[1,\"abc\"]", result);
}
public virtual byte[] GetExceptionResponse(Exception ex)
{
JToken jresult = JToken.FromObject(ex.Message);
JArray response = new JArray();
response.Add("ERR");
response.Add(jresult);
return Encoding.UTF8.GetBytes(response.ToString(Formatting.None));
}
public void Example()
{
#region Usage
IList<BlogPost> blogPosts = new List<BlogPost>
{
new BlogPost
{
Title = "Json.NET is awesome!",
AuthorName = "James Newton-King",
AuthorTwitter = "JamesNK",
PostedDate = new DateTime(2013, 1, 23, 19, 30, 0),
Body = @"<h3>Title!</h3>
<p>Content!</p>"
}
};
JArray blogPostsArray = new JArray(
blogPosts.Select(p => new JObject
{
{ "Title", p.Title },
{
"Author", new JObject
{
{ "Name", p.AuthorName },
{ "Twitter", p.AuthorTwitter }
}
},
{ "Date", p.PostedDate },
{ "BodyHtml", HttpUtility.HtmlEncode(p.Body) },
})
);
Console.WriteLine(blogPostsArray.ToString());
// [
// {
// "Title": "Json.NET is awesome!",
// "Author": {
// "Name": "James Newton-King",
// "Twitter": "JamesNK"
// },
// "Date": "2013-01-23T19:30:00",
// "BodyHtml": "<h3>Title!</h3>\r\n<p>Content!</p>"
// }
// ]
#endregion
Assert.AreEqual(@"[
{
""Title"": ""Json.NET is awesome!"",
""Author"": {
""Name"": ""James Newton-King"",
""Twitter"": ""JamesNK""
},
""Date"": ""2013-01-23T19:30:00"",
""BodyHtml"": ""<h3>Title!</h3>\r\n <p>Content!</p>""
}
]", blogPostsArray.ToString());
}
public static void SavePlayerConfig()
{
var obj = new JArray();
foreach(var ply in playerConfig.Select(x => x.Value))
{
obj.Add(ply);
}
File.WriteAllText("Plugins/minetessentials/players.json", obj.ToString());
}
public IActionResult List()
{
JArray arr = new JArray(
from grp in MasterController.Instance.Groups.Values
orderby grp.Order
select new JValue(grp.Name)
);
return Content(arr.ToString());
}
public static byte[] CreateEventMessage(string eventType, object ev)
{
JToken jev = JToken.FromObject(ev);
var message = new JArray();
message.Add(8);
message.Add(eventType);
message.Add(jev);
return Encoding.UTF8.GetBytes(message.ToString(Formatting.None));
}
public virtual byte[] GetOKResponse(object returnValue)
{
JToken jresult = (returnValue == null) ? new JRaw("null") : JToken.FromObject(returnValue);
JArray response = new JArray();
response.Add("OK");
response.Add(jresult);
return Encoding.UTF8.GetBytes(response.ToString(Formatting.None));
}
public static byte[] CreateCallMessage(string callID, string methodName, params object[] args)
{
var message = new JArray();
message.Add(2);
message.Add(callID);
message.Add(methodName);
message.Add(JArray.FromObject(args));
return Encoding.UTF8.GetBytes(message.ToString(Formatting.None));
}
private static string DeserializeToDynamic(string json)
{
var requests = new JArray();
var array = JArray.Parse(json);
foreach (var item in array)
{
if (item is JArray)
{
foreach (var nested in item)
{
dynamic request = JsonConvert.DeserializeObject(nested.ToString(Formatting.None));
if (request.Body.Payload != null && request.Body.Payload.Payload != null)
{
var token = JToken.Parse(request.Body.Payload.Payload.ToString());
if (token is JArray)
{
var payload = JArray.Parse(request.Body.Payload.Payload.ToString());
request.Body.Payload.Payload = payload;
}
else
{
var payload = JObject.Parse(request.Body.Payload.Payload.ToString());
request.Body.Payload.Payload = payload;
}
}
if (request.Body.Payload != null && request.Body.Payload.MetaData != null)
{
var token = JToken.Parse(request.Body.Payload.MetaData.ToString());
if (token is JArray)
{
var metaData = JArray.Parse(request.Body.Payload.MetaData.ToString());
request.Body.Payload.MetaData = metaData;
}
else
{
var metaData = JObject.Parse(request.Body.Payload.MetaData.ToString());
request.Body.Payload.MetaData = metaData;
}
}
//requests.Add(request.ToString());
requests.Add(JArray.Parse("[" + request.ToString() + "]"));
}
}
}
return requests.ToString(Formatting.None);
}
public void ProcessRequest (HttpContext context) {
var lane_id = context.Request ["lane_id"].ToUInt32 ();
if (lane_id == null) {
context.Response.StatusCode = 400;
context.Response.ContentType = "text/plain";
context.Response.Write ("lane_id GET parameter is required.");
return;
}
using (var db = new DB ())
using (var cmd = db.CreateCommand ()) {
DB.CreateParameter (cmd, "nlimit", LIMIT);
DB.CreateParameter (cmd, "lane_id", (int) lane_id.Value);
cmd.CommandText = @"SELECT 1 FROM lane WHERE id = @lane_id";
if (cmd.ExecuteScalar () == null) {
context.Response.StatusCode = 404;
context.Response.ContentType = "text/plain";
context.Response.Write ("No such lane.");
return;
}
cmd.CommandText = @"
SELECT rw.id, lane, host.host, revision, rw.state, rw.createdtime, rw.assignedtime, rw.startedtime, rw.endtime, workhost.host
FROM revisionwork AS rw
INNER JOIN lane ON lane.id = rw.lane_id
INNER JOIN host ON host.id = rw.host_id
LEFT OUTER JOIN host AS workhost ON workhost.id = rw.workhost_id
INNER JOIN revision ON revision.id = rw.revision_id
WHERE lane.id = @lane_id AND createdtime IS NOT NULL
ORDER BY rw.createdtime DESC
LIMIT @nlimit;
";
using (var reader = cmd.ExecuteReader ()) {
var commits = new JArray ();
while (reader.Read ()) {
var commit = new JObject ();
commit ["id"] = reader.GetInt32 (0);
commit ["lane"] = reader.GetString (1);
commit ["host"] = reader.GetString (2);
commit ["revision"] = reader.GetString (3);
commit ["status"] = reader.GetInt32 (4);
commit ["createdtime"] = dateTimeToMilliseconds(reader.GetDateTimeOrNull(5));
commit ["assignedtime"] = dateTimeToMilliseconds(reader.GetDateTimeOrNull(6));
commit ["startedtime"] = dateTimeToMilliseconds(reader.GetDateTimeOrNull(7));
commit ["endtime"] = dateTimeToMilliseconds(reader.GetDateTimeOrNull(8));
commit ["assignedhost"] = reader.IsDBNull(9) ? null : reader.GetString (9);
commits.Add (commit);
}
context.Response.StatusCode = 200;
context.Response.ContentType = "application/json";
context.Response.Write (commits.ToString ());
}
}
}
public string T()
{
JArray array = new JArray();
JValue text = new JValue("Manual text");
JValue date = new JValue(new DateTime(2000, 5, 23));
array.Add(text);
array.Add(date);
string json = array.ToString();
return json;
}
public void PublishEvent(string topic, string publishID) {
foreach (WAMPClient c in clients) {
if (c.subscribedTopics.ContainsKey(topic)) {
JArray packet = new JArray();
packet.Add (WAMPMessageType.EVENT);
packet.Add (c.subscribedTopics[topic]);
packet.Add (publishID);
packet.Add (new JObject());
c.Send(packet.ToString());
}
}
}
public override byte[] GetExceptionResponse(Exception ex)
{
if (requestId == null || requestId.Type == JTokenType.Null)
return null;
JToken jresult = JToken.FromObject(ex.Message);
JArray response = new JArray();
response.Add(4);
response.Add(requestId);
response.Add(jresult);
return Encoding.UTF8.GetBytes(response.ToString(Formatting.None));
}
public override byte[] GetOKResponse(object returnValue)
{
if (requestId == null || requestId.Type == JTokenType.Null)
return null;
JToken jresult = (returnValue == null) ? new JRaw("null") : JToken.FromObject(returnValue);
JArray response = new JArray();
response.Add(3);
response.Add(requestId);
response.Add(jresult);
return Encoding.UTF8.GetBytes(response.ToString(Formatting.None));
}
public async Task Run()
{
// Gather download count data from statistics warehouse
IReadOnlyCollection<DownloadCountData> downloadData;
Trace.TraceInformation("Gathering Download Counts from {0}/{1}...", StatisticsDatabase.DataSource, StatisticsDatabase.InitialCatalog);
using (var connection = await StatisticsDatabase.ConnectTo())
using (var transaction = connection.BeginTransaction(IsolationLevel.Snapshot))
{
downloadData = (await connection.QueryWithRetryAsync<DownloadCountData>(
_storedProcedureName, commandType: CommandType.StoredProcedure, transaction: transaction, commandTimeout: _defaultCommandTimeout)).ToList();
}
Trace.TraceInformation("Gathered {0} rows of data.", downloadData.Count);
if (downloadData.Any())
{
SemanticVersion semanticVersion = null;
// Group based on Package Id
var grouped = downloadData.GroupBy(p => p.PackageId);
var registrations = new JArray();
foreach (var group in grouped)
{
var details = new JArray();
details.Add(group.Key);
foreach (var gv in group)
{
// downloads.v1.json should only contain normalized versions - ignore others
if (SemanticVersion.TryParse(gv.PackageVersion, out semanticVersion)
&& gv.PackageVersion == semanticVersion.ToNormalizedString())
{
var version = new JArray(gv.PackageVersion, gv.TotalDownloadCount);
details.Add(version);
}
}
registrations.Add(details);
}
var reportText = registrations.ToString(Formatting.None);
foreach (var storageContainerTarget in Targets)
{
try
{
var targetBlobContainer = await GetBlobContainer(storageContainerTarget);
var blob = targetBlobContainer.GetBlockBlobReference(ReportName);
Trace.TraceInformation("Writing report to {0}", blob.Uri.AbsoluteUri);
blob.Properties.ContentType = "application/json";
await blob.UploadTextAsync(reportText);
Trace.TraceInformation("Wrote report to {0}", blob.Uri.AbsoluteUri);
}
catch (Exception ex)
{
Trace.TraceError("Error writing report to storage account {0}, container {1}. {2} {3}",
storageContainerTarget.StorageAccount.Credentials.AccountName,
storageContainerTarget.ContainerName, ex.Message, ex.StackTrace);
}
}
}
}
