public static void Upadte(BaoJingRen person)
{
SqlHelper.ExecuteNonQuery("update T_报警人信息 set 姓名=@姓名,性别=@性别,身份证号=@身份证号,报警电话=@报警电话,联系方式=@联系方式,家庭地址=@家庭地址 where 案件编号=@案件编号",
new SqlParameter("@姓名", person.Name),
new SqlParameter("@性别", person.Sex),
new SqlParameter("@身份证号", person.PeopleId),
new SqlParameter("@报警电话", person.BaoJingPhone),
new SqlParameter("@联系方式", person.LianXiFangShi),
new SqlParameter("@家庭住址", person.Address),
new SqlParameter("@案件编号", person.CaseId));
}
public static void Insert(BaoJingRen person)
{
SqlHelper.ExecuteNonQuery("insert into T_报警人信息 (案件编号,姓名,性别,身份证号,报警电话,联系方式,家庭地址) values(@案件编号,@姓名,@性别,@身份证号,@报警电话,@联系方式,@家庭地址)",
new SqlParameter("@案件编号", person.CaseId),
new SqlParameter("@姓名", person.Name),
new SqlParameter("@性别", person.Sex),
new SqlParameter("@身份证号", person.PeopleId),
new SqlParameter("@报警电话", person.BaoJingPhone),
new SqlParameter("@联系方式", person.LianXiFangShi),
new SqlParameter("@家庭住址", person.Address));
}
private static BaoJingRen ToBaoJingRen(DataRow row)
{
BaoJingRen person = new BaoJingRen();
person.CaseId = (string)row["案件编号"];
person.Name = (string)row["姓名"];
person.Sex = (string)row["性别"];
person.PeopleId = (string)row["身份证号"];
person.BaoJingPhone = (string)row["报警电话"];
person.LianXiFangShi = (string)row["联系方式"];
person.Address = (string)row["家庭住址"];
return(person);
}
