예제 #1
0
        static public void ImportBookBayMain2014(IObjectSpace os, fmCAVTBookVAT book)
        {
            Int32  kvartal   = Int32.Parse(book.PeriodKV);
            String period_m1 = book.PeriodYYYY + ((kvartal - 1) * 3 + 1).ToString("00");
            String period_m2 = book.PeriodYYYY + ((kvartal - 1) * 3 + 2).ToString("00");
            String period_m3 = book.PeriodYYYY + ((kvartal - 1) * 3 + 3).ToString("00");
            IList <fmCAVTInvoiceOperationType> oper_types = os.GetObjects <fmCAVTInvoiceOperationType>();

            os.Delete(book.BookVATRecords);
            UInt32 seq_num = 1;
            IList <fmCAVTBookBuhRecord> buhrecs = os.GetObjects <fmCAVTBookBuhRecord>(
                XPQuery <fmCAVTBookBuhRecord> .TransformExpression(((ObjectSpace)os).Session,
                                                                   rec => rec.BookBuhImport.IsNotUse == false && rec.BookType == "B" && (
                                                                       rec.PeriodOtchet == period_m1 ||
                                                                       rec.PeriodOtchet == period_m2 ||
                                                                       rec.PeriodOtchet == period_m3
                                                                       //&& (rec.RecordType != "AON" ||
                                                                       // rec.RecordType == "AON" &&
                                                                       // rec.RecordSummType == "NDS" &&
                                                                       // rec.SummVAT != 0)
                                                                       )
                                                                   ));
            var invoice_buhrecs = buhrecs.GroupBy(rec => new {
//                rec.RecordType,
                rec.AVTInvoicePartyCode,
                rec.AVTInvoiceType,
                rec.AVTInvoiceRegNumber,
                rec.AVTInvoiceNumber,
                rec.AVTInvoiceDate
            }).OrderBy(key => key.Key.AVTInvoicePartyCode);

            //
            foreach (var invoice_buhrec in invoice_buhrecs)
            {
                if (String.IsNullOrEmpty(invoice_buhrec.Key.AVTInvoiceType.Trim()))
                {
                    continue;
                }
                if (invoice_buhrec.Key.AVTInvoiceType.Trim() == "рд")
                {
                    continue;
                }
                fmCAVTBookVATRecord rec   = os.CreateObject <fmCAVTBookVATRecord>();
                crmCParty           party = os.GetObjects <crmCParty>(new BinaryOperator("Code", invoice_buhrec.Key.AVTInvoicePartyCode)).FirstOrDefault();
                rec.BuhRecordType =
                    invoice_buhrec.Select(x => x.RecordType).Distinct().OrderBy(x => x).Aggregate((x, y) => x + ";" + y);
                rec.Party               = party;
                rec.VATInvoiceType      = invoice_buhrec.Key.AVTInvoiceType;
                rec.VATInvoiceRegNumber = invoice_buhrec.Key.AVTInvoiceRegNumber;
                rec.VATInvoiceNumber    = invoice_buhrec.Key.AVTInvoiceNumber;
                rec.VATInvoiceDate      = invoice_buhrec.Key.AVTInvoiceDate;
                rec.Invoice             = os.FindObject <fmCAVTInvoiceBase>(
                    CriteriaOperator.And(new BinaryOperator("Number", invoice_buhrec.Key.AVTInvoiceNumber),
                                         new BinaryOperator("Date", invoice_buhrec.Key.AVTInvoiceDate.Date, BinaryOperatorType.GreaterOrEqual),
                                         new BinaryOperator("Date", invoice_buhrec.Key.AVTInvoiceDate.Date.AddDays(1), BinaryOperatorType.Less),
                                         new BinaryOperator("Supplier", party)));
                if (invoice_buhrec.Key.AVTInvoiceType == "ятю" && rec.Invoice == null)
                {
                    rec.Invoice = os.FindObject <fmCAVTInvoiceBase>(
                        CriteriaOperator.And(new BinaryOperator("Number", invoice_buhrec.Key.AVTInvoiceNumber),
                                             new BinaryOperator("Date", invoice_buhrec.Key.AVTInvoiceDate.Date, BinaryOperatorType.GreaterOrEqual),
                                             new BinaryOperator("Date", invoice_buhrec.Key.AVTInvoiceDate.Date.AddDays(1), BinaryOperatorType.Less),
                                             new BinaryOperator("Customer", party)));
                }
                rec.PayDate = invoice_buhrec.Select(buhrec => buhrec.PayDocDate).Max();
                rec.BuhDate = invoice_buhrec.Select(buhrec => buhrec.BuhDocDate).Min();
                //Decimal SummNoVAT_18;
                //Decimal SummNoVAT_10;
                //rec.SummVAT_18 = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "2").Sum(buhrec => buhrec.SummVAT);
                //SummNoVAT_18 = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "2").Sum(buhrec => buhrec.SummVATCost);
                //rec.SummVAT_10 = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "3").Sum(buhrec => buhrec.SummVAT);
                //SummNoVAT_10 = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "3").Sum(buhrec => buhrec.SummVATCost);
                //rec.SummCost_NoVAT = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "5").Sum(buhrec => buhrec.SummAll);
                //rec.SummCost_18 = Decimal.Round(rec.SummVAT_18 * 100m / 18m, 2);
                //rec.SummCost_10 = Decimal.Round(rec.SummVAT_10 * 100m / 10m, 2);
                //rec.SummCost_NoVAT = rec.SummCost_NoVAT +
                //    Decimal.Round(SummNoVAT_18 * 118m / 18m, 2) +
                //    Decimal.Round(SummNoVAT_10 * 110m / 10m, 2);
                rec.SummBayCost            = invoice_buhrec.Sum(buhrec => buhrec.SummCost);
                rec.SummBayVatCharge       = invoice_buhrec.Sum(buhrec => buhrec.SummVATIn);
                rec.SummBayVatDeduction    = invoice_buhrec.Sum(buhrec => buhrec.SummVAT);
                rec.SummBayVatInCost       = invoice_buhrec.Sum(buhrec => buhrec.SummVATCost);
                rec.SummBayVatExp          = invoice_buhrec.Sum(buhrec => buhrec.SummVATExp);
                rec.SummBayVatOtherCredit  = invoice_buhrec.Sum(buhrec => buhrec.SummVATCrdOther);
                rec.SummBayVatOtherCredit += invoice_buhrec.Sum(buhrec => buhrec.SummVATNoInvoice);

                if (rec.SummBayVatDeduction == 0)
                {
                    os.Delete(rec);
                    continue;
                }
                if (rec.SummBayCost == 0)
                {
                    rec.SummBayCost = Decimal.Round((rec.SummBayVatDeduction + rec.SummBayVatInCost) * 100 / 18, 2);
                }
                rec.SequenceNumber = seq_num++;
                switch (rec.BuhRecordType)
                {
                case "PAY":
                    rec.OperationType = oper_types.FirstOrDefault(x => x.Code == "01");
                    break;

                case "BAY":
                    rec.OperationType = oper_types.FirstOrDefault(x => x.Code == "01");
                    break;

                case "AIN":
                    rec.OperationType = oper_types.FirstOrDefault(x => x.Code == "02");
                    break;

                case "AON":
                    rec.OperationType = oper_types.FirstOrDefault(x => x.Code == "02");
                    break;

                case "EAT":
                    rec.OperationType = oper_types.FirstOrDefault(x => x.Code == "01");
                    break;

                case "EXP":
                    rec.OperationType = oper_types.FirstOrDefault(x => x.Code == "01");
                    break;

                case "SMN":
                    rec.OperationType = oper_types.FirstOrDefault(x => x.Code == "01");
                    break;

                case "SPC":
                    rec.OperationType = oper_types.FirstOrDefault(x => x.Code == "01");
                    break;

                default:
                    rec.OperationType = oper_types.FirstOrDefault(x => x.Code == "01");
                    break;
                }
                book.BookVATRecords.Add(rec);
            }
            IList <fmCAVTBookBuhStruct> book_structs = os.GetObjects <fmCAVTBookBuhStruct>();

            foreach (var book_struct in book_structs)
            {
                foreach (var record in book_struct.InInvoiceRecords)
                {
                    if (book.DatePeriodStart.Date <= record.BayDate.Date && record.BayDate.Date <= book.DatePeriodStop.Date)
                    {
                        if (record.BaySummAll == 0 || record.BaySummVAT == 0 && record.BayVATRate.Code != "0%")
                        {
                            continue;
                        }
                        fmCAVTBookVATRecord book_rec = os.CreateObject <fmCAVTBookVATRecord>();
                        //                        rec.BuhRecordType = invoice_buhrec.Key.RecordType;
                        book_rec.BookBuhStruct = book_struct;
                        book_rec.OperationType = record.OperationType;
                        if (record.InvoiceType == "ятю")
                        {
                            book_rec.BuhRecordType = "AIN";
                        }
                        else
                        {
                            book_rec.BuhRecordType = "BAY";
                        }
                        book_rec.Party = record.PartnerParty;
                        book_rec.VATInvoiceRegNumber = record.InvoiceRegNumber;
                        book_rec.VATInvoiceType      = record.InvoiceType;
                        book_rec.VATInvoiceNumber    = record.InvoiceNumber;
                        book_rec.VATInvoiceDate      = record.InvoiceDate;
                        book_rec.Invoice             = record.Invoice;
                        if (record.Invoice != null)
                        {
                            book_rec.InvoiceVersion = record.Invoice.Current;
                        }
                        book_rec.PayDate = record.SaleDate;
                        book_rec.BuhDate = record.SaleDate;

                        book_rec.SummBayVatCharge    = record.BaySummVAT;
                        book_rec.SummBayVatDeduction = Decimal.Round(book_rec.SummBayVatCharge * book_struct.BayNorma, 2);
                        book_rec.SummBayVatInCost    = book_rec.SummBayVatCharge - book_rec.SummBayVatDeduction;

                        book_rec.SummBayCost = record.BaySummAll - record.BaySummVAT;
                        //                        if (record.InvoiceType == "ятг") book_rec.PayDate = book_rec.BuhDate;
                        //                        if (record.Nds)
                        //                        book_rec.SummVAT_18 = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "2").Sum(buhrec => buhrec.SummVAT);
                        book_rec.SequenceNumber = seq_num++;
                        book.BookVATRecords.Add(book_rec);
                    }
                }
            }
            ReNumber(os, book);
        }
