/// <summary> /// 收藏管理 详情查询 /// </summary> public object Get(int id) { chosen_favorites info = favoritesBLL.GetInfo(id, out errmsg) ; if (!string.IsNullOrEmpty(errmsg)) { return(new { Rcode = -1, Rmsg = "获取数据失败" }); } return(new { Rcode = 1, Rdata = info }); }
/// <summary> /// 收藏管理 添加数据 /// </summary> public object Post([FromBody] chosen_favorites info) { bool success = favoritesBLL.Add(info, out errmsg); if (!success || !string.IsNullOrEmpty(errmsg)) { return new { Rcode = -1, Rmsg = "添加失败" } } ; return(new { Rcode = 1, Rmsg = "添加成功" }); }
/// <summary> /// 收藏管理 更新数据 /// </summary> public object Put(int id, [FromBody] chosen_favorites info) { info.seqid = id; bool success = favoritesBLL.Update(info, out errmsg); if (!success || !string.IsNullOrEmpty(errmsg)) { return new { Rcode = -1, Rmsg = "更新失败" } } ; return(new { Rcode = 1, Rmsg = "更新成功" }); }
/// <summary> /// 收藏管理 添加数据 /// </summary> /// <param name="chosen_favorites">要添加的收藏管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Add(chosen_favorites info, out string errmsg) { List <DataParameter> pars = new List <DataParameter>(); pars.Add(new DataParameter("userid", info.userid)); pars.Add(new DataParameter("restype", info.restype)); pars.Add(new DataParameter("rescode", info.rescode)); pars.Add(new DataParameter("resremark", info.resremark)); pars.Add(new DataParameter("createdtime", info.createdtime)); string sqlstr = "insert into chosen_favorites (userid,restype,rescode,resremark,createdtime) values (@userid,@restype,@rescode,@resremark,@createdtime) "; return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0); }
/// <summary> /// 收藏管理 更新数据 /// </summary> /// <param name="chosen_favorites">要更新的收藏管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Update(chosen_favorites info, out string errmsg) { List <DataParameter> pars = new List <DataParameter>(); pars.Add(new DataParameter("userid", info.userid)); pars.Add(new DataParameter("restype", info.restype)); pars.Add(new DataParameter("rescode", info.rescode)); pars.Add(new DataParameter("resremark", info.resremark)); pars.Add(new DataParameter("createdtime", info.createdtime)); string sqlstr = "update chosen_favorites set userid=@userid,restype=@restype,rescode=@rescode,resremark=@resremark,createdtime=@createdtime where seqid=@seqid "; pars.Add(new DataParameter("seqid", info.seqid)); return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0); }
/// <summary> /// 收藏管理 更新数据 /// </summary> /// <param name="chosen_favorites">要更新的收藏管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Update(chosen_favorites info, out string errmsg) { return(favoritesDAL.Update(info, out errmsg)); }
/// <summary> /// 收藏管理 添加数据 /// </summary> /// <param name="chosen_favorites">要添加的收藏管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Add(chosen_favorites info, out string errmsg) { return(favoritesDAL.Add(info, out errmsg)); }
/// <summary> /// 收藏管理 详情查询 /// </summary> public static chosen_favorites GetInfo(int seqid, out string errmsg) { chosen_favorites info = favoritesDAL.GetInfo(seqid, out errmsg); return(info); }