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