public static void DongBo(System.Data.DataTable table1, Client client, Client server)
{
string mmyy = DateTime.Now.Month.ToString().PadLeft(2, '0') + DateTime.Now.Year.ToString().Substring(2, 2);
string schema = "", table = "", field = "", key = "";
Accessdata acc = new Accessdata();
foreach (System.Data.DataRow row in table1.Rows)
{
schema = row["schema"].ToString();
schema = schema.Replace("xxx", mmyy);
table = row["tablename"].ToString();
field = row["field"].ToString();
key = row["key"].ToString();
acc.Syschronise2Server(schema, table, key, field, client, server);
}
}
//public static bool XoaClient(Client client, Client server)
//{
// Accessdata acc = new Accessdata();
// return acc.XoaClient(client, server);
//}
public static void DongBo(System.Data.DataTable table1, List <Client> list, Client server, bool bprogress)
{
string mmyy = DateTime.Now.Month.ToString().PadLeft(2, '0') + DateTime.Now.Year.ToString().Substring(2, 2);
string schema = "", table = "", field = "", key = "";
frmProgressBar progress = new frmProgressBar();
if (bprogress)
{
progress.Show();
progress.Maximum = table1.Rows.Count;
progress.Step = 1;
progress.Value = 1;
}
Accessdata acc = new Accessdata();
foreach (System.Data.DataRow row in table1.Rows)
{
schema = row["schema"].ToString();
schema = schema.Replace("xxx", mmyy);
table = row["tablename"].ToString();
field = row["field"].ToString();
key = row["key"].ToString();
if (bprogress)
{
progress.Status = schema + "." + table;
progress.PerformStep();
}
for (int i = 0; i < list.Count; i++)
{
acc.Syschronise2Server(schema, table, key, field, list[i], server);
}
}
if (bprogress)
{
progress.Close();
progress.Dispose();
}
}