/// <summary> /// 订单商品管理 详情查询 /// </summary> public object Get(int id) { chosen_ordershop info = ordershopBLL.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_ordershop info) { bool success = ordershopBLL.Add(info, out errmsg); WriteSysLog(0, string.Format("添加订单商品管理{0},返回{1} {2}", info.shopname, success, 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_ordershop info) { info.orderid = id; bool success = ordershopBLL.Update(info, out errmsg); WriteSysLog(1, string.Format("更新订单商品管理 id为{0},返回{1} {2}", id, success, errmsg)); if (!success || !string.IsNullOrEmpty(errmsg)) { return new { Rcode = -1, Rmsg = "更新失败" } } ; return(new { Rcode = 1, Rmsg = "更新成功" }); }
/// <summary> /// 订单商品管理 添加数据 /// </summary> /// <param name="chosen_ordershop">要添加的订单商品管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Add(chosen_ordershop info, out string errmsg) { List <DataParameter> pars = new List <DataParameter>(); pars.Add(new DataParameter("shopname", info.shopname)); pars.Add(new DataParameter("orderno", info.orderno)); pars.Add(new DataParameter("restype", info.restype)); pars.Add(new DataParameter("rescode", info.rescode)); pars.Add(new DataParameter("thumbnail", info.thumbnail)); pars.Add(new DataParameter("prices", info.prices)); pars.Add(new DataParameter("shopnum", info.shopnum)); string sqlstr = "insert into chosen_ordershop (shopname,orderno,restype,rescode,thumbnail,prices,shopnum) values (@shopname,@orderno,@restype,@rescode,@thumbnail,@prices,@shopnum) "; return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0); }
/// <summary> /// 订单商品管理 更新数据 /// </summary> /// <param name="chosen_ordershop">要更新的订单商品管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Update(chosen_ordershop info, out string errmsg) { List <DataParameter> pars = new List <DataParameter>(); pars.Add(new DataParameter("shopname", info.shopname)); pars.Add(new DataParameter("orderno", info.orderno)); pars.Add(new DataParameter("restype", info.restype)); pars.Add(new DataParameter("rescode", info.rescode)); pars.Add(new DataParameter("thumbnail", info.thumbnail)); pars.Add(new DataParameter("prices", info.prices)); pars.Add(new DataParameter("shopnum", info.shopnum)); string sqlstr = "update chosen_ordershop set shopname=@shopname,orderno=@orderno,restype=@restype,rescode=@rescode,thumbnail=@thumbnail,prices=@prices,shopnum=@shopnum where orderid=@orderid "; pars.Add(new DataParameter("orderid", info.orderid)); return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0); }
/// <summary> /// 订单商品管理 更新数据 /// </summary> /// <param name="chosen_ordershop">要更新的订单商品管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Update(chosen_ordershop info, out string errmsg) { return(ordershopDAL.Update(info, out errmsg)); }
/// <summary> /// 订单商品管理 添加数据 /// </summary> /// <param name="chosen_ordershop">要添加的订单商品管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Add(chosen_ordershop info, out string errmsg) { return(ordershopDAL.Add(info, out errmsg)); }
/// <summary> /// 订单商品管理 详情查询 /// </summary> public static chosen_ordershop GetInfo(int orderid, out string errmsg) { chosen_ordershop info = ordershopDAL.GetInfo(orderid, out errmsg); return(info); }