/// <summary>
/// 栏目管理 列表查询
/// </summary>
/// <param name="queryarr">查询条件</param>
/// <param name="offset">起始条数</param>
/// <param name="limit">获取条数</param>
/// <param name="total">返回总记录数</param>
//public static List<base_items> GetPageList(List<QueryModel> queryarr, int offset, int limit, out int total, out string errmsg)
//{
// List<base_items> list = itemsDAL.GetPageList(queryarr,offset,limit,out total,out errmsg);
// return list;
//}
public static List <base_items> GetPageList(out string errmsg)
{
int total = 0;
List <base_items> list = itemsDAL.GetPageList(new List <QueryModel>(), -1, 0, out total, out errmsg);
if (!string.IsNullOrEmpty(errmsg) || list == null)
{
return(new List <base_items>());
}
int outparentitemId = 0;
foreach (var item in list)
{
item.navigationname = BaseBLL.GlobalCommonBLL.GetDicName("YesOrNo", item.navigation.ToString());
item.sourcetypename = BaseBLL.GlobalCommonBLL.GetDicName("ItemSourceType", item.sourcetype.ToString());
item.statusname = BaseBLL.GlobalCommonBLL.GetDicName("EnableStatus", item.status.ToString());
}
base_items rootitem = new base_items()
{
itemid = 0
};
SetItemChildren(rootitem, list);
return(rootitem.children);
}
/// <summary>
/// 栏目管理 详情查询
/// </summary>
public object Get(int id)
{
base_items info = itemsBLL.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_items info)
{
info.itemid = id;
bool success = itemsBLL.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 = "更新成功" });
}
private static void SetItemChildren(base_items parentItem, List <base_items> list)
{
parentItem.children = new List <base_items>();
List <base_items> ItemChildren = list.FindAll(
delegate(base_items c)
{
return(c.parentid == parentItem.itemid);
});
foreach (base_items item in ItemChildren)
{
parentItem.children.Add(item);
SetItemChildren(item, list);
}
}
/// <summary>
/// 栏目管理 添加数据
/// </summary>
public object Post([FromBody] base_items info)
{
if (info.parentid == null || info.parentid == -1)
{
info.parentid = 0;
}
bool success = itemsBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加栏目标识为{0}，返回{1} {2}", info.itemname, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
return(new { Rcode = 1, Rmsg = "添加成功" });
}
/// <summary>
/// 栏目管理 添加数据
/// </summary>
/// <param name="base_items">要添加的栏目管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_items info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("parentid", info.parentid));
pars.Add(new DataParameter("itemname", info.itemname));
pars.Add(new DataParameter("itemmark", info.itemmark));
pars.Add(new DataParameter("navigation", info.navigation));
pars.Add(new DataParameter("sourcevalue", info.sourcevalue));
pars.Add(new DataParameter("sourcetype", info.sourcetype));
pars.Add(new DataParameter("sorts", info.sorts));
pars.Add(new DataParameter("status", info.status));
string sqlstr = "insert into base_items (parentid,itemname,itemmark,navigation,sourcevalue,sourcetype,sorts,status) values (@parentid,@itemname,@itemmark,@navigation,@sourcevalue,@sourcetype,@sorts,@status) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 栏目管理 更新数据
/// </summary>
/// <param name="base_items">要更新的栏目管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_items info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("parentid", info.parentid));
pars.Add(new DataParameter("itemname", info.itemname));
pars.Add(new DataParameter("itemmark", info.itemmark));
pars.Add(new DataParameter("navigation", info.navigation));
pars.Add(new DataParameter("sourcevalue", info.sourcevalue));
pars.Add(new DataParameter("sourcetype", info.sourcetype));
pars.Add(new DataParameter("sorts", info.sorts));
pars.Add(new DataParameter("status", info.status));
string sqlstr = "update base_items set parentid=@parentid,itemname=@itemname,itemmark=@itemmark,navigation=@navigation,sourcevalue=@sourcevalue,sourcetype=@sourcetype,sorts=@sorts,status=@status where itemid=@itemid ";
pars.Add(new DataParameter("itemid", info.itemid));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
public object Get(string codes, string type, string flag, string itemid)
{
if (!string.IsNullOrEmpty(type))
{
base_items info = itemsBLL.selectitemmark(codes, type, out errmsg);
if (string.Equals("编辑", flag))
{
if (info != null)
{
return(new { valid = (string.Equals(info.itemid.ToString(), itemid)) ? true : false });
}
return(new { valid = true });
}
return(new { valid = (info == null)?true:false });
}
return(new { valid = false });
}
/// <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_items">要添加的栏目管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_items info, out string errmsg)
{
return(itemsDAL.Add(info, out errmsg));
}
/// <summary>
/// 栏目管理 详情查询
/// </summary>
public static base_items GetInfo(int itemid, out string errmsg)
{
base_items info = itemsDAL.GetInfo(itemid, out errmsg);
return(info);
}
/// <summary>
/// 栏目管理 更新数据
/// </summary>
/// <param name="base_items">要更新的栏目管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_items info, out string errmsg)
{
return(itemsDAL.Update(info, out errmsg));
}
