/// <summary>
/// 服务权限表 详情查询
/// </summary>
public object Get(int id)
{
chosen_servicepermit info = servicepermitBLL.GetInfo(id, out errmsg)
; if (!string.IsNullOrEmpty(errmsg))
{
return(new { Rcode = -1, Rmsg = "获取数据失败" });
}
return(new { Rcode = 1, Rdata = info });
}
/// <summary>
/// 服务权限表 更新数据
/// </summary>
/// <param name="chosen_servicepermit">要更新的服务权限表对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(chosen_servicepermit info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("seqid", info.seqid));
pars.Add(new DataParameter("serviceno", info.serviceno));
pars.Add(new DataParameter("customerid", info.customerid));
pars.Add(new DataParameter("userid", info.userid));
string sqlstr = "update chosen_servicepermit set serviceno=@serviceno,customerid=@customerid,userid=@userid where seqid=@seqid ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 服务权限表 添加数据
/// </summary>
/// <param name="chosen_servicepermit">要添加的服务权限表对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(chosen_servicepermit 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("userid", info.userid));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("createdtime", info.createdtime));
string sqlstr = "insert into chosen_servicepermit (serviceno,customerid,userid,creator,createdtime) values (@serviceno,@customerid,@userid,@creator,@createdtime) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 服务权限表 更新数据
/// </summary>
public object Put(int id, [FromBody] chosen_servicepermit info)
{
info.seqid = id;
bool success = servicepermitBLL.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>
public object Post([FromBody] chosen_servicepermit info)
{
info.createdtime = DateTime.Now;
info.creator = LoginUserData.UserID;
bool success = servicepermitBLL.Add(info, out errmsg);
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
return(new { Rcode = 1, Rmsg = "添加成功" });
}
/// <summary>
/// 服务权限表 更新数据
/// </summary>
/// <param name="chosen_servicepermit">要更新的服务权限表对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(chosen_servicepermit info, out string errmsg)
{
return(servicepermitDAL.Update(info, out errmsg));
}
/// <summary>
/// 服务权限表 添加数据
/// </summary>
/// <param name="chosen_servicepermit">要添加的服务权限表对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(chosen_servicepermit info, out string errmsg)
{
return(servicepermitDAL.Add(info, out errmsg));
}
/// <summary>
/// 服务权限表 详情查询
/// </summary>
public static chosen_servicepermit GetInfo(int seqid, out string errmsg)
{
chosen_servicepermit info = servicepermitDAL.GetInfo(seqid, out errmsg);
return(info);
}
