public object GetItemEchart(string time)
{
string abstracts;
List <base_itemcontents> list = BLL.BaseBLL.GetItemEchart(time, out errmsg);
for (int i = 0; i < list.Count; i++)
{
list[i].seqid = i;
}
for (int j = 0; j < list.Count; j++)
{
string abstraid = "";
abstracts = list[j].abstracts;
string[] strArray = abstracts.Split('|');
foreach (string a in strArray)
{
base_itemcontents item = list.Find(o => o.title == a);
if (item != null)
{
abstraid += item.seqid + ",";
}
}
list[j].abstracts = abstraid.TrimEnd(',');
}
if (!string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "获取数据错误" }
}
;
else
{
return new { Rcode = 1, Rdata = list }
};
}
/// <summary>
/// 栏目内容管理 详情查询
/// </summary>
public object Get(int id)
{
base_itemcontents info = itemcontentsBLL.GetInfo(id, out errmsg)
; if (!string.IsNullOrEmpty(errmsg))
{
return(new { Rcode = -1, Rmsg = "获取数据失败" });
}
return(new { Rcode = 1, Rdata = info });
}
/// <summary>
/// 栏目内容管理 更新数据
/// </summary>
public object Put(int id, [FromBody] base_itemcontents info)
{
info.seqid = id;
bool success = itemcontentsBLL.Update(info, out errmsg);
WriteSysLog(1, string.Format("更新栏目内容{0}，返回{1}{2}", info.classname, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "更新失败" }
}
;
return(new { Rcode = 1, Rmsg = "更新成功" });
}
/// <summary>
/// 栏目内容管理 添加数据
/// </summary>
public object Post([FromBody] base_itemcontents info)
{
base_items items = new base_items();
items = itemsBLL.GetInfo(Convert.ToInt32(info.itemmark), out errmsg);
info.itemmark = items.itemmark;
info.createdtime = DateTime.Now;
info.creator = LoginUserData.UserID;
info.status = 1;
bool success = itemcontentsBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加栏目{0}的内容,返回{2}{3}", info.title, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
return(new { Rcode = 1, Rmsg = "添加成功" });
}
/// <summary>
/// 栏目内容管理 添加数据
/// </summary>
/// <param name="base_itemcontents">要添加的栏目内容管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_itemcontents info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("itemmark", info.itemmark));
pars.Add(new DataParameter("title", info.title));
pars.Add(new DataParameter("keywords", info.keywords));
pars.Add(new DataParameter("abstracts", info.abstracts));
pars.Add(new DataParameter("thumbnail", info.thumbnail));
pars.Add(new DataParameter("classname", info.classname));
pars.Add(new DataParameter("author", info.author));
pars.Add(new DataParameter("aboutdate", info.aboutdate));
pars.Add(new DataParameter("linkurl", info.linkurl));
pars.Add(new DataParameter("sorts", info.sorts));
pars.Add(new DataParameter("createdtime", info.createdtime));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("status", info.status));
pars.Add(new DataParameter("restype", info.restype));
pars.Add(new DataParameter("rescode", info.rescode));
string sqlstr = "insert into base_itemcontents (itemmark,title,keywords,abstracts,thumbnail,classname,author,aboutdate,linkurl,sorts,createdtime,creator,status,restype,rescode) values (@itemmark,@title,@keywords,@abstracts,@thumbnail,@classname,@author,@aboutdate,@linkurl,@sorts,@createdtime,@creator,@status,@restype,@rescode) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 栏目内容管理 更新数据
/// </summary>
/// <param name="base_itemcontents">要更新的栏目内容管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_itemcontents info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("itemmark", info.itemmark));
pars.Add(new DataParameter("title", info.title));
pars.Add(new DataParameter("keywords", info.keywords));
pars.Add(new DataParameter("abstracts", info.abstracts));
pars.Add(new DataParameter("thumbnail", info.thumbnail));
pars.Add(new DataParameter("classname", info.classname));
pars.Add(new DataParameter("author", info.author));
pars.Add(new DataParameter("aboutdate", info.aboutdate));
pars.Add(new DataParameter("linkurl", info.linkurl));
pars.Add(new DataParameter("sorts", info.sorts));
pars.Add(new DataParameter("createdtime", info.createdtime));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("status", info.status));
pars.Add(new DataParameter("restype", info.restype));
pars.Add(new DataParameter("rescode", info.rescode));
string sqlstr = "update base_itemcontents set itemmark=@itemmark,title=@title,keywords=@keywords,abstracts=@abstracts,thumbnail=@thumbnail,classname=@classname,author=@author,aboutdate=@aboutdate,linkurl=@linkurl,sorts=@sorts,createdtime=@createdtime,creator=@creator,status=@status,restype=@restype,rescode=@rescode where seqid=@seqid ";
pars.Add(new DataParameter("seqid", info.seqid));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 栏目内容管理 更新数据
/// </summary>
/// <param name="base_itemcontents">要更新的栏目内容管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_itemcontents info, out string errmsg)
{
return(itemcontentsDAL.Update(info, out errmsg));
}
/// <summary>
/// 栏目内容管理 添加数据
/// </summary>
/// <param name="base_itemcontents">要添加的栏目内容管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_itemcontents info, out string errmsg)
{
return(itemcontentsDAL.Add(info, out errmsg));
}
/// <summary>
/// 栏目内容管理 详情查询
/// </summary>
public static base_itemcontents GetInfo(int seqid, out string errmsg)
{
base_itemcontents info = itemcontentsDAL.GetInfo(seqid, out errmsg);
return(info);
}
