134 lines
5.1 KiB
C#
134 lines
5.1 KiB
C#
using HL_FristAidPlatform_Help;
|
|
using HL_FristAidPlatform_IDataBase;
|
|
using HL_FristAidPlatform_Models;
|
|
using SqlSugar;
|
|
using System.Collections.Generic;
|
|
|
|
namespace HL_FristAidPlatform_DataBase
|
|
{
|
|
public class T_Base_CityDB : BaseDB, IT_Base_City
|
|
{
|
|
public SqlSugarClient db = GetClient();
|
|
|
|
/// <summary>
|
|
/// 新增
|
|
/// </summary>
|
|
/// <param name="city">实体</param>
|
|
/// <returns></returns>
|
|
public bool Add(T_Base_City city)
|
|
{
|
|
return db.Insertable(city).IgnoreColumns(ignoreNullColumn: true).ExecuteCommand() == 1 ? true : false;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除
|
|
/// </summary>
|
|
/// <param name="guids"></param>
|
|
/// <returns></returns>
|
|
public bool Dels(dynamic[] guids)
|
|
{
|
|
return db.Deleteable<T_Base_City>().In(new dynamic[] { guids }).ExecuteCommand() == 1 ? true : false;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改
|
|
/// </summary>
|
|
/// <param name="city"></param>
|
|
/// <returns></returns>
|
|
public bool Update(T_Base_City city)
|
|
{
|
|
return db.Insertable(city).IgnoreColumns(ignoreNullColumn: true).ExecuteCommand() == 1 ? true : false;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键获取实体
|
|
/// </summary>
|
|
/// <param name="guid"></param>
|
|
/// <returns></returns>
|
|
public T_Base_City Get(string guid)
|
|
{
|
|
return db.Queryable<T_Base_City>().First(it => it.GUID == guid);//查询单条
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取分页列表
|
|
/// </summary>
|
|
/// <param name="pageIndex"></param>
|
|
/// <param name="pageSize"></param>
|
|
/// <returns></returns>
|
|
public TableModel<T_Base_City> GetPageList(int pageIndex, int pageSize)
|
|
{
|
|
int total = 0;
|
|
List<T_Base_City> data = db.Queryable<T_Base_City>().ToPageList(pageIndex, pageSize, ref total);
|
|
TableModel<T_Base_City> t = new TableModel<T_Base_City>();
|
|
t.Code = 0;
|
|
t.PageCount = data.Count;
|
|
t.TotalNumber = total;
|
|
t.Data = data;
|
|
t.Msg = "成功";
|
|
return t;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取列表-无分页
|
|
/// </summary>
|
|
/// <param name="provinceCode">所属省份代码</param>
|
|
/// <returns></returns>
|
|
public TableModel<T_Base_City> GetList(string provinceCode)
|
|
{
|
|
TableModel<T_Base_City> t = new TableModel<T_Base_City>();
|
|
var listMode = db.Queryable<T_Base_City>().Where(it => it.ProvinceCode == provinceCode).OrderBy(it => it.OrderBy).ToList();
|
|
|
|
t.Code = 0;
|
|
t.PageCount = listMode.Count;
|
|
t.TotalNumber = listMode.Count;
|
|
t.Data = listMode;
|
|
t.Msg = "成功";
|
|
return t;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取当前辖区下的市
|
|
/// </summary>
|
|
/// <param name="pageIndex">起始页</param>
|
|
/// <param name="pageSize">每页大小</param>
|
|
/// <param name="provinceCode">所属省份代码</param>
|
|
/// <param name="keyWord">关键词</param>
|
|
/// <returns></returns>
|
|
public TableModel<T_Base_CityModel> GetPageListByProvinceCode(int pageIndex, int pageSize, string provinceCode, string keyWord)
|
|
{
|
|
int TotalNumber = 0;
|
|
TableModel<T_Base_CityModel> t = new TableModel<T_Base_CityModel>();
|
|
|
|
var listMode = db.Queryable<T_Base_City, T_Base_Province, T_SYS_SystemModule>((City, Province, SystemModule) => new object[] {
|
|
JoinType.Left,City.ProvinceCode==Province.ProvinceCode,
|
|
JoinType.Left,Province.SystemModuleID==SystemModule.ID,
|
|
})
|
|
.Where((City, Province, SystemModule) => City.ProvinceCode == provinceCode)
|
|
.WhereIF(!string.IsNullOrEmpty(keyWord), (City, Province, SystemModule) => City.Abbreviation.Contains(keyWord) || City.Initials.Contains(keyWord) || City.PymCode.Contains(keyWord) || City.WbmCode.Contains(keyWord) || City.CityCode.Contains(keyWord) || City.CityName.Contains(keyWord) || City.ProvinceCode.Contains(keyWord))
|
|
.Select((City, Province, SystemModule) => new T_Base_CityModel
|
|
{
|
|
GUID = City.GUID,
|
|
CityCode = City.CityCode,
|
|
CityName = City.CityName,
|
|
Abbreviation = City.Abbreviation,
|
|
Initials = City.Initials,
|
|
PymCode = City.PymCode,
|
|
WbmCode = City.WbmCode,
|
|
ProvinceCode = City.ProvinceCode,
|
|
OrderBy = City.OrderBy,
|
|
SystemModuleID = SystemModule.ID,
|
|
SystemName = SystemModule.ShortName,
|
|
ProvinceName = Province.ProvinceName,
|
|
}).OrderBy(City => City.OrderBy).ToPageList(pageIndex, pageSize, ref TotalNumber);
|
|
|
|
t.Code = 0;
|
|
t.PageCount = listMode.Count;
|
|
t.TotalNumber = TotalNumber;
|
|
t.Data = listMode;
|
|
t.Msg = "成功";
|
|
return t;
|
|
}
|
|
}
|
|
}
|