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);
}
