private void timerData_Tick(object sender, EventArgs e)
{
if (pgInit.Value < pgInit.Maximum)
{
pgInit.Value++;
lblMsg.Text = PubComm.INIT_MSG + pgInit.Value + @"%";
}
else
{
timerData.Enabled = false;
this.Hide();
FrmShow frmShow = new FrmShow();
frmShow.ShowDialog();
}
}
private void btnchitiet_Click(object sender, EventArgs e)
{
string textname = "";
int textcount = 0;
List <TableOld> TableOld = new List <TableOld>();
List <TableNew> TableNew = new List <TableNew>();
int CountSrc = 0, CountDsc = 0;
DataSet dsdetailSrc, dsSrc, dsDsc, dsdetailDsc;
using (SqlConnection conn = new SqlConnection(GetStrConnect.GetStrDsc()))
{
conn.Open();
foreach (var tableName in table)
{
//Lấy danh sách Data
SqlDataAdapter sqlDA;
sqlDA = new SqlDataAdapter("Select zzzlvimport" + tableName.Table + ".* from zzzlvimport" + tableName.Table + " Where " + tableName.Condition, conn);
dsSrc = new DataSet();
sqlDA.Fill(dsSrc);
TableOld.Add(new TableOld
{
tableNameOld = tableName.Table,
RowsCountOld = (int)dsSrc.Tables[0].Rows.Count,
});
foreach (var item in detail)
{
if (item.ID == tableName.ID)
{
SqlDataAdapter sqlDAdetail;
string query = "Select * From zzzlvimport" + item.DetailName;
sqlDAdetail = new SqlDataAdapter(query, conn);
dsdetailSrc = new DataSet();
sqlDAdetail.Fill(dsdetailSrc);
TableOld.Add(new TableOld
{
tableNameOld = item.DetailName,
RowsCountOld = dsdetailSrc.Tables[0].Rows.Count,
});
}
}
}
foreach (var tableName in table)
{
//Lấy danh sách Data
SqlDataAdapter sqlDA;
sqlDA = new SqlDataAdapter("Select " + tableName.Table + ".* from " + tableName.Table + " Where " + tableName.Condition, conn);
dsDsc = new DataSet();
sqlDA.Fill(dsDsc);
TableNew.Add(new TableNew
{
tableNameNew = tableName.Table,
RowsCountNew = (int)dsDsc.Tables[0].Rows.Count,
});
foreach (var item in detail)
{
if (item.ID == tableName.ID)
{
SqlDataAdapter sqlDAdetail;
string query = "Select * From " + item.DetailName;
sqlDAdetail = new SqlDataAdapter(query, conn);
dsdetailDsc = new DataSet();
sqlDAdetail.Fill(dsdetailDsc);
TableNew.Add(new TableNew
{
tableNameNew = item.DetailName,
RowsCountNew = (int)dsdetailDsc.Tables[0].Rows.Count,
});
}
}
}
foreach (var itemold in TableOld)
{
foreach (var itemnew in TableNew)
{
if (itemold.tableNameOld == itemnew.tableNameNew)
{
textname += itemold.tableNameOld;
textname += "\r\n";
textcount += itemnew.RowsCountNew - itemold.RowsCountOld;
//textcount += ;
}
}
}
FrmShow frmShow = new FrmShow(textname + " " + textcount);
frmShow.Show();
//MessageBox.Show(textname + " " + textcount, "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
