public ActionResult UpdateLanmu(LanmuInfo obj)
{
obj = new LanmuInfo()
{
lanmuNeirong = obj.lanmuNeirong,
lanmuId = obj.lanmuId
};
int result = new LanmuBLL().Edit(obj);
string info = "修改成功 ！";
return(RedirectToAction("Index", "SysAdmin", new { info }));
}
public int Edit(LanmuInfo obj)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("update Lanmu_Info set lanmuNeirong='{0}' ");
sqlBuilder.Append(" where lanmuId = {1}");
string sql = string.Format(sqlBuilder.ToString(), obj.lanmuNeirong, obj.lanmuId);
try
{
return(Convert.ToInt32(SQLHelper.Update(sql)));
}
catch (SqlException ex)
{
throw new Exception("数据库操作出现异常！具体信息：\r\n" + ex.Message);
}
}
public LanmuInfo GetObjById(int id)
{
string sql = "select * from Lanmu_Info where lanmuId={0}";
sql = string.Format(sql, id);
SqlDataReader dr = SQLHelper.GetReader(sql);
LanmuInfo obj = null;
if (dr.Read())
{
obj = new LanmuInfo
{
lanmuId = Convert.ToInt32(dr["lanmuId"]),
lanmuName = dr["lanmuName"].ToString(),
lanmuNeirong = dr["lanmuNeirong"].ToString()
};
}
return(obj);
}
public int Edit(LanmuInfo obj)
{
return(new LanmuDAL().Edit(obj));
}
