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; } } }