Hotel/Core/SM/Dal/ButtonDal.cs

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using Common;
using Common.Provider;
using Common.Data;
using Common.Data.Filter;
using Core.SM.Model;

namespace Core.SM.Dal
{
    public class ButtonDal : BaseRepository<Button>
    {
        public static ButtonDal Instance
        {
            get { return SingletonProvider<ButtonDal>.Instance; }
        }

        public string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJson, string sort = "keyid", string order = "asc")
        {
            string sortorder = sort + " " + order;

            var pcp = new ProcSmPage("SM_BUTTONS")
            {
                PageIndex = pageindex,
                PageSize = pagesize,
                OrderFields = sortorder,
                WhereString = FilterTranslator.ToSql(filterJson)
            };
            int recordCount;
            DataTable dt = base.GetPageWithSp(pcp, out recordCount);
            return JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt);

        }

            /// <summary>
            /// 取得程式頁面按鈕列表
            /// </summary>
            /// <param name="proid"></param>
            /// <returns></returns>
        public IEnumerable<Button> GetButtonsBy(int proid)
        {
            const string sql = "select b.*,n.sortnum sn from SM_PRO_BTN n join SM_BUTTONS b on n.BtnId=b.KeyId where n.ProId=@ProId order by n.Sortnum";
            return GetList(sql, new { ProId = proid });

        }


    }
}