private static void ReadTable() { if (PLExpCode.bRead) { return; } uint num = 0; object szValue = new object(); uint createHandle = PLLink.GetLink().TableGET_CreateHandle("Explanation", 0, 0, 0U); PLLink.GetLink().TableGET_AddFilter(createHandle, "ActivityStatus", "EQ", "0", 1); while (PLLink.GetLink().TableGET_GetNextRecord(createHandle) == 0) { PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "ActivityNickName", "", ref szValue); string sNickname = szValue.ToString().ToUpper().Trim(); int recordFieldValueI32 = PLLink.GetLink().TableGET_RecordField_ValueI32(createHandle, "ActivityID"); PLExpCode.AddMapIDtoNN(recordFieldValueI32, sNickname.ToUpper()); PLExpCode.AddMapNNtoID(sNickname.ToUpper(), recordFieldValueI32); PLExpCode.AddNicknameToList(sNickname); PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "ActivityName", "", ref szValue); PLExpCode.AddMapIDtoExplanation(recordFieldValueI32, szValue.ToString()); PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "ActivityQuickBooksID", "", ref szValue); string str = szValue.ToString().ToUpper().Trim(); if (!str.Equals("")) { PLExpCode.AddMapPLIDtoQBID(recordFieldValueI32, str); } } PLLink.GetLink().TableGET_CloseHandle(createHandle); num = 0U; PLExpCode.bRead = true; }
public override void Send() { object nProcessed = new object(); object nExceptions = new object(); object vunIDCreated = new object(); object nExceptionError = new object(); object szExceptionErrorMsg = new object(); object szExceptionSentData = new object(); object szValue = new object(); string szDefault = ""; this.m_lSendErrorCount = 0L; this.GetLink().TablePOST_Send(this.m_hndPOST, ref nProcessed, ref nExceptions); while (this.GetLink().TablePOST_GetNextResult(this.m_hndPOST, ref vunIDCreated, ref nExceptionError, ref szExceptionErrorMsg, ref szExceptionSentData) == 0) { if (Convert.ToInt32(nExceptionError) <= 0) { int int32 = Convert.ToInt32(vunIDCreated); this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_NickName.sLinkName, szDefault, ref szValue); PLExpCode.AddMapIDtoNN(int32, szValue.ToString().ToUpper()); PLExpCode.AddMapNNtoID(szValue.ToString().ToUpper(), int32); this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_Name.sLinkName, szDefault, ref szValue); if (!szValue.ToString().Equals("")) { PLExpCode.AddMapIDtoExplanation(int32, szValue.ToString()); } this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_1.sLinkName, szDefault, ref szValue); if (!szValue.ToString().Equals("")) { PLExpCode.AddMapExtID1toPLID(szValue.ToString(), int32); } this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_2.sLinkName, szDefault, ref szValue); if (!szValue.ToString().Equals("")) { PLExpCode.AddMapExtID2toPLID(szValue.ToString(), int32); } this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, "ActivityQuickBooksID", szDefault, ref szValue); PLExpCode.AddMapPLIDtoQBID(Convert.ToInt32(vunIDCreated), szValue.ToString()); } } short int16_1 = Convert.ToInt16(nProcessed); short int16_2 = Convert.ToInt16(nExceptions); PLXMLData.m_lErrorCount += (long)int16_2; if (((int)int16_2 > 0 ? 1 : (this.m_lCounter != (int)int16_1 ? 1 : 0)) != 0) { this.GetLink().TablePOST_DumpExceptionsToLinkLog(this.m_hndPOST); PLExpCode plExpCode = this; plExpCode.m_lSendErrorCount = plExpCode.m_lSendErrorCount + 1L; } this.GetLink().TablePOST_Reset(this.m_hndPOST); this.m_lCounter = 0; }