예제 #2
0
        static public void ImportBookBayMain(IObjectSpace os, fmCAVTBookVAT book)
        {
            Int32  kvartal   = Int32.Parse(book.PeriodKV);
            String period_m1 = book.PeriodYYYY + ((kvartal - 1) * 3 + 1).ToString("00");
            String period_m2 = book.PeriodYYYY + ((kvartal - 1) * 3 + 2).ToString("00");
            String period_m3 = book.PeriodYYYY + ((kvartal - 1) * 3 + 3).ToString("00");

            os.Delete(book.BookVATRecords);
            IList <fmCAVTBookBuhRecord> buhrecs = os.GetObjects <fmCAVTBookBuhRecord>(
                XPQuery <fmCAVTBookBuhRecord> .TransformExpression(((ObjectSpace)os).Session,
                                                                   rec => rec.BookType == "B" && (
                                                                       rec.PeriodOtchet == period_m1 ||
                                                                       rec.PeriodOtchet == period_m2 ||
                                                                       rec.PeriodOtchet == period_m3
                                                                       //&& (rec.RecordType != "AON" ||
                                                                       // rec.RecordType == "AON" &&
                                                                       // rec.RecordSummType == "NDS" &&
                                                                       // rec.SummVAT != 0)
                                                                       )
                                                                   ));
            var invoice_buhrecs = buhrecs.GroupBy(rec => new {
                rec.RecordType,
                rec.AVTInvoicePartyCode,
                rec.AVTInvoiceType,
                rec.AVTInvoiceRegNumber,
                rec.AVTInvoiceNumber,
                rec.AVTInvoiceDate
            }).OrderBy(key => key.Key.AVTInvoicePartyCode);
            //
            UInt32 seq_num = 1;

            foreach (var invoice_buhrec in invoice_buhrecs)
            {
                if (String.IsNullOrEmpty(invoice_buhrec.Key.AVTInvoiceType.Trim()))
                {
                    continue;
                }
                if (invoice_buhrec.Key.AVTInvoiceType.Trim() == "рд")
                {
                    continue;
                }
                fmCAVTBookVATRecord rec   = os.CreateObject <fmCAVTBookVATRecord>();
                crmCParty           party = os.GetObjects <crmCParty>(new BinaryOperator("Code", invoice_buhrec.Key.AVTInvoicePartyCode)).FirstOrDefault();
                rec.BuhRecordType       = invoice_buhrec.Key.RecordType;
                rec.Party               = party;
                rec.VATInvoiceType      = invoice_buhrec.Key.AVTInvoiceType;
                rec.VATInvoiceRegNumber = invoice_buhrec.Key.AVTInvoiceRegNumber;
                rec.VATInvoiceNumber    = invoice_buhrec.Key.AVTInvoiceNumber;
                rec.VATInvoiceDate      = invoice_buhrec.Key.AVTInvoiceDate;
                rec.Invoice             = os.FindObject <fmCAVTInvoiceBase>(
                    CriteriaOperator.And(new BinaryOperator("Number", invoice_buhrec.Key.AVTInvoiceNumber),
                                         new BinaryOperator("Date", invoice_buhrec.Key.AVTInvoiceDate.Date, BinaryOperatorType.GreaterOrEqual),
                                         new BinaryOperator("Date", invoice_buhrec.Key.AVTInvoiceDate.Date.AddDays(1), BinaryOperatorType.Less),
                                         new BinaryOperator("Supplier", party)));
                rec.PayDate = invoice_buhrec.Select(buhrec => buhrec.PayDocDate).Max();
                rec.BuhDate = invoice_buhrec.Select(buhrec => buhrec.BuhDocDate).Min();
                Decimal SummNoVAT_18;
                Decimal SummNoVAT_10;
                rec.SummVAT_18     = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "2").Sum(buhrec => buhrec.SummVAT);
                SummNoVAT_18       = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "2").Sum(buhrec => buhrec.SummVATCost);
                rec.SummVAT_10     = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "3").Sum(buhrec => buhrec.SummVAT);
                SummNoVAT_10       = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "3").Sum(buhrec => buhrec.SummVATCost);
                rec.SummCost_NoVAT = invoice_buhrec.Where(buhrec => buhrec.NDSRate == "5").Sum(buhrec => buhrec.SummAll);
                rec.SummCost_18    = Decimal.Round(rec.SummVAT_18 * 100m / 18m, 2);
                rec.SummCost_10    = Decimal.Round(rec.SummVAT_10 * 100m / 10m, 2);
                rec.SummCost_NoVAT = rec.SummCost_NoVAT +
                                     Decimal.Round(SummNoVAT_18 * 118m / 18m, 2) +
                                     Decimal.Round(SummNoVAT_10 * 110m / 10m, 2);
                if (rec.SummAll == 0 && rec.SummVAT_18 == 0 && rec.SummVAT_10 == 0)
                {
                    os.Delete(rec);
                    continue;
                }
                rec.SequenceNumber = seq_num++;
                book.BookVATRecords.Add(rec);

                switch (invoice_buhrec.Key.RecordType)
                {
                case "PAY":
                    break;

                case "AIN":
                    break;

                case "AON":
                    break;

                case "EAT":
                    break;

                case "EXP":
                    break;

                case "SMN":
                    break;

                case "SPC":
                    break;

                default:
                    break;
                }
            }
        }