public ActionResult EditFTeSHuInforSave(FTeshu model)
{
const string EditFTeSHuSaveSql = @"UPDATE dbo.TB_FTeShu
SET BianHao=@BianHao,
XingMing=@XingMing,
TeShu=@TeShu
WHERE ID=@ID" ;
using (DbConnection conn = DbFactory.CreateConnection())
{
var result = conn.Execute(EditFTeSHuSaveSql, model) > 0;
}
return(RedirectToAction("ScanSpecialIndex", "EmployeeBenefits"));
}
public ActionResult AddSpe(FTeshu model)
{
SQLHelper sqlh = new SQLHelper();
const string AddSpesql = @"INSERT INTO dbo.TB_TeShu
( BianHao,XingMing,TeShu)
VALUES ( @BianHao,
@XingMing,
@TeShu
) ";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("BianHao", model.BianHao),
new SqlParameter("XingMing", model.XingMing),
new SqlParameter("TeShu", model.TeShu)
};
sqlh.ExecData(AddSpesql, para);
return(RedirectToAction("ScanSpecialIndex", "EmployeeBenefits"));
}
