Пример #1
0
        private static void ReadTable()
        {
            if (PLGBAcct.bRead)
            {
                return;
            }
            uint   num          = 0;
            object szValue      = new object();
            uint   createHandle = PLLink.GetLink().TableGET_CreateHandle("GeneralBankAcct", 0, 0, 0U);

            PLLink.GetLink().TableGET_AddFilter(createHandle, "GeneralBankAcctStatus", "EQ", "0", 1);
            while (PLLink.GetLink().TableGET_GetNextRecord(createHandle) == 0)
            {
                PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "GeneralBankAcctNickName", "", ref szValue);
                string Key = szValue.ToString().ToUpper().Trim();
                int    recordFieldValueI32 = PLLink.GetLink().TableGET_RecordField_ValueI32(createHandle, "GeneralBankAcctID");
                PLGBAcct.AddMapNNtoID(Key, recordFieldValueI32);
                PLGBAcct.AddMapIDtoNN(recordFieldValueI32, Key);
                PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "GeneralBankAcctPostRefNickName", "", ref szValue);
                string str1 = szValue.ToString().ToUpper().Trim();
                PLGBAcct.AddMapIDtoGLNN(recordFieldValueI32, str1);
                PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "GeneralBankAcctQuickBooksID", "", ref szValue);
                string str2 = szValue.ToString().ToUpper().Trim();
                if (!str2.Equals(""))
                {
                    PLGBAcct.AddMapPLIDtoQBID(recordFieldValueI32, str2);
                }
            }
            PLLink.GetLink().TableGET_CloseHandle(createHandle);
            num            = 0U;
            PLGBAcct.bRead = true;
        }
Пример #2
0
 public static string GetNNFromID(int nID)
 {
     if (!PLGBAcct.bRead)
     {
         PLGBAcct.ReadTable();
     }
     return(PLGBAcct.m_MapIDtoNN.ContainsKey(nID) ? PLGBAcct.m_MapIDtoNN[nID].ToString() : "");
 }
Пример #3
0
 public static int GetIDFromNN(string Key)
 {
     if (!PLGBAcct.bRead)
     {
         PLGBAcct.ReadTable();
     }
     Key = Key.ToUpper();
     return(PLGBAcct.m_MapNNtoID.ContainsKey(Key) ? Convert.ToInt32(PLGBAcct.m_MapNNtoID[Key]) : 0);
 }
Пример #4
0
        public override void AddRecord()
        {
            base.AddRecord();
            this.GetLink().TablePOST_AddRecord(this.m_hndPOST);
            PLGBAcct plgbAcct = this;

            plgbAcct.m_lCounter = plgbAcct.m_lCounter + 1;
            if (this.m_lCounter < PLXMLData.m_nMaxCounter)
            {
                return;
            }
            this.Send();
        }
Пример #5
0
 public PCLawConversion()
 {
     try
     {
         this.PL               = new PLLink();
         this.GenInf           = new PLGenInfo();
         this.Lawyer           = new PLLawyer();
         this.User             = new PLUser();
         this.Rate             = new PLRate();
         this.ContactType      = new PLContactType();
         this.DiaryCode        = new PLDiaryCode();
         this.ExpCode          = new PLExpCode();
         this.GLAccts          = new PLGLAccts();
         this.Task             = new PLTask();
         this.GBAcct           = new PLGBAcct();
         this.TBAcct           = new PLTBAcct();
         this.TypeOfLaw        = new PLTypeOfLaw();
         this.Location         = new PLLocationCode();
         this.Department       = new PLDepartment();
         this.RefSource        = new PLRefSource();
         this.Client           = new PLClient();
         this.Contact          = new PLContact();
         this.Matter           = new PLMatter();
         this.Vendor           = new PLVendor();
         this.Bill             = new PLBilling();
         this.WUD              = new PLWUD();
         this.TimeEntry        = new PLTimeEntry();
         this.Trust            = new PLTBEnt();
         this.General          = new PLGBEnt();
         this.Expense          = new PLExpense();
         this.Payable          = new PLPayableEntry();
         this.GJ               = new PLGJEntry();
         this.Diary            = new PLDiary();
         this.SCStageGroup     = new PLSafeCustStageGroup();
         this.SCStage          = new PLSafeCustStage();
         this.SCType           = new PLSafeCustType();
         this.SCStatus         = new PLSafeCustStatus();
         this.SCPacket         = new PLSafeCustPacket();
         this.SCSafeCustRecord = new PLSafeCustEntry();
         this.SCMovements      = new PLSafeCustMovement();
         this.CustomTab        = new PLCustomTab();
     }
     catch (Exception ex)
     {
         int num = (int)MessageBox.Show(ex.Message);
     }
 }
