C# JSONObject.put方法代码示例

//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in .NET:
//ORIGINAL LINE: public Object toJSON() throws org.json.JSONException
			public object toJSON()
			{
				JSONObject json = new JSONObject();
				json.put(Model.MSG_ID, mMessgaeId);
				json.put(ID_Renamed, mId);
				return json;
			}

 public JSONObject toJson() {
     JSONObject obj = new JSONObject();
     if (id != null) obj.put("id", id);
     if (name != null) obj.put("name", name);
     if (type != null) obj.put("type", type);
     if (options != null) obj.put("seloptions", options);
     return obj;
 }

        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
                        }
                    }
                }
            }
        }

        private void insertHolidays() {
            mQuery.beginBatch();

            // Iterate on each state, which is a key in the Dictionary data object
            foreach (string state in mData.Keys) {
                // get the array of dates for the state
                DateTime[] dates = mData[state];

                // Create a multi value variable containing all holiday dates
                MultiValue value = new MultiValue();
                foreach (DateTime date in dates) {
                    value.add(date);
                }
                // Insert one record on the Account Settings table, which has a key = state and a value  = date1|date2|..... in epoch formar
                JSONObject record = new JSONObject();
                record.put("id", "HOLIDAY_" + state);
                record.put("value", value.ToString());

                mQuery.insert("System.settings", record);
            }
            mQuery.commitBatch();
        }

        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);
            }
        }

        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();
        }

        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);
            }
        }

        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);
            }
        }

        private List<Job> getCompletedJobs() {
            logStart("Getting Completed Jobs");
            List<Job> list = new List<Job>();

            JSONObject where = new JSONObject();
            where.put("status", Job.COMPLETED);
            JSONObject[] completedJobs = mQuery.select(Job.TABLE, where);
            foreach (JSONObject obj in completedJobs) {
                Job job = Job.fromJson(obj);
                list.Add(job);
            }
            logFinish("Finished getting " + list.Count + " completed Jobs");
            return list;
        }