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