/// <summary>
/// 分类管理 详情查询
/// </summary>
public object Get(int id)
{
base_classes info = classesBLL.GetInfo(id, out errmsg)
; if (!string.IsNullOrEmpty(errmsg))
{
return(new { Rcode = -1, Rmsg = "获取数据失败" });
}
return(new { Rcode = 1, Rdata = info });
}
/// <summary>
/// 分类管理 添加数据
/// </summary>
/// <param name="base_classes">要添加的分类管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_classes info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("classname", info.classname));
pars.Add(new DataParameter("parentclassid", info.parentclassid));
pars.Add(new DataParameter("remarks", info.remarks));
pars.Add(new DataParameter("icon", info.icon));
pars.Add(new DataParameter("sorts", info.sorts));
pars.Add(new DataParameter("tag", info.tag));
string sqlstr = "insert into base_classes (classname,parentclassid,remarks,icon,sorts,tag) values (@classname,@parentclassid,@remarks,@icon,@sorts,@tag) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 分类管理 更新数据
/// </summary>
public object Put(int id, [FromBody] base_classes info)
{
info.classid = id;
bool success = classesBLL.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 = "更新失败" }
}
;
BaseBLL.FreelyListCache.CacheRemove("Cache_ClassList");
return(new { Rcode = 1, Rmsg = "更新成功" });
}
public static void SetClassChildren(base_classes parentclass, List <base_classes> list)
{
parentclass.children = new List <base_classes>();
List <base_classes> ClassChildren = list.FindAll(
delegate(base_classes c)
{
return(c.parentclassid == parentclass.classid);
});
foreach (base_classes item in ClassChildren)
{
parentclass.children.Add(item);
SetClassChildren(item, list);
}
}
/// <summary>
/// 分类管理 更新数据
/// </summary>
/// <param name="base_classes">要更新的分类管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_classes info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("classname", info.classname));
pars.Add(new DataParameter("parentclassid", info.parentclassid));
pars.Add(new DataParameter("remarks", info.remarks));
pars.Add(new DataParameter("icon", info.icon));
pars.Add(new DataParameter("sorts", info.sorts));
pars.Add(new DataParameter("tag", info.tag));
string sqlstr = "update base_classes set classname=@classname,parentclassid=@parentclassid,remarks=@remarks,icon=@icon,sorts=@sorts,tag=@tag where classid=@classid ";
pars.Add(new DataParameter("classid", info.classid));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 分类管理 添加数据
/// </summary>
public object Post([FromBody] base_classes info)
{
if (string.IsNullOrEmpty(info.parentclassid.ToString()))
{
info.parentclassid = 0;
}
bool success = classesBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加分类{0},返回{1} {2}", info.classname, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
BaseBLL.FreelyListCache.CacheRemove("Cache_ClassList");
return(new { Rcode = 1, Rmsg = "添加成功" });
}
/// <summary>
/// 分类管理 列表查询
/// </summary>
/// <param name="queryarr">查询条件</param>
/// <param name="offset">起始条数</param>
/// <param name="limit">获取条数</param>
/// <param name="total">返回总记录数</param>
public static List <base_classes> GetPageList(out string errmsg)
{
int total = 0;
List <base_classes> list = classesDAL.GetPageList(new List <QueryModel>(), -1, 0, out total, out errmsg);
if (!string.IsNullOrEmpty(errmsg) || list == null)
{
return(new List <base_classes>());
}
int outparentclassid = 0;
foreach (var item in list)
{
item.parentclassname = BaseBLL.GlobalCommonBLL.GetClassName(int.TryParse(item.parentclassid.ToString(), out outparentclassid) ? int.Parse(item.parentclassid.ToString()) : outparentclassid);
}
base_classes rootclass = new base_classes()
{
classid = 0
};
SetClassChildren(rootclass, list);
return(rootclass.children);
}
/// <summary>
/// 分类管理 更新数据
/// </summary>
/// <param name="base_classes">要更新的分类管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_classes info, out string errmsg)
{
return(classesDAL.Update(info, out errmsg));
}
/// <summary>
/// 分类管理 添加数据
/// </summary>
/// <param name="base_classes">要添加的分类管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_classes info, out string errmsg)
{
return(classesDAL.Add(info, out errmsg));
}
/// <summary>
/// 分类管理 详情查询
/// </summary>
public static base_classes GetInfo(int classid, out string errmsg)
{
base_classes info = classesDAL.GetInfo(classid, out errmsg);
return(info);
}
