private void Grid0_ComboSelectAfter(object sboObject, SAPbouiCOM.SBOItemEventArg pVal) { if ((pVal.ColUID == "CODSUPRA")) { int dtRow = Grid0.GetDataTableRowIndex(pVal.Row); SAPbouiCOM.ComboBoxColumn oCBC = (SAPbouiCOM.ComboBoxColumn)Grid0.Columns.Item("CODSUPRA"); string ValSelec = oCBC.GetSelectedValue(pVal.Row).Value; // Selecciona El Valor (U_CodigoSS) string DesSelec = oCBC.GetSelectedValue(pVal.Row).Description; // Selecciona la Descripcion (U_NombreSS) //mostrar la descripción en el combobox // oCBC.DisplayType = (SAPbouiCOM.BoComboDisplayType.cdt_Description); // Para Asignar el Valor a una celda del grid se puede asi: Grid0.DataTable.SetValue("SUPRA-SECCIÓN", dtRow, DesSelec); //O tambien asi //Grid0.DataTable.Columns.Item("CODSUPRA").Cells(pVal.Row).value = ValSelec; } }
public void gridreco() { //combobox en en un grid Grid2.Columns.Item("Proyecto").Type = SAPbouiCOM.BoGridColumnType.gct_ComboBox; SAPbouiCOM.ComboBoxColumn oCBC = (SAPbouiCOM.ComboBoxColumn)Grid2.Columns.Item("Proyecto"); SAPbobsCOM.Recordset oRec = (SAPbobsCOM.Recordset)oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); oRec.DoQuery(" SELECT CAST (U_CentroPyto AS VARCHAR) + '' + CAST (U_DeptoPyto AS VARCHAR) + '' + CAST (U_CodigoPyto AS VARCHAR) As Codigo,U_NombrePyto FROM [@PROYECTOSCOSTE]"); oRec.MoveFirst(); while (!oRec.EoF) { oCBC.ValidValues.Add(oRec.Fields.Item(0).Value.ToString(), oRec.Fields.Item(1).Value.ToString()); string Extraerdequery1 = oRec.Fields.Item("U_NombrePyto").Value.ToString(); Extraerdequery1 = Convert.ToString(Grid2.Columns.Item("Descripción")); oRec.MoveNext(); } oCBC = null; }
public void gridreco() { //combobox en en un grid Grid0.Columns.Item("CODSUPRA").Type = SAPbouiCOM.BoGridColumnType.gct_ComboBox; SAPbouiCOM.ComboBoxColumn oCBC = (SAPbouiCOM.ComboBoxColumn)Grid0.Columns.Item("CODSUPRA"); SAPbobsCOM.Recordset oRec = (SAPbobsCOM.Recordset)oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); oRec.DoQuery("SELECT U_CodigoSS AS 'Código',U_NombreSS AS 'Nombre' FROM [@SUPRASECCIONESCOL]"); oRec.MoveFirst(); while (!oRec.EoF) { oCBC.ValidValues.Add(oRec.Fields.Item(0).Value.ToString(), oRec.Fields.Item(1).Value.ToString()); //mostrar la descripción en el combobox // oCBC.DisplayType = (SAPbouiCOM.BoComboDisplayType.cdt_Description); // string Extraerdequery1 = oRec.Fields.Item("Código").Value.ToString(); string Extraerdequery = oRec.Fields.Item("Nombre").Value.ToString(); // Grid0.Columns.Item("SUPRA-SECCIÓN").T = oRec.Fields.Item("Nombre").Value.ToString(); //(Grid0.Columns.Item("SUPRA-SECCIÓN")).(Extraerdequery); oRec.MoveNext(); } }
private void populateGrid(String check = null) { StringBuilder query = new StringBuilder(); if (check != null) { // Set the default check settings branchCheckDict = new Dictionary <String, String>(); if (_cbARINV.Checked) { query.Append(String.Format(" UNION SELECT ObjType, '{2}' Checked, DocEntry, DocNum, DocDate, CardCode, CardName, NumAtCard, DocCur, CASE DocTotalFC when 0 then DocTotal else DocTotalFC END as DocTotal FROM OINV WHERE CANCELED ='N' AND DocDate between '{0}' AND '{1}'", _txtDTFRM.Value, _txtDTTO.Value, check)); branchCheckDict.Add("13", check); } if (_cbARCN.Checked) { query.Append(String.Format(" UNION SELECT ObjType, '{2}' Checked, DocEntry, DocNum, DocDate, CardCode, CardName, NumAtCard, DocCur, CASE DocTotalFC when 0 then DocTotal else DocTotalFC END as DocTotal FROM ORIN WHERE CANCELED ='N' AND DocDate between '{0}' AND '{1}'", _txtDTFRM.Value, _txtDTTO.Value, check)); branchCheckDict.Add("14", check); } if (_cbAPINV.Checked) { query.Append(String.Format(" UNION SELECT ObjType, '{2}' Checked, DocEntry, DocNum, DocDate, CardCode, CardName, NumAtCard, DocCur, CASE DocTotalFC when 0 then DocTotal else DocTotalFC END as DocTotal FROM OPCH WHERE CANCELED ='N' AND DocDate between '{0}' AND '{1}'", _txtDTFRM.Value, _txtDTTO.Value, check)); branchCheckDict.Add("18", check); } if (_cbAPCN.Checked) { query.Append(String.Format(" UNION SELECT ObjType, '{2}' Checked, DocEntry, DocNum, DocDate, CardCode, CardName, NumAtCard, DocCur, CASE DocTotalFC when 0 then DocTotal else DocTotalFC END as DocTotal FROM ORPC WHERE CANCELED ='N' AND DocDate between '{0}' AND '{1}'", _txtDTFRM.Value, _txtDTTO.Value, check)); branchCheckDict.Add("19", check); } } // currently this condition is not being used. line 211-212 else { if (branchCheckDict.ContainsKey("13")) { query.Append(String.Format(" UNION SELECT ObjType, '{2}' Checked, DocEntry, DocNum, DocDate, CardCode, CardName, NumAtCard, DocCur, CASE DocTotalFC when 0 then DocTotal else DocTotalFC END as DocTotal FROM OINV WHERE CANCELED ='N' AND DocDate between '{0}' AND '{1}'", _txtDTFRM.Value, _txtDTTO.Value, branchCheckDict["13"])); } if (branchCheckDict.ContainsKey("14")) { query.Append(String.Format(" UNION SELECT ObjType, '{2}' Checked, DocEntry, DocNum, DocDate, CardCode, CardName, NumAtCard, DocCur, CASE DocTotalFC when 0 then DocTotal else DocTotalFC END as DocTotal FROM ORIN WHERE CANCELED ='N' AND DocDate between '{0}' AND '{1}'", _txtDTFRM.Value, _txtDTTO.Value, branchCheckDict["14"])); } if (branchCheckDict.ContainsKey("18")) { query.Append(String.Format(" UNION SELECT ObjType, '{2}' Checked, DocEntry, DocNum, DocDate, CardCode, CardName, NumAtCard, DocCur, CASE DocTotalFC when 0 then DocTotal else DocTotalFC END as DocTotal FROM OPCH WHERE CANCELED ='N' AND DocDate between '{0}' AND '{1}'", _txtDTFRM.Value, _txtDTTO.Value, branchCheckDict["18"])); } if (branchCheckDict.ContainsKey("19")) { query.Append(String.Format(" UNION SELECT ObjType, '{2}' Checked, DocEntry, DocNum, DocDate, CardCode, CardName, NumAtCard, DocCur, CASE DocTotalFC when 0 then DocTotal else DocTotalFC END as DocTotal FROM ORPC WHERE CANCELED ='N' AND DocDate between '{0}' AND '{1}'", _txtDTFRM.Value, _txtDTTO.Value, branchCheckDict["19"])); } } // remove the first UNION in string String temmp = query.ToString().Remove(0, 7); _dt_grid_Trans.ExecuteQuery(temmp); // if no results from query delete first row which is empty if (_grid_Trans.DataTable.GetValue("DocEntry", 0).ToString() == "0") { _grid_Trans.DataTable.Rows.Remove(0); } _grid_Trans.Columns.Item("Checked").Type = SAPbouiCOM.BoGridColumnType.gct_CheckBox; _grid_Trans.Columns.Item("DocEntry").Editable = false; _grid_Trans.Columns.Item("DocNum").Editable = false; _grid_Trans.Columns.Item("ObjType").Type = SAPbouiCOM.BoGridColumnType.gct_ComboBox; SAPbouiCOM.ComboBoxColumn oCBC = (SAPbouiCOM.ComboBoxColumn)_grid_Trans.Columns.Item("ObjType"); oCBC.ValidValues.Add("13", "A/R Invoice"); oCBC.ValidValues.Add("14", "A/R Credit Note"); oCBC.ValidValues.Add("18", "A/P Invoice"); oCBC.ValidValues.Add("19", "A/P Credit Note"); oCBC.DisplayType = SAPbouiCOM.BoComboDisplayType.cdt_Description; _grid_Trans.Columns.Item("ObjType").Editable = false; _grid_Trans.Columns.Item("DocDate").Editable = false; _grid_Trans.Columns.Item("CardCode").Editable = false; _grid_Trans.Columns.Item("CardName").Editable = false; _grid_Trans.Columns.Item("NumAtCard").Editable = false; _grid_Trans.Columns.Item("DocCur").Editable = false; _grid_Trans.Columns.Item("DocTotal").Editable = false; // tree collaspable _grid_Trans.CollapseLevel = 1; }