public void InsterStudent(List <DSstudent> Stulst)
{
ArrayList al = new ArrayList();
ArrayList ad = new ArrayList();
string student = "";
string dep = "";
foreach (DSstudent ds in Stulst)
{
string guid = Guid.NewGuid().ToString("N").ToUpper();
student = string.Format("insert into Person(Id, person_code, person_name, person_gender, person_englishname, person_birthday, " +
" person_card_type, person_card_no, person_dept_id, person_job_level, person_job_position, person_educational," +
" person_nation, person_phone, person_email, person_address, person_dept_name) values " +
" ('{0}', '{1}', '{2}', '0', '', '0', '0', '{3}', '', '0', '', '', '', '{4}', '', '{5}', '')"
, guid, ds.人员编号, ds.人员姓名, ds.证件号码, ds.联系电话, ds.地址);
al.Add(student);
dep = string.Format("insert into Dept_Staff (dept_id,staff_id) values ('','{0}')", guid);
al.Add(dep);
}
sconn.ExecuteSqlTran(al);
}
