/// <summary>
/// 服务管理 详情查询
/// </summary>
public object Get(string id)
{
chosen_serviceinfo info = serviceinfoBLL.GetInfo(id, out errmsg)
; if (!string.IsNullOrEmpty(errmsg))
{
return(new { Rcode = -1, Rmsg = "获取数据失败" });
}
return(new { Rcode = 1, Rdata = info });
}
/// <summary>
/// 服务管理 更新数据
/// </summary>
public object Put(string id, [FromBody] chosen_serviceinfo info)
{
info.serviceno = id;
info.creator = LoginUserData.UserID;
info.createdtime = DateTime.Now;
bool success = serviceinfoBLL.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_serviceinfo">要更新的服务管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(chosen_serviceinfo info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
//pars.Add(new DataParameter("serviceno", info.serviceno));
pars.Add(new DataParameter("customerid", info.customerid));
pars.Add(new DataParameter("stype", info.stype));
pars.Add(new DataParameter("starttime", info.starttime));
pars.Add(new DataParameter("endtime", info.endtime));
pars.Add(new DataParameter("maxnum", info.maxnum));
pars.Add(new DataParameter("leftnum", info.leftnum));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("createdtime", info.createdtime));
pars.Add(new DataParameter("status", info.status));
string sqlstr = "update chosen_serviceinfo set serviceno=@serviceno,customerid=@customerid,stype=@stype,starttime=@starttime,endtime=@endtime,maxnum=@maxnum,leftnum=@leftnum,creator=@creator,createdtime=@createdtime,status=@status where serviceno=@serviceno ";
pars.Add(new DataParameter("serviceno", info.serviceno));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 服务管理 添加数据
/// </summary>
/// <param name="chosen_serviceinfo">要添加的服务管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(chosen_serviceinfo info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("serviceno", info.serviceno));
pars.Add(new DataParameter("servicename", info.servicename));
pars.Add(new DataParameter("customerid", info.customerid));
pars.Add(new DataParameter("stype", info.stype));
pars.Add(new DataParameter("starttime", info.starttime));
pars.Add(new DataParameter("endtime", info.endtime));
pars.Add(new DataParameter("maxnum", info.maxnum));
pars.Add(new DataParameter("leftnum", info.leftnum));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("createdtime", info.createdtime));
pars.Add(new DataParameter("status", info.status));
string sqlstr = "insert into chosen_serviceinfo (serviceno,servicename,customerid,stype,starttime,endtime,maxnum,leftnum,creator,createdtime,status) values (@serviceno,@servicename,@customerid,@stype,@starttime,@endtime,@maxnum,@leftnum,@creator,@createdtime,@status) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 服务管理 添加数据
/// </summary>
public object Post([FromBody] chosen_serviceinfo info)
{
info.creator = LoginUserData.UserID;
info.createdtime = DateTime.Now;
string datenum = DateTime.Now.ToString("yyyyMMddhh24mmss");
Random rd = new Random();
string sjnum = rd.Next(1000000, 10000000).ToString();
string viceo = datenum + sjnum;
info.serviceno = viceo;
info.leftnum = info.maxnum;
info.status = 0;
bool success = serviceinfoBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加服务{0}，返回{1} {2}", info.servicename, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
return(new { Rcode = 1, Rmsg = "添加成功" });
}
/// <summary>
/// 服务管理 更新数据
/// </summary>
/// <param name="chosen_serviceinfo">要更新的服务管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(chosen_serviceinfo info, out string errmsg)
{
return(serviceinfoDAL.Update(info, out errmsg));
}
/// <summary>
/// 服务管理 添加数据
/// </summary>
/// <param name="chosen_serviceinfo">要添加的服务管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(chosen_serviceinfo info, out string errmsg)
{
return(serviceinfoDAL.Add(info, out errmsg));
}
/// <summary>
/// 服务管理 详情查询
/// </summary>
public static chosen_serviceinfo GetInfo(string serviceno, out string errmsg)
{
chosen_serviceinfo info = serviceinfoDAL.GetInfo(serviceno, out errmsg);
return(info);
}
