示例#1
0
        void ReplaceStrings()
        {
            ContractDTO contract = MainForm.DB.Contracts.Get(MainForm.DB.Invoices.Get((lBDeliveryNotes.SelectedItem as DeliveryNoteDTO).InvoiceId).ContractId);
            InvoiceDTO  invoice  = MainForm.DB.Invoices.Get((lBDeliveryNotes.SelectedItem as DeliveryNoteDTO).InvoiceId);

            WordWorker.FindReplace("{dateNakl}", dTPData.Value.ToShortDateString());
            WordWorker.FindReplace("{contractName}", contract.ToString());
            WordWorker.FindReplace("{invoiceName}", invoice.ToString());
            WordWorker.FindReplace("{numberNakl}", tBNumber.Text.ToString());
            WordWorker.FindReplace("{nameCompanySeller}", MainForm.DB.Sellers.Get(contract.SellerId).NameCompany);
            WordWorker.FindReplace("{nameCompanyCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).NameCompany);
            WordWorker.FindReplace("{fullNameCompanySeller}", MainForm.DB.Sellers.Get(contract.SellerId).FullNameCompany);
            WordWorker.FindReplace("{fullNameCompanyCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).FullNameCompany);
            WordWorker.FindReplace("{nameSeller}", MainForm.DB.Sellers.Get(contract.SellerId).NameSeller);
            WordWorker.FindReplace("{addressCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).AddressCompany);
            WordWorker.FindReplace("{addressSeller}", MainForm.DB.Sellers.Get(contract.SellerId).AddressCompany);
            WordWorker.FindReplace("{innCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).INN.ToString());
            WordWorker.FindReplace("{innSeller}", MainForm.DB.Sellers.Get(contract.SellerId).INN.ToString());
            WordWorker.FindReplace("{kppCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).KPP.ToString());
            WordWorker.FindReplace("{kppSeller}", MainForm.DB.Sellers.Get(contract.SellerId).KPP.ToString());
            WordWorker.FindReplace("{personalAccountCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).PersonalAccount);
            WordWorker.FindReplace("{corespAccountSeller}", MainForm.DB.Sellers.Get(contract.SellerId).CorrespondentAccount);
            WordWorker.FindReplace("{bikCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).BIK.ToString());
            WordWorker.FindReplace("{bikSeller}", MainForm.DB.Sellers.Get(contract.SellerId).BIK.ToString());
            WordWorker.FindReplace("{bikCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).BIK.ToString());
            WordWorker.FindReplace("{bankCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).Bank);
            WordWorker.FindReplace("{bankSeller}", MainForm.DB.Sellers.Get(contract.SellerId).Bank);
            WordWorker.FindReplace("{bankAccountCustomer}", MainForm.DB.Customers.Get(contract.CustomerId).BankAccount);
            WordWorker.FindReplace("{bankAccountSeller}", MainForm.DB.Sellers.Get(contract.SellerId).BankAccount);
            WordWorker.FindReplace("{priemName}", tBPriemName.Text);
            WordWorker.FindReplace("{gruzName}", tBGruzName.Text);

            string replacedOfWord = WordWorker.ReplaceOfWord(float.Parse(lSumm.Text));

            if (lSumm.Text.Contains(','))
            {
                if (lSumm.Text.Substring(lSumm.Text.IndexOf(',')).Length - 1 == 2)
                {
                    WordWorker.FindReplace("{total}", replacedOfWord.Remove(replacedOfWord.Length - 1));
                    WordWorker.FindReplace("{kopeiki}", lSumm.Text.Substring(lSumm.Text.IndexOf(',') + 1));
                }
                else
                {
                    WordWorker.FindReplace("{total}", replacedOfWord.Remove(replacedOfWord.Length - 1));
                    WordWorker.FindReplace("{kopeiki}", lSumm.Text.Substring(lSumm.Text.IndexOf(',') + 1) + "0");
                }
            }
            else
            {
                WordWorker.FindReplace("{total}", replacedOfWord.Remove(replacedOfWord.Length - 1));
                WordWorker.FindReplace("{kopeiki}", "00");
            }
        }
        void ReplaceStrings()
        {
            WordWorker.FindReplace("{date}", dTPData.Value.ToShortDateString());
            WordWorker.FindReplace("{contractDate}", (cBContracts.SelectedItem as ContractDTO).ConclusionDate.ToLongDateString());
            WordWorker.FindReplace("{contractNumber}", (cBContracts.SelectedItem as ContractDTO).Number.ToString());
            WordWorker.FindReplace("{number}", tBNumber.Text.ToString());
            WordWorker.FindReplace("{NameCompanySeller}", MainForm.DB.Sellers.Get((cBContracts.SelectedItem as ContractDTO).SellerId).NameCompany);
            WordWorker.FindReplace("{nameCompanyCustomer}", MainForm.DB.Customers.Get((cBContracts.SelectedItem as ContractDTO).CustomerId).NameCompany);
            WordWorker.FindReplace("{nameSeller}", MainForm.DB.Sellers.Get((cBContracts.SelectedItem as ContractDTO).SellerId).NameSeller);
            WordWorker.FindReplace("{addressCustomer}", MainForm.DB.Customers.Get((cBContracts.SelectedItem as ContractDTO).CustomerId).AddressCompany);
            WordWorker.FindReplace("{addressSeller}", MainForm.DB.Sellers.Get((cBContracts.SelectedItem as ContractDTO).SellerId).AddressCompany);
            WordWorker.FindReplace("{innCustomer}", MainForm.DB.Customers.Get((cBContracts.SelectedItem as ContractDTO).CustomerId).INN.ToString());
            WordWorker.FindReplace("{innSeller}", MainForm.DB.Sellers.Get((cBContracts.SelectedItem as ContractDTO).SellerId).INN.ToString());
            WordWorker.FindReplace("{kppCustomer}", MainForm.DB.Customers.Get((cBContracts.SelectedItem as ContractDTO).CustomerId).KPP.ToString());
            WordWorker.FindReplace("{kppSeller}", MainForm.DB.Sellers.Get((cBContracts.SelectedItem as ContractDTO).SellerId).KPP.ToString());
            string replacedOfWord = WordWorker.ReplaceOfWord(Math.Round(float.Parse(lSumm.Text), 2));

            if (lSumm.Text.Contains(','))
            {
                if (lSumm.Text.Substring(lSumm.Text.IndexOf(',')).Length - 1 == 2)
                {
                    WordWorker.FindReplace("{total}", replacedOfWord.Remove(replacedOfWord.Length - 1));
                    WordWorker.FindReplace("{kopeiki}", lSumm.Text.Substring(lSumm.Text.IndexOf(',') + 1));
                }
                else
                {
                    WordWorker.FindReplace("{total}", replacedOfWord.Remove(replacedOfWord.Length - 1));
                    WordWorker.FindReplace("{kopeiki}", lSumm.Text.Substring(lSumm.Text.IndexOf(',') + 1) + "0");
                }
            }
            else
            {
                WordWorker.FindReplace("{total}", replacedOfWord.Remove(replacedOfWord.Length - 1));
                WordWorker.FindReplace("{kopeiki}", "00");
            }
        }
        void ReplaceStrings()
        {
            WordWorker.FindReplace("{date}", dTPData.Value.ToShortDateString());
            WordWorker.FindReplace("{dateEnd}", dTPOkonch.Value.ToShortDateString());
            WordWorker.FindReplace("{typeSpec}", cBTypeProducts.Text);
            WordWorker.FindReplace("{number}", tBNumber.Text.ToString());
            WordWorker.FindReplace("{address}", "п.Советский");
            WordWorker.FindReplace("{fullNameCompanyCustomer}", (cBCustomer.SelectedItem as CustomerDTO).FullNameCompany);
            WordWorker.FindReplace("{fullNameCompanySeller}", (cBSeller.SelectedItem as SellerDTO).FullNameCompany);
            WordWorker.FindReplace("{nameCustomerSpec}", (cBCustomer.SelectedItem as CustomerDTO).NameCustomerSpec);
            WordWorker.FindReplace("{nameCustomer}", (cBCustomer.SelectedItem as CustomerDTO).NameCustomer);
            WordWorker.FindReplace("{nameSeller}", (cBSeller.SelectedItem as SellerDTO).NameSeller);
            WordWorker.FindReplace("{nameSellerSpec}", (cBSeller.SelectedItem as SellerDTO).NameSellerSpec);
            WordWorker.FindReplace("{addressCustomer}", (cBCustomer.SelectedItem as CustomerDTO).AddressCompany);
            WordWorker.FindReplace("{addressSeller}", "Адрес: " + (cBSeller.SelectedItem as SellerDTO).AddressCompany);
            if (!(cBSeller.SelectedItem as SellerDTO).Email.Equals(""))
            {
                WordWorker.FindReplace("{emailSeller}", "Email:" + (cBSeller.SelectedItem as SellerDTO).Email);
            }
            else
            {
                WordWorker.FindReplace("{emailSeller}", "" + (cBSeller.SelectedItem as SellerDTO).Email);
            }
            WordWorker.FindReplace("{personalAccountCustomer}", (cBCustomer.SelectedItem as CustomerDTO).PersonalAccount);
            if (!(cBSeller.SelectedItem as SellerDTO).PersonalAccount.Equals(""))
            {
                WordWorker.FindReplace("{corespAccountSeller}", "к/с: " + (cBSeller.SelectedItem as SellerDTO).CorrespondentAccount);
            }
            else
            {
                WordWorker.FindReplace("{corespAccountSeller}", "" + (cBSeller.SelectedItem as SellerDTO).CorrespondentAccount);
            }
            WordWorker.FindReplace("{bikCustomer}", (cBCustomer.SelectedItem as CustomerDTO).BIK.ToString());
            if (!(cBSeller.SelectedItem as SellerDTO).BIK.Equals(""))
            {
                WordWorker.FindReplace("{bikSeller}", "БИК: " + (cBSeller.SelectedItem as SellerDTO).BIK.ToString());
            }
            else
            {
                WordWorker.FindReplace("{bikSeller}", "" + (cBSeller.SelectedItem as SellerDTO).BIK.ToString());
            }
            if (!(cBSeller.SelectedItem as SellerDTO).OGRN.Equals(""))
            {
                WordWorker.FindReplace("{ogrnSeller}", "ОГРН: " + (cBSeller.SelectedItem as SellerDTO).OGRN.ToString());
            }
            else
            {
                WordWorker.FindReplace("{ogrnSeller}", "" + (cBSeller.SelectedItem as SellerDTO).OGRN.ToString());
            }
            WordWorker.FindReplace("{bikCustomer}", (cBCustomer.SelectedItem as CustomerDTO).BIK.ToString());
            WordWorker.FindReplace("{innCustomer}", (cBCustomer.SelectedItem as CustomerDTO).INN.ToString());
            if (!(cBSeller.SelectedItem as SellerDTO).INN.Equals(""))
            {
                WordWorker.FindReplace("{innSeller}", "ИНН: " + (cBSeller.SelectedItem as SellerDTO).INN.ToString());
            }
            else
            {
                WordWorker.FindReplace("{innSeller}", "" + (cBSeller.SelectedItem as SellerDTO).INN.ToString());
            }
            WordWorker.FindReplace("{kppCustomer}", (cBCustomer.SelectedItem as CustomerDTO).KPP.ToString());
            if (!(cBSeller.SelectedItem as SellerDTO).KPP.Equals(""))
            {
                WordWorker.FindReplace("{kppSeller}", "КПП: " + (cBSeller.SelectedItem as SellerDTO).KPP.ToString());
            }
            else
            {
                WordWorker.FindReplace("{kppSeller}", "" + (cBSeller.SelectedItem as SellerDTO).KPP.ToString());
            }
            WordWorker.FindReplace("{bankCustomer}", (cBCustomer.SelectedItem as CustomerDTO).Bank);
            if (!(cBSeller.SelectedItem as SellerDTO).Bank.Equals(""))
            {
                WordWorker.FindReplace("{bankSeller}", "Банк: " + (cBSeller.SelectedItem as SellerDTO).Bank);
            }
            else
            {
                WordWorker.FindReplace("{bankSeller}", "" + (cBSeller.SelectedItem as SellerDTO).Bank);
            }
            WordWorker.FindReplace("{bankAccountCustomer}", (cBCustomer.SelectedItem as CustomerDTO).BankAccount);
            if (!(cBSeller.SelectedItem as SellerDTO).BankAccount.Equals(""))
            {
                WordWorker.FindReplace("{bankAccountSeller}", "р/с: " + (cBSeller.SelectedItem as SellerDTO).BankAccount);
            }
            else
            {
                WordWorker.FindReplace("{bankAccountSeller}", "" + (cBSeller.SelectedItem as SellerDTO).BankAccount);
            }
            if (!(cBSeller.SelectedItem as SellerDTO).PhoneNumber.Equals(""))
            {
                WordWorker.FindReplace("{phoneSeller}", "Телефон: " + (cBSeller.SelectedItem as SellerDTO).PhoneNumber);
            }
            else
            {
                WordWorker.FindReplace("{phoneSeller}", "" + (cBSeller.SelectedItem as SellerDTO).PhoneNumber);
            }
            WordWorker.FindReplace("{rangSeller}", (cBSeller.SelectedItem as SellerDTO).RangSeller);
            WordWorker.FindReplace("{nameResponssable}", tBOtv.Text.ToString());
            WordWorker.FindReplace("{year}", dTPData.Value.Year.ToString());
            WordWorker.FindReplace("{total}", Math.Round(float.Parse(lSumm.Text)).ToString());
            string replacedOfWord = WordWorker.ReplaceOfWord(float.Parse(lSumm.Text));

            if (lSumm.Text.Contains(','))
            {
                if (lSumm.Text.Substring(lSumm.Text.IndexOf(',')).Length - 1 == 2)
                {
                    WordWorker.FindReplace("{totalRub}", replacedOfWord.Remove(replacedOfWord.Length - 1));
                    WordWorker.FindReplace("{kopeiki}", lSumm.Text.Substring(lSumm.Text.IndexOf(',') + 1));
                }
                else
                {
                    WordWorker.FindReplace("{totalRub}", replacedOfWord.Remove(replacedOfWord.Length - 1));
                    WordWorker.FindReplace("{kopeiki}", lSumm.Text.Substring(lSumm.Text.IndexOf(',') + 1) + "0");
                }
            }
            else
            {
                WordWorker.FindReplace("{totalRub}", replacedOfWord.Remove(replacedOfWord.Length - 1));
                WordWorker.FindReplace("{kopeiki}", "00");
            }
        }