private void gridView1_CustomDrawFooterCell(object sender, DevExpress.XtraGrid.Views.Grid.FooterCellCustomDrawEventArgs e)
{
GridSummaryItem summary = e.Info.SummaryItem;
// Obtain the total summary's value.
txtTongTienPhong.EditValue = TongTienGio + Convert.ToDouble(summary.SummaryValue);
}
private void WaybillDetOutGridView_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
if (e.SummaryProcess == CustomSummaryProcess.Finalize)
{
var def_m = DBHelper.MeasuresList.FirstOrDefault(w => w.Def == 1);
GridSummaryItem item = e.Item as GridSummaryItem;
if (item.FieldName == "MsrName")
{
e.TotalValue = def_m.ShortName;
}
if (item.FieldName == "Amount")
{
var amount_sum = _db.WaybillDet.Where(w => w.WbillId == _wbill_id && w.Materials.MId == def_m.MId).ToList().Sum(s => s.Amount);
var ext_sum = _db.WaybillDet.Where(w => w.WbillId == _wbill_id && w.Materials.MId != def_m.MId)
.Select(s => new { MaterialMeasures = s.Materials.MaterialMeasures.Where(f => f.MId == def_m.MId), s.Amount }).ToList()
.SelectMany(sm => sm.MaterialMeasures, (k, n) => new { k.Amount, MeasureAmount = n.Amount }).Sum(su => su.MeasureAmount * su.Amount);
e.TotalValue = Math.Round(amount_sum + ext_sum, 2);
}
}
}
static void BuildSummaryTemplate(SnapDocument template, TableCell box, GridSummaryItem source, SummaryRunning running)
{
MatchCollection formatFields = formatFinder.Matches(source.DisplayFormat);
int k = 0;
template.InsertText(box.ContentRange.End, " ");
foreach (System.Text.RegularExpressions.Match match in formatFields)
{
template.InsertText(box.ContentRange.End, source.DisplayFormat.Substring(k, match.Groups[1].Index - k));
k = match.Groups[1].Index + match.Groups[1].Length;
SnapText snText = template.CreateSnText(box.ContentRange.End, source.FieldName);
snText.BeginUpdate();
snText.SummaryRunning = running;
snText.SummaryFunc = source.SummaryType;
string format = match.Groups[2].Value;
if (!String.IsNullOrEmpty(format))
{
if (format.EndsWith("C", StringComparison.InvariantCultureIgnoreCase))
{
snText.FormatString = @"$0.00";
}
}
snText.EndUpdate();
}
template.InsertText(box.ContentRange.End, source.DisplayFormat.Substring(k));
}
private async void LoadTransactions()
{
var store = await _storeManager.GetById(StoreId);
if (store != null)
{
var user = _userManager.GetByID(store.UserID);
lblStoreUser.Text = $@"Store user: { user.FirstName } {user.LastName }";
lblStoreDate.Text = $@"{Convert.ToDateTime(store.DateOpen).ToString("MMM. dd, yyyy hh:mm tt")}";
_transactions = await _saleManager.GetTransactionsByStoreID(StoreId);
gridControl1.DataSource = null;
foreach (GridColumn column in gridView1.Columns)
{
GridSummaryItem item = column.SummaryItem;
if (item != null)
{
column.Summary.Remove(item);
}
}
if (_transactions.Any())
{
var source = _transactions.Select(m => new GridItem()
{
Items = m.Items,
GrossSales = m.Total,
NetSales = m.Net,
AmountPaid = m.AmountPaid,
Change = m.Change,
Date = m.DateTime,
Id = m.SaleID,
Time = m.DateTime
});
gridControl1.DataSource = source;
GridColumnSummaryItem item1 = new GridColumnSummaryItem(SummaryItemType.Sum, "GrossSales", "{0:N}");
GridColumnSummaryItem item2 = new GridColumnSummaryItem(SummaryItemType.Sum, "NetSales", "{0:N}");
gridView1.Columns["GrossSales"].Summary.Add(item1);
gridView1.Columns["NetSales"].Summary.Add(item2);
}
//foreach (SaleDTO transaction in _transactions)
//{
// ListViewItem lvi = new ListViewItem(transaction.SaleID.ToString());
// lvi.SubItems.Add(transaction.DateStr);
// lvi.SubItems.Add(transaction.TimeStr);
// lvi.SubItems.Add(transaction.Items);
// lvi.SubItems.Add(transaction.Total.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(transaction.Net.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(transaction.AmountPaid.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(transaction.Change.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add($@"{ transaction.Firstname } { transaction.Lastname }");
// lvwSales.Items.Add(lvi);
// _net += transaction.Net;
// _gross += transaction.Total;
//}
}
}
private async void PopulateListview(string search = "")
{
var items = await _storeManager.GetStoreProductsByStoreID(Global.Store.StoreID);
gridControl1.DataSource = null;
foreach (GridColumn column in gridView1.Columns)
{
GridSummaryItem item = column.SummaryItem;
if (item != null)
{
column.Summary.Remove(item);
}
}
if (items.Any())
{
var source = items.Select(m => new FrmStoreGridItem
{
Quantity = m.Quantity,
Name = m.Name,
Id = m.StoreProductID,
Left = m.UnitsLeft,
Price = m.SalesPrice,
Sold = m.UnitsSold,
TotalPriceLeft = m.TotalPriceLeft,
TotalPriceSold = m.TotalPriceSold
});
gridControl1.DataSource = source;
GridColumnSummaryItem item3 = new GridColumnSummaryItem(SummaryItemType.Sum, "TotalPriceSold", "{0:N}");
GridColumnSummaryItem item5 = new GridColumnSummaryItem(SummaryItemType.Sum, "TotalPriceLeft", "{0:N}");
gridView1.Columns["TotalPriceSold"].Summary.Add(item3);
gridView1.Columns["TotalPriceLeft"].Summary.Add(item5);
}
//if (!string.IsNullOrWhiteSpace(search))
//{
// items.RemoveAll(m => !m.Name.ToLower().Contains(search.ToLower()));
//}
//listView1.Items.Clear();
//if (items.Any())
//{
// foreach(var item in items)
// {
// var lvi = new ListViewItem(item.StoreProductID.ToString());
// lvi.SubItems.Add(item.Name);
// lvi.SubItems.Add(item.Code);
// lvi.SubItems.Add(item.SalesPrice.ToString("C2").Replace("$",""));
// lvi.SubItems.Add(item.Quantity.ToString());
// lvi.SubItems.Add(item.UnitsSold.ToString());
// lvi.SubItems.Add(item.TotalPriceSold.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(item.UnitsLeft.ToString());
// lvi.SubItems.Add(item.TotalPriceLeft.ToString("C2").Replace("$", ""));
// listView1.Items.Add(lvi);
// }
//}
}
private void Form1_Load(object sender, System.EventArgs e)
{
gridControl1.DataSource = CreateTable(10);
gridView1.Columns.AddField("Dummy");
gridView1.Columns["Dummy"].UnboundType = DevExpress.Data.UnboundColumnType.Integer;
GridSummaryItem si = new GridSummaryItem(DevExpress.Data.SummaryItemType.Average, "CategoryID", "");
gridView1.Columns["Dummy"].SummaryItem.Assign(si);
gridView1.Columns["Dummy"].Visible = false;
}
private async void PopulateListView(string search = "")
{
var items = await _productManager.GetProductsByStoreID(StoreID);
gridControl1.DataSource = null;
foreach (GridColumn column in gridView1.Columns)
{
GridSummaryItem item = column.SummaryItem;
if (item != null)
{
column.Summary.Remove(item);
}
}
if (items.Any())
{
var source = items.Select(m => new FrmProductGridItem
{
Category = m.Category,
Id = m.ProductID,
Name = m.Name,
Cost = m.Cost,
AvailableStock = m.AvailableStock,
Price = m.SalesPrice,
Brand = m.Brand,
InStore = m.InStore,
TotalQuantity = m.TotalQuantity
});
gridControl1.DataSource = source;
//GridColumnSummaryItem item3 = new GridColumnSummaryItem(SummaryItemType.Sum, "Price", "{0:N}");
//GridColumnSummaryItem item5 = new GridColumnSummaryItem(SummaryItemType.Sum, "Cost", "{0:N}");
//gridView1.Columns["Price"].Summary.Add(item3);
//gridView1.Columns["Cost"].Summary.Add(item5);
}
//if (!string.IsNullOrWhiteSpace(search))
// items.RemoveAll(m => !m.Name.ToLower().Contains(search.ToLower()));
//listView1.Items.Clear();
//foreach (var item in items)
//{
// ListViewItem lvi = new ListViewItem(item.ProductID.ToString());
// lvi.SubItems.Add(item.Name);
// lvi.SubItems.Add(item.Code);
// lvi.SubItems.Add(item.AvailableStock.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(item.InStore.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(item.TotalQuantity.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(item.SalesPrice.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(item.Cost.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(item.Category);
// lvi.SubItems.Add(item.Brand);
// listView1.Items.Add(lvi);
//}
}
private void KAgentAdjustmentDetGridView_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
if (e.SummaryProcess == CustomSummaryProcess.Finalize)
{
GridSummaryItem item = e.Item as GridSummaryItem;
if (item.FieldName == "Saldo")
{
e.TotalValue = e.FieldValue;
}
}
}
private void carga_dato()
{
dtfull.Clear();
con.conectar("EX");
SqlCommand cmd2 = new SqlCommand();
cmd2 = new SqlCommand("[dismo].[FILL_RATE]", con.conex);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@fechaini", datePickerini.Value.ToString("yyyy/MM/dd"));
cmd2.Parameters.AddWithValue("@fechafin", datePickerfin.Value.ToString("yyyy/MM/dd"));
cmd2.Parameters.AddWithValue("@empresa", empresa);
SqlDataAdapter da1 = new SqlDataAdapter(cmd2);
da1.Fill(dtfull);
con.Desconectar("EX");
gridControl1.Refresh();
gridControl1.DataSource = dtfull;
total_arti = gridView1.GroupSummary.Add(SummaryItemType.Sum, "UNIDADES PEDIDAS", null, "Total Unidades ={0:N2}");
total_valor = gridView1.GroupSummary.Add(SummaryItemType.Sum, "VALOR PEDIDO", null, "Total Valor ={0:c2}");
Total_peso = gridView1.GroupSummary.Add(SummaryItemType.Sum, "PESO_BRUTO", null, "Total Peso ={0:N2}");
Total_volume = gridView1.GroupSummary.Add(SummaryItemType.Sum, "VOLUMEN", null, "Total Volume ={0:N2}");
//gridView1.Columns["VALOR PEDIDO"].Summary.Add(DevExpress.Data.SummaryItemType.Average, "VALOR PEDIDO", "Avg={0:n2}");
//gridView1.Columns["VALOR PEDIDO"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "VALOR PEDIDO", "Sum={0}");
//GridColumnSummaryItem item = new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Max, "VALOR PEDIDO", "Max={0}");
//gridView1.Columns["VALOR PEDIDO"].Summary.Add(item);
//gridView1.Columns["UNIDADES PEDIDAS"].Summary.Add(DevExpress.Data.SummaryItemType.Average, "UNIDADES PEDIDAS", "Avg={0:n2}");
//gridView1.Columns["UNIDADES PEDIDAS"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "UNIDADES PEDIDAS", "Sum={0}");
//GridColumnSummaryItem item2 = new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Max, "UNIDADES PEDIDAS", "Max={0}");
//gridView1.Columns["UNIDADES PEDIDAS"].Summary.Add(item2);
//gridView1.Columns["PESO_BRUTO"].Summary.Add(DevExpress.Data.SummaryItemType.Average, "PESO_BRUTO", "Avg={0:n2}");
//gridView1.Columns["PESO_BRUTO"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "PESO_BRUTO", "Sum={0}");
//GridColumnSummaryItem item3 = new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Max, "PESO_BRUTO", "Max={0}");
//gridView1.Columns["PESO_BRUTO"].Summary.Add(item3);
//gridView1.Columns["VOLUMEN"].Summary.Add(DevExpress.Data.SummaryItemType.Average, "VOLUMEN", "Avg={0:n2}");
//gridView1.Columns["VOLUMEN"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "VOLUMEN", "Sum={0}");
//GridColumnSummaryItem item4 = new GridColumn SummaryItem(DevExpress.Data.SummaryItemType.Max, "VOLUMEN", "Max={0}");
//gridView1.Columns["VOLUMEN"].Summary.Add(item4);
groupControl1.Text = "Fillaje & Capacidades";
barStaticItem1.Caption = Convert.ToString(gridView1.RowCount) + " Registros";
}
private void GridView_AttendanceData_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
GridView view = sender as GridView;
if (e.IsTotalSummary && (e.Item as GridSummaryItem).FieldName == "OverTime")
{
GridSummaryItem item = e.Item as GridSummaryItem;
if (item.FieldName == "OverTime")
{
e.TotalValue = ConvertTo.MinutesToHours(view.Columns["OverTime_1"].SummaryText);
}
}
}
private void GridView_SalaryProcess_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
GridView view = sender as GridView;
if (e.IsTotalSummary && (e.Item as GridSummaryItem).FieldName == "EmpSalary")
{
GridSummaryItem item = e.Item as GridSummaryItem;
if (item.FieldName == "EmpSalary")
{
//e.TotalValue = ConvertTo.MinutesToHours(view.Columns["EmpSalary"].SummaryText);
}
}
}
public void GroupSummaryAdd(GridSummaryItem item)
{
switch (GridViewType)
{
case GridViewType.GridView:
case GridViewType.BandedGridView:
case GridViewType.AdvBandedGridView:
((GridView)MainView).GroupSummary.Add(item);
break;
default:
break;
}
}
private void WhMatGridView_CustomSummaryCalculate(object sender, CustomSummaryEventArgs e)
{
if (e.SummaryProcess == CustomSummaryProcess.Finalize && wh_mat_list != null)
{
var def_m = DBHelper.MeasuresList.FirstOrDefault(w => w.Def == 1);
GridSummaryItem item = e.Item as GridSummaryItem;
if (item.FieldName == "Remain")
{
var amount_sum = wh_mat_list.Where(w => w.MId == def_m.MId).Sum(s => s.Remain ?? 0);
/* var ext_sum = _db.WaybillDet.Where(w => w.WbillId == _wbill_id && w.Materials.MId != def_m.MId)
* .Select(s => new { MaterialMeasures = s.Materials.MaterialMeasures.Where(f => f.MId == def_m.MId), s.Amount }).ToList()
* .SelectMany(sm => sm.MaterialMeasures, (k, n) => new { k.Amount, MeasureAmount = n.Amount }).Sum(su => su.MeasureAmount * su.Amount);*/
e.TotalValue = amount_sum.ToString() + " " + def_m.ShortName;//Math.Round(amount_sum + ext_sum, 2);
}
}
}
string GetToolTipText(GridColumn column)
{
string text = "";
if (column == null)
{
return(text);
}
Hashtable summaryValues = view.GetGroupSummaryValues(hitInfo.RowHandle);
foreach (DictionaryEntry itemObject in summaryValues)
{
GridSummaryItem item = itemObject.Key as GridSummaryItem;
if (item.FieldName == column.FieldName)
{
text = item.GetDisplayText(summaryValues[item], false);
break;
}
}
return(text);
}
private async void GetStoresByDateRange()
{
stores = await _storeManager.GetStoresByDateRange(this.dateFrom, this.dateTo);
selectedStoreId = 0;
gridControl1.DataSource = null;
foreach (GridColumn column in gridView1.Columns)
{
GridSummaryItem item = column.SummaryItem;
if (item != null)
{
column.Summary.Remove(item);
}
}
if (stores.Any())
{
var source = stores.Select(m => new BrowseStoreGridItem
{
StoreId = m.StoreId,
User = m.Firstname + " " + m.Lastname,
NetSales = m.NetSales,
GrossSales = m.TotalSales,
DateOpened = m.DateOpen
});
gridControl1.DataSource = source;
GridColumnSummaryItem item1 = new GridColumnSummaryItem(SummaryItemType.Sum, "GrossSales", "{0:N}");
gridView1.Columns["GrossSales"].Summary.Add(item1);
GridColumnSummaryItem item2 = new GridColumnSummaryItem(SummaryItemType.Sum, "NetSales", "{0:N}");
gridView1.Columns["NetSales"].Summary.Add(item2);
}
//foreach (var store in stores)
//{
// ListViewItem lvi = new ListViewItem(store.StoreId.ToString());
// lvi.SubItems.Add(store.DateOpen.ToString("MMM. dd hh:mm tt"));
// lvi.SubItems.Add(store.Firstname + " " + store.Lastname);
// lvi.SubItems.Add($@"{ store.TotalSales.ToString("C2").Replace("$", "") }");
// lvi.SubItems.Add($@"{ store.NetSales.ToString("C2").Replace("$", "") }");
// lvwStores.Items.Add(lvi);
//}
}
static void OnGridControlStartSorting(object sender, RoutedEventArgs e)
{
GridControl Grid = (GridControl)sender;
if (!GetSortGroupSummaryWithColumn(Grid) ||
GetAlreadyHandled(Grid))
{
return;
}
SetAlreadyHandled(Grid, true);
foreach (GridSortInfo sortInfo in Grid.SortInfo)
{
GridSummaryItem summaryItem = FindGridSummaryItem(Grid, sortInfo.FieldName);
if (summaryItem != null)
{
ArrayList groupedColumns = GetGroupedColumns(Grid);
ArrayList newSortInfoList = new ArrayList();
foreach (GridColumn col in groupedColumns)
{
GridGroupSummarySortInfo groupSummaryInfo = FindGridGroupSummarySortInfo(Grid, summaryItem.FieldName);
if (groupSummaryInfo != null &&
groupSummaryInfo.SortOrder == sortInfo.SortOrder)
{
continue;
}
GridGroupSummarySortInfo newSortInfo = new GridGroupSummarySortInfo(summaryItem,
col.FieldName,
sortInfo.SortOrder);
newSortInfoList.Add(newSortInfo);
e.Handled = true;
}
Grid.GroupSummarySortInfo.AddRange((GridGroupSummarySortInfo[])newSortInfoList.ToArray(typeof(GridGroupSummarySortInfo)));
continue;
}
}
SetAlreadyHandled(Grid, false);
}
public static GridColumn GetColumn(
string fieldName,
string caption,
int width,
bool isAllowEdit = true,
bool fixedWidth = true,
RepositoryItem itemCtrl = null,
GridSummaryItem summaryItem = null)
{
GridColumn col = new GridColumn
{
Caption = caption,
Name = fieldName,
FieldName = fieldName,
Visible = true,
Width = width
};
col.OptionsColumn.AllowEdit = isAllowEdit;
col.AppearanceHeader.Options.UseTextOptions = true;
col.AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
col.OptionsColumn.FixedWidth = fixedWidth;
if (itemCtrl != null)
{
col.ColumnEdit = itemCtrl;
}
// Add Summary Item
if (summaryItem != null)
{
col.Summary.Add(summaryItem);
}
return(col);
}
private void gvDetallePedido_CustomDrawFooterCell(object sender, FooterCellCustomDrawEventArgs e)
{
GridSummaryItem summary = e.Info.SummaryItem;
// Obtain the total summary's value.
switch (summary.FieldName)
{
case "Subtotal":
txtSubtotal.Text = summary.SummaryValue.ToString();
break;
case "Total":
txtTotal.Text = summary.SummaryValue.ToString();
break;
case "IVA":
txtIVA.Text = summary.SummaryValue.ToString();
break;
case "IEPS":
txtIEPS.Text = summary.SummaryValue.ToString();
break;
}
}
public Collection <GridSummaryItem> GetGridSummary()
{
var gridSummary = SqlServer.GetGridSummary();
var areaLayerSummary = SqlServer.GetAreaLayerSummary();
var gridSummaryItems = new Collection <GridSummaryItem>();
foreach (var gridItem in gridSummary)
{
var gridSummaryItem = new GridSummaryItem(gridItem.Item1);
foreach (var gridLayerItem in gridItem.Item2)
{
var ninCode = Naturkodetrær.Naturvariasjon.HentFraKode(gridLayerItem.Code.Value);
var gridLayerSummaryItem = new GridLayerSummaryItem
{
Id = gridLayerItem.Id,
DocGuid = gridLayerItem.DocGuid,
Name = gridLayerItem.Name,
Description = gridLayerItem.Description,
Established = gridLayerItem.Established,
MinValue = gridLayerItem.MinValue,
MaxValue = gridLayerItem.MaxValue,
Code = gridLayerItem.Code.Value
};
if (ninCode != null)
{
gridLayerSummaryItem.CodeDescription = ninCode.Name;
gridLayerSummaryItem.CodeUrl = ninCode.Url;
}
gridLayerSummaryItem.Owner = gridLayerItem.Owner;
gridLayerSummaryItem.Documents = gridLayerItem.Documents;
gridSummaryItem.GridLayers.Add(gridLayerSummaryItem);
}
gridSummaryItems.Add(gridSummaryItem);
}
foreach (var areaItem in areaLayerSummary)
{
var areaSummaryItem = new GridSummaryItem(areaItem.Item1);
foreach (var areaLayerItem in areaItem.Item2)
{
var ninCode = Naturkodetrær.Naturvariasjon.HentFraKode(areaLayerItem.Code.Value);
var areaLayerSummaryItem = new GridLayerSummaryItem
{
Id = areaLayerItem.Id,
DocGuid = areaLayerItem.DocGuid,
Name = areaLayerItem.Name,
Description = areaLayerItem.Description,
Established = areaLayerItem.Established,
MinValue = areaLayerItem.MinValue,
MaxValue = areaLayerItem.MaxValue,
Code = areaLayerItem.Code.Value
};
if (ninCode != null)
{
areaLayerSummaryItem.CodeDescription = ninCode.Name;
areaLayerSummaryItem.CodeUrl = ninCode.Url;
}
areaLayerSummaryItem.Owner = areaLayerItem.Owner;
areaLayerSummaryItem.Documents = areaLayerItem.Documents;
areaSummaryItem.GridLayers.Add(areaLayerSummaryItem);
}
gridSummaryItems.Add(areaSummaryItem);
}
return(gridSummaryItems);
}
private void BuscarRomaneo()
{
CooperativaProduccionEntities Context = new CooperativaProduccionEntities();
Expression <Func <Vw_Romaneo, bool> > pred = x => true;
pred = pred.And(x => x.FechaRomaneo >= dpDesdeRomaneo.Value.Date &&
x.FechaRomaneo <= dpHastaRomaneo.Value.Date);
pred = !string.IsNullOrEmpty(txtFet.Text) ? pred.And(x => x.ProductorId == ProductorId) : pred;
pred = !string.IsNullOrEmpty(cbTabaco.Text) ? pred.And(x => x.Tabaco == cbTabaco.Text) : pred;
var result =
(from a in Context.Vw_Romaneo
.Where(pred)
select new
{
ID = a.PesadaId,
FECHA = a.FechaRomaneo,
NUMROMANEO = a.NumRomaneo,
PRODUCTOR = a.NOMBRE,
CUIT = a.CUIT,
FET = a.nrofet,
PROVINCIA = a.Provincia,
KILOS = a.TotalKg,
BRUTOSINIVA = a.ImporteBruto,
TABACO = a.Tabaco
})
.OrderBy(x => x.NUMROMANEO)
.ToList();
gridControlRomaneo.DataSource = result;
gridViewRomaneo.Columns[0].Visible = false;
gridViewRomaneo.Columns[1].Caption = "Fecha Romaneo";
gridViewRomaneo.Columns[1].Width = 60;
gridViewRomaneo.Columns[1].AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[1].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[2].Caption = "Número Romaneo";
gridViewRomaneo.Columns[2].Width = 60;
gridViewRomaneo.Columns[2].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[2].AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[3].Caption = "Productor";
gridViewRomaneo.Columns[3].Width = 150;
gridViewRomaneo.Columns[4].Caption = "CUIT";
gridViewRomaneo.Columns[4].Width = 75;
gridViewRomaneo.Columns[5].Caption = "FET";
gridViewRomaneo.Columns[5].Width = 55;
gridViewRomaneo.Columns[5].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[5].AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[6].Caption = "Provincia";
gridViewRomaneo.Columns[6].Width = 60;
gridViewRomaneo.Columns[6].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[6].AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[7].Caption = "Kilos";
gridViewRomaneo.Columns[7].Width = 70;
gridViewRomaneo.Columns[7].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[7].AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[8].Caption = "Bruto";
gridViewRomaneo.Columns[8].Width = 60;
gridViewRomaneo.Columns[8].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[8].AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[9].Caption = "Tabaco";
gridViewRomaneo.Columns[9].Width = 80;
gridViewRomaneo.Columns[9].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Columns[9].AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
for (var i = 0; i <= gridViewRomaneo.RowCount; i++)
{
gridViewRomaneo.SelectRow(i);
}
foreach (GridColumn column in gridViewRomaneo.Columns)
{
GridSummaryItem item = column.SummaryItem;
if (item != null)
{
column.Summary.Remove(item);
}
}
gridViewRomaneo.Columns["KILOS"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "KILOS", "{0}");
gridViewRomaneo.Columns["BRUTOSINIVA"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "BRUTOSINIVA", "{0}");
gridViewRomaneo.Appearance.FooterPanel.TextOptions.HAlignment = HorzAlignment.Center;
gridViewRomaneo.Appearance.FooterPanel.Options.UseTextOptions = true;
}
private async void LoadTransactions()
{
if (Global.Store.StoreID == 0)
{
_transactions = await _saleManager.GetTransactions();
}
else
{
_transactions = await _saleManager.GetTransactionsByStoreID(Global.Store.StoreID);
}
//listView1.Items.Clear();
lblTotal.Text = string.Empty;
decimal subtotal = 0;
gridControl1.DataSource = null;
foreach (GridColumn column in gridView1.Columns)
{
GridSummaryItem item = column.SummaryItem;
if (item != null)
{
column.Summary.Remove(item);
}
}
if (_transactions.Any())
{
var source = _transactions.Select(m => new SalesGridItem()
{
Items = m.Items,
Total = m.Total,
User = m.Firstname + " " + m.Lastname,
AmountPaid = m.AmountPaid,
Change = m.Change,
Date = m.DateTime,
Id = m.SaleID,
Time = m.DateTime
});
gridControl1.DataSource = source;
GridColumnSummaryItem item1 = new GridColumnSummaryItem(SummaryItemType.Sum, "Total", "{0:N}");
gridView1.Columns["Total"].Summary.Add(item1);
}
//foreach (SaleDTO transaction in _transactions)
//{
// ListViewItem lvi = new ListViewItem(transaction.SaleID.ToString());
// lvi.SubItems.Add(transaction.DateStr);
// lvi.SubItems.Add(transaction.TimeStr);
// lvi.SubItems.Add(transaction.Items);
// lvi.SubItems.Add(transaction.Total.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(transaction.AmountPaid.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add(transaction.Change.ToString("C2").Replace("$", ""));
// lvi.SubItems.Add($@"{ transaction.Firstname } { transaction.Lastname }");
// listView1.Items.Add(lvi);
// subtotal += transaction.Total;
//}
subtotal = _transactions.Sum(m => m.Total);
lblTotal.Text = $@"Total Sales: { subtotal.ToString("C2").Replace("$", "") }";
}
private void BuscarCajaConsulta(string cajas)
{
int Campaña = int.Parse(cbCampaña.Text);
var ProductoId = Guid.Parse(cbProductoConsulta.SelectedValue.ToString());
Expression <Func <Caja, bool> > pred = x => true;
pred = checkCampaña.Checked ?
pred.And(x => x.Campaña == Campaña) : pred;
pred = pred.And(x => x.ProductoId == ProductoId);
pred = checkSinCata.Checked ? pred.And(x => x.CataId == null) : pred;
if (!string.IsNullOrEmpty(cajas))
{
var cantidad = int.Parse(txtCantidadCajaConsulta.Text);
var result =
(from c in Context.Caja.OrderBy(x => x.NumeroCaja)
.Where(pred).Take(cantidad)
join p in Context.Vw_Producto
on c.ProductoId equals p.ID into pr
from cp in pr.DefaultIfEmpty()
join ca in Context.Cata
on c.CataId equals ca.Id into cat
from joined in cat.DefaultIfEmpty()
select new CajaCata
{
Id = c.Id,
Campaña = c.Campaña,
NumLote = c.LoteCaja,
NumCaja = c.NumeroCaja,
Producto = cp.DESCRIPCION,
Tara = c.Tara,
Neto = c.Neto,
Bruto = c.Bruto,
Cata = joined.NumCata,
OrdenVentaId = c.OrdenVentaId,
NumOrden = c.OrdenVenta != null ? c.OrdenVenta.NumOrden : (long?)null,
ConRemito = c.OrdenVenta.Remito.FirstOrDefault() != null ? "SI" : "NO"
})
.OrderBy(x => x.Campaña)
.ThenBy(x => x.NumCaja)
.ToList();
gridControlCajaConsulta.DataSource = result;
ListCajaCata = result.ToList <CajaCata>();
}
else
{
var result =
(from c in Context.Caja
.Where(pred)
join p in Context.Vw_Producto
on c.ProductoId equals p.ID into pr
from cp in pr.DefaultIfEmpty()
join ca in Context.Cata
on c.CataId equals ca.Id into cat
from joined in cat.DefaultIfEmpty()
select new CajaCata
{
Id = c.Id,
Campaña = c.Campaña,
NumLote = c.LoteCaja,
NumCaja = c.NumeroCaja,
Producto = cp.DESCRIPCION,
Tara = c.Tara,
Neto = c.Neto,
Bruto = c.Bruto,
Cata = joined.NumCata,
OrdenVentaId = c.OrdenVentaId,
NumOrden = c.OrdenVenta != null ? c.OrdenVenta.NumOrden : (long?)null,
ConRemito = c.OrdenVenta.Remito.FirstOrDefault() != null ? "SI" : "NO"
})
.OrderBy(x => x.Campaña)
.ThenBy(x => x.NumCaja)
.ToList();
gridControlCajaConsulta.DataSource = result;
ListCajaCata = result.ToList <CajaCata>();
}
gridViewCajaConsulta.Columns[0].Visible = false;
gridViewCajaConsulta.Columns[1].Caption = "Campaña";
gridViewCajaConsulta.Columns[1].Width = 90;
gridViewCajaConsulta.Columns[2].Caption = "N° Lote";
gridViewCajaConsulta.Columns[2].Width = 110;
gridViewCajaConsulta.Columns[3].Caption = "N° Caja";
gridViewCajaConsulta.Columns[3].Width = 110;
gridViewCajaConsulta.Columns[4].Caption = "Producto";
gridViewCajaConsulta.Columns[4].Width = 100;
gridViewCajaConsulta.Columns[5].Caption = "Tara";
gridViewCajaConsulta.Columns[5].Width = 100;
gridViewCajaConsulta.Columns[6].Caption = "Neto";
gridViewCajaConsulta.Columns[6].Width = 100;
gridViewCajaConsulta.Columns[7].Caption = "Bruto";
gridViewCajaConsulta.Columns[7].Width = 100;
gridViewCajaConsulta.Columns[8].Caption = "N° Cata";
gridViewCajaConsulta.Columns[8].Width = 200;
gridViewCajaConsulta.Columns[9].Visible = false;
gridViewCajaConsulta.Columns[10].Visible = false;
gridViewCajaConsulta.Columns[11].Caption = "Remito";
gridViewCajaConsulta.Columns[11].Width = 100;
for (var i = 0; i <= gridViewCajaConsulta.RowCount; i++)
{
gridViewCajaConsulta.SelectRow(i);
}
foreach (GridColumn column in gridViewCajaConsulta.Columns)
{
GridSummaryItem item = column.SummaryItem;
if (item != null)
{
column.Summary.Remove(item);
}
}
gridViewCajaConsulta.Columns["NumCaja"].Summary.Add(DevExpress.Data.SummaryItemType.Count, "NumCaja", "Total Cajas : {0}");
gridViewCajaConsulta.Appearance.FooterPanel.TextOptions.HAlignment = HorzAlignment.Center;
gridViewCajaConsulta.Appearance.FooterPanel.Options.UseTextOptions = true;
}
private void CreateBand(List <BandInfo> Bands, GridBand RootBand)
{
this.bandedGridView1.Bands.Clear();
foreach (BandInfo bandinfo in Bands)
{
GridBand gridband = new GridBand();
gridband.AppearanceHeader.Options.UseTextOptions = true;
gridband.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridband.AppearanceHeader.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
gridband.Caption = bandinfo.HanderTitle;
gridband.ImageAlignment = StringAlignment.Far;
gridband.Width = bandinfo.Width;
gridband.MinWidth = bandinfo.Width;
if (bandinfo.Bands != null && bandinfo.Bands.Count > 0)
{
CreateBand(bandinfo.Bands, gridband);
}
else
{
// 开始生成列
BandedGridColumn column = new BandedGridColumn();
column.Visible = true;
column.FieldName = bandinfo.FieldName;
column.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column.AppearanceCell.ForeColor = m_CommonForeColor;
column.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
column.Caption = bandinfo.HanderTitle;
if (!string.IsNullOrEmpty(column.FieldName))
{
column.Name = column.FieldName;
}
this.bandedGridView1.Columns.Add(column);
gridband.Columns.Add(column);
if (bandinfo.SummaryTypeList != null)
{
for (int i = 0; i < bandinfo.SummaryTypeList.Count; i++)
{
GridSummaryItem item0 = column.SummaryItem.Collection.Add();
item0.FieldName = column.FieldName;
item0.SummaryType = bandinfo.SummaryTypeList[i];
item0.DisplayFormat = bandinfo.DisplayFormatList[i];
}
}
else
{
if (bandinfo.SummaryType != SummaryItemType.None)
{
column.SummaryItem.SummaryType = bandinfo.SummaryType;
}
if (!string.IsNullOrEmpty(bandinfo.DisplayFormat))
{
column.SummaryItem.DisplayFormat = bandinfo.DisplayFormat;
}
}
if (bandinfo.IsFix)
{
gridband.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
}
}
if (RootBand == null)
{
this.bandedGridView1.Bands.Add(gridband);
}
else
{
RootBand.Children.Add(gridband);
}
}
}
protected virtual void Attach(GridView view)
{
if (view == null)
{
return;
}
if (view.Columns[CheckFieldName] != null)
{
return;
}
//
selection.Clear();
this._view = view;
view.BeginUpdate();
try {
edit = view.GridControl.RepositoryItems.Add("CheckEdit") as RepositoryItemCheckEdit;
column = view.Columns.Add();
column.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
column.Visible = true;
column.VisibleIndex = 0;
column.FieldName = CheckFieldName;
column.Caption = "Mark";
column.OptionsColumn.ShowCaption = false;
column.OptionsColumn.AllowEdit = false;
column.OptionsColumn.AllowSize = false;
column.UnboundType = DevExpress.Data.UnboundColumnType.Boolean;
column.Width = GetCheckBoxWidth();
column.ColumnEdit = edit;
// --- summary items (for both group and total field)
column.SummaryItem.FieldName = column.FieldName;
column.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
/*view.CustomDrawFooterCell += (s, e) => {
* if (e.Column == column) {
* e.Info.DisplayText = string.Format("{0}", selection.Count);
* }
* };*/
int selectCount = 0;
view.CustomSummaryCalculate += (s, e) => {
GridView gv = s as GridView;
GridSummaryItem gsi = e.Item as GridSummaryItem;
if (gv == null || gsi == null)
{
return;
}
// Initialization
if (e.SummaryProcess == CustomSummaryProcess.Start)
{
selectCount = 0;
}
// Calculation
if (e.SummaryProcess == CustomSummaryProcess.Calculate)
{
if (IsRowSelected(e.RowHandle))
{
++selectCount;
}
}
// Finalization
if (e.SummaryProcess == CustomSummaryProcess.Finalize)
{
e.TotalValue = selectCount;
}
};
GridGroupSummaryItem item = new GridGroupSummaryItem();
item.FieldName = column.FieldName;
item.SummaryType = DevExpress.Data.SummaryItemType.Custom;
item.ShowInGroupColumnFooter = column;
view.GroupSummary.Add(item);
// ---
view.Click += new EventHandler(View_Click);
view.CustomDrawColumnHeader += new ColumnHeaderCustomDrawEventHandler(View_CustomDrawColumnHeader);
view.CustomDrawGroupRow += new RowObjectCustomDrawEventHandler(View_CustomDrawGroupRow);
view.CustomUnboundColumnData += new CustomColumnDataEventHandler(view_CustomUnboundColumnData);
view.KeyDown += new KeyEventHandler(view_KeyDown);
view.RowStyle += new RowStyleEventHandler(view_RowStyle);
}
finally {
view.EndUpdate();
}
}
void InitGrid()
{
gridList.Init();
gridList.ShowFooter = true;
gridList.AddGridColumns(
new XGridColumn()
{
FieldName = "ROW_NO"
},
new XGridColumn()
{
FieldName = "PRODUCT_TYPE", HorzAlignment = HorzAlignment.Center, Width = 80
},
new XGridColumn()
{
FieldName = "CATEGORY", HorzAlignment = HorzAlignment.Center, Width = 100
},
new XGridColumn()
{
FieldName = "PRODUCT_ID", HorzAlignment = HorzAlignment.Center, Width = 100, Visible = false
},
new XGridColumn()
{
FieldName = "PRODUCT_CODE", HorzAlignment = HorzAlignment.Center, Width = 100
},
new XGridColumn()
{
FieldName = "PRODUCT_NAME", Width = 200
},
new XGridColumn()
{
FieldName = "SALE_AMT", Caption = "당월매출", HorzAlignment = HorzAlignment.Far, Width = 110, FormatType = FormatType.Numeric, FormatString = "N0", IsSummary = true, SummaryItemType = DevExpress.Data.SummaryItemType.Sum
},
new XGridColumn()
{
FieldName = "BASE_AMT", Caption = "기초재고", HorzAlignment = HorzAlignment.Far, Width = 110, FormatType = FormatType.Numeric, FormatString = "N0", IsSummary = true, SummaryItemType = DevExpress.Data.SummaryItemType.Sum
},
new XGridColumn()
{
FieldName = "PURC_AMT", Caption = "당월매입", HorzAlignment = HorzAlignment.Far, Width = 110, FormatType = FormatType.Numeric, FormatString = "N0", IsSummary = true, SummaryItemType = DevExpress.Data.SummaryItemType.Sum
},
new XGridColumn()
{
FieldName = "PROD_AMT", Caption = "당월생산", HorzAlignment = HorzAlignment.Far, Width = 110, FormatType = FormatType.Numeric, FormatString = "N0", IsSummary = true, SummaryItemType = DevExpress.Data.SummaryItemType.Sum
},
new XGridColumn()
{
FieldName = "ADJS_AMT", Caption = "당월조정", HorzAlignment = HorzAlignment.Far, Width = 110, FormatType = FormatType.Numeric, FormatString = "N0", IsSummary = true, SummaryItemType = DevExpress.Data.SummaryItemType.Sum
},
new XGridColumn()
{
FieldName = "BLNC_AMT", Caption = "기말재고", HorzAlignment = HorzAlignment.Far, Width = 110, FormatType = FormatType.Numeric, FormatString = "N0", IsSummary = true, SummaryItemType = DevExpress.Data.SummaryItemType.Sum
},
new XGridColumn()
{
FieldName = "COST_AMT", Caption = "매출원가", HorzAlignment = HorzAlignment.Far, Width = 110, FormatType = FormatType.Numeric, FormatString = "N0", IsSummary = true, SummaryItemType = DevExpress.Data.SummaryItemType.Sum
},
new XGridColumn()
{
FieldName = "PRFT_AMT", Caption = "매출이익", HorzAlignment = HorzAlignment.Far, Width = 110, FormatType = FormatType.Numeric, FormatString = "N0", IsSummary = true, SummaryItemType = DevExpress.Data.SummaryItemType.Sum
},
new XGridColumn()
{
FieldName = "PRFT_RAT", Caption = "이익율(%)", HorzAlignment = HorzAlignment.Far, Width = 80, FormatType = FormatType.Numeric, FormatString = "P2", IsSummary = true, SummaryItemType = DevExpress.Data.SummaryItemType.Custom
},
new XGridColumn()
{
FieldName = "INS_TIME"
},
new XGridColumn()
{
FieldName = "INS_USER", Visible = false
},
new XGridColumn()
{
FieldName = "INS_USER_NAME"
},
new XGridColumn()
{
FieldName = "UPD_TIME"
},
new XGridColumn()
{
FieldName = "UPD_USER", Visible = false
},
new XGridColumn()
{
FieldName = "UPD_USER_NAME"
}
);
gridList.SetMerge("PRODUCT_TYPE", "CATEGORY");
gridList.SetColumnBackColor(SkinUtils.ForeColor, "ROW_NO");
gridList.SetColumnForeColor(SkinUtils.BackColor, "ROW_NO");
gridList.RowCellStyle += delegate(object sender, RowCellStyleEventArgs e)
{
if (e.RowHandle < 0)
{
return;
}
try
{
if (e.Column.FieldName.EndsWith("_QTY") ||
e.Column.FieldName.EndsWith("_AMT"))
{
if (e.CellValue.ToDecimalNullToZero() < 0)
{
e.Appearance.ForeColor = Color.Red;
}
}
}
catch (Exception ex)
{
ShowErrBox(ex);
}
};
(gridList.MainView as GridView).CustomSummaryCalculate += delegate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
try
{
GridView view = sender as GridView;
GridSummaryItem col = e.Item as GridSummaryItem;
if (col == null)
{
return;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
if (col.FieldName.Equals("PRFT_RAT"))
{
decimal den = view.Columns["SALE_AMT"].SummaryItem.SummaryValue.ToDecimalNullToZero();
decimal num = view.Columns["PRFT_AMT"].SummaryItem.SummaryValue.ToDecimalNullToZero();
e.TotalValue = (den > 0 && num > 0) ? num / den : 0;
}
}
}
catch (Exception ex)
{
ShowErrBox(ex);
}
};
}
