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 void DoLogin()
{
Util.WriteMethodInfoToConsole();
ccdLogin Login = new ccdLogin();
if (Login.DoLogin())
{
Console.WriteLine("--> Connected to DOMEA Server: " + Login.Session.HostName);
LoginSession = Login.Session;
}
}
public void startWorkGroupSession(int workGroupID)
{
try
{
SCBWflWorkGroup wg = sysSession.System.GetWorkGroupByID(sysSession.System.NewIDByLocalKey(workGroupID));
workGroupSession = sysSession.StartWorkGroupSession(wg);
}
catch (Exception ex)
{
workGroupSession = null;
}
}
public void OpenConnection()
{
ccdLogin login = new ccdLogin();
if (login.DoLogin())
{
try
{
Session = login.Session;
SysSession = new SCBWflSession();
SysSession.ConnectServer(Session.HostName, Session.PortNo);
SysSession.SystemLogin(c_APP_CODE, 0);
}
catch (Exception ex)
{
Console.WriteLine("OpenDOMEA Session: " + ex.Message);
System.Environment.Exit(0);
}
}
else
{
System.Environment.Exit(0);
}
}
public bool moveWorkItem(int igz, int workGroupID, int destFolderID, out string message)
{
message = "";
try
{
if (igz > 0)
{
SCBWflFolder folder = null;
if (allFolders.Count > 0)
{
folder = allFolders.Find(f => f.ID.ToLong(IDType.wflLocalKey) == destFolderID);
}
if (folder == null)
{
workGroupSession = getWorkGroupSession(workGroupID);
if (workGroupSession != null)
{
folder = FindFolder(workGroupSession.WorkList, destFolderID);
stopWorkGroupSession();
if (folder != null)
{
allFolders.Add(folder);
}
}
else
{
message = "WorkGroupSession is null: " + workGroupID;
}
}
if (folder != null)
{
//System.Windows.Forms.MessageBox.Show(folder.Name + " (" + folder.ID.ToLong(IDType.wflLocalKey) + ")" + " " + destFolderID);
Console.WriteLine(folder.Name + " (" + folder.ID.ToLong(IDType.wflLocalKey) + ")" + " " + destFolderID);
SCBWflProcessInstance pi = sysSession.System.GetProcessInstanceByID(sysSession.System.NewIDByLocalKey(igz));
SCBWflWorkItem wi = pi.GetWorkItems().Item(1);
if (wi.GetCurrentActor().ID.ToLong(IDType.wflLocalKey) == workGroupID)
{
pi.SetLock(LockTypeOfProcInst.wflProcInstWhole);
wi.MoveToFolder(folder);
pi.ReleaseLock(LockTypeOfProcInst.wflProcInstWhole);
return(true);
}
else
{
message = "Aktueller Benutzer stimmt nicht mit Arbeitsgruppe überein! CurrentActor: " + wi.GetCurrentActor().ID.ToLong(IDType.wflLocalKey) + " WorkGroupID: " + workGroupID;
return(false);
}
}
else
{
return(false);
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine("IGZ: " + igz + ": " + ex.Message);
message = "IGZ: " + igz + ": " + ex.Message;
return(false);
}
}
public DomeaHelper(SCBWflSession _sysSession)
{
sysSession = _sysSession;
allFolders = new List <SCBWflFolder>();
}
public frmMain()
{
InitializeComponent();
assem = typeof(frmMain).Assembly;
Console.Title = assem.FullName;
CCDGUI.ccdLogin login = new CCDGUI.ccdLogin();
if (login.DoLogin())
{
try
{
Console.WriteLine("\n...KONFIGURATION WIRD GELADEN...");
logger = new Logger();
logger.Filename = string.Format("{0}{1}_{2}.csv", AppDomain.CurrentDomain.BaseDirectory, System.Diagnostics.Process.GetCurrentProcess().ProcessName, DateTime.Now.ToString("yyyyMMddhhmmss"));
Cursor.Current = Cursors.WaitCursor;
sysSession = new SCBWflSession();
sysSession.ConnectServer(login.Session.HostName, login.Session.PortNo);
sysSession.SystemLogin(APP_CODE, PRODUCT_ID);
lblDOMEAConnection.Text = sysSession.HostName + ";" + sysSession.PortNo;
ora = new OracleHelper(DomeaConfiguration.GetOracleConnectionString(sysSession));
ora.OpenConnection();
dgvBIG_FOLDER_RESTORE_TMP.DataSource = bindingSource1;
/*
* string stmt = "select distinct f.tmp_ID ID, g.igz, g.gz, f.wgnr, f.wgname, f.PFAD_GESAMT, f.folderbez, f.FOLDERNR, f.VATER_FOLDERBEZ, f.PATH STATUS " +
* "from BIG_FOLDER_RESTORE_TMP f, gst g " +
* "where f.foldernr >= 0 " +
* "and g.gz = f.gz " +
* "and f.wgnr = f.usernr " +
* //"order by f.pfad_gesamt";
* "order by f.tmp_ID";
*
* string stmt = "select distinct f.tmp_ID ID, g.igz, g.gz, f.wgnr, f.wgname, f.PFAD_GESAMT, f.PFAD, f.folderbez, f.FOLDERNR, f.VATER_FOLDERBEZ, f.PATH STATUS, " +
* "m.DESTINATION_ID, m.DESTINATION_NAME, m.DESTINATION_NAME || '\' || f.PFAD PFAD_NEU " +
* "from BIG_FOLDER_RESTORE_TMP f, gst g, V_BIG_WORKGROUP_OLD_NEW m " +
* "where f.foldernr >= 0 " +
* "and g.gz = f.gz " +
* "and f.wgnr = f.usernr " +
* "and m.source_id = f.wgnr " +
* "order by f.tmp_ID";
*/
string stmt = "select distinct f.tmp_ID ID, g.igz, g.gz, f.wgnr, f.wgname, f.PFAD_GESAMT, f.PFAD, f.folderbez, f.FOLDERNR, f.VATER_FOLDERBEZ, f.PATH STATUS, " +
"m.DESTINATION_ID, m.DESTINATION_NAME, m.DESTINATION_NAME || '\\' || f.PFAD PFAD_NEU " +
"from BIG_FOLDER_RESTORE_TMP f, gst g, V_BIG_WORKGROUP_OLD_NEW m " +
"where trim(f.path) is null " + // nur solche die noch nicht verarbeitet wurden
"and f.foldernr >= 0 " +
"and g.gz = f.gz " +
"and f.wgnr = f.usernr " +
"and m.source_id = f.wgnr " +
"order by f.tmp_ID";
//bindingSource1.DataSource = ora.GetData(stmt);
//dgvBIG_FOLDER_RESTORE_TMP.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(dgvBIG_FOLDER_RESTORE_TMP_DataBindingComplete);
dgvBIG_FOLDER_RESTORE_TMP.DataSource = ora.GetData(stmt);
DataCount = dgvBIG_FOLDER_RESTORE_TMP.Rows.Count;
Tab2Loaded = false;
Cursor.Current = Cursors.Default;
}
catch (Exception ex)
{
Cursor.Current = Cursors.Default;
MessageBox.Show(ex.Message);
this.Close();
}
}
else
{
this.Close();
}
}
