基于Metronic的Bootstrap开发框架经验总结（13）--页面链接收藏夹功能的实现2（利用Sortable进行拖动排序）

/// <summary>
/// 更新向上或者向下的顺序
/// </summary>
/// <param name="id">记录的ID</param>
/// <param name="moveUp">往上，还是往下移动，往上则为true</param>
/// <returns></returns>
public bool UpDown(string id, bool moveUp)
{
    //设置排序的规则
    bool IsDescending = true;

    bool result = false;
    WebFavoriteInfo info = FindByID(id);
    if (info != null)
    {
        //构建查询的条件
        string condition = "";
        if (IsDescending)
        {
            condition = string.Format("Seq {0} {1}", moveUp ? ">" : "<", info.Seq);
        }
        else
        {
            condition = string.Format("Seq {0} {1}", moveUp ? "<" : ">", info.Seq);
        }

        var list = baseDal.Find(condition);
        decimal newSeq = 0M;
        switch (list.Count)
        {
            case 0:
                newSeq = info.Seq;//已在顶部或者底部，顺序默认不变
                break;

            case 1:
                //上面或者下面有一个记录
                if (IsDescending)
                {
                    newSeq = moveUp ? (list[0].Seq + 1M) : (list[0].Seq - 1M);
                }
                else
                {
                    newSeq = !moveUp ? (list[0].Seq + 1M) : (list[0].Seq - 1M);
                }
                break;

            case 2:
                //中间区域,取平均值
                newSeq = (list[0].Seq + list[1].Seq) / 2M;
                break;

            default:
                //多于两个的情况
                if (moveUp)
                {
                    newSeq = (list[list.Count - 2].Seq + list[list.Count - 1].Seq) / 2M;
                }
                else
                {
                    newSeq = (list[0].Seq + list[1].Seq) / 2M;
                }
                break;
        }

        //统一修改顺序
        info.Seq = newSeq;
        result = Update(info, info.ID);
    }

    return result;
}

<ul id="items">
    <li>item 1</li>
    <li>item 2</li>
    <li>item 3</li>
</ul>

var el = document.getElementById('items');
var sortable = new Sortable(el);

    <div class="portlet-body flip-scroll">
        <div class="portlet-body">
            <div>
                <span>每页显示</span>
                <select id="rows" onchange="ChangeRows()">
                    <option>10</option>
                    <option selected>50</option>
                    <option>100</option>
                    <option>1000</option>
                </select>
                <span>条记录</span>&nbsp;&nbsp;
                <span>共有记录：</span><span id='totalCount' class="label label-success">0</span>条，总页数：<span id='totalPageCount' class="label label-success">0</span>页。
            </div>
            <hr />
            <div id="grid_body" class='list-group'></div>

            <div class="paging-toolbar">
                <ul id='grid_paging'></ul>
            </div>
        </div>
    </div>

<div class="list-group-item">
    <span class="glyphicon glyphicon-move" aria-hidden="true"></span>
    <a class="btn btn-sm blue" id="e1f462c6-c749-4258-836f-e13ee8c8acd7" 
       href="http://localhost:2251/User/Index?tid=2744DBF5-A648-47C1-9E9A-D8B405884389">系统用户信息</a>
    <i class="js-remove"></i>
</div>

var grid_body = document.getElementById('grid_body');
new Sortable(grid_body, {
    handle: '.glyphicon-move',
    filter: ".js-remove",
    animation: 150,
    onUpdate: function (/**Event*/evt) {
        var list = [];//构造集合对象
        $('.list-group div a').each(function (i, item) {
            list.push({ 'Text': item.text, 'Value': item.href });
        });

        var url = "/WebFavorite/EditFavorite";
        var postData = { list: list };
        $.post(url, postData, function (json) {
            var data = $.parseJSON(json);
            if (data.Success) {
                //showTips("操作成功");
                Refresh();//刷新页面数据
            }
            else {
                showTips(data.ErrorMessage);
            }
        });
    },
});

/// <summary>
/// 编辑记录列表
/// </summary>
/// <param name="list">记录列表</param>
/// <returns></returns>
[HttpPost]
public ActionResult EditFavorite(List<CListItem> list)
{
    CommonResult result = new CommonResult();

    var userid = CurrentUser.ID;

    DbTransaction trans = BLLFactory<WebFavorite>.Instance.CreateTransaction();
    if (trans != null)
    {
        try
        {
            //先删除就记录
            var condition = string.Format("Creator='{0}'", userid);
            BLLFactory<WebFavorite>.Instance.DeleteByCondition(condition, trans);

            //逐条添加记录
            int i = list.Count;
            foreach (CListItem item in list)
            {
                WebFavoriteInfo info = new WebFavoriteInfo();
                info.Title = item.Text;
                info.Url = item.Value;
                info.Seq = i--;
                info.Creator = CurrentUser.ID.ToString();

                BLLFactory<WebFavorite>.Instance.Insert(info, trans);
            }

            trans.Commit();
            result.Success = true;
        }
        catch(Exception ex)
        {
            result.ErrorMessage = ex.Message;
            trans.Rollback();
            LogHelper.Error(ex);
        }
    }
    return ToJsonContent(result);
}