/// <summary>
/// 添加类别Root
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static FrontProductCategoryInfo InsertFrontProductCategoryRoot(FrontProductCategoryInfo info)
{
DataCommand cmd = DataCommandManager.GetDataCommand("InsertFrontProductCategoryRoot");
cmd.SetParameterValue("@CategoryName", info.CategoryName);
cmd.SetParameterValue("@IsLeaf", info.IsLeaf);
cmd.SetParameterValue("@Priority", info.Priority);
cmd.SetParameterValue("@Status", info.Status);
cmd.SetParameterValue("@FPCLinkUrlMode", info.FPCLinkUrlMode);
cmd.SetParameterValue("@FPCLinkUrl", info.FPCLinkUrl);
cmd.SetParameterValue("@UIModeType", info.UIModeType);
cmd.SetParameterValue("@SellerSysNo", info.SellerSysNo);
cmd.SetParameterValue("@InUserSysNo", info.InUserSysNo);
cmd.SetParameterValue("@InUserName", info.InUserName);
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
info.CategoryCode = cmd.GetParameterValue("@CategoryCode").ToString();
info.SysNo = int.Parse(cmd.GetParameterValue("@SysNo").ToString());
}
return(info);
}
public JsonResult SaveFrontProductCategory(FrontProductCategoryInfo info)
{
JsonResult result = new JsonResult();
if (info != null)
{
UserAuthVM user = UserAuthHelper.GetCurrentUser();
if (user != null)
{
info.SellerSysNo = user.SellerSysNo;
info.InUserSysNo = user.UserSysNo;
info.InUserName = user.UserDisplayName;
info.EditUserSysNo = user.UserSysNo;
info.EditUserName = user.UserDisplayName;
}
}
result.Data = ProductService.SaveFrontProductCategory(info);
return(result);
}
/// <summary>
/// 修改前台类别
/// </summary>
/// <param name="info"></param>
public static FrontProductCategoryInfo UpdateFrontProductCategory(FrontProductCategoryInfo info)
{
DataCommand cmd = DataCommandManager.GetDataCommand("UpdateFrontProductCategory");
cmd.SetParameterValue("@CategoryCode", info.CategoryCode);
cmd.SetParameterValue("@CategoryName", info.CategoryName);
cmd.SetParameterValue("@UIModeType", info.UIModeType);
cmd.SetParameterValue("@FPCLinkUrlMode", info.FPCLinkUrlMode);
cmd.SetParameterValue("@FPCLinkUrl", info.FPCLinkUrl);
cmd.SetParameterValue("@Priority", info.Priority);
cmd.SetParameterValue("@Status", info.Status);
cmd.SetParameterValue("@EditUserSysNo", info.EditUserSysNo);
cmd.SetParameterValue("@EditUserName", info.EditUserName);
cmd.SetParameterValue("@SellerSysNo", info.SellerSysNo);
cmd.ExecuteNonQuery();
info.SysNo = int.Parse(cmd.GetParameterValue("@SysNo").ToString());
info.Status = (CommonStatus)int.Parse(cmd.GetParameterValue("@StatusOutput").ToString());
return(info);
}
/// <summary>
/// 保存前台类别
/// </summary>
/// <param name="info"></param>
public static FrontProductCategoryInfo SaveFrontProductCategory(FrontProductCategoryInfo info)
{
if (info != null)
{
#region 验证
if (!info.SellerSysNo.HasValue)
{
throw new BusinessException("商家编号不能为空");
}
if (string.IsNullOrEmpty(info.CategoryName))
{
throw new BusinessException("名称不能为空");
}
if (info.FPCLinkUrlMode == Enums.FPCLinkUrlModeType.Define && string.IsNullOrEmpty(info.FPCLinkUrl))
{
throw new BusinessException("链接地址不能为空");
}
#endregion
if (string.IsNullOrEmpty(info.CategoryCode) && string.IsNullOrEmpty(info.ParentCategoryCode))//新增Root节点
{
info.IsLeaf = Enums.CommonYesOrNo.No;
return(ProductDA.InsertFrontProductCategoryRoot(info));
}
else if (string.IsNullOrEmpty(info.CategoryCode) && !string.IsNullOrEmpty(info.ParentCategoryCode))//新增子节点
{
info.IsLeaf = Enums.CommonYesOrNo.Yes;
return(ProductDA.InsertFrontProductCategory(info));
}
else//编辑
{
return(ProductDA.UpdateFrontProductCategory(info));
}
}
else
{
throw new BusinessException("不能添加空类");
}
}
/// <summary>
///
/// </summary>
/// <param name="info">前台类别</param>
/// <param name="selectedSysNo">选中的节点SysNo</param>
/// <param name="list">所有类别</param>
/// <returns></returns>
private static TreeInfo MappingTreeInfo(FrontProductCategoryInfo info, int selectedSysNo, List <FrontProductCategoryInfo> list)
{
TreeInfo treeInfo = new TreeInfo();
treeInfo.id = info.SysNo;
if (info.Status == Enums.CommonStatus.Actived)
{
treeInfo.text = info.CategoryName;
}
else
{
treeInfo.text = info.CategoryName + "(*)";
}
treeInfo.state = new TreeState();
if (info.SysNo == selectedSysNo)
{
treeInfo.state.selected = true;
}
else
{
treeInfo.state.selected = false;
}
if (list.Exists(item => item.ParentCategoryCode == info.CategoryCode))
{
treeInfo.type = "default";
treeInfo.icon = "fa fa-folder icon-state-warning icon-lg";
treeInfo.state.opened = true;
}
else
{
treeInfo.type = "file";
treeInfo.icon = "fa fa-file icon-state-warning";
treeInfo.state.opened = false;
}
return(treeInfo);
}
