You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
34 lines
830 B
C#
34 lines
830 B
C#
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);
|
|
}
|
|
}
|
|
}
|