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); }