using System;
using System.Collections.Generic;
using System.Text;
using Model;
using Common;
using System.Data;

namespace BLL
{
    public class DALGetUserMenu : IDALGerUserMenu
    {
        public IList<ResMenu> GetList(string UserCode)
        {


            try
            {
                IList<ResMenu> list = new List<ResMenu>();

                StringBuilder strSql = new StringBuilder();
                strSql.Append("Select ResNum,ResName,ParentName,UserCode,CssName,ResType,Url,Ord,IsDel from view_getUserMenu where ");
                strSql.Append("UserCode = @UserCode ");
                strSql.Append("and IsDel != 1 and left(ResNum,2) <> 'RF'  order by  Ord");
                SqlParam[] para = new SqlParam[]
                {
                new SqlParam("@UserCode", UserCode),

                };

                IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);


                list = ModelConvertHelper<ResMenu>.DataReaderToModel(dt);


                return list;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

    }
}