public ActionResult EditUnionArchiSave(JiaGou model)
{
const string EditUnionArchiSaveSql = @"UPDATE dbo.TB_JiaGou
SET MingCheng=@MingCheng,
FabuRen=@FabuRen,
JieShao=@JieShao
WHERE ID=@ID" ;
using (DbConnection conn = DbFactory.CreateConnection())
{
var result = conn.Execute(EditUnionArchiSaveSql, model) > 0;
}
return(RedirectToAction("ScanUnionArchiIndex", "UnionInfor"));
}
/// <summary>
/// 添加工会架构信息的方法
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult AddJiaGouMSG(JiaGou model)
{
SQLHelper sqlh = new SQLHelper();
model.ShiJian = DateTime.Now;
const string AddJiaGousql = @"INSERT INTO dbo.TB_JiaGou
( 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(AddJiaGousql, para);
return(RedirectToAction("ScanUnionArchiIndex", "UnionInfor"));
}
