public ActionResult EditBodyExamInforSave(TiJian model)
{
const string BodyExamInforSaveSql = @"UPDATE dbo.TB_TiJian
SET BianHao=@BianHao,
XingMing=@XingMing,
ShiJian=@ShiJian,
YiYuan=@YiYuan,
JieGuo=@JieGuo
WHERE ID=@ID" ;
using (DbConnection conn = DbFactory.CreateConnection())
{
var result = conn.Execute(BodyExamInforSaveSql, model) > 0;
}
return(RedirectToAction("ScanBodyExamIndex", "EmployeeBenefits"));
}
public ActionResult AddBodyExamInfor(TiJian model)
{
SQLHelper sqlh = new SQLHelper();
const string AddEyeBeftsql = @"INSERT INTO dbo.TB_TiJian
( BianHao,JieGuo,ShiJian,XingMing,YiYuan)
VALUES ( @BianHao,
@JieGuo,
@ShiJian,
@XingMing,
@YiYuan
) ";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("BianHao", model.BianHao),
new SqlParameter("JieGuo", model.JieGuo),
new SqlParameter("ShiJian", model.ShiJian),
new SqlParameter("XingMing", model.XingMing),
new SqlParameter("YiYuan", model.YiYuan)
};
sqlh.ExecData(AddEyeBeftsql, para);
return(RedirectToAction("ScanBodyExamIndex", "EmployeeBenefits"));
}