Пример #6
0
        public static string GetQBIDFromPLID(int nID)
        {
            string str;

            if (!nID.Equals(0))
            {
                if (!PLGBAcct.bRead)
                {
                    PLGBAcct.ReadTable();
                }
                str = PLGBAcct.m_MapPLIDtoQBID == null ? "" : (PLGBAcct.m_MapPLIDtoQBID.ContainsKey(nID) ? Convert.ToString(PLGBAcct.m_MapPLIDtoQBID[nID]) : "");
            }
            else
            {
                str = "";
            }
            return(str);
        }
Пример #7
0
        public static int GetPLIDFromQBID(string sQBID)
        {
            int num1;

            if (!sQBID.Equals(""))
            {
                if (!PLGBAcct.bRead)
                {
                    PLGBAcct.ReadTable();
                }
                if (PLGBAcct.m_MapPLIDtoQBID == null)
                {
                    num1 = 0;
                }
                else if (PLGBAcct.m_MapPLIDtoQBID.ContainsValue(sQBID))
                {
                    int num2 = 0;
                    Dictionary <int, string> .Enumerator enumerator = PLGBAcct.m_MapPLIDtoQBID.GetEnumerator();
                    while (enumerator.MoveNext())
                    {
                        Dictionary <int, string>   mapPliDtoQbid = PLGBAcct.m_MapPLIDtoQBID;
                        KeyValuePair <int, string> current       = enumerator.Current;
                        if (mapPliDtoQbid[current.Key].ToUpper().CompareTo(sQBID.ToUpper()) == 0)
                        {
                            current = enumerator.Current;
                            num2    = current.Key;
                        }
                    }
                    num1 = num2;
                }
                else
                {
                    num1 = 0;
                }
            }
            else
            {
                num1 = 0;
            }
            return(num1);
        }
Пример #8
0
        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;
            string    str1      = "";
            PLGLAccts plglAccts = new PLGLAccts();

            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);
                    PLGBAcct.AddMapIDtoNN(int32, szValue.ToString());
                    PLGBAcct.AddMapNNtoID(szValue.ToString(), int32);
                    this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_GLNN.sLinkName, szDefault, ref szValue);
                    PLGBAcct.AddMapIDtoGLNN(int32, szValue.ToString());
                    this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_1.sLinkName, szDefault, ref szValue);
                    if (!szValue.ToString().Equals(""))
                    {
                        PLGBAcct.AddMapExtID1toPLID(szValue.ToString(), Convert.ToInt32(vunIDCreated));
                    }
                    this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_2.sLinkName, szDefault, ref szValue);
                    if (!szValue.ToString().Equals(""))
                    {
                        PLGBAcct.AddMapExtID2toPLID(szValue.ToString(), Convert.ToInt32(vunIDCreated));
                    }
                    this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, "GeneralBankAcctQuickBooksID", szDefault, ref szValue);
                    szValue = (object)szValue.ToString().ToUpper().Trim();
                    if (!szValue.Equals((object)""))
                    {
                        PLGBAcct.AddMapPLIDtoQBID(int32, szValue.ToString());
                        str1 = szValue.ToString();
                    }
                    this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, "GeneralBankAcctPostRefNickName", szDefault, ref szValue);
                    szValue = (object)szValue.ToString().ToUpper().Trim();
                    if (!szValue.Equals((object)""))
                    {
                        string str2 = szValue.ToString();
                        plglAccts.AddFilter(plglAccts.NickName_LinkName, PLXMLData.eFilterCompare.EQ, str2, 1);
                        while (plglAccts.GetNextRecord() == 0)
                        {
                            PLGLAccts.AddMapNNtoID(str2, plglAccts.ID);
                            PLGLAccts.AddMapIDtoNN(plglAccts.ID, str2);
                            plglAccts.ReadExisting((uint)plglAccts.ID);
                            if (str1 != "")
                            {
                                plglAccts.QuickBooksID = str1;
                                plglAccts.AddRecord();
                                plglAccts.SendLast();
                            }
                        }
                    }
                }
            }
            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);
                PLGBAcct plgbAcct = this;
                plgbAcct.m_lSendErrorCount = plgbAcct.m_lSendErrorCount + 1L;
            }
            this.GetLink().TablePOST_Reset(this.m_hndPOST);
            this.m_lCounter = 0;
        }