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