private void f_caplai_mabd(int i_nhom)
{
string user = m.user;
LibDuoc.AccessData d = new LibDuoc.AccessData();
string sql = "update " + user + ".d_dmbd set ma='000000' where nhom=" + i_nhom;// +" and ma='BAN001'";
d.execute_data(sql);
sql = "select id, ma, ten from " + user + ".d_dmbd where nhom=" + i_nhom + " order by ten, id ";//+" and ma='000000'
DataSet lds = m.get_data(sql);
string s_ma = "";
int i1 = lds.Tables[0].Rows.Count;
int i2 = 0;
foreach (DataRow r in lds.Tables[0].Rows)
{
s_ma = d.getMabd("d_dmbd", r["ten"].ToString(), i_nhom);
sql = "update " + user + ".d_dmbd set ma='" + s_ma + "' where id=" + r["id"].ToString();
d.execute_data(sql);
i2 += 1;
lblma.Text = s_ma;
lblma.Refresh();
lblten.Text = r["ten"].ToString() + " - " + i2.ToString() + "/" + i1.ToString();
lblten.Refresh();
}
}
