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