public void DeleteStudent(List <DSstudent> stulst)
{
ArrayList da = new ArrayList();
string student = "";
string dep = "";
foreach (DSstudent ds in stulst)
{
student = string.Format("select Id from Person where person_card_no = '{0}' and person_name = '{1}'"
, ds.证件号码, ds.人员姓名);
DataTable dt = sconn.SQLiteGetTable(student);
if (dt.Rows.Count == 0)
{
continue;
}
foreach (DataRow dr in dt.Rows)
{
dep = string.Format("delete from Dept_Staff where staff_id = '{0}'", dr["Id"].ToString());
da.Add(dep);
student = string.Format("delete from Person where id = '{0}'", dr["Id"].ToString());
da.Add(student);
}
}
sconn.ExecuteSqlTran(da);
}
