private void RadForm1_Load(object sender, EventArgs e)
{
this.productsTableAdapter.Fill(this.nwindDataSet.Products);
this.radGridView1.DataSource = this.productsBindingSource;
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.radGridView1.AllowAddNewRow = false;
this.radGridView1.EnableGrouping = true;
this.radGridView1.MasterTemplate.ShowGroupedColumns = true;
this.radGridView1.TableElement.GroupHeaderHeight = 60;
// group by CategoryID
GroupDescriptor descriptor = new GroupDescriptor();
descriptor.GroupNames.Add("CategoryID", ListSortDirection.Ascending);
this.radGridView1.GroupDescriptors.Add(descriptor);
// add summary items
GridViewSummaryItem item1 = new GridViewSummaryItem("UnitPrice", "Avg = {0:N2}", GridAggregateFunction.Avg);
GridViewSummaryItem item2 = new GridViewSummaryItem("ProductID", "Count = {0}", GridAggregateFunction.Count);
GridViewSummaryItem item4 = new GridViewSummaryItem("UnitsOnOrder", "Max = {0}", GridAggregateFunction.Max);
GridViewSummaryItem item5 = new GridViewSummaryItem("UnitsInStock", "Sum = {0}", GridAggregateFunction.Sum);
GridViewSummaryRowItem row = new GridViewSummaryRowItem(new GridViewSummaryItem[] { item1, item2, item4, item5 });
this.radGridView1.SummaryRowsTop.Add(row);
}
public virtual Dictionary <string, string> GetSummaryValues()
{
if (this.ElementTree == null)
{
return(new Dictionary <string, string>());
}
Dictionary <string, string> result = new Dictionary <string, string>();
foreach (SummaryCellElement cell in this.stack.Children)
{
if (this.GridControl.SummaryRowsTop[0][cell.ColumnName] == null)
{
result.Add(cell.ColumnName, String.Empty);
}
else
{
GridViewSummaryItem summaryItem = this.GridControl.SummaryRowsTop[0][cell.ColumnName][0];
object value = this.ViewTemplate.DataView.Evaluate(summaryItem.GetSummaryExpression(), this.GetDataRows());
string text = string.Format(summaryItem.FormatString, value);
result.Add(summaryItem.Name, text);
}
}
return(result);
}
public Form1()
{
InitializeComponent();
//This project demonstrates how to show the summary cells when the groups are collpased
#region Populate with data
for (int i = 0; i < 5; i++)
{
GridViewDecimalColumn col = new GridViewDecimalColumn("Col " + (i + 1));
this.radGridView1.Columns.Add(col);
}
for (int i = 0; i < 20; i++)
{
this.radGridView1.Rows.Add(i % 5, i % 3, i % 2, i, i);
}
#endregion
#region Add summary items
GridViewSummaryItem item1 = new GridViewSummaryItem("Col 1", "Sum = {0}", GridAggregateFunction.Sum);
GridViewSummaryItem item2 = new GridViewSummaryItem("Col 2", "Avg = {0}", GridAggregateFunction.Avg);
GridViewSummaryItem item4 = new GridViewSummaryItem("Col 4", "Max = {0}", GridAggregateFunction.Max);
GridViewSummaryItem item5 = new GridViewSummaryItem("Col 5", "First = {0}", GridAggregateFunction.First);
GridViewSummaryRowItem row = new GridViewSummaryRowItem(new GridViewSummaryItem[] { item1, item2, item4, item5 });
this.radGridView1.SummaryRowsTop.Add(row);
#endregion
this.radGridView1.TableElement.GroupHeaderHeight = 50;
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.radGridView1.CreateCell += new GridViewCreateCellEventHandler(radGridView1_CreateCell);
this.radGridView1.Columns.CollectionChanged += new NotifyCollectionChangedEventHandler(Columns_CollectionChanged);
}
private void TotalExpenses()
{
GridViewSummaryItem summaryItemFreight = new GridViewSummaryItem("RequiarAmount", "الاجمالي={0}" + InformationsClass.Coin + " ", GridAggregateFunction.Sum);
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem(new GridViewSummaryItem[] { summaryItemFreight });
this.ExpensesGridView.SummaryRowsBottom.Clear();
this.ExpensesGridView.SummaryRowsBottom.Add(summaryRowItem);
}
private void LoadMyCollection()
{
gridMyCollection.Columns["Cost"].SortOrder = RadSortOrder.Ascending;
gridMyCollection.Columns["Name"].SortOrder = RadSortOrder.Ascending;
gridMyCollection.MasterTemplate.GroupComparer = new GroupComparer();
gridMyCollection.DataSource = MyCollection.Cards;
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
GridViewSummaryItem summaryItem = new GridViewSummaryItem();
summaryItem.Name = "Own";
summaryItem.AggregateExpression = "Sum(IIf(Own > 0, 1, 0))";
summaryRowItem.Add(summaryItem);
summaryItem = new GridViewSummaryItem();
summaryItem.Name = "Missing";
summaryItem.AggregateExpression = "Sum(IIf(Missing > 0, 1, 0))";
summaryRowItem.Add(summaryItem);
summaryItem = new GridViewSummaryItem();
summaryItem.Name = "Dust";
summaryItem.AggregateExpression = "Sum(Dust * Missing)";
summaryRowItem.Add(summaryItem);
gridMyCollection.SummaryRowsTop.Add(summaryRowItem);
gridMyCollection.MasterTemplate.ShowTotals = true;
gridMyCollection.MasterView.SummaryRows[0].PinPosition = PinnedRowPosition.Top;
gridMyCollection.MasterTemplate.ExpandAllGroups();
}
private void MyTimer_Tick(object sender, EventArgs e)
{
this.ProductsRadGridView.TableElement.Text = string.Empty;
this.ProductsRadGridView.TableElement.BackgroundImage = null;
FillProductsRadGridView();
if (ProductsRadGridView.Rows.Count == 0)
{
this.ProductsRadGridView.TableElement.Text = "Producto(s) no encontrado(s)..";
}
this.MyTimer.Stop();
ConditionalFormattingObject objFormat =
new ConditionalFormattingObject("MyCondiction", ConditionTypes.Equal, "0", "", true);
objFormat.CellForeColor = Color.Red;
objFormat.RowBackColor = Color.SkyBlue;
this.ProductsRadGridView.Columns["Stock"]
.ConditionalFormattingObjectList
.Add(objFormat);
GridViewSummaryItem summaryItem = new GridViewSummaryItem("ProductCode", "Producto(s) Reg. {0}", GridAggregateFunction.Count);
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
summaryRowItem.Add(summaryItem);
ProductsRadGridView.SummaryRowsTop.Add(summaryRowItem);
}
private void UcConsignacionesPorEditorial_Load(object sender, EventArgs e)
{
this.Width = this.Parent.Width - 40;
var incremento = 150;
if (_itemsCount < 3)
incremento = 100;
else if (incremento < 6)
incremento = 127;
this.Height = 60 + incremento;
splitContainer1.SplitterDistance = 45;
var summaryItem = new GridViewSummaryItem
{
Name = "TotalARendir",
Aggregate = GridAggregateFunction.Sum,
FormatString = "{0:c}"
};
var summaryRowItem = new GridViewSummaryRowItem {summaryItem};
this.GridTitulos.SummaryRowsBottom.Add(summaryRowItem);
}
private void UcConsignacionesPorEditorial_Load(object sender, EventArgs e)
{
this.Width = this.Parent.Width - 40;
var incremento = 150;
if (_itemsCount < 3)
{
incremento = 100;
}
else if (incremento < 6)
{
incremento = 127;
}
this.Height = 60 + incremento;
splitContainer1.SplitterDistance = 45;
var summaryItem = new GridViewSummaryItem
{
Name = "TotalARendir",
Aggregate = GridAggregateFunction.Sum,
FormatString = "{0:c}"
};
var summaryRowItem = new GridViewSummaryRowItem {
summaryItem
};
this.GridTitulos.SummaryRowsBottom.Add(summaryRowItem);
}
private void loadList()
{
IPaymentService payService = new PaymentService();
if (IDnum == "All")
payment = new List<Payment>(payService.GetAllPayments());
else
payment = new List<Payment>(payService.GetAllStudentsPayments(IDnum));
gridView.DataSource = payment;
GroupDescriptor descriptor = new GroupDescriptor();
descriptor.GroupNames.Add("Student", ListSortDirection.Ascending);
this.gridView.GroupDescriptors.Add(descriptor);
GridViewSummaryItem summaryItem;
if (IDnum != "All")
summaryItem = new GridViewSummaryItem("Amount", "Total: {0} Balance: " + payment[0].Balance, GridAggregateFunction.Sum);
else
summaryItem = new GridViewSummaryItem("Amount", "Total: {0}", GridAggregateFunction.Sum);
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
summaryRowItem.Add(summaryItem);
this.gridView.SummaryRowsBottom.Add(summaryRowItem);
}
private void AddSummaries()
{
this.grdLister.MasterGridViewTemplate.SummaryRowsBottom.Clear();
GridViewSummaryRowItem item2 = new GridViewSummaryRowItem();
GridViewSummaryItem c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.None;
c.AggregateExpression = "SUM(PaidTotalRentCommission)";
c.Name = "DriverNo";
c.FormatString = "Gr. Total";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(PaidAccountBookings)";
c.Name = "AccountBookings";
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(PaidTotalRentCommission)";
c.Name = "TotalRentCommission";
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(PaidOfficeToPay)";
c.Name = "OfficeToPay";
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(PaidDriverToPay)";
c.Name = "DriverToPay";
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(PaidPreviousBalance)";
c.Name = "PreviousBalance";
c.FormatString = "{0}";
item2.Add(c);
this.grdLister.MasterGridViewTemplate.SummaryRowsBottom.Add(item2);
this.grdLister.MasterView.SummaryRows[0].PinPosition = PinnedRowPosition.Bottom;
}
private void TotalAmount()
{
GridViewSummaryItem summaryItemFreight = new GridViewSummaryItem("TotalSalary", "الاجمالي={0}" + InformationsClass.Coin + " ", GridAggregateFunction.Sum);
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem(new GridViewSummaryItem[] { summaryItemFreight });
this.ContractsGridView.SummaryRowsBottom.Clear();
this.ContractsGridView.SummaryRowsBottom.Add(summaryRowItem);
///
}
private void TotalActivites()
{
GridViewSummaryItem summaryItemFreight1 = new GridViewSummaryItem("SubTotalCost", "الاجمالي={0}"+InformationsClass.Coin+"", GridAggregateFunction.Sum);
GridViewSummaryRowItem summaryRowItem1 = new GridViewSummaryRowItem(new GridViewSummaryItem[] { summaryItemFreight1 });
this.gridViewTemplate2.SummaryRowsBottom.Clear();
this.gridViewTemplate2.SummaryRowsBottom.Add(summaryRowItem1);
///
GridViewSummaryItem summaryItemFreight = new GridViewSummaryItem("ActivityTotalCost", "الاجمالي العام={0}" + InformationsClass.Coin + "", GridAggregateFunction.Sum);
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem(new GridViewSummaryItem[] { summaryItemFreight });
this.ActivitiesGridView.SummaryRowsBottom.Clear();
this.ActivitiesGridView.SummaryRowsBottom.Add(summaryRowItem);
}
public RadForm1()
{
InitializeComponent();
radGridView1.CreateCell += RadGridView1_CreateCell;
radGridView1.DataSource = GetTable();
GridViewSummaryItem summaryItem = new GridViewSummaryItem();
summaryItem.Name = "Dosage";
summaryItem.Aggregate = GridAggregateFunction.Avg;
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
summaryRowItem.Add(summaryItem);
this.radGridView1.SummaryRowsTop.Add(summaryRowItem);
radGridView1.TableElement.RowHeight = 60;
radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}
private void loadList()
{
IPaymentService payService = new PaymentService();
if (IDnum == "All")
{
payment = new List <Payment>(payService.GetAllPayments());
}
else
{
payment = new List <Payment>(payService.GetAllStudentsPayments(IDnum));
}
gridView.DataSource = payment;
GroupDescriptor descriptor = new GroupDescriptor();
descriptor.GroupNames.Add("Student", ListSortDirection.Ascending);
this.gridView.GroupDescriptors.Add(descriptor);
GridViewSummaryItem summaryItem;
if (IDnum != "All")
{
summaryItem = new GridViewSummaryItem("Amount", "Total: {0} Balance: " + payment[0].Balance, GridAggregateFunction.Sum);
}
else
{
summaryItem = new GridViewSummaryItem("Amount", "Total: {0}", GridAggregateFunction.Sum);
}
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
summaryRowItem.Add(summaryItem);
this.gridView.SummaryRowsBottom.Add(summaryRowItem);
}
private void frmCapturaPedidos_Load(object sender, EventArgs e)
{
try {
/* GRUPO POR TIPO Y ENTIDAD */
GroupDescriptor tipo = new GroupDescriptor();
tipo.GroupNames.Add("Tipo", ListSortDirection.Ascending);
tipo.GroupNames.Add("Entidad", ListSortDirection.Ascending);
this.gvDatos.GroupDescriptors.Add(tipo);
/* SUMA DE TOTALES */
GridViewSummaryItem summaryItem = new GridViewSummaryItem("Total", "{0:C2}", GridAggregateFunction.Sum);
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
summaryRowItem.Add(summaryItem);
this.gvDatos.SummaryRowsBottom.Add(summaryRowItem);
this.gvDatos.MasterTemplate.ShowTotals = true;
} catch (Exception ex) {
RadMessageBox.Show("Ocurrió un error al cargar la pantalla\n" + ex.Message, this.Text, MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
private void frmInputUJ_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'sinarekDataSet.kota' table. You can move, or remove it, as needed.
this.kotaTableAdapter.Fill(this.sinarekDataSet.kota);
// TODO: This line of code loads data into the 'sinarekDataSet.vproductbase' table. You can move, or remove it, as needed.
this.vproductbaseTableAdapter.Fill(this.sinarekDataSet.vproductbase);
// TODO: This line of code loads data into the 'sinarekDataSet.logother' table. You can move, or remove it, as needed.
this.logotherTableAdapter.FillByTipeLap(this.sinarekDataSet.logother, int.Parse(ujid_)
, int.Parse(row_["logid"].ToString())
, int.Parse(lappenid_));
InitialiazeButtons();
GridViewSummaryRowItem summaryRowItem2 = new GridViewSummaryRowItem();
GridViewSummaryItem summaryItem = new GridViewSummaryItem();
summaryItem.Name = "Detail3";
summaryItem.FormatString = "Sisa Uang Jalan :";
summaryItem.Aggregate = GridAggregateFunction.Last;
summaryRowItem2.Add(summaryItem);
GridViewSummaryItem summaryItem2 = new GridViewSummaryItem();
summaryItem2.Name = "Total";
summaryItem2.FormatString = "{0:Rp #,###.00}";
summaryItem2.AggregateExpression = value_.ToString() + " - Sum(Total)";
summaryRowItem2.Add(summaryItem2);
this.radGridView2.SummaryRowsTop.Add(summaryRowItem2);
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
GridViewSummaryItem summaryItem3 = new GridViewSummaryItem();
summaryItem3.Name = "Total";
summaryItem3.FormatString = "{0:Rp #,###.00}";
summaryItem3.Aggregate = GridAggregateFunction.Sum;
summaryRowItem.Add(summaryItem3);
GridViewSummaryItem summaryItem4 = new GridViewSummaryItem();
summaryItem4.Name = "Detail3";
summaryItem4.FormatString = "Total Biaya :";
summaryItem4.Aggregate = GridAggregateFunction.Sum;
summaryRowItem.Add(summaryItem4);
this.radGridView2.SummaryRowsTop.Add(summaryRowItem);
}
private void LoadDef()
{
using (var db = new DataClasses1DataContext())
{
int yy = 2018;
while (yy <= DateTime.Now.Year + 3)
{
cbbYY.Items.Add(yy.ToSt());
yy++;
}
cbbYY.Text = DateTime.Now.Year.ToSt();
//cbbMonth.Items.Add("");
int mm = 1;
while (mm <= 12)
{
DateTime dTemp = new DateTime(yy, mm, 1);
cbbMM.Items.Add(dTemp.ToString("MMM"));
cbbMM2.Items.Add(dTemp.ToString("MMM"));
mm++;
}
cbbMM.SelectedIndex = DateTime.Now.Month - 1;
cbbMM2.SelectedIndex = DateTime.Now.Month - 1;
var item = db.mh_Items.Where(x => x.Active && x.InventoryGroup == "FG")
.Select(x => new ItemCombo {
Item = x.InternalNo, ItemName = x.InternalName
}).ToList();
item.Add(new ItemCombo
{
Item = "",
ItemName = ""
});
item = item.OrderBy(x => x.Item).ToList();
cbbItem.AutoSizeDropDownToBestFit = true;
cbbItem.DisplayMember = "ItemName";
cbbItem.ValueMember = "Item";
cbbItem.DataSource = item;
cbbItem.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
var Customers = db.mh_Customers.Where(x => x.Active)
.Select(x => new CustomerCombo {
No = x.No, Name = x.Name
}).ToList();
Customers.Add(new CustomerCombo
{
No = "",
Name = "",
});
Customers = Customers.OrderBy(x => x.No).ToList();
cbbCSTM.AutoSizeDropDownToBestFit = true;
cbbCSTM.DisplayMember = "Name";
cbbCSTM.ValueMember = "No";
cbbCSTM.DataSource = Customers;
cbbCSTM.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
var sumaryRow = new GridViewSummaryRowItem();
dgvData.SummaryRowsBottom.Add(sumaryRow);
dgvData.MasterTemplate.ShowTotals = true;
var sum2 = new GridViewSummaryItem("Summary", "{0:N2}", GridAggregateFunction.Sum);
sumaryRow.Add(sum2);
//Default Column Month
int im = 1;
do
{
DateTime dTemp = new DateTime(2018, im, 1);
dgvData.Columns.Insert(5 + im - 1, new GridViewDecimalColumn
{
Name = dTemp.ToString("MMM"),
FieldName = dTemp.ToString("MMM"),
HeaderText = dTemp.ToString("MMM"),
FormatString = "{0:N2}",
TextAlignment = ContentAlignment.MiddleRight,
Width = 80,
});
var sum1 = new GridViewSummaryItem(dTemp.ToString("MMM"), "{0:N2}", GridAggregateFunction.Sum);
sumaryRow.Add(sum1);
im++;
} while (im <= 12);
}
}
private void AddSummaries()
{
this.grdLister.MasterGridViewTemplate.SummaryRowsBottom.Clear();
GridViewSummaryRowItem item2 = new GridViewSummaryRowItem();
GridViewSummaryItem c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.None;
c.Name = "DriverNo";
c.AggregateExpression = "SUM(Rent)";
c.FormatString = "Total";
item2.Add(c);
// item2.Add(new GridViewSummaryItem("DriverNo", "Total", GridAggregateFunction.None));
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(" + COLS.PaidRent + ")";
c.Name = COLS.Rent;
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(" + COLS.PaidPreviousBalance + ")";
c.Name = COLS.PreviousBalance;
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(" + COLS.PaidCollection + ")";
c.Name = COLS.Collection;
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(" + COLS.OldPaidCollection + ")";
c.Name = COLS.OldCollection;
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(" + COLS.PaidAgentCommission + ")";
c.Name = COLS.AgentCommission;
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(" + COLS.PaidOldAgentBalance + ")";
c.Name = COLS.OldAgentBalance;
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(" + COLS.PaidAdjustment + ")";
c.Name = COLS.Adjustment;
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(" + COLS.OldPaidAdjustment + ")";
c.Name = COLS.OldAdjustment;
c.FormatString = "{0}";
item2.Add(c);
c = new GridViewSummaryItem();
c.Aggregate = GridAggregateFunction.Sum;
c.AggregateExpression = "SUM(" + COLS.PaidTotal + ")";
c.Name = COLS.Total;
c.FormatString = "{0}";
item2.Add(c);
//item2.Add(new GridViewSummaryItem("Rent", "{0}", GridAggregateFunction.Sum));
//item2.Add(new GridViewSummaryItem("Collection", "{0}", GridAggregateFunction.Sum));
//item2.Add(new GridViewSummaryItem("AgentCommission", "{0}", GridAggregateFunction.Sum));
//item2.Add(new GridViewSummaryItem("OldAgentBalance", "{0}", GridAggregateFunction.Sum));
// item2.Add(new GridViewSummaryItem(COLS.Adjustment, "{0}", GridAggregateFunction.Sum));
//// item2.Add(new GridViewSummaryItem(COLS.PreviousBalance, "{0}", GridAggregateFunction.Sum));
// item2.Add(new GridViewSummaryItem("Total", "{0}", GridAggregateFunction.Sum));
this.grdLister.MasterGridViewTemplate.SummaryRowsBottom.Add(item2);
this.grdLister.MasterView.SummaryRows[0].PinPosition = PinnedRowPosition.Bottom;
}
private void RefreshAll()
{
this.radGridView1.SummaryRowsBottom.Clear();
// TODO: This line of code loads data into the 'sinarekDataSet.vbotolkotor' table. You can move, or remove it, as needed.
this.vbotolkotorTableAdapter.FillByTanggal(this.sinarekDataSet.vbotolkotor, dtpTanggal.Value);
sinarekDataSet.vbotolkotorDataTable tbl = new sinarekDataSet.vbotolkotorDataTable();
this.vbotolkotorTableAdapter.FillByTipeTanggal(tbl, dtpTanggal.Value, "AWAL");
radGridView2.DataSource = tbl;
if (radGridView2.Rows.Count == 1 && radGridView1.Rows.Count > 0)
{
string K100, K99, K98, K16, BTL, Total;
K100 = radGridView2.Rows[0].Cells["K100"].Value.ToString();
K99 = radGridView2.Rows[0].Cells["K99"].Value.ToString();
K98 = radGridView2.Rows[0].Cells["K98"].Value.ToString();
K16 = radGridView2.Rows[0].Cells["K16"].Value.ToString();
BTL = radGridView2.Rows[0].Cells["BTL"].Value.ToString();
Total = radGridView2.Rows[0].Cells["Total"].Value.ToString();
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
GridViewSummaryItem summaryItem = new GridViewSummaryItem();
summaryItem.Name = "K100";
summaryItem.FormatString = "{0:#,###}";
summaryItem.AggregateExpression = K100.ToString() + " + Sum(K100)";
summaryRowItem.Add(summaryItem);
GridViewSummaryItem summaryItem2 = new GridViewSummaryItem();
summaryItem2.Name = "K98";
summaryItem2.FormatString = "{0:#,###}";
summaryItem2.AggregateExpression = K98.ToString() + " + Sum(K99) + Sum(K98)";
summaryRowItem.Add(summaryItem2);
GridViewSummaryItem summaryItem9 = new GridViewSummaryItem();
summaryItem9.Name = "K16";
summaryItem9.FormatString = "{0:#,###}";
summaryItem9.AggregateExpression = "(" + K16 + "*16) + " + " Sum(K16*16) + Sum(BTL) + " + BTL;
summaryRowItem.Add(summaryItem9);
GridViewSummaryItem summaryItem4 = new GridViewSummaryItem();
summaryItem4.Name = "BTL";
summaryItem4.AggregateExpression = "0";
summaryRowItem.Add(summaryItem4);
GridViewSummaryItem summaryItem5 = new GridViewSummaryItem();
summaryItem5.Name = "NoSJ";
summaryItem5.Aggregate = GridAggregateFunction.Last;
summaryItem5.FormatString = "AKHIR";
summaryRowItem.Add(summaryItem5);
GridViewSummaryItem summaryItem8 = new GridViewSummaryItem();
summaryItem8.Name = "Total";
summaryItem8.Aggregate = GridAggregateFunction.Sum;
summaryItem8.FormatString = "{0:#,###}";
summaryRowItem.Add(summaryItem8);
this.radGridView1.SummaryRowsBottom.Add(summaryRowItem);
int val = 0
, div = 0
, rem = 0;
try
{
GridViewSummaryItem summaryItem3 = radGridView1.SummaryRowsBottom[0][2];
string value = summaryItem3.Evaluate(radGridView1.MasterTemplate).ToString();
val = int.Parse(value.Split('.')[0]);
div = Math.DivRem(val, 16, out rem);
summaryItem3.AggregateExpression = div.ToString();
summaryItem4.AggregateExpression = rem.ToString();
}
catch (Exception ex)
{
RadMessageBox.Show(ex.Message + " : " + ex.StackTrace, "SMS - Error");
}
GridViewSummaryRowItem summaryRowItem2 = new GridViewSummaryRowItem();
GridViewSummaryItem summaryItem6 = new GridViewSummaryItem();
summaryItem6.Name = "K100";
summaryItem6.AggregateExpression = Total + " + ((Sum(K100)*100)"
+ " + ((Sum(K99) + Sum(K98))* 98)"
+ " + (Sum(K16)*16)"
+ " + Sum(BTL))";
summaryItem6.FormatString = "{0:#,###}";
summaryRowItem2.Add(summaryItem6);
GridViewSummaryItem summaryItem7 = new GridViewSummaryItem();
summaryItem7.Name = "NoSJ";
summaryItem7.Aggregate = GridAggregateFunction.Last;
summaryItem7.FormatString = "TOTAL BTL :";
summaryRowItem2.Add(summaryItem7);
this.radGridView1.SummaryRowsBottom.Add(summaryRowItem2);
}
}
private void btnRunReport_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection("Data Source=hermes\\Routematch60;Initial Catalog=RM_MN_AEOA;Integrated Security=True");
con.Open();
SqlCommand myCmd = new SqlCommand("AEOA_UltraReport2", con);
//SqlCommand myCmd = new SqlCommand("AEOA_HourlyNSE2", con);
myCmd.CommandTimeout = 45;
myCmd.CommandType = CommandType.StoredProcedure;
myCmd.Parameters.AddWithValue("@ReportStartDateTime", dtpStartDate.Value);
myCmd.Parameters.AddWithValue("@ReportEndDateTime", dtpEndDate.Value);
myCmd.Parameters.AddWithValue("@areaname", cbArea.Text);
myCmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(myCmd);
da.Fill(dt);
gridMain.DataSource = dt;
gridMain.MasterTemplate.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;
GridViewSummaryItem summaryPointsItem = new GridViewSummaryItem();
summaryPointsItem.Name = "Points";
summaryPointsItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryTotalMilesItem = new GridViewSummaryItem();
summaryTotalMilesItem.Name = "Total Miles";
summaryTotalMilesItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryAdultItem = new GridViewSummaryItem();
summaryAdultItem.Name = "Adult";
summaryAdultItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryElderlyItem = new GridViewSummaryItem();
summaryElderlyItem.Name = "Elderly";
summaryElderlyItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryChildItem = new GridViewSummaryItem();
summaryChildItem.Name = "Child";
summaryChildItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryDisabledItem = new GridViewSummaryItem();
summaryDisabledItem.Name = "Disabled";
summaryDisabledItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryNonAmbItem = new GridViewSummaryItem();
summaryNonAmbItem.Name = "NonAmb";
summaryNonAmbItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryStudentItem = new GridViewSummaryItem();
summaryStudentItem.Name = "Student";
summaryStudentItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryTotalPassengersItem = new GridViewSummaryItem();
summaryTotalPassengersItem.Name = "Total Passengers";
summaryTotalPassengersItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryCashItem = new GridViewSummaryItem();
summaryCashItem.Name = "People that paid cash";
summaryCashItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryPassItem = new GridViewSummaryItem();
summaryPassItem.Name = "Pass";
summaryPassItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryTicketItem = new GridViewSummaryItem();
summaryTicketItem.Name = "Ticket";
summaryTicketItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryItem summaryFreeItem = new GridViewSummaryItem();
summaryFreeItem.Name = "Free";
summaryFreeItem.Aggregate = GridAggregateFunction.Sum;
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
summaryRowItem.Add(summaryPointsItem);
summaryRowItem.Add(summaryTotalMilesItem);
summaryRowItem.Add(summaryAdultItem);
summaryRowItem.Add(summaryElderlyItem);
summaryRowItem.Add(summaryChildItem);
summaryRowItem.Add(summaryDisabledItem);
summaryRowItem.Add(summaryNonAmbItem);
summaryRowItem.Add(summaryStudentItem);
summaryRowItem.Add(summaryTotalPassengersItem);
summaryRowItem.Add(summaryCashItem);
summaryRowItem.Add(summaryPassItem);
summaryRowItem.Add(summaryTicketItem);
summaryRowItem.Add(summaryFreeItem);
gridMain.SummaryRowsTop.Add(summaryRowItem);
}
private void InitializeGrid()
{
///<summary>
///Инициализирует поля сетки.
///Если коллекция операций в экземпляре формы не инициализированна - действия не происходят.
/// </summary>
if (this.Summaries == null)
{
return;
}
this.radGridView.DataSource = this.Summaries;
this.radGridView.Columns["Id"].IsVisible = false;
this.radGridView.Columns["RowVersion"].IsVisible = false;
this.radGridView.Columns["ActionDate"].IsVisible = false;
this.radGridView.Columns["CurrentRateUSD"].IsVisible = false;
this.radGridView.Columns["CurrentEuroToDollarRate"].IsVisible = false;
this.radGridView.Columns["UserLastChanged"].IsVisible = false;
this.radGridView.Columns["ReadOnly"].IsVisible = false;
//Упорядчивание столбцов
this.radGridView.Columns.Move(this.radGridView.Columns["SummaryDate"].Index, 0);
this.radGridView.Columns.Move(this.radGridView.Columns["CashFlowType"].Index, 1);
this.radGridView.Columns.Move(this.radGridView.Columns["Project"].Index, 2);
this.radGridView.Columns.Move(this.radGridView.Columns["Accountable"].Index, 3);
this.radGridView.Columns.Move(this.radGridView.Columns["BudgetItem"].Index, 4);
this.radGridView.Columns.Move(this.radGridView.Columns["SummaUAH"].Index, 5);
this.radGridView.Columns.Move(this.radGridView.Columns["SummaUSD"].Index, 6);
this.radGridView.Columns.Move(this.radGridView.Columns["SummaEuro"].Index, 7);
this.radGridView.Columns.Move(this.radGridView.Columns["TotalSumma"].Index, 8);
this.radGridView.Columns.Move(this.radGridView.Columns["Description"].Index, 9);
//Настройка данных столбцов
//Явное указание свойства привязки. Необходимо для корректной работы сортировки и группировки ассоциированных обьктов.
this.radGridView.Columns["Accountable"].HeaderText = "Подотчетник";
this.radGridView.Columns["Accountable"].FieldName = "Accountable.AccountableName";
this.radGridView.Columns["BudgetItem"].HeaderText = "Статья";
this.radGridView.Columns["BudgetItem"].FieldName = "BudgetItem.ItemName";
this.radGridView.Columns["CashFlowType"].HeaderText = "Приход/Расход";
this.radGridView.Columns["Description"].HeaderText = "Расшифровка";
this.radGridView.Columns["Project"].HeaderText = "Проект";
this.radGridView.Columns["Project"].FieldName = "Project.ProjectName";
this.radGridView.Columns["ReadOnly"].HeaderText = "Только чтение";
this.radGridView.Columns["SummaUAH"].HeaderText = "Сумма, грн.";
this.radGridView.Columns["SummaUAH"].FormatString = "{0:C}";
this.radGridView.Columns["SummaUSD"].FormatInfo = CultureInfo.CreateSpecificCulture("uk-UA");
this.radGridView.Columns["SummaUSD"].HeaderText = "Сумма, $";
this.radGridView.Columns["SummaUSD"].FormatString = "{0:C}";
this.radGridView.Columns["SummaUSD"].FormatInfo = CultureInfo.CreateSpecificCulture("en-US");
this.radGridView.Columns["SummaEuro"].HeaderText = "Сумма, ЕВРО";
this.radGridView.Columns["SummaEuro"].FormatString = "{0:C}";
this.radGridView.Columns["SummaEuro"].FormatInfo = CultureInfo.CreateSpecificCulture("fr-FR");
this.radGridView.Columns["TotalSumma"].HeaderText = "Итого, $";
this.radGridView.Columns["TotalSumma"].FormatString = "{0:C}";
this.radGridView.Columns["TotalSumma"].FormatInfo = CultureInfo.CreateSpecificCulture("en-US");
this.radGridView.Columns["SummaryDate"].HeaderText = "Дата";
this.radGridView.Columns["SummaryDate"].FormatString = "{0:d}";
this.radGridView.Columns["SummaryDate"].TextAlignment = ContentAlignment.MiddleRight;
//Добавление итогов
this.radGridView.MasterTemplate.ShowTotals = true;
GridViewSummaryItem summaryItemCount = new GridViewSummaryItem();
summaryItemCount.Name = "SummaryDate";
summaryItemCount.Aggregate = GridAggregateFunction.Count;
summaryItemCount.FormatString = "Итог, количество = {0}";
GridViewSummaryItem summaryItemUAH = new GridViewSummaryItem();
summaryItemUAH.Name = "SummaUAH";
summaryItemUAH.Aggregate = GridAggregateFunction.Sum;
summaryItemUAH.FormatString = "Итог, грн. = {0:N2} грн.";
GridViewSummaryItem summaryItemUSD = new GridViewSummaryItem();
summaryItemUSD.Name = "SummaUSD";
summaryItemUSD.Aggregate = GridAggregateFunction.Sum;
summaryItemUSD.FormatString = "Итог, $ = ${0:N2}";
GridViewSummaryItem summaryItemEuro = new GridViewSummaryItem();
summaryItemEuro.Name = "SummaEuro";
summaryItemEuro.Aggregate = GridAggregateFunction.Sum;
summaryItemEuro.FormatString = "Итог, ЕВРО = {0:N2} EUR";
GridViewSummaryItem summaryItemTotal = new GridViewSummaryItem();
summaryItemTotal.Name = "TotalSumma";
summaryItemTotal.Aggregate = GridAggregateFunction.Sum;
summaryItemTotal.FormatString = "Итог, $ = ${0:N2}";
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
summaryRowItem.Add(summaryItemCount);
summaryRowItem.Add(summaryItemUAH);
summaryRowItem.Add(summaryItemUSD);
summaryRowItem.Add(summaryItemEuro);
summaryRowItem.Add(summaryItemTotal);
if (this.radGridView.SummaryRowsTop != null && this.radGridView.SummaryRowsTop.Count > 0)
{
this.radGridView.SummaryRowsTop.Clear();
}
this.radGridView.SummaryRowsTop.Add(summaryRowItem);
}
