QMS.DAL/SysLimitDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.Mvc;
using QMS.Model;
using QMS.Common;

namespace QMS.DAL
{
/// <summary>
/// 权限列表-数据访问类
/// 创建人:Jimy
/// 日期:2016/8/6 2:50:13
/// </summary>

public class  SysLimitDAL:Base.SysLimit
{
    #region 读取排序号
    /// <summary>
    /// 读取排序号
    /// </summary>
    public int GetListID(SqlTransaction trans)
    {
        StringBuilder sql = new StringBuilder();
        sql.Append("select top 1 ListID from t_SysLimit order by ListID desc");
        object obj = GetScalar(trans, CommandType.Text, sql.ToString(), null);
        int ListID = 0;
        try { ListID = Convert.ToInt32(obj); }
        catch { ListID = 0; }
        return ListID + 1;
    }
    #endregion

    #region 排序信息
    /// <summary>
    /// 排序信息
    /// </summary>
    /// <returns></returns>
    public void OrderInfo(SqlTransaction trans, int ListID, int OldListID)
    {
        if (ListID > OldListID)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("update t_SysLimit set ListID=ListID-1 where SysLimitID in(select SysLimitID from t_SysLimit where  ListID<=@ListID and ListID>@OldListID)");
            SqlParameter[] cmdParams = {
                new SqlParameter("@ListID",ListID),
                new SqlParameter("@OldListID",OldListID)};
            ExecuteSql(trans, CommandType.Text, sql.ToString(), cmdParams);
        }
        else if (ListID < OldListID)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("update t_SysLimit set ListID=ListID+1 where SysLimitID in(select SysLimitID from t_SysLimit where  ListID>=@ListID and ListID<@OldListID)");
            SqlParameter[] cmdParams = {
                new SqlParameter("@ListID",ListID),
                new SqlParameter("@OldListID",OldListID)};