private void PivotGrid_CellDoubleClick(object sender, PivotCellEventArgs e)
{
XtraForm form = new XtraForm();
form.Icon = Marbid.Module.Win.Properties.Resources.mareinico;
form.Height = 800;
form.Width = 600;
form.StartPosition = FormStartPosition.CenterScreen;
form.Owner = pivotForm;
form.Text = "Drill Down: " + ReportName;
drillGrid = new GridControl();
drillView = new DevExpress.XtraGrid.Views.Grid.GridView();
drillGrid.DataSource = e.CreateDrillDownDataSource();
drillGrid.ViewCollection.Add(drillView);
drillGrid.ForceInitialize();
drillGrid.Parent = form;
drillGrid.Dock = DockStyle.Fill;
DevExpress.XtraGrid.Views.Grid.GridView view = (DevExpress.XtraGrid.Views.Grid.GridView)drillGrid.MainView;
view.PopulateColumns();
foreach (GridColumn col in view.Columns)
{
if (col.GetType() == typeof(System.Decimal) || col.GetType() == typeof(System.Double))
{
col.DisplayFormat.FormatType = FormatType.Numeric;
col.DisplayFormat.FormatString = "n2";
}
}
view.PopupMenuShowing += DrillGrid_PopupMenuShowing;
view.OptionsView.ColumnAutoWidth = false;
view.BestFitColumns(true);
form.ShowDialog();
form.Dispose();
}
private void Form1_Load(object sender, System.EventArgs e)
{
FillDataSet();
gridControl1.DataSource = dataTable1;
gridView1.PopulateColumns();
gridView1.Columns[OrderFieldName].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
gridView1.OptionsCustomization.AllowSort = false;
gridView1.OptionsView.ShowGroupPanel = false;
}
public void GetTeklifler()
{
try
{
DataSet ds = TeklifMethods.GetRelation(this.ilkTarihDateEdit.DateTime, this.sonTarihDateEdit.DateTime, this.gemiAdiTextEdit.Text);
this.teklifBindingSource.DataSource = ds.Tables[0];
this.teklifGridControl.ForceInitialize();
DevExpress.XtraGrid.Views.Grid.GridView grdDetailView = new DevExpress.XtraGrid.Views.Grid.GridView(this.teklifGridControl);
this.teklifGridControl.LevelTree.Nodes.Add("FK_Teklif_TO_Detay", grdDetailView);
grdDetailView.ViewCaption = "Teklif Detayları";
grdDetailView.PopulateColumns(ds.Tables[1]);
grdDetailView.OptionsView.ShowFooter = true;
grdDetailView.OptionsView.ShowGroupPanel = false;
grdDetailView.OptionsBehavior.AutoSelectAllInEditor = false;
grdDetailView.OptionsBehavior.Editable = false;
grdDetailView.OptionsBehavior.AutoExpandAllGroups = true;
grdDetailView.OptionsSelection.EnableAppearanceFocusedCell = false;
grdDetailView.OptionsView.EnableAppearanceEvenRow = true;
grdDetailView.GroupCount = 1;
grdDetailView.SortInfo.AddRange(new DevExpress.XtraGrid.Columns.GridColumnSortInfo[] {
new DevExpress.XtraGrid.Columns.GridColumnSortInfo(grdDetailView.Columns[2], DevExpress.Data.ColumnSortOrder.Ascending)
});
byte index = 0;
grdDetailView.Columns[index++].VisibleIndex = -1;
//TeklifID,UrunAdi,FirmaBilgi,Adet,Birim,BirimFiyati,KarOrani
string[] kolonIsimleri = { L.UrunAciklama, L.TedarikciFirma, L.Miktar, L.Birim, L.AlisFiyati, L.KarOrani, L.SatisFiyati, L.AlisTutar, L.SatisTutar, L.NetKar };
DevExpress.XtraGrid.Columns.GridColumn c = null;
string kolon = "";
for (int i = 0; i < kolonIsimleri.Length; i++)
{
kolon = kolonIsimleri[i];
switch (i)
{
case 6:
c = new DevExpress.XtraGrid.Columns.GridColumn();
c.VisibleIndex = -1;
c.Name = "colSatisFiyati";
c.FieldName = c.Name;
c.Caption = kolon;
c.UnboundExpression = "([BirimFiyati] + ([BirimFiyati] * [KarOrani]))";
c.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
grdDetailView.Columns.Add(c);
break;
case 7:
c = new DevExpress.XtraGrid.Columns.GridColumn();
c.VisibleIndex = 9;
c.Name = "colAlisTutar";
c.FieldName = c.Name;
c.Caption = kolon;
c.Summary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, c.Name, Commons.Kur0FormatCustom)
});
c.UnboundExpression = "[BirimFiyati] * [Adet]";
c.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
grdDetailView.Columns.Add(c);
break;
case 8:
c = new DevExpress.XtraGrid.Columns.GridColumn();
c.VisibleIndex = 10;
c.Name = "colSatisTutar";
c.FieldName = c.Name;
c.Caption = kolon;
c.Summary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, c.Name, Commons.Kur0FormatCustom)
});
c.UnboundExpression = "([BirimFiyati] + ([BirimFiyati] * [KarOrani])) * [Adet]";
c.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
grdDetailView.Columns.Add(c);
break;
case 9:
c = new DevExpress.XtraGrid.Columns.GridColumn();
c.VisibleIndex = 11;
c.Name = "colNetKar";
c.FieldName = c.Name;
c.Caption = kolon;
c.Summary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, c.Name, Commons.Kur0FormatCustom)
});
c.UnboundExpression = "([BirimFiyati] * [KarOrani]) * [Adet]";
c.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
grdDetailView.Columns.Add(c);
break;
case 4:
case 5:
grdDetailView.Columns[index].Caption = kolon;
grdDetailView.Columns[index].VisibleIndex = -1;
break;
default:
grdDetailView.Columns[index].Caption = kolon;
break;
}
index++;
}
grdDetailView.Columns[1].Width = 300;
grdDetailView.Columns[2].Width = 200;
for (int i = 3; i < index; i++)
{
grdDetailView.Columns[i].OptionsColumn.AllowSize = false;
if (i != 3 & i != 4 & i != 6 & i != 7)
{
grdDetailView.Columns[i].Width = 70;
grdDetailView.Columns[i].DisplayFormat.FormatString = Commons.Kur0Format;
grdDetailView.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
}
else if (i == 3)
{
grdDetailView.Columns[i].Width = 40;
}
else if (i == 4)
{
grdDetailView.Columns[i].Width = 40;
}
else if (i == 6)
{
grdDetailView.Columns[i].DisplayFormat.FormatString = "% ##0";
grdDetailView.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
grdDetailView.Columns[i].Width = 40;
}
else if (i == 7)
{
grdDetailView.Columns[i].DisplayFormat.FormatString = "##0";
grdDetailView.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
grdDetailView.Columns[i].Width = 40;
}
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FTD", 2) + ex.Message);
}
}
public void PopulateColumns()
{
_view.PopulateColumns();
}
