// constructor
public U2DictReader(UniSession uSession, string fileName)
{
_uSession = uSession;
try
{
uFile = _uSession.CreateUniDictionary(fileName);
usl = _uSession.CreateUniSelectList(0);
usl.Select(uFile);
string[] keys = usl.ReadListAsStringArray();
_uds = uFile.ReadRecords(keys);
}
catch (UniSessionException e) // unisession file not exists
{
if (e.ErrorCode == 14002)
{
Console.WriteLine("U2 file not found");
}
else
{
// dont know, so rethrow
throw;
}
}
}
// constructor
public U2DataReader(UniSession uSession, string fileName)
{
_uSession = uSession;
try
{
uFile = _uSession.CreateUniFile(fileName);
UniCommand uCmd = _uSession.CreateUniCommand();
uCmd.Command = string.Format("SELECT {0} BY @ID SAMPLED 100", uFile.FileName);
uCmd.Execute();
usl = _uSession.CreateUniSelectList(0);
_keySample = usl.ReadListAsStringArray();
RecordsAffected = 0;
}
catch (UniSessionException e) // unisession file not exists
{
if (e.ErrorCode == 14002)
{
Console.WriteLine("U2 file not found");
}
else
{
// dont know, so rethrow
throw;
}
}
}
static void Main(string[] args)
{
try
{
U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder();
conn_str.UserID = "user";
conn_str.Password = "******";
conn_str.Server = "localhost";
conn_str.Database = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "udcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
// get RECID
UniSession us1 = con.UniSession;
UniSelectList sl = us1.CreateUniSelectList(2);
// Select UniFile
UniFile fl = us1.CreateUniFile("STUDENT");
sl.Select(fl);
bool lLastRecord = sl.LastRecordRead;
while (!lLastRecord)
{
string s2 = sl.Next();
Console.WriteLine("Record ID:" + s2);
lLastRecord = sl.LastRecordRead;
}
con.Close();
}
catch (Exception e)
{
string s = e.Message;
if (e.InnerException != null)
{
s += e.InnerException.Message;
}
Console.WriteLine(s);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
static void Main(string[] args)
{
try
{
U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder();
conn_str.UserID = "user";
conn_str.Password = "******";
conn_str.Server = "localhost";
conn_str.Database = "HS.SALES";
conn_str.ServerType = "UNIVERSE";
conn_str.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "uvcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
// get RECID
UniSession us1 = con.UniSession;
UniSelectList sl = us1.CreateUniSelectList(2);
// Select UniFile
UniFile fl = us1.CreateUniFile("CUSTOMER");
sl.Select(fl);
bool lLastRecord = sl.LastRecordRead;
List <string> lRecIdList = new List <string>();
while (!lLastRecord)
{
string sRecID = sl.Next();
lRecIdList.Add(sRecID);
Console.WriteLine("Record ID:" + sRecID);
lLastRecord = sl.LastRecordRead;
}
UniDataSet uSet = fl.ReadRecords(lRecIdList.ToArray());
// use for each statement to print the record
foreach (UniRecord item in uSet)
{
Console.WriteLine(item.ToString());
}
con.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
public static CssFileResult GetData(AccountList list, CssAccountFile file, CssCredentials cssCredentials)
{
var lHostName = cssCredentials.Hostname;
var lAccount = cssCredentials.Account;
var lUser = cssCredentials.User;
var lPassword = cssCredentials.UserPassword;
var lServiceType = cssCredentials.ServiceType;
var response = new CssFileResult();
var fileResults = new CssFile {
FileName = list.AccountListName
};
UniSession us = null;
try
{
//get the session object
us = UniObjects.OpenSession(lHostName, lUser, lPassword, lAccount, lServiceType);
// create select list
UniSelectList selectList = us.CreateUniSelectList(2);
selectList.GetList(list.AccountListName);
// read records using array of records ids
var ids = selectList.ReadListAsStringArray();
//open file
UniFile cssFile = us.CreateUniFile(file.FileName);
var lSet = cssFile.ReadRecords(ids);
//var dict = us.CreateUniDictionary(file.FileName);
//var field1 = dict.ReadField(1);
//use foreach statement to construct data to be displayed
foreach (UniRecord item in lSet)
{
var record = new CssRecord(item.RecordID, "");
var numFields = item.Record.Dcount();
for (int i = 0; i < numFields; i++)
{
var field = item.Record.Extract(i);
var valuesCount = field.Dcount();
if (valuesCount > 1)
{
throw new Exception("This field has sub-values" + field);
}
record.Fields.Add(new CssField(i.ToString(), field.ToString()));
}
fileResults.Records.Add(record);
}
response.FileContents = fileResults;
return(response);
}
catch (Exception ex)
{
response.CssResponses.Results.Add(new CommandResponse("Exception", ex.ToString()));
}
finally
{
if (us != null && us.IsActive)
{
UniObjects.CloseSession(us);
}
}
response.CssResponses.Results.Add(new CommandResponse("Error", "There was an error procesing your request."));
return(response);
}
static void Main(string[] args)
{
try
{
U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder();
conn_str.UserID = "user";
conn_str.Password = "******";
conn_str.Server = "localhost";
conn_str.Database = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "udcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
UniSession us1 = con.UniSession;
UniSelectList sl = us1.CreateUniSelectList(2);
// Select UniFile
UniFile fl = us1.CreateUniFile("STUDENT");
sl.Select(fl);
// read records as unidataset
string[] sArray = { "291222021", "521814564", "424325656" };
UniDataSet uSet = fl.ReadRecords(sArray);
// use for each statement to print the record
foreach (UniRecord item in uSet)
{
Console.WriteLine(item.ToString());
}
// use index to print the record
int lCount = uSet.RowCount;
for (int ii = 0; ii < lCount; ii++)
{
UniRecord ee = uSet[ii];
Console.WriteLine(ee.ToString());
}
// print one by one record
UniRecord q2 = uSet["291222021"];
string sq2 = q2.ToString();
Console.WriteLine(" Record data for rec id 291222021:" + sq2);
UniRecord q3 = uSet["521814564"];
string sq3 = q3.ToString();
Console.WriteLine(" Record data for rec id 521814564:" + sq3);
UniRecord q4 = uSet["424325656"];
string sq4 = q4.ToString();
Console.WriteLine(" Record data for rec id 424325656:" + sq4);
//create UniDataSet in the Client Side
UniDataSet uSet3 = us1.CreateUniDataSet();
uSet3.Insert("3", "aaa");
uSet3.Insert("4", "bbb");
uSet3.Insert("5", "vvv");
uSet3.Insert(2, "8", "www");
con.Close();
}
catch (Exception e)
{
string s = e.Message;
if (e.InnerException != null)
{
s += e.InnerException.Message;
}
Console.WriteLine(s);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
static void Main(string[] args)
{
bool debug = Properties.Settings.Default.Verbose;
U2Conn srcConn = new U2Conn();
SqlConn destConn = new SqlConn();
srcConn.Host = Properties.Settings.Default.U2Host; // "pmsteel.kwyk.net";
srcConn.Login = Properties.Settings.Default.U2Login; // "administrator";
srcConn.Password = Properties.Settings.Default.U2Password; // "H!carb0n";
srcConn.Catalog = Properties.Settings.Default.U2Account; // "C:\\BAI.PROD\\PM";
destConn.Host = Properties.Settings.Default.SqlHost; // "pmsteel.kwyk.net";
destConn.Login = Properties.Settings.Default.SqlLogin; // "pmsteel";
destConn.Password = Properties.Settings.Default.SqlPassword; // "H!carb0n";
destConn.Catalog = Properties.Settings.Default.SqlDatabase; // "pmsteel"
/*
try
{
srcConn.Connect();
destConn.Connect();
srcConn.Disconnect();
destConn.Disconnect();
}
catch (Exception e)
{
debugPrint(true, "Error: " + e);
}
*/
String sqlStmt = "";
try
{
// every thing runs out of the UniSession instance.
UniSession uSession = null;
//Set up variables.
uSession = UniObjects.OpenSession(Properties.Settings.Default.U2Host, Properties.Settings.Default.U2Login,
Properties.Settings.Default.U2Password, Properties.Settings.Default.U2Account);
debugPrint(debug, "U2 openSession succeeded\n");
debugPrint(debug, "Status = " + uSession.Status + "\n");
//Class.forName("net.sourceforge.jtds.jdbc.Driver");
//Connection conn = DriverManager.getConnection(sqlJdbcUrl, sqlUser, sqlPass);
//debugPrint(debug, "SQL Server connection succeeded");
//Statement stmt = conn.createStatement();
UniFile uf = uSession.CreateUniFile(Properties.Settings.Default.U2File);
debugPrint(debug, Properties.Settings.Default.U2File + " file opened\n");
//debugPrint(debug, uf.ToString());
UniSelectList usl = uSession.CreateUniSelectList(8);
StreamWriter sw = new StreamWriter(@"c:\temp\u2rl.xml");
usl.Select(uf);
while (!usl.LastRecordRead)
{
String key = usl.Next();
debugPrint(debug, "key: " + key + "\n");
if (key != "")
{
XElement xd = new XElement("data");
XElement xd2 = new XElement("data");
UniDynArray udaRow = uf.Read(key);
int v2 = 0;
int s2 = 1;
while (s2 > 0)
{
XElement xv2 = new XElement("val", new XAttribute("loc", s2));
s2 = 0;
for (int f2 = 1; f2 <= udaRow.Dcount(); f2++)
{
if ( s2 <= udaRow.Dcount(f, v))
{
XElement xf2 = new XElement("fld", new XAttribute("loc", f2));
string fld = udaRow.Extract(f2, v2).ToString();
if ("" != fld)
{
}
}
}
for (int f = 1; f <= udaRow.Dcount(); f++)
{
XElement xf = new XElement("fld", new XAttribute("loc", f));
string fld = udaRow.Extract(f).ToString();
if ("" != fld)
{
for (int v = 1; v <= udaRow.Dcount(f); v++)
{
XElement xv = new XElement("val", new XAttribute("loc", v));
string val = udaRow.Extract(f, v).ToString();
if ("" != val)
{
for (int s = 1; s <= udaRow.Dcount(f, v); s++)
{
xv.Add(new XElement("sub", new XAttribute("loc", s), udaRow.Extract(f, v, s).ToString()));
}
}
xf.Add(xv);
}
}
xd.Add(xf);
}
XElement xr = new XElement("row", new XElement("id", key), xd);
sqlStmt = "INSERT INVF(u2_id, u2_data) VALUES ('" + key.Replace("'", "''") + "', '" + xd.ToString().Replace("'", "''") + "')";
sw.WriteLine(xr);
}
}
sw.Close();
//UniDynArray udaRow = uSession.CreateUniDynArray(usl.Next());
//debugPrint(debug, usl.readList().ToString());
//while (!usl.IsLastRecordRead)
//while (null != udaRow)
//{
//String usKey = udaRow.Extract(1).ToString();
//Properties.Settings.Default.SqlTable = usKey;
//debugPrint(debug, "key: " + usKey + "\n");
//debugPrint(debug, usKey.ToString() + ": " + Properties.Settings.Default.SqlTable);
//sqlStmt = "IF EXISTS (SELECT * FROM sys.tables WHERE OBJECT_ID('dbo.[" + Properties.Settings.Default.SqlTable + "]') IS NOT NULL) DROP TABLE dbo.[" + Properties.Settings.Default.SqlTable + "]";
//debugPrint(debug, sqlStmt);
//stmt.executeUpdate(sqlStmt);
//sqlStmt = "CREATE TABLE dbo.[" + Properties.Settings.Default.SqlTable + "] (ID varchar(255) NOT NULL,LOC smallint NOT NULL,SEQ smallint NOT NULL,VAL varchar(8000) NOT NULL)";
//debugPrint(debug, sqlStmt);
//stmt.executeUpdate(sqlStmt);
//{{ int valIdx = 1; int fldIdx = 1;
//for (int fldIdx = 1; fldIdx <= udaRow.Dcount(); fldIdx++)
//{
// debugPrint(debug, "field: " + udaRow.Extract(fldIdx).ToString());
// for (int valIdx = 1; valIdx <= udaRow.dcount(fldIdx); valIdx++)
// {
// UniString usValue = udaRow.extract(fldIdx, valIdx);
// debugPrint(debug, usValue.ToString());
// }
//}
//UniFile ufTblFile = uSession.open(usKey);
//debugPrint(debug, "file opened");
////debugPrint(debug, usKey.ToString());
//UniSelectList uslTblList = uSession.selectList(2);
//uslTblList.select(ufTblFile);
//UniString usTblKey = uslTblList.next();
//int cnt = 0;
//while (!uslTblList.isLastRecordRead())
//{
// if (cnt++ % 1000 == 0) debugPrint(debug, "rows: " + cnt);
// //debugPrint(debug, usTblKey.ToString());
// UniDynArray udaTblRow = new UniDynArray(ufTblFile.read(usTblKey));
// for (int fldTblIdx = 1; fldTblIdx <= udaTblRow.dcount(); fldTblIdx++)
// {
// for (int valTblIdx = 1; valTblIdx <= udaTblRow.dcount(fldTblIdx); valTblIdx++)
// {
// UniString usTblValue = udaTblRow.extract(fldTblIdx, valTblIdx);
// //debugPrint(debug, usTblValue.ToString());
// sqlStmt = "INSERT [" + Properties.Settings.Default.SqlTable + "] VALUES ('" + usTblKey.ToString().replace("'", "''") + "', " + fldTblIdx + ", " + valTblIdx + ", '" + usTblValue.ToString().replace("'", "''") + "')";
// //debugPrint(debug, sqlStmt);
// //stmt.executeUpdate(sqlStmt);
// }
// }
// usTblKey = uslTblList.next();
//}
//udaRow = uSession.CreateUniDynArray(usl.Next());
//}
/*
udaKeys = usl.readList();
//UniDynArray udaValues;
sqlStmt = "TRUNCATE TABLE [" + Properties.Settings.Default.SqlTable + ']';
debugPrint(debug, sqlStmt);
stmt.executeUpdate(sqlStmt);
for (int keyIdx = 1;keyIdx < udaKeys.count();keyIdx++) {
usKey = udaKeys.extract(keyIdx);
debugPrint(debug, usKey.ToString());
if (usKey.length() > 0) {
debugPrint(debug, udaKeys.count() + " " + usKey + usKey.length() + " " + keyIdx);
sqlStmt = "INSERT [" + Properties.Settings.Default.SqlTable + "] VALUES ('" + usKey + "', 0, 1, '" + usKey + "')";
debugPrint(debug, sqlStmt);
stmt.executeUpdate(sqlStmt);
udaRow = new UniDynArray(uf.read(usKey));
for (int fldIdx = 1; fldIdx <= udaRow.dcount(); fldIdx++) {
//usField = udaRow.extract(fldIdx) ;
//udaValues = new UniDynArray(usField);
for (int valIdx = 1; valIdx <= udaRow.dcount(fldIdx); valIdx++) {
usValue = udaRow.extract(fldIdx, valIdx) ;
if (usValue.length() > 0) {
//debugPrint(debug, fldIdx + " " + valIdx + " -->" + usValue + "<--");
sqlStmt = "INSERT [" + Properties.Settings.Default.SqlTable+ "] VALUES ('" + usKey + "', " + fldIdx + ", " + valIdx + ", '" + usValue.ToString().replace("'", "''") + "')";
debugPrint(debug, sqlStmt);
stmt.executeUpdate(sqlStmt);
}
}
}
}
//debugPrint(debug, udaKeys.extract(keyIdx));
}
*/
uf.Close();
debugPrint(debug, Properties.Settings.Default.U2File + " file closed\n");
// did we connect?
debugPrint(debug, "U2 Disconnected\n");
//conn.close();
//debugPrint(debug, "SQL Disconnected.");
}
catch (UniSessionException e)
{
debugPrint(debug, "Error: " + e);
}
catch (UniFileException e)
{
debugPrint(debug, "File Error: " + e);
}
catch (UniSelectListException e)
{
// TODO Auto-generated catch block
debugPrint(debug, "File Error: " + e);
}
Console.ReadKey();
}
public bool Read()
{
if (_keySample == null)
{
return(false);
}
if ((_blockIdx > _keySample.Length) || (Limit > 0 && RecordsAffected >= Limit))
{
return(false);
}
if (0 == _rowIdx)
{
UniCommand uCmd = _uSession.CreateUniCommand();
_keyBlock = null;
while (_keyBlock == null)
{
uCmd.Command = string.Format("SELECT {0} BY @ID", uFile.FileName);
if (_blockIdx > 0)
{
uCmd.Command += string.Format(" WITH @ID >= \"{0}\"",
_keySample[_blockIdx - 1].Replace("\"", "\"\""));
}
if (_blockIdx < _keySample.Length)
{
if (_blockIdx > 0)
{
uCmd.Command += " AND ";
}
else
{
uCmd.Command += " WITH ";
}
uCmd.Command += string.Format("@ID < \"{0}\"", _keySample[_blockIdx].Replace("\"", "\"\""));
}
uCmd.Execute();
usl = _uSession.CreateUniSelectList(0);
_keyBlock = usl.ReadListAsStringArray();
if (_keyBlock == null)
{
_blockIdx++;
}
}
// Console.Write(_keyBlock.ToString());
_uds = uFile.ReadRecords(_keyBlock);
}
if (_rowIdx < _keyBlock.Length)
{
_row.Clear();
_row.Add(_keyBlock[_rowIdx]);
_row.Add(_uds.GetRecord(_rowIdx).Record.ToString());
_rowIdx++;
if (_rowIdx == _keyBlock.Length)
{
_rowIdx = 0;
_blockIdx++;
}
}
RecordsAffected++;
return(true);
/*
* try
* {
*
* if (0 == i)
* value = key;
* else
* {
* var fld = udaRow.Extract(i).ToString();
* if ("" != fld)
* {
* var xf = new XElement("fld" / *, new XAttribute("loc", i) * /);
* for (var v = 1; v <= udaRow.Dcount(i); v++)
* {
* / *
* XElement xv = new XElement("val", new XAttribute("loc", v));
* string val = udaRow.Extract(i, v).ToString();
* if ("" != val)
* {
* for (int s = 1; s <= udaRow.Dcount(i, v); s++)
* {
* xv.Add(new XElement("sub", new XAttribute("loc", s), udaRow.Extract(i, v, s).ToString()));
* }
* }
* xf.Add(xv);
* /
*
* var val = udaRow.Extract(i, v).ToString();
*
*
* //replace control characters that are invalid in xml with empty string
* var re = @"[^\x09\x0A\x0D\x20-\xD7FF\xE000-\xFFFD\x10000-x10FFFF]";
* val = Regex.Replace(val, re, "");
*
* // replace text and subtext remarks with carriage return
* re = @"[\xFB\xFC]";
* val = Regex.Replace(val, re, "\n");
* //const string TM_CHAR = "\xFB";
* //const string SM_CHAR = "\xFC";
* //val.Replace(SM_CHAR, "\n");
* //val.Replace(TM_CHAR, "\n");
*
* xf.Add(new XElement("val", new XAttribute("loc", v), val));
* }
* value = xf.ToString();
* }
* }
* }
* catch (Exception e)
* {
* Console.WriteLine(e.ToString());
* }
* if (null == value)
* return DBNull.Value;
* else
* return value;
* */
}