/// <summary>
/// 栏目模板管理 详情查询
/// </summary>
public object Get(int id)
{
base_itemtemplate info = itemtemplateBLL.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_itemtemplate info)
{
bool success = itemtemplateBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加标题为{0}的栏目模板，返回{1} {2}", info.templatename, 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] base_itemtemplate info)
{
info.templateid = id;
bool success = itemtemplateBLL.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="base_itemtemplate">要添加的栏目模板管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_itemtemplate info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("themesid", info.themesid));
pars.Add(new DataParameter("templatename", info.templatename));
pars.Add(new DataParameter("itemmark", info.itemmark));
pars.Add(new DataParameter("templatetype", info.templatetype));
pars.Add(new DataParameter("fileurl", info.fileurl));
pars.Add(new DataParameter("status", info.status));
string sqlstr = "insert into base_itemtemplate (themesid,templatename,itemmark,templatetype,fileurl,status) values (@themesid,@templatename,@itemmark,@templatetype,@fileurl,@status) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 栏目模板管理 更新数据
/// </summary>
/// <param name="base_itemtemplate">要更新的栏目模板管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_itemtemplate info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("themesid", info.themesid));
pars.Add(new DataParameter("templatename", info.templatename));
pars.Add(new DataParameter("itemmark", info.itemmark));
pars.Add(new DataParameter("templatetype", info.templatetype));
pars.Add(new DataParameter("fileurl", info.fileurl));
pars.Add(new DataParameter("status", info.status));
string sqlstr = "update base_itemtemplate set themesid=@themesid,templatename=@templatename,itemmark=@itemmark,templatetype=@templatetype,fileurl=@fileurl,status=@status where templateid=@templateid ";
pars.Add(new DataParameter("templateid", info.templateid));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 栏目模板管理 更新数据
/// </summary>
/// <param name="base_itemtemplate">要更新的栏目模板管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_itemtemplate info, out string errmsg)
{
return(itemtemplateDAL.Update(info, out errmsg));
}
/// <summary>
/// 栏目模板管理 添加数据
/// </summary>
/// <param name="base_itemtemplate">要添加的栏目模板管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_itemtemplate info, out string errmsg)
{
return(itemtemplateDAL.Add(info, out errmsg));
}
/// <summary>
/// 栏目模板管理 详情查询
/// </summary>
public static base_itemtemplate GetInfo(int templateid, out string errmsg)
{
base_itemtemplate info = itemtemplateDAL.GetInfo(templateid, out errmsg);
return(info);
}
