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