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