private static DataTable GetSforceData() { DataTable dt = null; mypartner.SforceService binding = new mypartner.SforceService(); mypartner.LoginResult lr = binding.login("*****@*****.**", "xyz6854XhuVzAcbHWENCYLHNQX41z943"); string strSQL ="", strColumnNames = ""; if (!lr.passwordExpired) { binding.Url = lr.serverUrl; binding.SessionHeaderValue = new mypartner.SessionHeader(); binding.SessionHeaderValue.sessionId = lr.sessionId; mypartner.QueryResult qr = null; binding.QueryOptionsValue = new mypartner.QueryOptions(); binding.QueryOptionsValue.batchSize = 25; binding.QueryOptionsValue.batchSizeSpecified = true; qr = binding.query(strSQL); bool done = false; if (qr.size > 0) { dt = new DataTable(); mypartner.sObject sOtmp = (mypartner.sObject)qr.records[0]; int iColumnCount = 0; if (strColumnNames.Length > 0) { string[] arrColumnNames = strColumnNames.Split(','); iColumnCount = arrColumnNames.Length; for (int i = 0; i < iColumnCount; i++) { dt.Columns.Add(arrColumnNames.GetValue(i).ToString()); } } else { iColumnCount = sOtmp.Any.Length; for (int i = 0; i < sOtmp.Any.Length; i++) { dt.Columns.Add(sOtmp.Any[i].LocalName); } } string[] prValues = new string[iColumnCount]; while (!done) { for (int i = 0; i < qr.records.Length; i++) { sOtmp = (mypartner.sObject)qr.records[i]; int j = 0, iColIndex = 0; while (j < sOtmp.Any.Length) { prValues.SetValue(sOtmp.Any[j].InnerText, iColIndex); iColIndex++; j++; } dt.Rows.Add(prValues); } if (qr.done) { done = true; } else { qr = binding.queryMore(qr.queryLocator); } } } } return dt; }
private void button1_Click(object sender, EventArgs e) { try { mypartner.SforceService binding = new mypartner.SforceService(); mypartner.LoginResult lr = binding.login("*****@*****.**", "xyz6854XhuVzAcbHWENCYLHNQX41z943"); if (!lr.passwordExpired) { binding.Url = lr.serverUrl; binding.SessionHeaderValue = new mypartner.SessionHeader(); binding.SessionHeaderValue.sessionId = lr.sessionId; mypartner.sObject[] accs = new mypartner.sObject[1]; mypartner.sObject sObj = new mypartner.sObject(); System.Xml.XmlElement[] acct = new System.Xml.XmlElement[14]; System.Xml.XmlDocument doc = new System.Xml.XmlDocument(); acct[0] = doc.CreateElement("Name"); acct[0].InnerText = txtName.Text.Trim(); acct[1] = doc.CreateElement("FirstPlayer__c"); acct[1].InnerText = txtFirstPlayer.Text; acct[2] = doc.CreateElement("SecondPlayer__c"); acct[2].InnerText = txtSecondPlayer.Text; acct[3] = doc.CreateElement("MoveList__c"); acct[3].InnerText = txtMoveList.Text; acct[4] = doc.CreateElement("Description__c"); acct[4].InnerText = txtDescription.Text; acct[5] = doc.CreateElement("Event__c"); acct[5].InnerText = txtEvent.Text; acct[6] = doc.CreateElement("Round__c"); acct[6].InnerText = txtRound.Text; acct[7] = doc.CreateElement("PlayDate__c"); acct[7].InnerText = txtPlayDate.Text; acct[8] = doc.CreateElement("RedFirst__c"); acct[8].InnerText = txtRed.Text; acct[9] = doc.CreateElement("Result__c"); acct[9].InnerText = txtResult.Text; acct[10] = doc.CreateElement("SharedBy__c"); acct[10].InnerText = txtSharedBy.Text; acct[11] = doc.CreateElement("SharedToken__c"); acct[11].InnerText = txtSharedToken.Text; acct[12] = doc.CreateElement("Source__c"); acct[12].InnerText = txtSource.Text; acct[13] = doc.CreateElement("XiangqiType__c"); acct[13].InnerText = txtXiangqiType.Text; sObj.type = "Xiangqi__c"; sObj.Any = acct; accs[0] = sObj; mypartner.SaveResult[] sr = binding.create(accs); for (int k = 0; k < sr.Length; k++) { if (sr[k].success) { } else { } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { try { mypartner.SforceService binding = new mypartner.SforceService(); mypartner.LoginResult lr = binding.login("*****@*****.**", "+v+h@0+v6854XhuVzAcbHWENCYLHNQX41z943"); if (!lr.passwordExpired) { binding.Url = lr.serverUrl; binding.SessionHeaderValue = new mypartner.SessionHeader(); binding.SessionHeaderValue.sessionId = lr.sessionId; mypartner.sObject[] accs = new mypartner.sObject[1]; mypartner.sObject sObj = new mypartner.sObject(); System.Xml.XmlElement[] acct = new System.Xml.XmlElement[12]; System.Xml.XmlDocument doc = new System.Xml.XmlDocument(); acct[0] = doc.CreateElement("Name"); acct[0].InnerText = txtName.Text.Trim(); acct[1] = doc.CreateElement("Author__c"); acct[1].InnerText = txtAuthor.Text; acct[2] = doc.CreateElement("MoveList__c"); acct[2].InnerText = txtMoveList.Text; acct[3] = doc.CreateElement("Description__c"); acct[3].InnerText = txtDescription.Text; acct[4] = doc.CreateElement("RedFirst__c"); acct[4].InnerText = txtRed.Text; acct[5] = doc.CreateElement("Result__c"); acct[5].InnerText = txtResult.Text; acct[6] = doc.CreateElement("SharedBy__c"); acct[6].InnerText = txtSharedBy.Text; acct[7] = doc.CreateElement("SharedToken__c"); acct[7].InnerText = txtSharedToken.Text; acct[8] = doc.CreateElement("Source__c"); acct[8].InnerText = txtSource.Text; acct[9] = doc.CreateElement("Comments__c"); acct[9].InnerText = txtComments.Text; acct[10] = doc.CreateElement("Variations__c"); acct[10].InnerText = txtVariations.Text; acct[11] = doc.CreateElement("Fen__c"); acct[11].InnerText = txtFen.Text; sObj.type = "XiangqiQuiz__c"; sObj.Any = acct; accs[0] = sObj; mypartner.SaveResult[] sr = binding.create(accs); for (int k = 0; k < sr.Length; k++) { if (sr[k].success) { MessageBox.Show(sr[k].id.ToString()); } else { } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }