예제 #1
0
        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;
        }
예제 #2
0
 public static string GetNNFromID(int Key)
 {
     if (!PLExpCode.bRead)
     {
         PLExpCode.ReadTable();
     }
     return(PLExpCode.m_MapIDtoNN.ContainsKey(Key) ? PLExpCode.m_MapIDtoNN[Key].ToString() : "");
 }
예제 #3
0
 public static int GetIDFromNN(string Key)
 {
     if (!PLExpCode.bRead)
     {
         PLExpCode.ReadTable();
     }
     Key = Key.ToUpper();
     return(PLExpCode.m_MapNNtoID.ContainsKey(Key) ? Convert.ToInt32(PLExpCode.m_MapNNtoID[Key]) : 0);
 }
예제 #4
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;
            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;
        }
예제 #5
0
        public override string MakeNN(bool bSetNickName)
        {
            if (!PLExpCode.bRead)
            {
                PLExpCode.ReadTable();
            }
            string str = this.MakeListNN(this.Name, PLExpCode.m_NNs, (short)6);

            if (bSetNickName)
            {
                this.NickName = str;
            }
            return(str);
        }
예제 #6
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);
     }
 }
예제 #7
0
        public static string GetQBIDFromPLID(int nID)
        {
            string str;

            if (!nID.Equals(0))
            {
                if (!PLExpCode.bRead)
                {
                    PLExpCode.ReadTable();
                }
                str = PLExpCode.m_MapPLIDtoQBID == null ? "" : (PLExpCode.m_MapPLIDtoQBID.ContainsKey(nID) ? Convert.ToString(PLExpCode.m_MapPLIDtoQBID[nID]) : "");
            }
            else
            {
                str = "";
            }
            return(str);
        }
예제 #8
0
        public override void AddRecord()
        {
            //if (!this.m_NickName.m_bIsSet)
            //  this.NickName = this.MakeNN(true);
            //else if ((this.m_ID.m_bIsSet && this.m_ID.nValue.Equals(0) || !this.m_ID.m_bIsSet) && PLExpCode.GetIDFromNN(this.NickName) > 0)
            // this.NickName = this.MakeNN(true);
            //else if ((this.NickName.Length.Equals(0) ? 1 : (this.NickName.Length > 6 ? 1 : 0)) != 0)
            //this.NickName = this.MakeNN(true);
            PLExpCode.AddNicknameToList(this.NickName);
            base.AddRecord();
            this.GetLink().TablePOST_AddRecord(this.m_hndPOST);
            PLExpCode plExpCode = this;

            plExpCode.m_lCounter = plExpCode.m_lCounter + 1;
            if (this.m_lCounter < PLXMLData.m_nMaxCounter)
            {
                return;
            }
            this.Send();
        }
예제 #9
0
        public static int GetPLIDFromQBID(string sQBID)
        {
            int num1;

            if (!sQBID.Equals(""))
            {
                if (!PLExpCode.bRead)
                {
                    PLExpCode.ReadTable();
                }
                if (PLExpCode.m_MapPLIDtoQBID == null)
                {
                    num1 = 0;
                }
                else if (PLExpCode.m_MapPLIDtoQBID.ContainsValue(sQBID))
                {
                    int num2 = 0;
                    Dictionary <int, string> .Enumerator enumerator = PLExpCode.m_MapPLIDtoQBID.GetEnumerator();
                    while (enumerator.MoveNext())
                    {
                        Dictionary <int, string>   mapPliDtoQbid = PLExpCode.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);
        }
예제 #10
0
        public override void AddRecord()
        {
            if ((int)this.m_hndPOST == 0)
            {
                this.m_hndPOST = this.GetLink().TablePOST_CreateHandle(this.m_sTableName, 0);
            }
            if (!this.m_NickName.m_bIsSet)
            {
                ++PLVendor.m_nVendorNN;
                this.NickName = "~" + PLVendor.m_nVendorNN.ToString();
            }
            else if ((this.m_ID.m_bIsSet && this.m_ID.nValue.Equals(0) || !this.m_ID.m_bIsSet) && PLVendor.GetIDFromNN(this.NickName) > 0)
            {
                ++PLVendor.m_nVendorNN;
                this.NickName = "~" + PLVendor.m_nVendorNN.ToString();
            }
            else if ((this.NickName.Length.Equals(0) ? 1 : (this.NickName.Length > 6 ? 1 : 0)) != 0)
            {
                ++PLVendor.m_nVendorNN;
                this.NickName = "~" + PLVendor.m_nVendorNN.ToString();
            }
            this.Name.AddFields(this.m_hndPOST);
            this.Address.AddFields(this.m_hndPOST);
            this.Phone.AddFields(this.m_hndPOST);
            this.m_ID.AddField(this.m_hndPOST);
            this.m_Status.AddField(this.m_hndPOST);
            this.m_NickName.AddField(this.m_hndPOST);
            if (this.DefExpCodeNN.Length > 0)
            {
                int idFromNn = PLExpCode.GetIDFromNN(this.DefExpCodeNN);
                if (idFromNn > 0)
                {
                    this.DefExpCodeID = idFromNn;
                    this.m_DefExpCode.AddField(this.m_hndPOST);
                    this.DefExpCodeNN = "";
                }
            }
            if (this.DefGLAcctNN.Length > 0)
            {
                int idFromNn = PLGLAccts.GetIDFromNN(this.DefExpCodeNN);
                if (idFromNn > 0)
                {
                    this.DefGLAcctID = idFromNn;
                    this.m_DefGLAcctID.AddField(this.m_hndPOST);
                    this.DefGLAcctNN = "";
                }
            }
            this.m_US1099BoxNumber.AddField(this.m_hndPOST);
            this.m_US1099ID.AddField(this.m_hndPOST);
            this.m_US1099Type.AddField(this.m_hndPOST);
            this.m_AcctNum.AddField(this.m_hndPOST);
            this.m_ActiveFlag.AddField(this.m_hndPOST);
            this.m_DefGSTCat.AddField(this.m_hndPOST);
            this.m_DiscDays1.AddField(this.m_hndPOST);
            this.m_DiscPct1.AddField(this.m_hndPOST);
            this.m_DiscDays2.AddField(this.m_hndPOST);
            this.m_DiscPct2.AddField(this.m_hndPOST);
            this.m_DiscDays3.AddField(this.m_hndPOST);
            this.m_DiscPct3.AddField(this.m_hndPOST);
            this.m_Notes.AddField(this.m_hndPOST);
            this.m_Terms.AddField(this.m_hndPOST);
            this.m_QuickBooksID.AddField(this.m_hndPOST);
            this.m_ContactID.AddField(this.m_hndPOST);
            this.m_ExternalID_1.AddField(this.m_hndPOST);
            this.m_ExternalID_2.AddField(this.m_hndPOST);
            this.GetLink().TablePOST_AddRecord(this.m_hndPOST);
            PLVendor plVendor = this;

            plVendor.m_lCounter = plVendor.m_lCounter + 1;
            if (this.m_lCounter < PLXMLData.m_nMaxCounter)
            {
                return;
            }
            this.Send();
        }