private void butIn_Click(object sender, EventArgs e)
{
xxx = user + m.mmyy(ngay.Text);
int itable = m.tableid(m.mmyy(ngay.Text), "inchiphipk");
foreach (DataRow r in ds.Tables[0].Select("chon=true"))
{
m.upd_eve_tables(ngay.Text, itable, i_userid, "del");
m.upd_eve_upd_del(ngay.Text, itable, i_userid, "del", m.fields(xxx + ".inchiphipk", "mavaovien=" + decimal.Parse(r["mavaovien"].ToString())));
m.execute_data("delete from " + xxx + ".inchiphipk where mavaovien=" + decimal.Parse(r["mavaovien"].ToString()));
d.execute_data_mmyy("update xxx.v_chidinh set paid=0 where mavaovien=" + decimal.Parse(r["mavaovien"].ToString()) + " or maql=" + decimal.Parse(r["mavaovien"].ToString()), ngay.Text, ngay.Text, 30);
d.execute_data_mmyy("delete xxx.bhytcls where id in(select id from xxx.bhytkb where mavaovien=" + decimal.Parse(r["mavaovien"].ToString()) + " or maql=" + decimal.Parse(r["mavaovien"].ToString()), ngay.Text, ngay.Text, 30);
}
butTim_Click(sender, e);
}
