84 lines
3.2 KiB
C#
84 lines
3.2 KiB
C#
using HL_FristAidPlatform_Help;
|
|
using HL_FristAidPlatform_IDataBase;
|
|
using HL_FristAidPlatform_Models;
|
|
using Newtonsoft.Json.Linq;
|
|
using SqlSugar;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
|
|
namespace HL_FristAidPlatform_DataBase
|
|
{
|
|
/// <summary>
|
|
/// 院前急救文件信息DB
|
|
/// </summary>
|
|
public class T_Service_FirstAid_FileInfoDB : BaseDB, IT_Service_FirstAid_FileInfo
|
|
{
|
|
public SqlSugarClient db = GetClient();
|
|
|
|
/// <summary>
|
|
/// 新增:集合
|
|
/// </summary>
|
|
/// <param name="modelList"></param>
|
|
/// <returns></returns>
|
|
public int AddList(List<T_Service_FirstAid_FileInfo> modelList)
|
|
{
|
|
return db.Insertable(modelList).IgnoreColumns(it => new { it.ID }).ExecuteCommand();
|
|
// return db.InsertRange(modelList) == true ? 1 : 0;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取 文件类型(文件后缀)
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public List<string> GetSuffixList()
|
|
{
|
|
JObject obj = new JObject();
|
|
List<string> list = db.Ado.SqlQuery<string>("SELECT Suffix FROM T_Service_FirstAid_FileInfo where DeleteFlag=@DeleteFlag group by Suffix", new { DeleteFlag = 0 });
|
|
return list;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 院前急救 数据列表 分页
|
|
/// </summary>
|
|
public TableModel<T_Service_FirstAid_FileInfo> GetPageList(string hospitalGuid, string fileName, string suffix, string startTime, string endTime, int pageIndex, int pageSize)
|
|
{
|
|
var expression = PredicateBuilder.True<T_Service_FirstAid_FileInfo>().And(x => x.DeleteFlag == 0).And(x => x.HospitalGuid == hospitalGuid);
|
|
if (!string.IsNullOrEmpty(fileName))
|
|
{
|
|
expression = expression.And(x => x.FileName.Contains(fileName));
|
|
}
|
|
if (!string.IsNullOrEmpty(suffix))
|
|
{
|
|
expression = expression.And(x => x.Suffix == suffix);
|
|
}
|
|
if (!string.IsNullOrEmpty(startTime))
|
|
{
|
|
var _startTime = DateTime.Parse(startTime);
|
|
expression = expression.And(x => x.CreationTime >= _startTime);
|
|
}
|
|
if (!string.IsNullOrEmpty(endTime))
|
|
{
|
|
var _endTime = DateTime.Parse(endTime).AddDays(1);
|
|
expression = expression.And(x => x.CreationTime <= _endTime);
|
|
}
|
|
int total = 0;
|
|
List<T_Service_FirstAid_FileInfo> data = db.Queryable<T_Service_FirstAid_FileInfo>().Where(expression).OrderBy(i=>i.CreationTime,OrderByType.Desc).ToPageList(pageIndex, pageSize, ref total);
|
|
TableModel<T_Service_FirstAid_FileInfo> t = new TableModel<T_Service_FirstAid_FileInfo>();
|
|
t.Code = 0;
|
|
t.PageCount = data.Count;
|
|
t.TotalNumber = total;
|
|
t.Data = data;
|
|
t.Msg = "成功";
|
|
return t;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键批量删除数据
|
|
/// </summary>
|
|
public int Delete(List<T_Service_FirstAid_FileInfo> list)
|
|
{
|
|
return db.Updateable(list).SetColumns(t => t.DeleteFlag == 1).ExecuteCommand();
|
|
}
|
|
}
|
|
}
|