static public fmCAVTBookVAT LocateBook(IObjectSpace os, crmCParty organ, fmCAVTBookVAT.fmCAVTBookVATType type, String period)
{
IList <fmCAVTBookVAT> books = os.GetObjects <fmCAVTBookVAT>(
XPQuery <fmCAVTBookVAT> .TransformExpression(((ObjectSpace)os).Session,
b => b.Party == organ &&
b.Period == period), true).ToList();
fmCAVTBookVAT book_main = null;
foreach (fmCAVTBookVAT book in books)
{
if ((type == fmCAVTBookVAT.fmCAVTBookVATType.PAY_MAIN ||
type == fmCAVTBookVAT.fmCAVTBookVATType.PAY_ADD) &&
book.BookVATType == fmCAVTBookVAT.fmCAVTBookVATType.PAY_MAIN)
{
book_main = book;
break;
}
if ((type == fmCAVTBookVAT.fmCAVTBookVATType.BAY_MAIN ||
type == fmCAVTBookVAT.fmCAVTBookVATType.BAY_ADD) &&
book.BookVATType == fmCAVTBookVAT.fmCAVTBookVATType.BAY_MAIN)
{
book_main = book;
break;
}
}
if (book_main == null)
{
if (type == fmCAVTBookVAT.fmCAVTBookVATType.PAY_MAIN ||
type == fmCAVTBookVAT.fmCAVTBookVATType.PAY_ADD)
{
}
}
return(book_main);
}
public void Clear()
{
using (IObjectSpace os = CommonMethods.FindObjectSpaceByObject(this).CreateNestedObjectSpace()) {
fmCAVTBookVAT book = os.GetObject <fmCAVTBookVAT>(this);
fmCAVTBookVATLogic.Clear(os, book);
os.CommitChanges();
}
}
static public void ReNumber(IObjectSpace os, fmCAVTBookVAT book)
{
UInt32 number = 0;
foreach (var date_records in book.BookVATRecords.GroupBy(x => x.VATInvoiceDate).OrderBy(x => x.Key))
{
foreach (var record in date_records.OrderBy(x => x.VATInvoiceNumber))
{
record.SequenceNumber = ++number;
}
}
}
private void ImportAction_Execute(object sender, SimpleActionExecuteEventArgs e)
{
fmCAVTBookVAT book = e.CurrentObject as fmCAVTBookVAT;
if (book == null)
{
return;
}
using (IObjectSpace os = ObjectSpace.CreateNestedObjectSpace()) {
fmCAVTBookVATLogic.ImportBuhData(os, os.GetObject <fmCAVTBookVAT>(book));
os.CommitChanges();
}
}
static public void Clear(IObjectSpace os, fmCAVTBookVAT book)
{
IList <fmCAVTBookVATRecord> del_record = new List <fmCAVTBookVATRecord>();
foreach (var record in book.BookVATRecords)
{
if (Decimal.Round(record.C14_SummCost18, 2) == 0 && Decimal.Round(record.C15_SummCost10, 2) == 0 &&
Decimal.Round(record.C16_SummCost0, 2) == 0 && Decimal.Round(record.C17_SummVat18, 2) == 0 &&
Decimal.Round(record.C18_SummVat10, 2) == 0)
{
del_record.Add(record);
}
}
os.Delete(del_record);
}
static public fmCAVTBookVAT LocateBookAdd(IObjectSpace os, crmCParty organ, fmCAVTBookVAT.fmCAVTBookVATType type, String period)
{
if (type != fmCAVTBookVAT.fmCAVTBookVATType.PAY_ADD &&
type != fmCAVTBookVAT.fmCAVTBookVATType.BAY_ADD)
{
throw new ArgumentException();
}
fmCAVTBookVAT book_main = null;
if (type == fmCAVTBookVAT.fmCAVTBookVATType.PAY_ADD)
{
book_main = LocateBookMain(os, organ, fmCAVTBookVAT.fmCAVTBookVATType.PAY_MAIN, period);
}
if (type == fmCAVTBookVAT.fmCAVTBookVATType.BAY_ADD)
{
book_main = LocateBookMain(os, organ, fmCAVTBookVAT.fmCAVTBookVATType.BAY_MAIN, period);
}
return(book_main);
}
static public void ImportBuhData(IObjectSpace os, fmCAVTBookVAT book)
{
if (book.BookVATType == fmCAVTBookVAT.fmCAVTBookVATType.PAY_MAIN)
{
ImportBookPayMain(os, book);
}
if (book.BookVATType == fmCAVTBookVAT.fmCAVTBookVATType.PAY_2014)
{
ImportBookPayMain2014(os, book);
}
if (book.BookVATType == fmCAVTBookVAT.fmCAVTBookVATType.BAY_MAIN)
{
ImportBookBayMain(os, book);
}
if (book.BookVATType == fmCAVTBookVAT.fmCAVTBookVATType.BAY_2014)
{
ImportBookBayMain2014(os, book);
}
}
private void ImportSummAllAction_Execute(object sender, SimpleActionExecuteEventArgs e)
{
fmCAVTBookVAT book = e.CurrentObject as fmCAVTBookVAT;
if (book == null)
{
return;
}
OpenFileDialog dialog = new OpenFileDialog();
if (dialog.ShowDialog() != DialogResult.OK)
{
return;
}
using (IObjectSpace os = ObjectSpace.CreateNestedObjectSpace()) {
book = os.GetObject <fmCAVTBookVAT>(book);
fmCAVTBookVATLogic.ImportSummAll_Correct(os, book, dialog.FileName);
os.CommitChanges();
}
}
static public fmCAVTBookVAT LocateBookMain(IObjectSpace os, crmCParty organ, fmCAVTBookVAT.fmCAVTBookVATType type, String period)
{
if (type != fmCAVTBookVAT.fmCAVTBookVATType.PAY_MAIN &&
type != fmCAVTBookVAT.fmCAVTBookVATType.BAY_MAIN)
{
throw new ArgumentException();
}
fmCAVTBookVAT book = os.FindObject <fmCAVTBookVAT>(
XPQuery <fmCAVTBookVAT> .TransformExpression(((ObjectSpace)os).Session,
b => b.Party == organ &&
b.BookVATType == type &&
b.Period == period), true);
if (book == null)
{
book = os.CreateObject <fmCAVTBookVAT>();
book.Party = organ;
book.BookVATType = type;
book.Period = period;
}
return(book);
}
static public void ImportSummAll_Correct(IObjectSpace os, fmCAVTBookVAT book, String file_name)
{
// OpenFileDialog dialog = new OpenFileDialog();
// if (dialog.ShowDialog() == DialogResult.OK) {
FixedFileEngine engine = new FixedFileEngine(typeof(InvoiceInfo));
InvoiceInfo[] imp_res = (InvoiceInfo[])engine.ReadFile(file_name);
foreach (var line in book.BookVATRecords)
{
if (line.BookBuhStruct != null)
{
continue;
}
InvoiceInfo info = imp_res.FirstOrDefault(
x => x.sf_intnum.Trim() == line.VATInvoiceRegNumber &&
x.sf_number.Trim() == line.VATInvoiceNumber &&
x.sf_date == line.VATInvoiceDate.ToString("yyyyMMdd") &&
x.vo_code.Trim() == line.Party.Code
);
if (info == null)
{
info = imp_res.FirstOrDefault(
x => x.sf_intnum.Trim() == line.VATInvoiceRegNumber &&
x.sf_number.Trim() == line.VATInvoiceNumber &&
x.reg_sf_date == line.VATInvoiceDate.ToString("yyyyMMdd") &&
x.vo_code.Trim() == line.Party.Code
);
}
if (info == null)
{
info = imp_res.FirstOrDefault(
x => x.sf_intnum.Trim() == line.VATInvoiceRegNumber &&
x.sf_intnum.Trim() == line.VATInvoiceNumber &&
x.sf_date == line.VATInvoiceDate.ToString("yyyyMMdd") &&
x.vo_code.Trim() == line.Party.Code
);
if (info != null)
{
line.VATInvoiceNumber = info.sf_number.Trim();
}
}
if (info == null)
{
info = imp_res.FirstOrDefault(
x => x.sf_intnum.Trim() == line.VATInvoiceNumber &&
String.IsNullOrEmpty(line.VATInvoiceRegNumber) &&
x.sf_date == line.VATInvoiceDate.ToString("yyyyMMdd") &&
x.vo_code.Trim() == line.Party.Code
);
if (info != null)
{
line.VATInvoiceRegNumber = info.sf_intnum.Trim();
line.VATInvoiceNumber = info.sf_number.Trim();
}
}
if (info != null)
{
Decimal vat = Decimal.Parse(info.vat_19_deb.Trim().Replace('.', ',')) +
Decimal.Parse(info.vat_19_deb_71.Trim().Replace('.', ',')) +
Decimal.Parse(info.vat_19_deb_98.Trim().Replace('.', ',')) +
Decimal.Parse(info.vat_virtual.Trim().Replace('.', ','));
Decimal cost_full = Decimal.Parse(info.cost_full.Trim().Replace('.', ','));
Decimal cost_crd = Decimal.Parse(info.cost_crd.Trim().Replace('.', ','));
Decimal cost_nocrd = Decimal.Parse(info.cost_nocrd.Trim().Replace('.', ','));
Decimal cost_calc = Decimal.Parse(info.cost_calc.Trim().Replace('.', ','));
if (cost_full != 0)
{
line.SummAll_Correct = cost_full;
}
else if (cost_crd >= cost_nocrd + cost_calc)
{
line.SummAll_Correct = cost_crd + vat;
}
else
{
line.SummAll_Correct = cost_nocrd + cost_calc + vat;
}
}
else
{
}
}
}
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);
}
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;
}
}
}
