public int GetWorkGroupID(string Name)
{
SCBWflRows rows = SysSession.System.SQLCommand("select usernr from mitarbeiter where username = '******' and ist_rolle = 1");
foreach (SCBWflRow row in rows)
{
return(Convert.ToInt32(row.ToString()));
}
return(-1);
}
public static string GetOracleConnectionString(SCBWflSession sysSession)
{
SCBWflRows rows = sysSession.System.SQLCommand("select value from BIG_CONNECTION_STRING");
foreach (SCBWflRow row in rows)
{
return(row.GetColumns().Item(1).ToString());
}
return("");
}
public frmMain()
{
InitializeComponent();
try
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("select 49 OENR, 'OM Team Wien 1' OEBEZ, 'OFM W1' OE_KURZBEZ, ");
sb.AppendLine("'OFM W1' || substr(username, instr(username, '_')) ARBEITSGRUPPE ");
sb.AppendLine("from mitarbeiter where username like 'W1%' and ist_rolle = 1 and status = 0 ");
sb.AppendLine("order by 1");
txtWGStatement.Text = sb.ToString();
txtUserStatement.Text = "select USERNR, USERNAME from mitarbeiter where usernr = 11";
CCDGUI.ccdLogin login = new CCDGUI.ccdLogin();
if (login.DoLogin())
{
Session = login.Session;
SCBWflRows rows = Session.SQLCommand(USER_CODE, "select value from BIG_CONNECTION_STRING");
foreach (SCBWflRow row in rows)
{
ConnectionString = row.ToString();
oracleConnection = new oraClient.OracleConnection(ConnectionString);
oracleConnection.Open();
}
}
else
{
this.Close();
}
rbSelectUser.Checked = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error in frmMain()", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public FolderObject getFolderObject(int UserNr, string FolderName, List <string> allPreviousFolder)
{
try
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT usernr,pfad_gesamt, pfad,vater_folderbez, folderbez,foldernr,vater_foldernr,FOLDER_LEVEL FROM( ");
sb.Append("SELECT ");
sb.Append("USERNR, ");
sb.Append("USERNAME || SYS_CONNECT_BY_PATH(FOLDERBEZ, '\\') PFAD_GESAMT, ");
sb.Append("SUBSTR(SYS_CONNECT_BY_PATH(FOLDERBEZ, '\\'), 2) PFAD, ");
sb.Append("NVL(substr(SYS_CONNECT_BY_PATH(FOLDERBEZ, '\\'), 2, LENGTH(SYS_CONNECT_BY_PATH(FOLDERBEZ, '\\') )- LENGTH(FOLDERBEZ) - 2), ' ') VATER_FOLDERBEZ, ");
sb.Append("FOLDERBEZ, ");
sb.Append("FOLDERNR, ");
sb.Append("VATER_FOLDERNR, ");
sb.Append("LEVEL FOLDER_LEVEL ");
sb.Append("FROM ");
sb.Append("(SELECT f.USERNR, m.USERNAME, f.FOLDERNR, f.VATER_FOLDERNR, f.FOLDERBEZ ");
sb.Append("FROM FOLDER f, MITARBEITER m ");
sb.Append("WHERE f.USERNR = " + UserNr); //--> USERNUMMER
sb.Append(" AND m.USERNR = f.USERNR ");
sb.Append("AND m.IST_ROLLE = 1) f ");
sb.Append("START WITH f.VATER_FOLDERNR = 0 ");
sb.Append("CONNECT BY PRIOR f.FOLDERNR=f.VATER_FOLDERNR ");
sb.Append(") WHERE FOLDERBEZ = '" + FolderName + "'"); //--> FOLDERBEZEICHNUNG
SCBWflRows rows = SysSession.System.SQLCommand(sb.ToString());
string parentFolder = "";
for (int i = allPreviousFolder.Count - 1; i >= 0; i--)
{
parentFolder = allPreviousFolder[i];
foreach (SCBWflRow row in rows)
{
//Console.WriteLine("4: " + row.GetColumns().Item(4).ToString());
//Console.WriteLine("5: " + row.GetColumns().Item(5).ToString());
if (parentFolder == row.GetColumns().Item(4).ToString() || rows.Count == 1)
{
//yes
try
{
fo = new FolderObject();
if (row.GetColumns().Item(1) != null)
{
fo.USERNR = Convert.ToInt32(row.GetColumns().Item(1).ToString());
}
if (row.GetColumns().Item(2) != null)
{
fo.PFAD_GESAMT = row.GetColumns().Item(2).ToString();
}
if (row.GetColumns().Item(3) != null)
{
fo.PFAD = row.GetColumns().Item(3).ToString();
}
if (row.GetColumns().Item(4) != null)
{
fo.VATER_FOLDERBEZ = row.GetColumns().Item(4).ToString();
}
if (row.GetColumns().Item(5) != null)
{
fo.FOLDERBEZ = row.GetColumns().Item(5).ToString();
}
if (row.GetColumns().Item(6) != null)
{
fo.FOLDERNR = Convert.ToInt32(row.GetColumns().Item(6).ToString());
}
if (row.GetColumns().Item(7) != null)
{
fo.VATER_FOLDERNR = Convert.ToInt32(row.GetColumns().Item(7).ToString());
}
if (row.GetColumns().Item(8) != null)
{
fo.FOLDER_LEVEL = Convert.ToInt32(row.GetColumns().Item(8).ToString());
}
}
catch (Exception ex)
{
Console.WriteLine("getFolderObject --> " + parentFolder + " --> " + ex.Message);
}
return(fo);
}
}
}
return(null);
}
catch (Exception ex)
{
Console.WriteLine("getFolderObject --> " + ex.Message);
return(null);
}
}
