public ActionResult AddCil(ZiNV model)
{
SQLHelper sqlh = new SQLHelper();
const string AddCilsql = @"INSERT INTO dbo.TB_ZiNV
( BianHao,XingMing,Age,GuanXi,XingMing2,XueLi,XueXiao)
VALUES ( @BianHao,
@XingMing,
@Age,
@GuanXi,
@XingMing2,
@XueLi,
@XueXiao
) ";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("BianHao", model.BianHao),
new SqlParameter("XingMing", model.XingMing),
new SqlParameter("Age", model.Age),
new SqlParameter("GuanXi", model.GuanXi),
new SqlParameter("XingMing2", model.XingMing2),
new SqlParameter("XueLi", model.XueLi),
new SqlParameter("XueXiao", model.XueXiao)
};
sqlh.ExecData(AddCilsql, para);
return(RedirectToAction("ScanChildIndex", "EmployeeFamily"));
}
public ActionResult EditChildSave(ZiNV model)
{
const string EditChildSaveSql = @"UPDATE dbo.TB_ZiNV
SET BianHao=@BianHao,
XingMing=@XingMing,
GuanXi=@GuanXi,
XingMing2=@XingMing2,
Age=@Age,
XueLi=@XueLi,
XueXiao=@XueXiao
WHERE ID=@ID" ;
using (DbConnection conn = DbFactory.CreateConnection())
{
var result = conn.Execute(EditChildSaveSql, model) > 0;
}
return(RedirectToAction("ScanChildIndex", "EmployeeFamily"));
}
