fork download

copy

SAPbobsCOM.Recordset rs = (SAPbobsCOM.Recordset)B1Connections.diCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
 
var sql = @"
SELECT OHEM.empID 
FROM OHEM 
INNER JOIN HEM6 ON
	OHEM.empID = HEM6.empID
WHERE HEM6.roleID = '{0}'
";
 
try
{
 
    SAPbouiCOM.ChooseFromListCollection oCFLs = null;
    SAPbouiCOM.Conditions oCons = null;
    SAPbouiCOM.Condition oCon = null;
 
    oCFLs = form.ChooseFromLists;
 
 
 
    SAPbouiCOM.ChooseFromList oCFL = null;
    SAPbouiCOM.ChooseFromListCreationParams oCFLCreationParams = null;
    oCFLCreationParams = ((SAPbouiCOM.ChooseFromListCreationParams)(B1Connections.theAppl.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams)));
 
    oCFLCreationParams.MultiSelection = false;
    oCFLCreationParams.ObjectType = "171"; // EmployeesInfo object
    oCFLCreationParams.UniqueID = ChooseFromList_technician;
 
    oCFL = oCFLs.Add(oCFLCreationParams);
 
    oCons = oCFL.GetConditions();
 
    rs.DoQuery(String.Format(sql, Properties.Settings.Default.HEM6_rolerID));
 
    var count = rs.RecordCount;
    while (!rs.EoF)
    {
        oCon = oCons.Add();
        oCon.Alias = "empID";
        oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL;
        oCon.CondVal = rs.Fields.Item("empID").Value.ToString();
        oCFL.SetConditions(oCons);
 
        if ((count--) > 1)
            oCon.Relationship = BoConditionRelationship.cr_OR;
 
        rs.MoveNext();
    }
 
}
catch (Exception ex)
{
    B1Connections.theAppl.MessageBox("Erro na criação do CFL : " + ex.Message);
}
 

Main.java:1: error: class, interface, or enum expected
SAPbobsCOM.Recordset rs = (SAPbobsCOM.Recordset)B1Connections.diCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
^
Main.java:3: error: class, interface, or enum expected
var sql = @"
^
Main.java:3: error: unclosed string literal
var sql = @"
           ^
Main.java:4: error: class, interface, or enum expected
SELECT OHEM.empID 
       ^
Main.java:8: error: unclosed character literal
WHERE HEM6.roleID = '{0}'
                    ^
Main.java:8: error: illegal line end in character literal
WHERE HEM6.roleID = '{0}'
                        ^
Main.java:9: error: unclosed string literal
";
^
Main.java:15: error: class, interface, or enum expected
    SAPbouiCOM.Conditions oCons = null;
    ^
Main.java:16: error: class, interface, or enum expected
    SAPbouiCOM.Condition oCon = null;
    ^
Main.java:18: error: class, interface, or enum expected
    oCFLs = form.ChooseFromLists;
    ^
Main.java:22: error: class, interface, or enum expected
    SAPbouiCOM.ChooseFromList oCFL = null;
    ^
Main.java:23: error: class, interface, or enum expected
    SAPbouiCOM.ChooseFromListCreationParams oCFLCreationParams = null;
    ^
Main.java:24: error: class, interface, or enum expected
    oCFLCreationParams = ((SAPbouiCOM.ChooseFromListCreationParams)(B1Connections.theAppl.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams)));
    ^
Main.java:26: error: class, interface, or enum expected
    oCFLCreationParams.MultiSelection = false;
    ^
Main.java:27: error: class, interface, or enum expected
    oCFLCreationParams.ObjectType = "171"; // EmployeesInfo object
    ^
Main.java:28: error: class, interface, or enum expected
    oCFLCreationParams.UniqueID = ChooseFromList_technician;
    ^
Main.java:30: error: class, interface, or enum expected
    oCFL = oCFLs.Add(oCFLCreationParams);
    ^
Main.java:32: error: class, interface, or enum expected
    oCons = oCFL.GetConditions();
    ^
Main.java:34: error: class, interface, or enum expected
    rs.DoQuery(String.Format(sql, Properties.Settings.Default.HEM6_rolerID));
    ^
Main.java:36: error: class, interface, or enum expected
    var count = rs.RecordCount;
    ^
Main.java:37: error: class, interface, or enum expected
    while (!rs.EoF)
    ^
Main.java:40: error: class, interface, or enum expected
        oCon.Alias = "empID";
        ^
Main.java:41: error: class, interface, or enum expected
        oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL;
        ^
Main.java:42: error: class, interface, or enum expected
        oCon.CondVal = rs.Fields.Item("empID").Value.ToString();
        ^
Main.java:43: error: class, interface, or enum expected
        oCFL.SetConditions(oCons);
        ^
Main.java:45: error: class, interface, or enum expected
        if ((count--) > 1)
        ^
Main.java:48: error: class, interface, or enum expected
        rs.MoveNext();
        ^
Main.java:49: error: class, interface, or enum expected
    }
    ^
Main.java:55: error: class, interface, or enum expected
}
^
29 errors

Standard output is empty