本文整理汇总了C#中Query.select方法的典型用法代码示例。如果您正苦于以下问题：C# Query.select方法的具体用法？C# Query.select怎么用？C# Query.select使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Query的用法示例。
在下文中一共展示了Query.select方法的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Find
public static Query Find( String condition, ObjectInfo state )
{
Includer includer = state.Includer;
if (strUtil.HasText( includer.SelectedProperty ) && (includer.SelectedProperty != "*")) {
Query query = new Query( condition, state );
return query.select( includer.SelectedProperty );
}
return new Query( condition, state );
}示例2: run
public void run() {
string token = Query.login("[email protected]", "demobiz");
Query query = new Query(token);
// 1. Get the Template Id for a given Template Name
JSONObject where = new JSONObject();
where.put("name", "My Template");
Template template = null;
JSONObject[] templates = query.select(Template.TABLE, where);
if (templates.Length == 0) {
// no template, creating a new one
} else {
template = Template.fromJson(templates[0]);
}
// 2. Selecting all submitted Forms for this template
JSONObject where2 = new JSONObject();
where2.put("templateid", template.id);
where2.put("status", Form.SUBMITTED);
JSONObject[] forms = query.select(Form.TABLE, where2);
foreach (JSONObject formObj in forms) {
Form form = Form.fromJson(formObj, query);
// Iterate on each form field and print out its value
foreach(FormField field in form.fields) {
Console.Write(" Label: " + field.label);
Console.Write(" Value: " + field.value);
Console.Write(" Type " + field.type);
Console.WriteLine(" ID: " + field.name);
// For photo fields, Download all photos for the field
if (field.type == "photo") {
File[] files = query.selectFiles("unybiz.forms.forms", (string) field.value);
foreach(File file in files) {
byte[] content = query.downloadFile(file.id);
// TODO Save it to disk
}
}
}
}
}示例3: run
public void run() {
try {
// Login
string token = Query.login("[email protected]", "demobiz");
Query query = new Query(token);
// 1. Select All Contacts
JSONObject[] items = query.select(Contact.TABLE, null);
foreach (JSONObject item in items) {
// get Contact object from Json for easy record values manipulation
Contact contact = Contact.fromJson(item);
Console.WriteLine("Name: " + contact.name + ", email:" + contact.email + ", mobile: " + contact.mobile);
}
// 2. Create a new contact
Contact newContact = new Contact();
newContact.id = "MyUniqueId";
newContact.name = "John Smith";
newContact.email = "[email protected]";
newContact.mobile = "6979 0486";
newContact.jobtitle = "CTO";
query.insert(Contact.TABLE, newContact.toJson());
// Verify that the contact has been correctly inserted by selecting it again
JSONObject obj = query.selectId(Contact.TABLE, newContact.id);
if (obj != null) {
Console.WriteLine("Contact: " + obj.ToString());
}
// 3. Update Contact
Contact updatedContact = new Contact();
updatedContact.mobile = "111111";
query.updateId(Contact.TABLE, newContact.id, updatedContact.toJson());
// Verify that the contact has been correctly updated
obj = query.selectId(Contact.TABLE, newContact.id);
if (obj != null) {
Console.WriteLine("Contact Mobile:" + obj.getString("mobile"));
}
// 4. Delete Contact
query.deleteId(Contact.TABLE, newContact.id);
// Verify that the contact has been correctly updated
obj = query.selectId(Contact.TABLE, newContact.id);
if (obj == null) {
Console.WriteLine("Contact has been deleted");
}
} catch (Exception e) {
Console.WriteLine("Error:" + e.Message);
}
}示例4: run
public void run() {
try {
// Login
string token = Query.login("[email protected]", "demobiz");
Query query = new Query(token);
// Query the System.settings table
JSONObject where = new JSONObject();
JSONObject[] items = query.select("System.settings", where);
foreach (JSONObject item in items) {
//if ()
}
} catch(Exception e) {
Console.WriteLine("Error: " + e.Message);
}
}示例5: run
public void run() {
try {
// Login
string token = Query.login("[email protected]", "demobiz");
Query query = new Query(token);
// 3. Returns all Assets with no geocode
JSONObject where = new JSONObject();
where.put("geo", "");
JSONObject[] assets = query.select("Assets.assets", where);
foreach (JSONObject obj in assets) {
Console.WriteLine(obj.ToString());
}
// Update the first asset with a geo location
JSONObject firstAsset = (assets.Length > 0) ? assets[0] : null;
if (firstAsset != null) {
JSONObject asset = new JSONObject();
asset.put("geo", "51.522020,-0.122198");
query.updateId("assets.assets", firstAsset.getString("id"), asset);
}
// Insert a new Asset
JSONObject newAsset = new JSONObject();
newAsset.put("id", "69794");
newAsset.put("name", "My Assset");
newAsset.put("model", "Fiat");
newAsset.put("geo", "48.858238, 2.347918");
newAsset.put("serialnumber", "69493949658TYH");
newAsset.putDate("purchasedate", DateTime.Now);
newAsset.put("purchaseprice", 12.4f);
newAsset.put("manufacturer", "Foxconn");
newAsset.put("geo", "48.858238,2.347918");
query.insert("assets.assets", newAsset);
} catch (Exception e) {
Console.WriteLine(e.Message);
}
}示例6: run
public void run() {
string token = Query.login("[email protected]", "demobiz");
Query query = new Query(token);
// 1. insert one job
Job newjob = new Job();
newjob.id = "ID1";
newjob.status = Job.OPEN;
newjob.name = "Maintain Air Conditining";
newjob.note = "Verify gaz pressure";
newjob.duedate = DateTime.Now.AddHours(2);
newjob.owner = "John"; // if you want to assign a Job, set the Upvise user Display name here
newjob.street = "1 infinite Loop";
newjob.city = "Cupertino";
newjob.zipcode = "";
newjob.country = "USA";
newjob.geo = "12,3.444"; // set the coordinates for the job
newjob.priority = Job.HIGHPRIORITY; // High priority
// set some custom fields values
newjob.setCustomField("F1", "WATER");
newjob.setCustomField("F2", "12");
query.insert(Job.TABLE, newjob.toJson());
// 2. Update the existing job and mark it complete
Job updatedValues = new Job();
updatedValues.status = Job.COMPLETED;
updatedValues.checkout = DateTime.Now;
updatedValues.checkoutnote = "Aircon is leaking, requirews further fixing";
query.updateId(Job.TABLE, "ID1", updatedValues.toJson());
// 3. Select All Completed Jobs
JSONObject where = new JSONObject();
where.put("status", Job.COMPLETED);
JSONObject[] completedJobs = query.select(Job.TABLE, where);
foreach (JSONObject obj in completedJobs) {
Job job = Job.fromJson(obj);
Console.Write("Checkout note: " + job.checkoutnote);
Console.Write("Custom Field 1: " + job.getCustomField("F1"));
Console.Write("Custom Field 2: " + job.getCustomField("F2"));
// Download all photos for the Job
File[] files = query.selectFiles(Job.TABLE, job.id);
foreach (File file in files) {
if (file.mime == "image/jpeg") {
byte[] content = query.downloadFile(file.id);
string filename = @"c:\temp\" + file.name + ".jpeg";
System.IO.File.WriteAllBytes(filename, content);
}
}
// Get All forms for the Job
JSONObject formWhere = new JSONObject();
formWhere.put("linkedid", job.id);
JSONObject[] forms = query.select(Form.TABLE, formWhere);
foreach (JSONObject formObj in forms) {
Form form = Form.fromJson(formObj, query);
Console.WriteLine("Form : " + formObj.ToString());
}
}
// 4. Delete completed Jobs in batch mode
query.beginBatch();
foreach (JSONObject obj in completedJobs) {
string jobid = obj.getString("id");
query.deleteId(Job.TABLE, jobid);
}
query.commitBatch();
}示例7: run
public void run() {
try {
// Login
string token = Query.login("[email protected]", "demobiz");
Console.WriteLine("Login OK");
// Create an instance of hte query class
Query query = new Query(token);
// Select all open tasks from the "Tasks.tasks" table
// You can go to your Upvise web account in the Task app and create some tasks first
JSONObject where = new JSONObject();
where.put("status", 0);
JSONObject[] tasks = query.select("Tasks.tasks", where);
Console.WriteLine("Found " + tasks.Length + " open tasks in this database");
foreach (JSONObject task in tasks) {
Console.WriteLine("Task ID: " + task.getString("id"));
Console.WriteLine("Name: " + task.getString("name"));
Console.WriteLine("Due Date: " + task.getDate("duedate"));
Console.WriteLine("Owner: " + task.getString("owner"));
Console.WriteLine("Status:" + task.getInt("status"));
}
// Create a bunch of tasks using Batch operation
Console.WriteLine("Creating 10 new tasks...");
query.beginBatch();
for (int i = 0; i < 10; i ++) {
JSONObject task = new JSONObject();
task.put("id", "TASKID_" + i);
task.put("name", "My Task " + i);
task.put("owner", "John");
task.put("status", 0);
task.putDate("duedate", DateTime.Now.AddDays(2));
query.insert("Tasks.tasks", task);
}
query.commitBatch();
// update All open John's Tasks and mark them complete (status=1)
where.put("owner", "John");
where.put("status", 0);
JSONObject[] myTasks = query.select("Tasks.tasks", where);
Console.WriteLine("found " + myTasks.Length + " open tasks for John");
// Start a new batch operation to group all updates into one HTTPS request for best performance
query.beginBatch();
foreach(JSONObject task in myTasks) {
string id = task.getString("id");
JSONObject values = new JSONObject();
values.putDate("duedate", DateTime.Now);
values.put("status", 1);
query.updateId("Tasks.tasks", id, values);
}
query.commitBatch();
Console.WriteLine("Updated the tasks to Complete");
// Now Get All John's completed Tasks, export them in a file and delete them
where.put("owner", "John");
where.put("status", 1);
JSONObject[] completedTasks = query.select("Tasks.tasks", where);
Console.WriteLine("found " + completedTasks.Length + " completed tasks for John");
StringBuilder buffer = new StringBuilder();
// Start a new batch operation
query.beginBatch();
foreach (JSONObject task in completedTasks) {
string id = task.getString("id");
// Add the task data in the buffer
buffer.AppendLine(task.ToString());
query.deleteId("Tasks.tasks", id);
}
query.commitBatch();
Console.WriteLine("Deleted completed tasks for John");
// Save the file to disk
System.IO.File.WriteAllText(@"C:\\temp\completedTasks.txt", buffer.ToString());
} catch (Exception e) {
Console.WriteLine("Error:" + e.Message);
}
}示例8: run
public void run() {
try {
// Login
string token = Query.login("[email protected]", "demobiz");
Query query = new Query(token);
// Create a new test Contact
string contactId = "TESTCONTACT1";
JSONObject contact = new JSONObject();
contact.put("id", contactId);
contact.put("name", "John Smith");
query.insert("Contacts.contacts", contact);
// Now upload 5 simple test files linked to the test contact
for (var i = 0; i < 5; i++) {
File file = new File();
file.id = "TESTFILE" + i;
file.name = "Test File " + i;
file.mime = "txt";
file.linkedtable = "unybiz.contacts.contacts";
file.linkedid = contactId;
byte[] content = Encoding.UTF8.GetBytes("This is a text file content");
// You can also load from a local file
// byte[] content = System.IO.File.ReadAllBytes(@"c:\temp\test.txt");
query.uploadFile(file, content);
Console.WriteLine("Uploaded one file : " + file.id);
}
// Select All Files for the contact and download their content
JSONObject where = new JSONObject();
where.put("linkedrecid", contactId);
JSONObject[] files = query.select(File.TABLE, where);
foreach (JSONObject obj in files) {
File file = File.fromJson(obj);
Console.WriteLine("File ID: " + file.id);
Console.Write(" Name: " + file.name);
Console.Write(" Size: " + file.size + " bytes");
Console.Write(" Creation Date: " + file.date);
// Download and write in disk the file content
byte[] content = query.downloadFile(file.id);
System.IO.File.WriteAllBytes(@"C:\temp\" + file.name + ".txt", content);
}
// Delete All Files in batch operation
query.beginBatch();
foreach (JSONObject obj in files) {
query.deleteId(File.TABLE, obj.getString("id"));
}
query.commitBatch();
Console.Write(" Deleted Files!");
} catch (Exception e) {
Console.WriteLine("Error:" + e.Message);
}
}