private void Form1_Load(object sender, System.EventArgs e)
{
if (fid > maxfid)
{
Console.WriteLine("fid " + fid + " loaded at " + DateTime.Now);
}
if (fid > maxloaded)
{
maxloaded = fid;
}
if (fid != 1)
{
UserChoice();
}
else
{
try
{
var s = conn.ExecuteQuery("select count(W_ID) from WAREHOUSE");
activewh = (int)s.items[0].fields[0].Value;
textBox1.Text = "" + activewh;
// deferred = new Thread(new ThreadStart(new Deferred(db,wid).Run));
// deferred.Name = "Deferred";
// deferred.Start();
StrongConnect.OpenRequests();
}
catch (Exception)
{
}
}
}
internal ClientStream(StrongConnect pc, Socket c)
{
client = c;
wtr = new ClientWriter(client);
rdr = new ClientReader(client);
rdr.buf.pos = 2;
rdr.buf.len = 0;
}
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
Control.CheckForIllegalCrossThreadCalls = false;
conn = new StrongConnect("127.0.0.1", 50433, "Tpcc");
}
public NewOrder(StrongConnect c, int w)
{
db = c;
wid = w;
//
// Required for Windows Form Designer support
//
InitializeComponent();
VTerm vt1 = this;
Width = vt1.Width;
Height = vt1.Height + 50;
vt1.Put(36, 1, "New Order");
vt1.Put(1, 2, "Warehouse: 9999 District: 99");
vt1.Put(55, 2, "Date: DD-MM-YYYY hh:mm:ss");
vt1.Put(1, 3, "Customer: 9999 Name: XXXXXXXXXXXXXXXX Credit: XX %Disc: 99.99");
vt1.Put(1, 4, "Order Number: 99999999 Number of Lines: 99");
vt1.Put(52, 4, "W_tax: 99.99 D_tax: 99.99");
vt1.Put(2, 6, "Supp_W Item_Id Item Name");
vt1.Put(45, 6, "Qty Stock B/G Price Amount");
for (int j = 7; j <= 21; j++)
{
vt1.Put(3, j, "9999 999999 XXXXXXXXXXXXXXXXXXXXXXXX 99 999 X $999.99 $9999.99");
}
vt1.Put(1, 22, "Execution Status: XXXXXXXXXXXXXXXXXXXXXXXX");
vt1.Put(62, 22, "Total: $99999.99");
vt1.AddField(12, 2, 4);
vt1.AddField(29, 2, 2, true);
vt1.AddField(12, 3, 4, true);
vt1.AddField(25, 3, 16);
vt1.AddField(52, 3, 2);
vt1.AddField(64, 3, 5);
vt1.AddField(15, 4, 8);
vt1.AddField(42, 4, 2, true);
vt1.AddField(59, 4, 5);
vt1.AddField(74, 4, 5);
for (int k = 7; k <= 21; k++)
{
vt1.AddField(3, k, 4, true);
vt1.AddField(10, k, 6, true);
vt1.AddField(19, k, 24);
vt1.AddField(45, k, 2, true);
vt1.AddField(51, k, 3);
vt1.AddField(58, k, 1);
vt1.AddField(62, k, 7);
vt1.AddField(71, k, 8);
}
vt1.AddField(19, 22, 24);
vt1.AddField(70, 22, 9);
vt1.AddField(61, 2, 19);
vt1.PutBlanks();
}
Program(string[] args)
{
conn = new StrongConnect("127.0.0.1", 50433, "testdb");
if (args.Length >= 2)
{
test = int.Parse(args[0]);
qry = int.Parse(args[1]);
}
if (args.Length == 3)
{
commit = true;
}
}
private void button4_Click(object sender, EventArgs e)
{
if (checkBox1.Checked)
{
int d = int.Parse(textBox4.Text);
conn = new StrongConnect("localhost", 50433, "Tpcc");
new GenBase().FillDistrict(int.Parse(textBox1.Text), d);
}
else
{
new GenBase().FillDistricts(int.Parse(textBox1.Text));
}
}
public Delivery(StrongConnect c, int w)
{
db = c;
wid = w;
//
// Required for Windows Form Designer support
//
InitializeComponent();
Put(38, 1, "Delivery");
Put(1, 2, "Warehouse: ");
AddField(12, 2, 4);
Put(1, 4, "Carrier Number:");
AddField(17, 4, 2, true);
Put(1, 6, "Execution Status:");
AddField(19, 6, 24);
}
public DelReport(StrongConnect c, int w)
{
db = c;
wid = w;
// This call is required by the Windows.Forms Form Designer.
InitializeComponent();
Put(34, 1, "Delivery Report");
Put(1, 2, "Warehouse: ");
AddField(12, 2, 4);
Put(1, 4, "Carrier Number:");
AddField(17, 4, 2, true);
Put(1, 6, "No of Deliveries:");
AddField(26, 6, 4);
Put(1, 7, "No of Districts Skipped:");
AddField(26, 7, 4);
}
static void Show(StrongConnect c, DocArray da)
{
List <Column> cols = new List <Column>(); // of Column
SDict <string, int> names = SDict <string, int> .Empty;
SDict <int, SDict <string, string> > rows = SDict <int, SDict <string, string> > .Empty; // of string[]
for (var b = c.description.First(); b != null; b = b.Next())
{
names = names + (b.Value.Item2, b.Value.Item1);
cols.Add(new Column(b.Value.Item2, b.Value.Item2.Length));
}
for (int i = 0; i < da.items.Count; i++)
{
var dc = da[i];
var row = SDict <string, string> .Empty;
for (var j = 0; j < dc.fields.Count; j++)
{
var f = dc.fields[j];
if (f.Key.StartsWith("_"))
{
continue;
}
if (!names.Contains(f.Key))
{
throw new Exception("Unexpected column " + f.Key);
}
var k = names.Lookup(f.Key);
var s = f.Value.ToString();
if (s.Length > cols[k].width)
{
cols[k].width = s.Length;
}
row = row + (f.Key, s);
}
rows = rows + (rows.Length.Value, row);
}
DrawLine(cols);
ShowHeads(cols);
DrawLine(cols);
for (var j = 0; j < rows.Length.Value; j++)
{
ShowRow(rows.Lookup(j), cols);
}
DrawLine(cols);
}
public StockLevel(StrongConnect c, int w)
{
db = c;
wid = w;
//
// Required for Windows Form Designer support
//
InitializeComponent();
Put(36, 1, "Stock-Level");
Put(1, 2, "Warehouse: District:");
AddField(12, 2, 4);
AddField(29, 2, 2);
Put(1, 4, "Stock Level Threshold:");
AddField(24, 4, 2, true);
Put(1, 6, "low stock:");
AddField(12, 6, 3);
AddField(18, 6, 1, true);
}
public OrderStatus(StrongConnect c, int w)
{
db = c;
wid = w;
//
// Required for Windows Form Designer support
//
InitializeComponent();
VTerm vt1 = this;
Width = vt1.Width;
Height = vt1.Height + 50;
vt1.Put(36, 1, "Order-Status");
vt1.Put(1, 2, "Warehouse: 9999 District: 99");
vt1.AddField(12, 2, 4);
vt1.AddField(29, 2, 2, true);
vt1.Put(1, 3, "Customer: 9999 Name: ");
vt1.AddField(11, 3, 4, true);
vt1.AddField(24, 3, 16);
vt1.AddField(41, 3, 2);
vt1.AddField(44, 3, 16, true);
vt1.Put(1, 4, "Cust-Balance: ");
vt1.AddField(16, 4, 9);
vt1.Put(1, 6, "Order-Number: 99999999 Entry-Date: DD-HH-YYY hh:mm:ss Carrier-Number: 99");
vt1.AddField(15, 6, 8);
vt1.AddField(38, 6, 18);
vt1.AddField(75, 6, 2);
vt1.Put(1, 7, "Supply-W Item-Id Qty Amount Delivery-Date");
for (int j = 8; j <= 22; j++)
{
vt1.AddField(3, j, 4);
vt1.AddField(14, j, 6);
vt1.AddField(25, j, 2);
vt1.AddField(33, j, 9);
vt1.AddField(48, j, 10);
}
vt1.AddField(79, 22, 1, true);
vt1.PutBlanks();
}
static void Main(string[] args)
{
try
{
conn = new StrongConnect("127.0.0.1", 50433, "testdb");
if (args.Length >= 2)
{
test = int.Parse(args[0]);
qry = int.Parse(args[1]);
}
if (args.Length == 3)
{
commit = true;
}
new Program().Tests();
}
catch (Exception e)
{
Console.WriteLine("Exception: " + e.Message);
}
Console.WriteLine("Testing complete");
Console.ReadLine();
}
static void Main(string[] args)
{
conn = new StrongConnect("127.0.0.1", 50433, "Tpcc");
new Program().BuildTpcc();
}
public Payment(StrongConnect c, int w)
{
db = c;
wid = w;
//
// Required for Windows Form Designer support
//
InitializeComponent();
VTerm vt1 = this;
Width = vt1.Width;
Height = vt1.Height + 50;
vt1.Put(38, 1, "Payment");
vt1.Put(1, 2, "Date: DD-MM-YYYY hh:mm:ss");
vt1.Put(1, 4, "Warehouse: 9999");
vt1.AddField(12, 4, 4);
// vt1.Put(1,5,new string('X',20));
vt1.AddField(1, 5, 20);
// vt1.Put(1,6,new string('X',20));
vt1.AddField(1, 6, 20);
// vt1.Put(1,7,new string('X',20));
vt1.AddField(1, 7, 20);
vt1.Put(22, 7, "XX XXXXX-XXXX");
vt1.AddField(22, 7, 2);
vt1.AddField(25, 7, 5);
vt1.AddField(31, 7, 4);
vt1.Put(42, 4, "District: 99");
vt1.AddField(52, 4, 2, true); //7
// vt1.Put(42,5,new string('X',20));
vt1.AddField(42, 5, 20);
// vt1.Put(42,6,new string('X',20));
vt1.AddField(42, 6, 20);
// vt1.Put(42,7,new string('X',20));
vt1.AddField(42, 7, 20);
vt1.Put(64, 7, "XX XXXXX-XXXX");
vt1.AddField(64, 7, 2);
vt1.AddField(67, 7, 5);
vt1.AddField(73, 7, 4);
vt1.Put(1, 9, "Customer: 9999 Cust-Warehouse: 9999 Cust-District: 99");
vt1.AddField(11, 9, 4, true); // 14
vt1.AddField(33, 9, 4, true); // 15
vt1.AddField(54, 9, 2, true); // 16
vt1.Put(1, 10, "Name:");
// vt1.Put(9,10,new string('X',16));
vt1.AddField(9, 10, 16);
// vt1.Put(26,10,new string('X',2));
vt1.AddField(26, 10, 2);
// vt1.Put(29,10,new string('X',16));
vt1.AddField(29, 10, 16, true); // 19
// vt1.Put(9,11,new string('X',20));
vt1.AddField(9, 11, 20);
// vt1.Put(9,12,new string('X',20));
vt1.AddField(9, 12, 20);
// vt1.Put(9,13,new string('X',20));
vt1.AddField(9, 13, 20);
vt1.Put(30, 13, "XX XXXXX-XXXX");
vt1.AddField(30, 13, 2);
vt1.AddField(33, 13, 5);
vt1.AddField(39, 13, 4);
vt1.Put(50, 10, "Since: DD-MM-YYYY");
vt1.AddField(58, 10, 2);
vt1.AddField(61, 10, 2);
vt1.AddField(64, 10, 4);
vt1.Put(50, 11, "Credit: XX");
vt1.AddField(58, 11, 2);
vt1.Put(50, 12, "%Disc: 99.99");
vt1.AddField(58, 12, 5);
vt1.Put(50, 13, "Phone: XXXXXX-XXX-XXX-XXXX");
vt1.AddField(58, 13, 6);
vt1.AddField(65, 13, 3);
vt1.AddField(69, 13, 3);
vt1.AddField(73, 13, 4);
vt1.Put(1, 15, "Amount Paid:");
vt1.Put(23, 15, "$9999.99");
vt1.AddField(24, 15, 7, true); // 35
vt1.Put(36, 15, "New-Cust-Balance: $-9999999999.99");
vt1.AddField(55, 15, 14);
vt1.Put(1, 16, "Credit Limit: $9999999999.99");
vt1.AddField(18, 16, 13);
vt1.Put(1, 18, "Cust-Data:");
// vt1.Put(12,18,new string('X',50));
vt1.AddField(12, 18, 50);
// vt1.Put(12,19,new string('X',50));
vt1.AddField(12, 19, 50);
// vt1.Put(12,20,new string('X',50));
vt1.AddField(12, 20, 50);
// vt1.Put(12,21,new string('X',50));
vt1.AddField(12, 21, 50);
vt1.AddField(7, 2, 20);
vt1.AddField(75, 21, 1, true);
vt1.PutBlanks();
}
bool Check(StrongConnect c)
{
return(false);
}
public Deferred(int w)
{
db = new StrongConnect("127.0.0.1", 50433, "Tpcc");
wid = w;
}
static void Main(string[] args)
{
string str = "Temp";
string host = "127.0.0.1";
string port = "50433";
string line = "";
Exception lasterr = null;
bool interactive = true;
Link stack = null;
StreamReader file = null;
bool newfile = false;
string files = "";
int k = 0;
while (args.Length > k)
{
if (args[k].StartsWith("-"))
{
switch (args[k][1])
{
#if (!NETCF)
case 'c': Thread.CurrentThread.CurrentUICulture = new CultureInfo(args[k].Substring(3)); break;
#endif
#if !EMBEDDED
case 'h': host = args[k].Substring(3); break;
case 'p': port = args[k].Substring(3); break;
#endif
case 'e': line = args[k].Substring(3); interactive = false; break;
case 'f':
try
{
file = new StreamReader(args[k].Substring(3));
newfile = true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return;
}
break;
}
}
else
{
files += ((files.Length > 0) ? "," : "") + args[k];
}
k++;
}
try
{
StrongConnect db = new StrongConnect(host, int.Parse(port), files);
for (bool done = false; !done; done = !interactive)
{
if (interactive)
{
if (file != null)
{
str = file.ReadLine();
if (newfile)
{
newfile = false;
}
}
else
{
if (db.inTransaction)
{
Console.Write("SQL-T>");
}
else
{
Console.Write("SQL> ");
}
str = Console.ReadLine();
}
if (str == null)
{
return;
}
str = str.Trim();
if (str.Length == 0)
{
continue;
}
// support QUIT
if (str.Length >= 4 && str.ToUpper().StartsWith("QUIT"))
{
break;
}
// support comments
if (str[0] == '/')
{
continue;
}
// support file input
if (str[0] == '@')
{
if (file != null)
{
stack = new Link(file, stack);
}
try
{
file = new StreamReader(str.Substring(1).Trim());
newfile = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
continue;
}
// support multiline SQL statements for people who don't like wraparound
if (str[0] == '[')
{
line = "";
for (; ;)
{
if (str[str.Length - 1] == ']')
{
break;
}
if (file != null)
{
line = file.ReadLine();
}
else
{
Console.Write("> ");
line = Console.ReadLine();
}
RemoveTrailingComment(ref line);
if (line == null)
{
str += "]";
break;
}
if (line.Length > 0)
{
line = line.Trim();
if (str[str.Length - 1] == '\'' && line[0] == '\'')
{
str = str.Substring(0, str.Length - 1) + line.Substring(1);
}
else
{
str += " " + line;
}
}
}
str = str.Substring(1, str.Length - 2);
}
}
else
{
str = line;
}
try
{
var strlow = str.Trim().Trim(';').ToLower();
switch (strlow)
{
case "begin":
if (db.inTransaction)
{
Console.WriteLine("Transaction already started");
continue;
}
db.BeginTransaction();
continue;
case "rollback":
if (!db.inTransaction)
{
Console.WriteLine("No current transaction");
continue;
}
db.Rollback();
continue;
case "commit":
if (!db.inTransaction)
{
Console.WriteLine("No current transaction");
continue;
}
db.Commit();
continue;
}
if (strlow.StartsWith("select"))
{
Show(db, db.ExecuteQuery(str));
}
else
{
db.ExecuteNonQuery(str);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
if (!interactive)
{
break;
}
file?.Close();
file = null;
}
}
file?.Close();
} catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
void Test10B()
{
var conn1 = new StrongConnect("127.0.0.1", 50433, "testdb");
conn1.ExecuteNonQuery("update RDC where A=42 set B='the product of 6 and 7'");
}
public GenBase(StrongConnect c)
{
conn = c;
}
public void BuildTpcc()
{
conn = Form1.conn;
CreationScript();
FillItems();
}
