public ActionResult editUpGonggao()
{
Int32 id = Request["strId"] != null?Convert.ToInt32(Request["strId"]) : 0;
bool bl = Request["bl"] != null?Convert.ToBoolean(Request["bl"]) : false;
if (id == 0)
{
return(Json("noid", JsonRequestBehavior.AllowGet));
}
GongGao gg = GongGaoService.LoadEntities(x => x.ID == id).FirstOrDefault();
if (bl)
{
gg.del = bl;
}
if (GongGaoService.EditEntity(gg))
{
return(Json("ok", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("err", JsonRequestBehavior.AllowGet));
}
}
//创建公告
public ActionResult AddUpGonggao(GongGao gg)
{
if (gg.ID > 0)
{
GongGao ggs = GongGaoService.LoadEntities(x => x.ID == gg.ID).FirstOrDefault();
ggs.text = gg.text;
if (GongGaoService.EditEntity(ggs))
{
return(Json("ok", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("err", JsonRequestBehavior.AllowGet));
}
}
else
{
gg.del = false;
gg.Addtime = MvcApplication.GetT_time();
gg.Items = 7;
gg.bak = "通知公告";
GongGaoService.AddEntity(gg);
return(Json("ok", JsonRequestBehavior.AllowGet));
}
}
//修改公告信息
public ActionResult editGongGao(GongGao tqz)
{
if (tqz.ID <= 0)
{
GongGaoService.AddEntity(tqz);
return(Json(new { ret = "ok", JsonRequestBehavior.AllowGet }));
}
else
{
return(Json(new { msg = "添加出错，请联系管理员！~", JsonRequestBehavior.AllowGet }));
}
}
/// <summary>
/// 修改最新公告信息的方法
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult EditAnnounSave(GongGao model)
{
const string EditUnionAnnounSaveSql = @"UPDATE dbo.TB_GongGao
SET MingCheng=@MingCheng,
FabuRen=@FabuRen,
JieShao=@JieShao
WHERE ID=@ID" ;
using (DbConnection conn = DbFactory.CreateConnection())
{
var result = conn.Execute(EditUnionAnnounSaveSql, model) > 0;
}
return(RedirectToAction("ScanUnionAnnounIndex", "UnionInfor"));
}
//添加公告信息
public ActionResult AddGongGao(GongGao tqz)
{
if (tqz.ID <= 0)
{
var isnull = GongGaoService.LoadEntities(x => x.Items == tqz.Items).FirstOrDefault();
if (isnull != null)
{
return(Json(new { msg = "文本分类必须保证唯一性~", JsonRequestBehavior.AllowGet }));
}
GongGaoService.AddEntity(tqz);
return(Json(new { ret = "ok", JsonRequestBehavior.AllowGet }));
}
else
{
GongGaoService.EditEntity(tqz);
return(Json(new { ret = "editok", msg = "修改成功！~", JsonRequestBehavior.AllowGet }));
}
}
//删除公告
public ActionResult delUpGonggao()
{
Int32 id = Request["strId"] != null?Convert.ToInt32(Request["strId"]) : 0;
if (id == 0)
{
return(Json(new { ret = "noid" }, JsonRequestBehavior.AllowGet));
}
GongGao gg = GongGaoService.LoadEntities(x => x.ID == id).FirstOrDefault();
gg.del = true;
if (GongGaoService.EditEntity(gg))
{
return(Json("ok", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("err", JsonRequestBehavior.AllowGet));
}
}
private void GetData()
{
this.unlb.Text = this.Session["userName"].ToString();
List<GongGao> list = new GongGaoManager().GetList().Take<GongGao>(5).ToList<GongGao>();
if (list.Count == 0)
{
GongGao item = new GongGao
{
title = ""
};
list.Add(item);
this.GridView1.DataSource = list;
this.GridView1.DataBind();
}
else
{
this.GridView1.DataSource = list;
this.GridView1.DataBind();
}
}
public void tianjia()
{
linqGongGaoDataContext gg = new linqGongGaoDataContext();
GongGao newgg = new GongGao();
//保存添加者姓名
newgg.Gg_User = Session["Yg_XingMing"].ToString();
newgg.Gg_UserId = Convert.ToInt32(Session["Yg_Id"]);
newgg.Gg_Name = txtTM.Text.Trim();
newgg.Gg_NeiRong = txtNR.Text.Trim();
//利用系统函数DateTime.Now保存添加时间
newgg.Gg_TianJiaShiJian = DateTime.Now;
//往数据库提交添加请求
gg.GongGao.InsertOnSubmit(newgg);
//执行添加请求
gg.SubmitChanges();
//提示添加成功
Response.Write("<Script language=javascript>");
Response.Write("window.alert('添加公告成功!');");
Response.Write("window.location='GongGaoTJ.aspx");
Response.Write("'</script>");
}
/// <summary>
/// 添加工会公告信息的方法
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult AddGongGaoMSG(GongGao model)
{
SQLHelper sqlh = new SQLHelper();
model.ShiJian = DateTime.Now;
const string AddGongGaosql = @"INSERT INTO dbo.TB_GongGao
( 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(AddGongGaosql, para);
return(RedirectToAction("ScanUnionAnnounIndex", "UnionInfor"));
}
partial void DeleteGongGao(GongGao instance);
partial void UpdateGongGao(GongGao instance);
partial void InsertGongGao(GongGao instance);