/// <summary>
/// 系统日志管理 详情查询
/// </summary>
public object Get(int id)
{
base_syslogs info = syslogsBLL.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] base_syslogs info)
{
bool success = syslogsBLL.Add(info, out errmsg);
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
return(new { Rcode = 1, Rmsg = "添加成功" });
}
/// <summary>
/// 系统日志管理 更新数据
/// </summary>
public object Put(int id, [FromBody] base_syslogs info)
{
info.logid = id;
bool success = syslogsBLL.Update(info, out errmsg);
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "更新失败" }
}
;
return(new { Rcode = 1, Rmsg = "更新成功" });
}
/// <summary>
/// 系统日志管理 添加数据
/// </summary>
/// <param name="base_syslogs">要添加的系统日志管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_syslogs info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("logmenu", info.logmenu));
pars.Add(new DataParameter("logfunname", info.logfunname));
pars.Add(new DataParameter("logtype", info.logtype));
pars.Add(new DataParameter("logcontent", info.logcontent));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("createdtime", info.createdtime));
string sqlstr = "insert into base_syslogs (logmenu,logfunname,logtype,logcontent,creator,createdtime) values (@logmenu,@logfunname,@logtype,@logcontent,@creator,@createdtime) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 系统日志管理 更新数据
/// </summary>
/// <param name="base_syslogs">要更新的系统日志管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_syslogs info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("logmenu", info.logmenu));
pars.Add(new DataParameter("logfunname", info.logfunname));
pars.Add(new DataParameter("logtype", info.logtype));
pars.Add(new DataParameter("logcontent", info.logcontent));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("createdtime", info.createdtime));
string sqlstr = "update base_syslogs set logmenu=@logmenu,logfunname=@logfunname,logtype=@logtype,logcontent=@logcontent,creator=@creator,createdtime=@createdtime where logid=@logid ";
pars.Add(new DataParameter("logid", info.logid));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 系统日志管理 更新数据
/// </summary>
/// <param name="base_syslogs">要更新的系统日志管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_syslogs info, out string errmsg)
{
return(syslogsDAL.Update(info, out errmsg));
}
/// <summary>
/// 系统日志管理 添加数据
/// </summary>
/// <param name="base_syslogs">要添加的系统日志管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_syslogs info, out string errmsg)
{
return(syslogsDAL.Add(info, out errmsg));
}
/// <summary>
/// 系统日志管理 详情查询
/// </summary>
public static base_syslogs GetInfo(int logid, out string errmsg)
{
base_syslogs info = syslogsDAL.GetInfo(logid, out errmsg);
return(info);
}
