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