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")); }