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