public void FilterData() { ReportMovement = new Report_Movement(); ReportMovement.DoFilter = false; ReportMovement.DT1 = DT1; ReportMovement.DT2 = DT2; ReportMovement.DoFilter = DoFilter; ReportMovement.FilterCat1 = Filter[0]; ReportMovement.FilterCatD = Filter[1]; ReportMovement.FilterCatT = Filter[2]; ReportMovement.FilterDep = Filter[3]; ReportMovement.FilterPlace = Filter[4]; ReportMovement.DoGrouping = DoGrouping; ReportMovement.DoSortByRegnr = chOrderByRegNr.Checked; ReportMovement.GroupOrderCat1 = GroupFieldsOrder[0]; ReportMovement.GroupOrderCatD = GroupFieldsOrder[1]; ReportMovement.GroupOrderCatT = GroupFieldsOrder[2]; ReportMovement.GroupOrderDep = GroupFieldsOrder[3]; ReportMovement.GroupOrderPlace = GroupFieldsOrder[4]; if (DoGrouping) { ReportMovement.MakeGroupReport(); } else { ReportMovement.MakeSimpleReport(); } CheckTable(); bsRows.DataSource = ReportMovement.ReportRows; }
private void CheckGroupList() { int ord = 0; int nk = -1; DoGrouping = chlbGroupItems.CheckedIndices.Count > 0; if (DoGrouping) { int firstnotchecked = -1; for (int i = 0; i < 5; i++) { if (!chlbGroupItems.GetItemChecked(i)) { firstnotchecked = i; break; } } if (firstnotchecked > -1) { for (int i = firstnotchecked + 1; i < 5; i++) { if (chlbGroupItems.GetItemChecked(i)) { GroupListBoxDragDropHelper.MoveItem(chlbGroupItems, i, firstnotchecked); firstnotchecked++; } } } } for (int i = 0; i < 5; i++) { var s = chlbGroupItems.Items[i] as string; int k = GroupFieldsInit.IndexOf(s); FieldsOrder[k] = i; if (DoGrouping) { if (chlbGroupItems.GetItemChecked(i)) { nk = ord++; } else { nk = -1; } } else { nk = i; } GroupFieldsOrder[k] = nk; } FieldsOrderA = Report_Movement.GetBackSortOrder(FieldsOrder); GroupFieldsOrderA = Report_Movement.GetBackSortOrder(GroupFieldsOrder); }
public void FilterData() { ReportMovement = new Report_Movement(); ReportMovement.DoFilter = false; ReportMovement.DT1 = new DateTime(YR, 1, 1); ReportMovement.DT2 = new DateTime(YR, 12, 31); ReportMovement.DoFilter = false; ReportMovement.DoGrouping = true; ReportMovement.GroupOrderCat1 = -1; ReportMovement.GroupOrderCatD = -1; ReportMovement.GroupOrderCatT = 0; ReportMovement.GroupOrderDep = -1; ReportMovement.GroupOrderPlace = -1; ReportMovement.MakeGroupReport(); bsRows.DataSource = ReportMovement.ReportRows; }
public List <TaxDeprecCalcInfo> CalcYear(int yr, bool addstartvalues) { var ReportMovement = new Report_Movement(); ReportMovement.DoFilter = false; ReportMovement.DT1 = new DateTime(yr, 1, 1); ReportMovement.DT2 = new DateTime(yr, 12, 31); ReportMovement.DoFilter = false; ReportMovement.AddTotals = false; ReportMovement.DoGrouping = true; ReportMovement.GroupOrderCat1 = -1; ReportMovement.GroupOrderCatD = -1; ReportMovement.GroupOrderCatT = 0; ReportMovement.GroupOrderDep = -1; ReportMovement.GroupOrderPlace = -1; ReportMovement.MakeGroupReport(); var table_deprec = MyData.DataSetKlons.TAXDEPRECYEAR; var table_catt = MyData.DataSetKlons.CATT; var drs_new = new List <TaxDeprecCalcInfo>(); var drs_prev = table_deprec.WhereX(d => d.YR == yr - 1).ToList(); foreach (var evr in ReportMovement.ReportRows) { var dr_new = new TaxDeprecCalcInfo(); var dr_catt = table_catt.FindByID(evr.CatT); var dr_prev = drs_prev.Where(d => d.CATT == evr.CatT).FirstOrDefault(); drs_new.Add(dr_new); dr_new.YR = yr; dr_new.CatID = evr.CatT; dr_new.CountAtEnd = evr.CountAtEnd; dr_new.Rate = dr_catt.RATE / 100.0f; dr_new.Kind = dr_catt.KIND; dr_new.ValueC = evr.TaxValNewCalc + evr.TaxValAddCalc + evr.TaxValRecatCalc - evr.TaxValExcludeCalc; dr_new.ValueNew = evr.TaxValNewCalc; dr_new.ValueAdd = Math.Max(evr.TaxValAddCalc, 0.0M); dr_new.ValueRem = -Math.Min(evr.TaxValAddCalc, 0.0M); dr_new.ValueAdd += Math.Max(evr.TaxValRecatCalc, 0.0M); dr_new.ValueRem += -Math.Min(evr.TaxValRecatCalc, 0.0M); dr_new.ValueExclude = evr.TaxValExcludeCalc; if (dr_new.Kind == 0) { if (addstartvalues) { dr_new.Value0 = dr_catt.VALUE0; } else if (dr_prev != null) { dr_new.Value0 = dr_prev.VALUE1; } if (dr_prev != null) { dr_new.ValueCor = dr_prev.VALUE_COR; } dr_new.ValueCor += dr_new.ValueC; dr_new.ValueD = dr_new.Value0 + dr_new.ValueC; } else { dr_new.Value0 = evr.TaxValLeft0; dr_new.Deprec = evr.TaxDeprecCalc; dr_new.Value1 = evr.TaxValLeft1; dr_new.ValueCor = evr.TaxVal; dr_new.ValueD = dr_new.Value0 + dr_new.ValueC; } } var drs_prev2 = drs_prev .Where(d => d.VALUE1 != 0.0M && drs_new .Where(d2 => d2.CatID == d.CATT) .FirstOrDefault() == null) .ToList(); foreach (var dr_prev in drs_prev2) { var dr_new = new TaxDeprecCalcInfo(); var dr_catt = table_catt.FindByID(dr_prev.ID); drs_new.Add(dr_new); dr_new.YR = yr; dr_new.CatID = dr_prev.ID; dr_new.Rate = dr_catt.RATE / 100.0f; dr_new.Kind = dr_catt.KIND; dr_new.Value0 = dr_prev.VALUE1; dr_new.ValueCor = dr_prev.VALUE_COR; dr_new.ValueD = dr_new.Value0; } if (addstartvalues) { var drs_catt_toadd = table_catt .WhereX(d => d.VALUE0 != 0.0M && drs_new .Where(d2 => d2.CatID == d.ID) .FirstOrDefault() == null); foreach (var dr_catt in drs_catt_toadd) { var dr_new = new TaxDeprecCalcInfo(); drs_new.Add(dr_new); dr_new.YR = yr; dr_new.CountAtEnd = 0; dr_new.CatID = dr_catt.ID; dr_new.Rate = dr_catt.RATE / 100.0f; dr_new.Kind = dr_catt.KIND; dr_new.Value0 = dr_catt.VALUE0; dr_new.ValueCor = dr_new.Value0; dr_new.ValueD = dr_new.Value0; } } foreach (var dr_new in drs_new) { var va = dr_new.Value0 + dr_new.ValueC; if (dr_new.Kind == 0) { if (va < 71.14M || dr_new.CountAtEnd == 0) { dr_new.Deprec = va; } else { dr_new.Deprec = Math.Round(va * (decimal)dr_new.Rate, 2, MidpointRounding.AwayFromZero); } } dr_new.Value1 = va - dr_new.Deprec; } return(drs_new); }