public ActionResult EditInsuranceSave(Baoxian model)
{
const string EditBaoXianSaveSql = @"UPDATE dbo.TB_BaoXian
SET BianHao=@BianHao,
XingMing=@XingMing,
YouXiaoQi=@YouXiaoQi,
BaoXian=@BaoXian,
FenSHu=@FenSHu
WHERE ID=@ID" ;
using (DbConnection conn = DbFactory.CreateConnection())
{
var result = conn.Execute(EditBaoXianSaveSql, model) > 0;
}
return(RedirectToAction("ScanInsuranceIndex", "EmployeeBenefits"));
}
public ActionResult AddEmpBenf(Baoxian model)
{
SQLHelper sqlh = new SQLHelper();
const string AddEmpBenfsql = @"INSERT INTO dbo.TB_BaoXian
( BianHao,XingMing,BaoXian,FenSHu,YouXiaoQi)
VALUES ( @BianHao,
@XingMing,
@BaoXian,
@FenSHu,
@YouXiaoQi
) ";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("BianHao", model.BianHao),
new SqlParameter("XingMing", model.XingMing),
new SqlParameter("BaoXian", model.BaoXian),
new SqlParameter("FenSHu", model.FenSHu),
new SqlParameter("YouXiaoQi", model.YouXiaoQi)
};
sqlh.ExecData(AddEmpBenfsql, para);
return(RedirectToAction("ScanInsuranceIndex", "EmployeeBenefits"));
}
