public xfViewSalesOrder(int COD_SOCI_NEGO,DateTime FEC_DESD, DateTime FEC_HAST)
{
InitializeComponent();
oBe = new BEReport();
oBe.COD_SOCI_NEGO = COD_SOCI_NEGO;
oBe.FEC_DESD = FEC_DESD;
oBe.FEC_HAST = FEC_HAST;
}
public DataTable SVPR_REPO_LIST(BEReport oBe)
{
using (var odr = oda.SVPR_REPO_LIST(oBe))
{
if (odr.Tables.Count == 0) return (new DataTable());
var olst = odr.Tables[0];
Dispose(false);
return (olst);
}
}
public DataTable Get_PSCP_SPLS_SVTC_OVEN(BEReport oBe)
{
using (var odr = oda.Get_PSCP_SPLS_SVTC_OVEN(oBe))
{
if (odr.Tables.Count == 0) return (new DataTable());
var olst = odr.Tables[0];
Dispose(false);
return (olst);
}
}
public DataSet Get_PSCP_SPLS_SVTC_OVEN(BEReport oBe)
{
try
{
if (ocn.State == ConnectionState.Closed) ocn.Open();
var ocmd = odb.GetStoredProcCommand("PSCP_SPLS_SVTC_OVEN",
oBe.FEC_DESD,
oBe.FEC_HAST,
oBe.COD_COMP,
oBe.NUM_ACCI);
ocmd.CommandTimeout = 2000;
var odr = odb.ExecuteDataSet(ocmd);
Dispose(false);
return (odr);
}
finally
{
ocn.Close();
}
}
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);
}
}
/// <summary>
/// CON DATASET
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public DataSet SVPR_REPO_LIST(BEReport oBe)
{
try
{
if (ocn.State == ConnectionState.Closed) ocn.Open();
var ocmd = odb.GetStoredProcCommand("SVPR_REPO_LIST",
oBe.FEC_DESD,
oBe.FEC_HAST,
oBe.COD_COMP,
oBe.COD_SOCI_NEGO,
oBe.NUM_ACCI);
ocmd.CommandTimeout = 2000;
var odr = odb.ExecuteDataSet(ocmd);
Dispose(false);
return (odr);
}
finally
{
ocn.Close();
}
}
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;
}
}
}
