private void Init()
{
DateTime dt = DateTime.Now;
string line = dt.ToString();
Log(line + " INIT");
SqlSpCommand init_cmd = NewSqlSpCommand();
init_cmd.ExecuteNonQuery("DROP TABLE custmast");
init_cmd.ExecuteNonQuery("DROP TABLE custordr");
init_cmd.ExecuteNonQuery("DROP TABLE ordritem");
init_cmd.ExecuteNonQuery("DROP TABLE itemmast");
}
private void Delete_Records(String tablename)
{
DateTime dt = DateTime.Now;
string line = dt.ToString();
Log(line + "\tDelete Records...");
SqlSpCommand delete_cmd = NewSqlSpCommand();
delete_cmd.ExecuteNonQuery("DELETE FROM " + tablename);
}
private void Create_ItemMaster_Table()
{
DateTime dt = DateTime.Now;
string line = dt.ToString();
Log(line + "\ttable Item Master");
SqlSpCommand create_cmd = NewSqlSpCommand();
create_cmd.ExecuteNonQuery(
"CREATE TABLE itemmast (" +
"im_itemwght INTEGER, " +
"im_itempric MONEY, " +
"im_itemnumb CHAR(5), " +
"im_itemdesc VARCHAR(47))"
);
create_cmd.ExecuteNonQuery(
"CREATE UNIQUE INDEX im_itemnumb_idx ON itemmast (im_itemnumb)"
);
}
private void Create_OrderMaster_Table()
{
DateTime dt = DateTime.Now;
string line = dt.ToString();
Log(line + "\ttable Order Master");
SqlSpCommand create_cmd = NewSqlSpCommand();
create_cmd.ExecuteNonQuery(
"CREATE TABLE ordritem (" +
"oi_sequnumb SMALLINT, " +
"oi_quantity SMALLINT, " +
"oi_ordrnumb CHAR(6), " +
"oi_itemnumb CHAR(5))"
);
create_cmd.ExecuteNonQuery(
"CREATE UNIQUE INDEX oi_ordrnumb_idx ON ordritem (oi_ordrnumb, oi_sequnumb)"
);
create_cmd.ExecuteNonQuery(
"CREATE INDEX oi_itemnumb_idx ON ordritem (oi_itemnumb)"
);
}
private void Create_CustomerOrders_Table()
{
DateTime dt = DateTime.Now;
string line = dt.ToString();
Log(line + "\ttable CustomerOrders");
SqlSpCommand create_cmd = NewSqlSpCommand();
create_cmd.ExecuteNonQuery(
"CREATE TABLE custordr (" +
"co_ordrdate DATE, " +
"co_promdate DATE, " +
"co_ordrnumb CHAR(6), " +
"co_custnumb CHAR(4)) "
);
create_cmd.ExecuteNonQuery(
"CREATE UNIQUE INDEX co_ordrnumb_idx ON custordr (co_ordrnumb)"
);
create_cmd.ExecuteNonQuery(
"CREATE INDEX co_custnumb_idx ON custordr (co_custnumb)"
);
}
private void Create_CustomerMaster_Table()
{
DateTime dt = DateTime.Now;
string line = dt.ToString();
Log(line + "\ttable Customer Master");
SqlSpCommand create_cmd = NewSqlSpCommand();
create_cmd.ExecuteNonQuery(
"CREATE TABLE custmast (" +
"cm_custnumb CHAR(4), " +
"cm_custzipc CHAR(9), " +
"cm_custstat CHAR(2), " +
"cm_custrtng CHAR(1), " +
"cm_custname VARCHAR(47), " +
"cm_custaddr VARCHAR(47), " +
"cm_custcity VARCHAR(47))"
);
create_cmd.ExecuteNonQuery(
"CREATE UNIQUE INDEX cm_custnumb_idx ON custmast (cm_custnumb)"
);
}
private void Define()
{
DateTime dt = DateTime.Now;
string line = dt.ToString();
Log(line + " DEFINE");
SqlSpCommand create_cmd = NewSqlSpCommand();
create_cmd.ExecuteNonQuery("CREATE TABLE custmast (" +
"cm_custnumb CHAR(4), " +
"cm_custzipc CHAR(9), " +
"cm_custstat CHAR(2), " +
"cm_custrtng CHAR(1), " +
"cm_custname VARCHAR(47), " +
"cm_custaddr VARCHAR(47), " +
"cm_custcity VARCHAR(47))");
}