前端JS

 

// //保存排序

// if (window.location.href.indexOf("showStatus=0") == -1) {

// $('#saveSort').click(function () {

// var Ids = '';

// $('#tab-sort tbody tr').each(function () {

// var id = $(this).attr('data-id');

// Ids += id + ',';

// });

Ids是得到拖动后的顺序

// if (Ids.length > 0) {

// Ids = Ids.substring(0, Ids.length - 1);

// }

// $.ajax({

// url: '',

// type: 'POST',

// data: { ids: Ids },

// dataType: 'text',

// success: function (ret) {

// alert(ret == '1' ? '保存成功' : '保存失败');

// window.location.reload();

// },

// error: function (xhr, t) {

// console.log(xhr, t);

// alert('保存失败');

// }

// });

// });

// }

 

MVC后台处理

// 任务管理保存排序

// POST: /Gift/SaveSort

[HttpPost]

public string SaveSort(string ids)

{

PayServices PayServices = new PayServices();

int ret = PayServices.SaveSort(ids) ? 1 : 0;

return ret.ToString();

}

 

 

/// <summary>

/// 保存排序

/// </summary>

/// <param name="giftIds"></param>

/// <returns></returns>

public bool SaveSort(string ids)

{

if (string.IsNullOrWhiteSpace(ids) || ids.IndexOf(',') < 0)

{

return false;

}

using (GiftInfrastructure g = new GiftInfrastructure())

{

return g.GiftSaveSort(ids);

}

}

 

/// <summary>

/// 保存任务管理序

/// </summary>

/// <param name="giftIds">eg: 101,102,103</param>

/// <returns></returns>

public bool GiftSaveSort(string ids)

{

DynamicParameters param = new DynamicParameters();

param.AddDynamicParams(new { giftIds= ids });

try

{

return conn.Execute("AS_SortUserTaskInfo", param, commandType: CommandType.StoredProcedure) > 0;

}

catch (Exception ex)

{

return false;

}

}

 

SQL数据库存储过程

ALTER proc [dbo].[SP_Mliao_SaveSort]

@giftIds varchar(2000) -- eg: 101,102,103

as

begin

if @giftIds is not null and CHARINDEX(',',@giftIds)>0

begin

select ROW_NUMBER()over(order by (select 0))sortid,a as id into #tab_sortid

from [tableListSplit] (@giftIds,',')

update a set a.sortId=b.sortid

from Mliao_Gift a,#tab_sortid b

where a.giftId=b.id

drop table #tab_sortid

end

end