/// <summary> /// 编辑保存法规信息的方法 /// </summary> /// <param name="Id"></param> /// <returns></returns> public ActionResult EditUnionPolicySave(FaGui model) { const string EditUnionPolicySaveSql = @"UPDATE dbo.TB_FaGui SET MingCheng=@MingCheng, FabuRen=@FabuRen, JieShao=@JieShao WHERE ID=@ID" ; using (DbConnection conn = DbFactory.CreateConnection()) { var result = conn.Execute(EditUnionPolicySaveSql, model) > 0; } return(RedirectToAction("ScanUnionPolicyIndex", "UnionInfor")); }
/// <summary> /// 添加工会法规信息的方法 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult AddFaGuiMSG(FaGui model) { SQLHelper sqlh = new SQLHelper(); model.ShiJian = DateTime.Now; const string AddFaGuisql = @"INSERT INTO dbo.TB_FaGui ( MingCheng, FabuRen,JieShao,ShiJian) VALUES ( @MingCheng, @FabuRen, @JieShao, @ShiJian ) "; SqlParameter[] para = new SqlParameter[] { new SqlParameter("MingCheng", model.MingCheng), new SqlParameter("FabuRen", model.FabuRen), new SqlParameter("JieShao", model.JieShao), new SqlParameter("ShiJian", model.ShiJian) }; sqlh.ExecData(AddFaGuisql, para); return(RedirectToAction("ScanUnionPolicyIndex", "UnionInfor")); }