private void xfViewSalesOrder_Load(object sender, EventArgs e)
{
try
{
var oBr = new BRSales();
oBe.NUM_ACCI = 12;
var oList = oBr.SVPR_REPO_LIST(oBe);
gdcResults.DataSource = oList;
gdvResults.BestFitColumns();
for (int i = 0; i < gdvResults.Columns.Count; i++)
{
gdvResults.Columns[i].OptionsColumn.AllowEdit = false;
gdvResults.Columns[i].OptionsColumn.AllowFocus = false;
gdvResults.Columns[i].OptionsColumn.ReadOnly = true;
var Type = gdvResults.Columns[i].ColumnType;
if (Type.Name.ToUpper().Equals("DECIMAL"))
{
gdvResults.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gdvResults.Columns[i].DisplayFormat.FormatString = "n2";
gdvResults.Columns[i].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gdvResults.Columns[i].SummaryItem.DisplayFormat = "{0:#,##0.00}";
gdvResults.Columns[i].Width = gdvResults.Columns[i].Width + 20;
}
}
oBe.NUM_ACCI = 13;
var oList02 = oBr.SVPR_REPO_LIST(oBe);
gdcResults01.DataSource = oList02;
gdvResults01.BestFitColumns();
for (int i = 0; i < gdvResults01.Columns.Count; i++)
{
gdvResults01.Columns[i].OptionsColumn.AllowEdit = false;
gdvResults01.Columns[i].OptionsColumn.AllowFocus = false;
gdvResults01.Columns[i].OptionsColumn.ReadOnly = true;
var Type = gdvResults01.Columns[i].ColumnType;
if (Type.Name.ToUpper().Equals("DECIMAL"))
{
gdvResults01.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gdvResults01.Columns[i].DisplayFormat.FormatString = "n2";
gdvResults01.Columns[i].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gdvResults01.Columns[i].SummaryItem.DisplayFormat = "{0:#,##0.00}";
gdvResults01.Columns[i].Width = gdvResults01.Columns[i].Width + 20;
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void sbSearch_Click(object sender, EventArgs e)
{
try
{
var oBe = new BEReport();
var oBr = new BRSales();
oBe.COD_COMP = SESSION_COMP;
oBe.FEC_DESD = deFEC_DESD.DateTime;
oBe.FEC_HAST = deFEC_HAST.DateTime;
oBe.NUM_ACCI = 5;
var oList = oBr.SVPR_REPO_LIST(oBe);
gdcResults.DataSource = oList;
gdvResults.BestFitColumns();
for (int i = 0; i < gdvResults.Columns.Count; i++)
{
gdvResults.Columns[i].OptionsColumn.AllowEdit = false;
gdvResults.Columns[i].OptionsColumn.AllowFocus = false;
gdvResults.Columns[i].OptionsColumn.ReadOnly = true;
var Type = gdvResults.Columns[i].ColumnType;
if (Type.Name.ToUpper().Equals("DECIMAL"))
{
gdvResults.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gdvResults.Columns[i].DisplayFormat.FormatString = "n2";
gdvResults.Columns[i].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gdvResults.Columns[i].SummaryItem.DisplayFormat = "{0:#,##0.00}";
gdvResults.Columns[i].Width = gdvResults.Columns[i].Width + 20;
}
}
//gdvResults.OptionsView.ColumnAutoWidth=true;
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void xfCommittedArticles_Load(object sender, EventArgs e)
{
SESSION_USER = ((xfMain)MdiParent).SESSION_USER;
SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF;
SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP;
deFEC_DESD.DateTime = DateTime.Today;
deFEC_HAST.DateTime = DateTime.Today;
var oBe = new BEReport();
var oBr = new BRSales();
oBe.COD_COMP = SESSION_COMP;
oBe.FEC_DESD = deFEC_DESD.DateTime;
oBe.FEC_HAST = deFEC_HAST.DateTime;
oBe.NUM_ACCI = 10;
var oList = oBr.SVPR_REPO_LIST(oBe);
gdcResults.DataSource = oList;
gdvResults.BestFitColumns();
for (int i = 0; i < gdvResults.Columns.Count; i++)
{
gdvResults.Columns[i].OptionsColumn.AllowEdit = false;
gdvResults.Columns[i].OptionsColumn.AllowFocus = false;
gdvResults.Columns[i].OptionsColumn.ReadOnly = true;
var Type = gdvResults.Columns[i].ColumnType;
if (Type.Name.ToUpper().Equals("DECIMAL"))
{
gdvResults.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gdvResults.Columns[i].DisplayFormat.FormatString = "n2";
gdvResults.Columns[i].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gdvResults.Columns[i].SummaryItem.DisplayFormat = "{0:#,##0.00}";
gdvResults.Columns[i].Width = gdvResults.Columns[i].Width + 20;
}
else if (Type.Name.ToUpper().Equals("INT32"))
{
gdvResults.Columns[i].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gdvResults.Columns[i].SummaryItem.DisplayFormat = "{0:#,##0.00}";
gdvResults.Columns[i].Width = gdvResults.Columns[i].Width + 20;
}
}
}