using SqlSugar;
using ZJ_BYD.Model;
using ZJ_BYD.Untils;

namespace ZJ_BYD.DB
{
    public class DeptHelper
    {
        public DeptHelper() : base()
        {

        }

        /// <summary>
        /// 查询工厂
        /// </summary>
        /// <returns></returns>
        public static ISugarQueryable<T_Dept> QueryDepts()
        {
            return DBHelper.sqlSugarDb.Queryable<T_Dept>().Where(m => !m.IsDeleted);
        }

        /// <summary>
        /// 根据地域代码查询工厂
        /// </summary>
        /// <param name="areaCode"></param>
        /// <returns></returns>
        public static ISugarQueryable<T_Dept> QueryDeptsByAreaCode(string areaCode)
        {
            return DBHelper.sqlSugarDb.Queryable<T_Dept>().Where(m => m.AreaCode == areaCode && !m.IsDeleted);
        }
    }
}