public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
String tmpPrevKey = prevGroupId;
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
//ArrayList keepTotal1 = copyTotalArray(groupSums);
ArrayList keepTotal2 = copyTotalArray(sums);
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
double newh = AvailableSpace - nr.GetHeight();
filterDrCrAmount(o);
if (newh > 0)
{
String groupId = o.GetFieldValue(getGroupKey());
if (row == 0)
{
prevGroupId = groupId;
}
if (!groupId.Equals(prevGroupId))
{
prevGroupId = groupId;
groupSum1 = groupSums;
}
ArrayList temps = getColumnDataTexts("L1", row + 1, o);
nr.FillColumnsText(temps);
rpp.AddReportRow(nr);
sums = sumDataTexts("L1", sums, temps);
if (row == rowcount - 1)
{
double h = addNewFooterRow(rowdef, rpp, "FOOTER_LEVEL1", "L1", "total", sums);
newh = newh - h;
}
}
if (newh < 1)
{
rpp.IsNewPageRequired = true;
//พวก sum ทั้งหลายจะถูกคืนค่ากลับไปด้วย เพราะถูกบวกไปแล้ว
//groupSums = keepTotal1;
sums = keepTotal2;
prevGroupId = tmpPrevKey;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
protected override void createRowTemplates()
{
String nm = "";
Thickness defMargin = new Thickness(3, 1, 3, 1);
configReport();
nm = "HEADER_LEVEL1";
CRow h2 = new CRow(nm, 30, getColumnCount("L1"), defMargin);
h2.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = h2;
configRow("L1", h2, "H");
nm = "DATA_LEVEL1";
CRow r0 = new CRow(nm, 30, getColumnCount("L1"), defMargin);
r0.SetFont(null, FontStyles.Normal, 0, FontWeights.Normal);
rowdef[nm] = r0;
configRow("L1", r0, "B");
nm = "FOOTER_LEVEL1";
CRow f1 = new CRow(nm, 30, getColumnCount("L1"), defMargin);
f1.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = f1;
configRow("L1", f1, "F");
baseTemplateName = "DATA_LEVEL1";
}
public TResult <IBRServiceContracts.CRow> GetTaskDataByUid(string user, string projectname, string workinglayer, string systemuid)
{
//object comosobject = System.Web.HttpContext.Current.ApplicationInstance.Application["ComosAPI"];
//IBRServiceContracts.IServiceContract m_ComosAPIService = (IBRServiceContracts.IServiceContract)comosobject;
IServiceContract m_ComosAPIService = GetComosAPI();
int idworkinglayer = 0;
if (workinglayer != "")
{
idworkinglayer = int.Parse(workinglayer);
}
IBRServiceContracts.CCell[] result = m_ComosAPIService.GetTaskDataByUid(user, projectname, idworkinglayer, systemuid);
CRow row = new CRow();
row.Values = result;
return(new TResult <IBRServiceContracts.CRow>()
{
Status = (result.Length > 0),
data = row,
Message = null,
});
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
String tmpPrevKey = prevKeyId;
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
ArrayList keepTotal1 = copyTotalArray(entitySums);
ArrayList keepTotal2 = copyTotalArray(sums);
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
double newh = AvailableSpace - nr.GetHeight();
populateTempFields(o);
double h = 0.00;
if (newh > 0)
{
String keyId = o.GetFieldValue("EMPLOYEE_CODE");
if (row == 0)
{
prevKeyId = keyId;
}
h = addNewDataRow(rowdef, rpp, "DATA_LEVEL1", "L1", row, o);
//newh = newh - h;
ArrayList temps = getColumnDataTexts("L1", row, o);
nr.FillColumnsText(temps);
sums = sumDataTexts("L1", sums, temps);
entitySums = sumDataTexts("L1", entitySums, temps);
if (row == rowcount - 1)
{
h = addNewFooterRow(rowdef, rpp, "FOOTER_LEVEL1", "L1", "total", sums);
newh = newh - h;
}
}
if (newh < 1)
{
rpp.IsNewPageRequired = true;
//พวก sum ทั้งหลายจะถูกคืนค่ากลับไปด้วย เพราะถูกบวกไปแล้ว
entitySums = keepTotal1;
sums = keepTotal2;
prevKeyId = tmpPrevKey;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
private void createDataHeaderRow2(UReportPage page)
{
CRow r = (CRow)rowdef["HEADER_LEVEL1"];
r.FillColumnsText(getColumnHederTexts("L1", "H"));
ConstructUIRow(page, r);
AvailableSpace = AvailableSpace - r.GetHeight();
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
String tmpPrevKey = prevEntityId;
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
ArrayList keepTotal1 = copyTotalArray(entitySums);
ArrayList keepTotal2 = copyTotalArray(sums);
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
double newh = AvailableSpace - nr.GetHeight();
populateTempFields(o);
if (newh > 0)
{
ArrayList temps = getColumnDataTexts("L1", row + 1, o);
nr.FillColumnsText(temps);
rpp.AddReportRow(nr);
sums = sumDataTexts("L1", sums, temps);
entitySums = sumDataTexts("L1", entitySums, temps);
if (row == rowcount - 1)
{
//=== End row
CRow ft1 = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr1 = ft1.Clone();
ArrayList totals = displayTotalTexts("L1", sums, 1, "total");
ftr1.FillColumnsText(totals);
rpp.AddReportRow(ftr1);
newh = newh - ftr1.GetHeight();
}
}
if (newh < 1)
{
rpp.IsNewPageRequired = true;
//พวก sum ทั้งหลายจะถูกคืนค่ากลับไปด้วย เพราะถูกบวกไปแล้ว
entitySums = keepTotal1;
sums = keepTotal2;
prevEntityId = tmpPrevKey;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
private void addTotalRow(CReportDataProcessingProperty rpp, ArrayList sumArray)
{
CRow ft1 = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr1 = ft1.Clone();
ArrayList totals = displayTotalTexts("L1", sumArray, 1, "total");
ftr1.FillColumnsText(totals);
rpp.AddReportRow(ftr1);
}
protected override void createRowTemplates()
{
String nm = "";
Thickness defMargin = new Thickness(3, 1, 3, 1);
configReport();
//== START HEADER ===
nm = "HEADER_LEVEL0";
CRow h0 = new CRow(nm, 30, getColumnCount("L0"), defMargin);
h0.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = h0;
configRow("L0", h0, "H");
nm = "HEADER_LEVEL1";
CRow h1 = new CRow(nm, 30, getColumnCount("L1"), defMargin);
h1.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = h1;
configRow("L1", h1, "H");
//== END HEADER ===
//== START BODY ===
nm = "DATA_LEVEL0";
CRow r00 = new CRow(nm, 30, getColumnCount("L0"), defMargin);
r00.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = r00;
configRow("L0", r00, "B");
nm = "DATA_LEVEL1";
CRow r01 = new CRow(nm, 30, getColumnCount("L1"), defMargin);
r01.SetFont(null, FontStyles.Normal, 0, FontWeights.Normal);
rowdef[nm] = r01;
configRow("L1", r01, "B");
//== END BODY ===
nm = "FOOTER_LEVEL1";
CRow f1 = new CRow(nm, 30, getColumnCount("L1"), defMargin);
f1.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = f1;
configRow("L1", f1, "F");
baseTemplateName = "DATA_LEVEL1";
}
private void createDataHeaderRow1(UReportPage page)
{
CRow r = (CRow)rowdef["HEADER_LEVEL1"];
r.FillColumnsText(
CLanguage.getValue("item_code"),
CLanguage.getValue("item_name_thai"),
CLanguage.getValue("location_name"));
ConstructUIRow(page, r);
AvailableSpace = AvailableSpace - r.GetHeight();
}
private CQuerieResult GetFavoritesData()
{
CQuerieResult q = new CQuerieResult();
var db = Services.XServices.Instance.GetService <Services.XDatabase>();
List <string> favorites = db.GetFavorites();
CColumn[] columns = new CColumn[2];
CRow[] rows = new CRow[favorites.Count];
columns[0] = new CColumn()
{
DisplayDescription = "Name"
};
columns[1] = new CColumn()
{
DisplayDescription = "Description"
};
//columns[2] = new CColumn() { DisplayDescription = "Pic" };
q.Columns = columns;
q.Rows = rows;
int i = 0;
foreach (var item in favorites)
{
CRow row = new CRow();
CObject output = Newtonsoft.Json.JsonConvert.DeserializeObject <CObject>(item);
m_Query.SetMainObject(output);
row.Items = new CCell[2];
row.Items[0] = new CCell()
{
Text = output.Name, UID = output.UID, Picture = output.Picture
};
row.Items[1] = new CCell()
{
Text = output.Description, UID = output.UID, Picture = output.Picture
};
//row.Items[2] = new CCell() { Text = output.Picture, UID = output.UID, Picture = output.Picture };
row.UID = output.UID;
rows[i] = row;
i++;
}
m_Query.SetNavigator(this.Navigator.Database);
m_Query.Query = q;
m_Query.ShowListQuery();
return(q);
}
private void createDataHeaderRow1(UReportPage page)
{
CRow r = (CRow)rowdef["HEADER_LEVEL1"];
r.FillColumnsText(
CLanguage.getValue("customer_type"),
CLanguage.getValue("customer_group"));
ConstructUIRow(page, r);
AvailableSpace = AvailableSpace - r.GetHeight();
}
private void createDataHeaderRow2(UReportPage page)
{
CRow r = (CRow)rowdef["HEADER_LEVEL2"];
r.FillColumnsText(
CLanguage.getValue("number"),
CLanguage.getValue("customer_code"),
CLanguage.getValue("customer_name"),
CLanguage.getValue("telephone"));
ConstructUIRow(page, r);
AvailableSpace = AvailableSpace - r.GetHeight();
}
private void createDataHeaderRow1(UReportPage page)
{
CRow r = (CRow)rowdef["HEADER_LEVEL1"];
r.FillColumnsText(
CLanguage.getValue("AccNo"),
CLanguage.getValue("AccName"),
CLanguage.getValue("Bank"),
CLanguage.getValue("Branch"));
ConstructUIRow(page, r);
AvailableSpace = AvailableSpace - r.GetHeight();
}
private void createDataHeaderRow2(UReportPage page)
{
CRow r = (CRow)rowdef["HEADER_LEVEL2"];
r.FillColumnsText(
CLanguage.getValue("number"),
CLanguage.getValue("DocuDate"),
CLanguage.getValue("in_quantity"),
CLanguage.getValue("out_quantity"),
CLanguage.getValue("balance_quantity"));
ConstructUIRow(page, r);
AvailableSpace = AvailableSpace - r.GetHeight();
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
ArrayList keepTotal2 = copyTotalArray(sums);
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
double newh = AvailableSpace - nr.GetHeight();
if (newh > 0)
{
filterDrCrAmount(o);
ArrayList temps = getColumnDataTexts("L1", row + 1, o);
nr.FillColumnsText(temps);
rpp.AddReportRow(nr);
sums = sumDataTexts("L1", sums, temps);
if (row == rowcount - 1)
{
CRow ft1 = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr1 = ft1.Clone();
ArrayList totals = displayTotalTexts("L1", sums, 1, "total");
ftr1.FillColumnsText(totals);
rpp.AddReportRow(ftr1);
newh = newh - ftr1.GetHeight();
}
}
if (newh < 1)
{
rpp.IsNewPageRequired = true;
sums = keepTotal2;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
private void createDataHeaderRow(UReportPage page)
{
CRow r = (CRow)rowdef["HEADER_LEVEL1"];
r.FillColumnsText(
"NO.",
CLanguage.getValue("inventory_doc_no"),
CLanguage.getValue("date"),
CLanguage.getValue("AccNo"),
CLanguage.getValue("Bank"),
CLanguage.getValue("money_quantity"),
CLanguage.getValue("inventory_doc_status"),
CLanguage.getValue("note"));
ConstructUIRow(page, r);
AvailableSpace = AvailableSpace - r.GetHeight();
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
double newh = AvailableSpace - nr.GetHeight();
if (newh > 0)
{
ArrayList temps = getColumnDataTexts("L1", row + 1, o);
nr.FillColumnsText(temps);
rpp.AddReportRow(nr);
projSums = sumDataTexts("L1", projSums, temps);
if (row == rowcount - 1)
{
//=== End row
CRow ft1 = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr1 = ft1.Clone();
rpp.AddReportRow(ftr1);
newh = newh - ftr1.GetHeight();
}
}
if (newh < 1)
{
rpp.IsNewPageRequired = true;
//พวก sum ทั้งหลายจะถูกคืนค่ากลับไปด้วย เพราะถูกบวกไปแล้ว
//projSums = keepTotal1;
//sums = keepTotal2;
//prevProject = tmpPrevProject;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
CRow ft = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr = ft.Clone();
MInventoryTransaction v = new MInventoryTransaction(o);
double newh = AvailableSpace - nr.GetHeight();
if (Parameter.GetFieldValue("COSTING_TYPE").Equals("MOVE"))
{
nr.FillColumnsText((row + 1).ToString(), v.DocumentDateFmt, v.DocumentNo, v.LocationName, v.LocationToName, v.ItemCode, v.ItemNameThai
, CUtil.FormatNumber(v.ItemQuantity, "-"), CUtil.FormatNumber(v.ItemPrice, "-"), CUtil.FormatNumber(v.ItemAmount, "-"));
totals += CUtil.StringToDouble(v.ItemAmount);
}
rpp.AddReportRow(nr);
if (row == rowcount - 1)
{
newh = newh - ftr.GetHeight();
if (newh > 0)
{
ftr.FillColumnsText("", CLanguage.getValue("total"), "", "", "", "", "", "", "", CUtil.FormatNumber(totals.ToString(), "-"));
rpp.AddReportRow(ftr);
totals = 0;
}
}
if (newh < 0)
{
rpp.IsNewPageRequired = true;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
private void createDataHeaderRow1(UReportPage page)
{
CRow r = (CRow)rowdef["HEADER_LEVEL1"];
r.FillColumnsText(
CLanguage.getValue("number"),
CLanguage.getValue("date"),
CLanguage.getValue("inventory_doc_no"),
CLanguage.getValue("location_name"),
CLanguage.getValue("item_code"),
CLanguage.getValue("item_name_thai"),
CLanguage.getValue("lot_quantity"),
CLanguage.getValue("lot_avg"),
CLanguage.getValue("ProdValue"));
ConstructUIRow(page, r);
AvailableSpace = AvailableSpace - r.GetHeight();
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
MCashAccount v = new MCashAccount(o);
double newh = AvailableSpace - nr.GetHeight();
nr.FillColumnsText((row + 1).ToString(), v.AccountNo, v.AccountName, v.BankName, v.BankBranchName,
v.TotalAmountFmt);
totals[5] = totals[5] + CUtil.StringToDouble(v.TotalAmount);
rpp.AddReportRow(nr);
if (row == rowcount - 1)
{
//End row
CRow ft = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr = ft.Clone();
ftr.FillColumnsText(CLanguage.getValue("total"), "", "", "", "", CUtil.FormatNumber(totals[5].ToString()));
rpp.AddReportRow(ftr);
newh = AvailableSpace - ftr.GetHeight();
}
if (newh < 0)
{
rpp.IsNewPageRequired = true;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
private async void listQuery_ItemTapped(object sender, ItemTappedEventArgs e)
{
CRow tapped = (CRow)e.Item;
if (tapped.Items[0].UID != "")
{
CSystemObject sysobj;
try
{
sysobj = await m_ComosWeb.GetObject(m_Layer, tapped.Items[0].UID, m_Language);
}
catch (Exception ex)
{
await App.Current.MainPage.DisplayAlert("Error", "Error al cargar objetos de Comos Web: " + ex.Message, Services.TranslateExtension.TranslateText("OK"));
return;
}
if (sysobj == null)
{
return;
}
CObject o = new CObject()
{
ClassType = sysobj.SystemType,
Description = sysobj.Description,
IsClientPicture = sysobj.IsClientPicture,
Name = sysobj.Name,
UID = sysobj.UID,
OverlayUID = m_Mainobject.OverlayUID,
Picture = sysobj.Picture,
ProjectUID = m_Mainobject.ProjectUID,
SystemFullName = sysobj.Name,
};
PageSpecifications page = new PageSpecifications(m_Navigator, o, m_Language);
this.Navigation.PushAsync(page);
}
}
public void Nav_OnFiltered(object sender, EventArgs e)
{
if (view == QueryViewMode.Accordion)
{
listQuery.ItemsSource = nav.FilteredList;
}
else
{
CRow[] newRows = new CRow[nav.FilteredList.Count];
int i = 0;
foreach (CRow item in nav.FilteredList)
{
newRows[i] = new CRow {
Items = item.Items, UID = item.UID
};
i = i + 1;
}
m_Query.Rows = newRows;
ShowTableQuery();
}
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
//ArrayList keepTotal1 = copyTotalArray(groupSums);
//ArrayList keepTotal2 = copyTotalArray(sums);
filterRecord(o);
String rowType = o.GetFieldValue("ROW_TYPE");
CRow r = (CRow)rowdef[rowType];
CRow nr = r.Clone();
double newh = AvailableSpace - nr.GetHeight();
if (newh > 0)
{
ArrayList temps = getColumnDataTexts("L1", row + 1, o);
nr.FillColumnsText(temps);
rpp.AddReportRow(nr);
}
if (newh < 1)
{
rpp.IsNewPageRequired = true;
//พวก sum ทั้งหลายจะถูกคืนค่ากลับไปด้วย เพราะถูกบวกไปแล้ว
//groupSums = keepTotal1;
//sums = keepTotal2;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
protected override void createRowTemplates()
{
String nm = "";
Thickness defMargin = new Thickness(3, 1, 3, 1);
nm = "HEADER_LEVEL1";
CRow h = new CRow(nm, defHeightCol, defCol, defMargin);
h.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = h;
CColumn c_0 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[0], GridUnitType.Star));
h.AddColumn(c_0);
CColumn c_1 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[1], GridUnitType.Star));
h.AddColumn(c_1);
CColumn c_2 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[2], GridUnitType.Star));
h.AddColumn(c_2);
CColumn c_3 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[3], GridUnitType.Star));
h.AddColumn(c_3);
CColumn c_4 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[4], GridUnitType.Star));
h.AddColumn(c_4);
CColumn c_5 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[5], GridUnitType.Star));
h.AddColumn(c_5);
CColumn c_6 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[6], GridUnitType.Star));
h.AddColumn(c_6);
CColumn c_7 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[7], GridUnitType.Star));
h.AddColumn(c_7);
CColumn c_8 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[8], GridUnitType.Star));
h.AddColumn(c_8);
CColumn c_9 = new CColumn(new Thickness(0.5, 0.5, 0.5, 0.5), new GridLength(widths[9], GridUnitType.Star));
h.AddColumn(c_9);
nm = "DATA_LEVEL1";
CRow r0 = new CRow(nm, defHeightCol, defCol, defMargin);
r0.SetFont(null, FontStyles.Normal, 0, FontWeights.Normal);
rowdef[nm] = r0;
CColumn r0_c0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[0], GridUnitType.Star));
r0_c0.SetHorizontalAlignment(HorizontalAlignment.Center);
r0.AddColumn(r0_c0);
CColumn r0_c1_0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[1], GridUnitType.Star));
r0_c1_0.SetHorizontalAlignment(HorizontalAlignment.Center);
r0.AddColumn(r0_c1_0);
CColumn r0_c1_1 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[2], GridUnitType.Star));
r0_c1_1.SetHorizontalAlignment(HorizontalAlignment.Left);
r0.AddColumn(r0_c1_1);
CColumn r0_c2 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[3], GridUnitType.Star));
r0_c2.SetHorizontalAlignment(HorizontalAlignment.Left);
r0.AddColumn(r0_c2);
CColumn r0_c3 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[4], GridUnitType.Star));
r0_c3.SetHorizontalAlignment(HorizontalAlignment.Left);
r0.AddColumn(r0_c3);
CColumn r0_c4 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[5], GridUnitType.Star));
r0_c4.SetHorizontalAlignment(HorizontalAlignment.Left);
r0.AddColumn(r0_c4);
CColumn r0_c5 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[6], GridUnitType.Star));
r0_c5.SetHorizontalAlignment(HorizontalAlignment.Left);
r0.AddColumn(r0_c5);
CColumn r0_c6 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[7], GridUnitType.Star));
r0_c6.SetHorizontalAlignment(HorizontalAlignment.Right);
r0.AddColumn(r0_c6);
CColumn r0_c7 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[8], GridUnitType.Star));
r0_c7.SetHorizontalAlignment(HorizontalAlignment.Right);
r0.AddColumn(r0_c7);
CColumn r0_c8 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths[9], GridUnitType.Star));
r0_c8.SetHorizontalAlignment(HorizontalAlignment.Right);
r0.AddColumn(r0_c8);
nm = "FOOTER_LEVEL1";
CRow f1 = new CRow(nm, defHeightCol, defCol, defMargin);
f1.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = f1;
CColumn fc_0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[0], GridUnitType.Star));
f1.AddColumn(fc_0);
CColumn fc_1 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[1], GridUnitType.Star));
f1.AddColumn(fc_1);
CColumn fc_2 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[2], GridUnitType.Star));
f1.AddColumn(fc_2);
CColumn fc_3 = new CColumn(new Thickness(0, 0, 0, 0.5), new GridLength(widths[3], GridUnitType.Star));
fc_3.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_3);
CColumn fc_4 = new CColumn(new Thickness(0, 0, 0, 0.5), new GridLength(widths[4], GridUnitType.Star));
fc_4.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_4);
CColumn fc_5 = new CColumn(new Thickness(0, 0, 0, 0.5), new GridLength(widths[5], GridUnitType.Star));
fc_5.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_5);
CColumn fc_6 = new CColumn(new Thickness(0, 0, 0, 0.5), new GridLength(widths[6], GridUnitType.Star));
fc_6.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_6);
CColumn fc_7 = new CColumn(new Thickness(0, 0, 0, 0.5), new GridLength(widths[7], GridUnitType.Star));
fc_7.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_7);
CColumn fc_8 = new CColumn(new Thickness(0, 0, 0, 0.5), new GridLength(widths[8], GridUnitType.Star));
fc_8.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_8);
CColumn fc_9 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths[9], GridUnitType.Star));
fc_9.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_9);
}
protected override void createRowTemplates()
{
String nm = "";
Thickness defMargin = new Thickness(3, 1, 3, 1);
nm = "HEADER_LEVEL1";
CRow h2 = new CRow(nm, 30, 6, defMargin);
h2.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = h2;
CColumn c2_0 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[0], GridUnitType.Star));
h2.AddColumn(c2_0);
CColumn c2_1_0 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[1], GridUnitType.Star));
h2.AddColumn(c2_1_0);
CColumn c2_1_1 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[2], GridUnitType.Star));
h2.AddColumn(c2_1_1);
CColumn c2_2 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[3], GridUnitType.Star));
h2.AddColumn(c2_2);
CColumn c2_3 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths[4], GridUnitType.Star));
h2.AddColumn(c2_3);
CColumn c2_4 = new CColumn(new Thickness(0.5, 0.5, 0.5, 0.5), new GridLength(widths[5], GridUnitType.Star));
h2.AddColumn(c2_4);
nm = "DATA_LEVEL1";
CRow r0 = new CRow(nm, 30, 6, defMargin);
r0.SetFont(null, FontStyles.Normal, 0, FontWeights.Normal);
rowdef[nm] = r0;
CColumn r0_c0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[0], GridUnitType.Star));
r0_c0.SetHorizontalAlignment(HorizontalAlignment.Center);
r0.AddColumn(r0_c0);
CColumn r0_c1_0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[1], GridUnitType.Star));
r0_c1_0.SetHorizontalAlignment(HorizontalAlignment.Left);
r0.AddColumn(r0_c1_0);
CColumn r0_c1_1 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[2], GridUnitType.Star));
r0_c1_1.SetHorizontalAlignment(HorizontalAlignment.Left);
r0.AddColumn(r0_c1_1);
CColumn r0_c2 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[3], GridUnitType.Star));
r0_c2.SetHorizontalAlignment(HorizontalAlignment.Left);
r0.AddColumn(r0_c2);
CColumn r0_c3 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[4], GridUnitType.Star));
r0_c3.SetHorizontalAlignment(HorizontalAlignment.Left);
r0.AddColumn(r0_c3);
CColumn r0_c4 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths[5], GridUnitType.Star));
r0_c4.SetHorizontalAlignment(HorizontalAlignment.Right);
r0.AddColumn(r0_c4);
nm = "FOOTER_LEVEL1";
CRow f1 = new CRow(nm, 30, 6, defMargin);
f1.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = f1;
CColumn fc_0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[0], GridUnitType.Star));
f1.AddColumn(fc_0);
CColumn fc_1 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[1], GridUnitType.Star));
f1.AddColumn(fc_1);
CColumn fc_2 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[2], GridUnitType.Star));
f1.AddColumn(fc_2);
CColumn fc_3 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[3], GridUnitType.Star));
f1.AddColumn(fc_3);
CColumn fc_4 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths[4], GridUnitType.Star));
fc_4.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_4);
CColumn fc_5 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths[5], GridUnitType.Star));
fc_5.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_5);
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
if (isSkipRow(o))
{
//In case the last record is skipped
if (row == rowcount - 1)
{
addTotalRow(rpp, sums);
}
//Do Nothing
return(rpp);
}
ArrayList keepTotal2 = copyTotalArray(sums);
rowProcess++;
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
double newh = AvailableSpace - nr.GetHeight();
if (newh > 0)
{
filterDrCrAmount(o);
String refDocNo = o.GetFieldValue("REF_DOCUMENT_NO");
if (refDocNo.Equals(""))
{
refDocNo = o.GetFieldValue("ACTUAL_INVOICE_NO");
}
o.SetFieldValue("REF_DOCUMENT_NO", refDocNo);
String refDocDate = o.GetFieldValue("REF_DOCUMENT_DATE");
if (refDocDate.Equals(""))
{
refDocDate = o.GetFieldValue("ACTUAL_INVOICE_DATE");
}
o.SetFieldValue("REF_DOCUMENT_DATE", refDocDate);
ArrayList temps = getColumnDataTexts("L1", rowProcess, o);
nr.FillColumnsText(temps);
rpp.AddReportRow(nr);
sums = sumDataTexts("L1", sums, temps);
if (row == rowcount - 1)
{
addTotalRow(rpp, sums);
}
}
if (newh < 1)
{
rpp.IsNewPageRequired = true;
sums = keepTotal2;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
protected override void createRowTemplates()
{
String nm = "";
Thickness defMargin = new Thickness(3, 1, 3, 1);
nm = "HEADER_LEVEL1";
CRow h1 = new CRow(nm, 30, 4, defMargin);
h1.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = h1;
CColumn c2_0 = new CColumn(new Thickness(0.5, 0.5, 0, 0), new GridLength(widths4Col[0], GridUnitType.Star));
h1.AddColumn(c2_0);
CColumn c2_1_0 = new CColumn(new Thickness(0.5, 0.5, 0, 0), new GridLength(widths4Col[1], GridUnitType.Star));
h1.AddColumn(c2_1_0);
CColumn c2_1_1 = new CColumn(new Thickness(0.5, 0.5, 0, 0), new GridLength(widths4Col[2], GridUnitType.Star));
h1.AddColumn(c2_1_1);
CColumn c2_1_2 = new CColumn(new Thickness(0.5, 0.5, 0.5, 0), new GridLength(widths4Col[3], GridUnitType.Star));
h1.AddColumn(c2_1_2);
nm = "HEADER_LEVEL2";
CRow h2 = new CRow(nm, 30, 5, defMargin);
h2.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = h2;
CColumn c3_0 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths5Col[0], GridUnitType.Star));
h2.AddColumn(c3_0);
CColumn c3_1 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths5Col[1], GridUnitType.Star));
h2.AddColumn(c3_1);
CColumn c3_2 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths5Col[2], GridUnitType.Star));
h2.AddColumn(c3_2);
CColumn c3_3 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths5Col[3], GridUnitType.Star));
h2.AddColumn(c3_3);
CColumn c3_4 = new CColumn(new Thickness(0.5, 0.5, 0.5, 0.5), new GridLength(widths5Col[4], GridUnitType.Star));
h2.AddColumn(c3_4);
//CColumn c3_5 = new CColumn(new Thickness(0.5, 0.5, 0, 0.5), new GridLength(widths7Col[5], GridUnitType.Star));
// h2.AddColumn(c3_5);
//CColumn c3_6 = new CColumn(new Thickness(0.5, 0.5, 0.5, 0.5), new GridLength(widths7Col[6], GridUnitType.Star));
// h2.AddColumn(c3_6);
nm = "DATA_LEVEL1";
CRow r1 = new CRow(nm, 30, 4, defMargin);
r1.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = r1;
CColumn r1_c0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths4Col[0], GridUnitType.Star));
r1_c0.SetHorizontalAlignment(HorizontalAlignment.Center);
r1.AddColumn(r1_c0);
CColumn r1_c1 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths4Col[1], GridUnitType.Star));
r1_c1.SetHorizontalAlignment(HorizontalAlignment.Left);
r1.AddColumn(r1_c1);
CColumn r1_c2 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths4Col[2], GridUnitType.Star));
r1_c2.SetHorizontalAlignment(HorizontalAlignment.Left);
r1.AddColumn(r1_c2);
CColumn r1_c3 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths4Col[3], GridUnitType.Star));
r1_c3.SetHorizontalAlignment(HorizontalAlignment.Left);
r1.AddColumn(r1_c3);
nm = "DATA_LEVEL2";
CRow r0 = new CRow(nm, 30, 5, defMargin);
r0.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = r0;
CColumn r0_c0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[0], GridUnitType.Star));
r0_c0.SetHorizontalAlignment(HorizontalAlignment.Center);
r0.AddColumn(r0_c0);
CColumn r0_c1_0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[1], GridUnitType.Star));
r0_c1_0.SetHorizontalAlignment(HorizontalAlignment.Center);
r0.AddColumn(r0_c1_0);
CColumn r0_c1_1 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[2], GridUnitType.Star));
r0_c1_1.SetHorizontalAlignment(HorizontalAlignment.Right);
r0.AddColumn(r0_c1_1);
CColumn r0_c2 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[3], GridUnitType.Star));
r0_c2.SetHorizontalAlignment(HorizontalAlignment.Right);
r0.AddColumn(r0_c2);
CColumn r0_c3 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths5Col[4], GridUnitType.Star));
r0_c3.SetHorizontalAlignment(HorizontalAlignment.Right);
r0.AddColumn(r0_c3);
//CColumn r0_c4 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths7Col[5], GridUnitType.Star));
//r0_c4.SetHorizontalAlignment(HorizontalAlignment.Right);
//r0.AddColumn(r0_c4);
//CColumn r0_c5 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths7Col[6], GridUnitType.Star));
//r0_c5.SetHorizontalAlignment(HorizontalAlignment.Left);
//r0.AddColumn(r0_c5);
nm = "DATA_LEVEL3";
CRow r2 = new CRow(nm, 30, 5, defMargin);
r2.SetFont(null, FontStyles.Normal, 0, FontWeights.Normal);
rowdef[nm] = r2;
CColumn r2_c0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[0], GridUnitType.Star));
r2_c0.SetHorizontalAlignment(HorizontalAlignment.Center);
r2.AddColumn(r2_c0);
CColumn r2_c1_0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[1], GridUnitType.Star));
r2_c1_0.SetHorizontalAlignment(HorizontalAlignment.Center);
r2.AddColumn(r2_c1_0);
CColumn r2_c1_1 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[2], GridUnitType.Star));
r2_c1_1.SetHorizontalAlignment(HorizontalAlignment.Right);
r2.AddColumn(r2_c1_1);
CColumn r2_c2 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[3], GridUnitType.Star));
r2_c2.SetHorizontalAlignment(HorizontalAlignment.Right);
r2.AddColumn(r2_c2);
CColumn r2_c3 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths5Col[4], GridUnitType.Star));
r2_c3.SetHorizontalAlignment(HorizontalAlignment.Right);
r2.AddColumn(r2_c3);
//CColumn r2_c4 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths7Col[5], GridUnitType.Star));
//r2_c4.SetHorizontalAlignment(HorizontalAlignment.Right);
//r2.AddColumn(r2_c4);
//CColumn r2_c5 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths7Col[6], GridUnitType.Star));
//r2_c5.SetHorizontalAlignment(HorizontalAlignment.Left);
//r2.AddColumn(r2_c5);
nm = "FOOTER_LEVEL1";
CRow f1 = new CRow(nm, 30, 5, defMargin);
f1.SetFont(null, FontStyles.Normal, 0, FontWeights.Bold);
rowdef[nm] = f1;
CColumn fc_0 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[0], GridUnitType.Star));
f1.AddColumn(fc_0);
CColumn fc_1 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[1], GridUnitType.Star));
f1.AddColumn(fc_1);
CColumn fc_2 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[2], GridUnitType.Star));
fc_2.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_2);
CColumn fc_3 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths5Col[3], GridUnitType.Star));
fc_3.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_3);
CColumn fc_4 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths5Col[4], GridUnitType.Star));
fc_4.SetHorizontalAlignment(HorizontalAlignment.Right);
f1.AddColumn(fc_4);
//CColumn fc_5 = new CColumn(new Thickness(0.5, 0, 0, 0.5), new GridLength(widths7Col[5], GridUnitType.Star));
//fc_5.SetHorizontalAlignment(HorizontalAlignment.Right);
//f1.AddColumn(fc_5);
//CColumn fc_6 = new CColumn(new Thickness(0.5, 0, 0.5, 0.5), new GridLength(widths7Col[6], GridUnitType.Star));
//fc_6.SetHorizontalAlignment(HorizontalAlignment.Right);
//f1.AddColumn(fc_6);
}
public async Task <CQuerieResult> GetqueriesResult(string database, string projectuid, string layer, string lcid, string target, string start_objid)
{
var content = await communicationManager.GetqueriesResult(m_Url, database, projectuid, target, lcid, layer, start_objid, m_Session.Id, serverName);
if (content == null)
{
return(null);
}
JObject json = JObject.Parse(content);
if (json == null)
{
return(null);
}
CQuerieResult q = new CQuerieResult()
{
UID = json.SelectToken("UID").Value <string>(),
};
List <int> invisiblecolumns = new List <int>();
int index = 0;
List <CColumn> columns = new List <CColumn>();
foreach (var jcol in (JArray)json.SelectToken("Columns"))
{
CColumn c = new CColumn()
{
Alignment = jcol.SelectToken("Alignment").Value <int>(),
DisplayDescription = jcol.SelectToken("DisplayDescription").Value <string>(),
Id = jcol.SelectToken("Id").Value <int>(),
IsDate = jcol.SelectToken("IsDate").Value <bool>(),
Numeric = jcol.SelectToken("Numeric").Value <bool>(),
Visible = jcol.SelectToken("Visible").Value <bool>(),
Width = jcol.SelectToken("Width").Value <int>(),
WithPicture = jcol.SelectToken("WithPicture").Value <bool>(),
WrapText = jcol.SelectToken("WrapText").Value <bool>(),
};
if (c.Width > 0)
{
columns.Add(c);
}
else
{
invisiblecolumns.Add(index);
}
index++;
}
q.Columns = columns.ToArray();
List <CRow> rows = new List <CRow>();
foreach (var jrow in (JArray)json.SelectToken("Rows"))
{
CRow c = new CRow()
{
UID = jrow.SelectToken("UID").Value <string>(),
};
List <CCell> cells = new List <CCell>();
index = 0;
foreach (var jcell in (JArray)jrow.SelectToken("Items"))
{
CCell cell = new CCell()
{
IsClientPicture = jcell.SelectToken("IsClientPicture").Value <bool>(),
NumericValue = jcell.SelectToken("NumericValue").Value <double>(),
Picture = jcell.SelectToken("Picture").Value <string>(),
Text = jcell.SelectToken("Text").Value <string>(),
UID = jcell.SelectToken("UID").Value <string>(),
};
if (!invisiblecolumns.Contains(index))
{
cells.Add(cell);
}
index++;
}
c.Items = cells.ToArray();
rows.Add(c);
}
q.Rows = rows.ToArray();
return(q);
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
CRow r1 = (CRow)rowdef["DATA_LEVEL2"];
CRow nr1 = r1.Clone();
CRow r2 = (CRow)rowdef["DATA_LEVEL3"];
CRow nr2 = r2.Clone();
CRow ft = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr = ft.Clone();
CRow ftrLast = ft.Clone();
double newh = AvailableSpace;
int temp = 0;
MCashDoc v = new MCashDoc(o);
D = v.AccountNo;
if (!H.Equals(D))
{
//v.IsBalanceForward = true;
nr.FillColumnsText(v.AccountNo, v.AccountName, v.BankName, v.BankBranchName);
nr1.FillColumnsText("",
CLanguage.getValue("balance_forward"),
"", "",
CUtil.FormatNumber(v.BeginAmount_BalanceeFmt, "-"));
Account = v.AccountNo;
// v.IsBalanceForward = false;
if ((!H.Equals("")) && (!H.Equals(D)))
{
ftr.FillColumnsText("",
CLanguage.getValue("total"),
CUtil.FormatNumber(totals[0].ToString(), "-"),
CUtil.FormatNumber(totals[1].ToString(), "-"),
CUtil.FormatNumber(totals[2].ToString(), "-"));
newh = newh - ftr.GetHeight();
if (newh > 0)
{
rpp.AddReportRow(ftr);
newh = newh - nr.GetHeight() - nr1.GetHeight();
if (newh > 0)
{
rpp.AddReportRow(nr);
rpp.AddReportRow(nr1);
temp++;
H = Account;
totals[0] = 0;
totals[1] = 0;
totals[2] = 0;
rowNo = 0;
}
}
}
else
{
newh = newh - nr.GetHeight() - nr1.GetHeight();
if (newh > 0)
{
rpp.AddReportRow(nr);
rpp.AddReportRow(nr1);
temp++;
}
}
}
if (newh > 0)
{
newh = newh - nr2.GetHeight();
if (newh > 0)
{
rowNo++;
nr2.FillColumnsText(
CUtil.FormatInt(rowNo.ToString()),
v.DocumentDateFmt,
CUtil.FormatNumber(v.InAmount_BalnceFmt, "-"),
CUtil.FormatNumber(v.OutAmount_BalanceFmt, "-"),
CUtil.FormatNumber(v.EndAmount_BalanceFmt, "-"));
totals[0] += CUtil.StringToDouble(v.InAmount_BalnceFmt);
totals[1] += CUtil.StringToDouble(v.OutAmount_BalanceFmt);
totals[2] = CUtil.StringToDouble(v.EndAmount_BalanceFmt);
rpp.AddReportRow(nr2);
}
}
if (newh > 0)
{
if (row == rowcount - 1)
{
ftrLast.FillColumnsText("",
CLanguage.getValue("total"),
CUtil.FormatNumber(totals[0].ToString(), "-"),
CUtil.FormatNumber(totals[1].ToString(), "-"),
CUtil.FormatNumber(totals[2].ToString(), "-"));
newh = newh - ftrLast.GetHeight();
if (newh > 0)
{
rpp.AddReportRow(ftrLast);
rowNo = 0;
totals[0] = 0;
totals[1] = 0;
totals[2] = 0;
}
}
Account = v.AccountNo;
H = Account;
}
if (newh < 0)
{
rpp.IsNewPageRequired = true;
rpp.TempNotRowDetails = temp;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
public void AddCRow(CRow row) {
this.Rows.Add(row);
}
public void RemoveCRow(CRow row) {
this.Rows.Remove(row);
}
public CRowChangeEvent(CRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
public override CReportDataProcessingProperty DataToProcessingProperty(CTable o, ArrayList rows, int row)
{
String tmpPrevKey = prevProject;
int rowcount = rows.Count;
CReportDataProcessingProperty rpp = new CReportDataProcessingProperty();
ArrayList keepTotal1 = copyTotalArray(projSums);
ArrayList keepTotal2 = copyTotalArray(sums);
CRow r = (CRow)rowdef["DATA_LEVEL1"];
CRow nr = r.Clone();
double newh = AvailableSpace - nr.GetHeight();
if (newh > 0)
{
filterDrCrAmount(o);
populatePaymentIndex(o);
String projCd = o.GetFieldValue(getGroupKey());
if (row == 0)
{
prevProject = projCd;
}
String rptType = Parameter.GetFieldValue("REPORT_TYPE");
if (!projCd.Equals(prevProject))
{
prevProject = projCd;
CRow ft = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr = ft.Clone();
ArrayList projTotals = displayTotalTexts("L1", projSums, 1, "total");
ftr.FillColumnsText(projTotals);
if (rptType.Equals("2") || rptType.Equals("3"))
{
//Only by project report
rpp.AddReportRow(ftr);
newh = newh - ftr.GetHeight();
}
//Reset
projSums = new ArrayList();
}
ArrayList temps = getColumnDataTexts("L1", row + 1, o);
nr.FillColumnsText(temps);
rpp.AddReportRow(nr);
sums = sumDataTexts("L1", sums, temps);
projSums = sumDataTexts("L1", projSums, temps);
if (row == rowcount - 1)
{
//=== Project
CRow ft0 = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr0 = ft0.Clone();
ArrayList projTotals = displayTotalTexts("L1", projSums, 1, "total");
ftr0.FillColumnsText(projTotals);
if (rptType.Equals("2") || rptType.Equals("3"))
{
//Only by project report
rpp.AddReportRow(ftr0);
newh = newh - ftr0.GetHeight();
}
//=== End row
CRow ft1 = (CRow)rowdef["FOOTER_LEVEL1"];
CRow ftr1 = ft1.Clone();
ArrayList totals = displayTotalTexts("L1", sums, 1, "total");
ftr1.FillColumnsText(totals);
rpp.AddReportRow(ftr1);
newh = newh - ftr1.GetHeight();
}
}
if (newh < 1)
{
rpp.IsNewPageRequired = true;
//พวก sum ทั้งหลายจะถูกคืนค่ากลับไปด้วย เพราะถูกบวกไปแล้ว
projSums = keepTotal1;
sums = keepTotal2;
prevProject = tmpPrevKey;
}
else
{
AvailableSpace = newh;
}
return(rpp);
}
