public void run()
{
while (state)
{
updateGUI("Start.");
this.shopList = new Dictionary<String, Shop>();
try
{
updateGUI("Getting shop ip list.");
SqlConnection connection = new SqlConnection(Properties.Settings.Default.crrhkitop);
connection.Open();
String shop_sql = @"
select store_code, store_ip, store_loginid, store_loginpw
from ShopIPAddress where store_active = 'T' order by store_code";
SqlCommand command = new SqlCommand(shop_sql, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
shopList.Add(reader[0].ToString(), new Shop(reader[1].ToString(), reader[2].ToString(), reader[3].ToString()));
}
reader.Close();
connection.Close();
}
catch (SqlException ex)
{
updateGUI(ex.Message);
stop();
}
ds = new DataSet();
dt = new DataTable();
dt.Columns.Add(new DataColumn("Shop", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("Size", Type.GetType("System.String")));
foreach (KeyValuePair<String, Shop> kvp in shopList)
{
key = kvp.Key;
shop = kvp.Value;
dr = dt.NewRow();
dr["Shop"] = key;
updateGUI("Checking " + key);
connectionString = "Provider=MSDAORA.1;Data Source=@ip;Persist Security Info=True;User ID=@id;Password=@pw;Unicode=True";
connectionString = connectionString.Replace("@ip", shop.ip + "/xe");
connectionString = connectionString.Replace("@id", shop.id);
connectionString = connectionString.Replace("@pw", shop.pw);
try
{
OleDbConnection con = new OleDbConnection(connectionString);
con.Open();
OleDbCommand command = new OleDbCommand(sizeSql, con);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
dr["Size"] = reader[0].ToString() + " MB";
}
catch (OleDbException ex)
{
updateGUI(key + " " +ex.Message);
dr["Size"] = ex.Message;
}
dt.Rows.Add(dr);
}
if (dt.Rows.Count > 0)
{
ds.Tables.Add(dt);
using (ShopDBFreeSpaceReport sdbfsr = new ShopDBFreeSpaceReport())
{
sdbfsr.setDataSet(ds);
sdbfsr.ShowDialog();
}
}
state = false;
}
}
public void run()
{
while (state)
{
updateGUI("Start.");
this.shopList = new Dictionary <String, Shop>();
try
{
updateGUI("Getting shop ip list.");
SqlConnection connection = new SqlConnection(Properties.Settings.Default.crrhkitop);
connection.Open();
String shop_sql = @"
select store_code, store_ip, store_loginid, store_loginpw
from ShopIPAddress where store_active = 'T' order by store_code";
SqlCommand command = new SqlCommand(shop_sql, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
shopList.Add(reader[0].ToString(), new Shop(reader[1].ToString(), reader[2].ToString(), reader[3].ToString()));
}
reader.Close();
connection.Close();
}
catch (SqlException ex)
{
updateGUI(ex.Message);
stop();
}
ds = new DataSet();
dt = new DataTable();
dt.Columns.Add(new DataColumn("Shop", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("Size", Type.GetType("System.String")));
foreach (KeyValuePair <String, Shop> kvp in shopList)
{
key = kvp.Key;
shop = kvp.Value;
dr = dt.NewRow();
dr["Shop"] = key;
updateGUI("Checking " + key);
connectionString = "Provider=MSDAORA.1;Data Source=@ip;Persist Security Info=True;User ID=@id;Password=@pw;Unicode=True";
connectionString = connectionString.Replace("@ip", shop.ip + "/xe");
connectionString = connectionString.Replace("@id", shop.id);
connectionString = connectionString.Replace("@pw", shop.pw);
try
{
OleDbConnection con = new OleDbConnection(connectionString);
con.Open();
OleDbCommand command = new OleDbCommand(sizeSql, con);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
dr["Size"] = reader[0].ToString() + " MB";
}
}
catch (OleDbException ex)
{
updateGUI(key + " " + ex.Message);
dr["Size"] = ex.Message;
}
dt.Rows.Add(dr);
}
if (dt.Rows.Count > 0)
{
ds.Tables.Add(dt);
using (ShopDBFreeSpaceReport sdbfsr = new ShopDBFreeSpaceReport())
{
sdbfsr.setDataSet(ds);
sdbfsr.ShowDialog();
}
}
state = false;
}
}
