public ActionResult getZgFabu(ZhaoGong obj)
{
//if (ModelState.IsValid)
//{
obj = new ZhaoGong
{
//zgId, zgTitle, zgXuqiu, zgZhuTilei, zgZhuti, zgArea, zgGz, zgNum, zgDetail, zgUser, zgPhone,
//zgFaburen, zgStarttime, zgEndtime, zgAddtime, zgImg1, zgImg2, zgImg3, isTuijian, isRemen
zgTitle = obj.zgTitle,
zgXuqiu = obj.zgXuqiu,
zgZhuTilei = obj.zgZhuTilei,
zgZhuti = obj.zgZhuti,
zgArea = obj.zgArea,
zgGz = obj.zgGz,
zgNum = obj.zgNum,
zgDetail = obj.zgDetail,
zgUser = obj.zgUser,
zgPhone = obj.zgPhone,
zgStarttime = obj.zgStarttime,
zgEndtime = obj.zgEndtime,
zgFaburen = obj.zgFaburen
};
int result = new ZhaoGongBLL().Add(obj);
string info = "--->" + obj.zgTitle + "消息已经成功发布！";
return(RedirectToAction("zgFabu", new { info }));
//return this.Content("<script>window.location='" + Url.Action("GetList", "SysAdmin") + "'</script>");
//return this.Content("发布成功！");
//}
//return View("aZgFabu");
}
public ZhaoGong GetObjById(string id)
{
string sql = "select * from Zg_Info where zgId ='{0}'";
sql = string.Format(sql, id);
SqlDataReader dr = SQLHelper.GetReader(sql);
ZhaoGong obj = null;
if (dr.Read())
{
obj = new ZhaoGong
{
zgId = Convert.ToInt32(dr["zgId"]),
zgTitle = dr["zgTitle"].ToString(),
zgXuqiu = dr["zgXuqiu"].ToString(),
zgZhuTilei = dr["zgZhuTilei"].ToString(),
zgZhuti = dr["zgZhuti"].ToString(),
zgNum = Convert.ToInt32(dr["zgNum"]),
zgUser = dr["zgUser"].ToString(),
zgPhone = dr["zgPhone"].ToString(),
zgArea = dr["zgArea"].ToString(),
zgGz = dr["zgGz"].ToString(),
zgDetail = dr["zgDetail"].ToString(),
zgFaburen = dr["zgFaburen"].ToString(),
zgAddtime = Convert.ToDateTime(dr["zgAddtime"]),
zgStarttime = Convert.ToDateTime(dr["zgStarttime"]),
zgEndtime = Convert.ToDateTime(dr["zgEndtime"])
};
}
return(obj);
}
public int Add(ZhaoGong obj)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("insert into Zg_Info (zgXuqiu, zgZhuTilei, zgZhuti, zgArea, zgGz, zgNum, zgDetail, zgUser, zgPhone, zgFaburen, zgAddtime,zgStarttime,zgEndtime) ");
sqlBuilder.Append("values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')");
string sql = string.Format(sqlBuilder.ToString(), obj.zgXuqiu, obj.zgZhuTilei, obj.zgZhuti, obj.zgArea, obj.zgGz, obj.zgNum, obj.zgDetail, obj.zgUser, obj.zgPhone, obj.zgFaburen, DateTime.Now, obj.zgStarttime, obj.zgEndtime);
try
{
return(Convert.ToInt32(SQLHelper.Update(sql)));
}
catch (SqlException ex)
{
throw new Exception("数据库操作出现异常！具体信息：\r\n" + ex.Message);
}
}
public int Add(ZhaoGong obj)
{
return(new ZhaoGongDAL().Add(obj));
}
