public IList <vAuthRoleNodeButton> GetListByUserIdNodeId(Guid iUserId, int iNodeId, bool isSuper)
{
var szServices = new DbHelperEfSql <vAuthRoleNodeButton>();
if (isSuper)
{
return(szServices.SearchListByCondition(c => c.UserID == iUserId && c.NodeId == iNodeId, true, c => c.OrderIndex));
}
else
{
return(szServices.SearchListByCondition(c => c.UserID == iUserId && c.NodeId == iNodeId && c.IsSuper == 0, true, c => c.OrderIndex));
}
}
public IList <vLeftAuthRoleNode> SearchListByLeftUserId(Guid iUserId, bool isSuper)
{
var szServices = new DbHelperEfSql <vLeftAuthRoleNode>();
if (isSuper)
{
return(szServices.SearchListByCondition(c => c.UserID == iUserId, true, c => c.OrderIndex));
}
else
{
return(szServices.SearchListByCondition(c => c.UserID == iUserId && c.IsSuper == 0, true, c => c.OrderIndex));
}
}
public IList <Nodes> SearchLeftListByValid(bool isSuper, int nodeType)
{
var szServices = new DbHelperEfSql <Nodes>();
if (isSuper)
{
return(szServices.SearchListByCondition(c => c.IsValid == 1 && c.IsLeftNode == 1 && c.NodeBizType == nodeType));
}
else
{
return(szServices.SearchListByCondition(c => c.IsValid == 1 && c.IsLeftNode == 1 && c.IsSuper == 0 && c.NodeBizType == nodeType));
}
}
public IList <Nodes> SearchListByValid(bool isSuper)
{
var szServices = new DbHelperEfSql <Nodes>();
if (isSuper)
{
return(szServices.SearchListByCondition(c => c.IsValid == 1));
}
else
{
return(szServices.SearchListByCondition(c => c.IsValid == 1 && c.IsSuper == 0));
}
}
public double SearchByCustomerAgeAverage()
{
var szSrevices = new DbHelperEfSql <tbCustomer>();
var list = szSrevices.SearchListByCondition(c => c.IsValid == 1 && c.BedID != null);
return(list.Average(c => c.CustomerAge) ?? 0);
}
private void DoNurseByWhole(Guid welfareCentreId, Guid CustomerID, Guid HgID, Guid NursingMessageID, ref string content)
{
var szServices = new DbHelperEfSql <tbNursingPer>();
var list = szServices.SearchListByCondition(c => c.CustomerID == CustomerID && c.HgID == HgID && c.NursingMessageID == NursingMessageID && c.WelfareCentreID == welfareCentreId && c.IsValid == 1);
if (list == null || list.Count <= 0)
{
return;
}
var arrayRank = new List <int?>();
foreach (var item in list)
{
arrayRank.Add(item.NursingRankID);
}
var szRank = new DbHelperEfSql <tbNursingRank>();
var source = szRank.SearchListByCondition(c => arrayRank.Contains(c.ID) && c.WelfareCentreID == welfareCentreId);
if (source == null)
{
source = new List <tbNursingRank>();
}
var szServiceExt = new DbHelperEfSql <tbNursingPerExt>();
var sourceExt = szServiceExt.SearchListByCondition(c => c.CustomerID == CustomerID && c.HgID == HgID && c.NursingMessageID == NursingMessageID && c.WelfareCentreID == welfareCentreId && c.IsValid == 1);
if (sourceExt == null)
{
sourceExt = new List <tbNursingPerExt>();
}
DoFactNurseByWhole(welfareCentreId, source, sourceExt, ref content);
}
public IList <vNodeButton> SearchByValid(bool isSuper)
{
var szServices = new DbHelperEfSql <vNodeButton>();
if (isSuper)
{
return(szServices.SearchByAll());
}
else
{
return(szServices.SearchListByCondition(c => c.IsSuper == 0));
}
}
/// <summary>
/// 递归获取子项内容
/// </summary>
/// <param name="parentId"></param>
/// <param name="resultList"></param>
/// <param name="list"></param>
private void SearchListByWhole(int parentId, Guid?welfareCentreId, IList <tbNursingRank> resultList, IList <tbNursingRank> list)
{
var szServices = new DbHelperEfSql <tbNursingRank>();
list = szServices.SearchListByCondition(c => c.ParentID == parentId && c.WelfareCentreID == welfareCentreId && c.IsValid == 1, true, c => c.OrderIndex);
if (list != null && list.Count > 0)
{
foreach (var item in list)
{
resultList.Add(item);
SearchListByWhole(item.ID, item.WelfareCentreID, resultList, list);
}
}
}
/// <summary>
/// 递归获取护理内容项顶级id
/// 修改方法：添加参数养老院id--welfareCentreId，防止多家养老院是取值重复 2019-02-28 林中枝修改
/// </summary>
/// <param name="parentId"></param>
/// <param name="resultId"></param>
private void DoExtByWhole(Guid?welfareCentreId, int?parentId, ref int resultId)
{
var szServices = new DbHelperEfSql <tbNursingRank>();
var item = szServices.SearchBySingle(c => c.ID == parentId && c.WelfareCentreID == welfareCentreId);
if (item == null)
{
return;
}
var listK = szServices.SearchListByCondition(c => c.ParentID == 0 && c.WelfareCentreID == welfareCentreId && c.IsValid == 1);
if (listK == null || listK.Count <= 0)
{
return;
}
if (listK.Count(c => c.ID == item.ParentID && c.WelfareCentreID == welfareCentreId) > 0)
{
resultId = item.ID;
}
else
{
DoExtByWhole(item.WelfareCentreID, item.ParentID, ref resultId);
}
}
public IList <AuthRoleNodeButton> GetListByRoleId(Guid?iRoleId)
{
var szServices = new DbHelperEfSql <AuthRoleNodeButton>();
return(szServices.SearchListByCondition(c => c.RoleID == iRoleId));
}
public IList <Nodes> GetListByLeftNode()
{
var szServices = new DbHelperEfSql <Nodes>();
return(szServices.SearchListByCondition(c => c.IsLeftNode == 1));
}
public IList <tbCustomer> SearchAllByIsValid()
{
var szSrevices = new DbHelperEfSql <tbCustomer>();
return(szSrevices.SearchListByCondition(c => c.IsValid == 1));
}
public IList <tbCustomer> SearchAllByIsValid(Guid welfareCentreId)
{
var szSrevices = new DbHelperEfSql <tbCustomer>();
return(szSrevices.SearchListByCondition(c => c.IsValid == 1 && c.WelfareCentreID == welfareCentreId));
}
/// <summary>
/// 离院老人
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public IList <vCustomer> GetCustomerByLiyuan(Guid welfareCentreId, DateTime startDate, DateTime endDate)
{
var szServices = new DbHelperEfSql <vCustomer>();
return(szServices.SearchListByCondition(c => c.WelfareCentreID == welfareCentreId && c.OperateDate >= startDate && c.OperateDate < endDate && c.IsValid != 1, false, c => c.OperateDate));
}
public IList <tbCustomer> SearchAllOrderByName()
{
var szSrevices = new DbHelperEfSql <tbCustomer>();
return(szSrevices.SearchListByCondition(c => c.IsValid == 1, true, c => c.CustomerXMPY));
}
public IList <tbCustomer> SearchLaorenByZdzl(Guid welfareCentreId)
{
var szSrevices = new DbHelperEfSql <tbCustomer>();
return(szSrevices.SearchListByCondition(c => c.IsValid == 1 && c.Describe == "重点照料" && c.WelfareCentreID == welfareCentreId));
}
public IList <tbDictionary> SearchListByType(int iType)
{
var szService = new DbHelperEfSql <tbDictionary>();
return(szService.SearchListByCondition(c => c.DictionaryID == iType && c.IsValid == 1));
}
public IList <tbNursingRank> SearchListByParentId(Guid welfareCentreId)
{
var szServices = new DbHelperEfSql <tbNursingRank>();
return(szServices.SearchListByCondition(c => c.ParentID == 0 && c.IsValid == 1 && c.WelfareCentreID == welfareCentreId, true, c => c.OperateDate));
}
public IList <NodeButton> SearchByValid(int nodeId)
{
var szServices = new DbHelperEfSql <NodeButton>();
return(szServices.SearchListByCondition(c => c.NodeId == nodeId));
}
public IList <vNursingPerLedger> GetById(Guid?welfareCentreId)
{
var szServices = new DbHelperEfSql <vNursingPerLedger>();
return(szServices.SearchListByCondition(c => c.WelfareCentreID == welfareCentreId && c.IsValid == 1));
}
public IList <AuthNodeButton> GetListByUserId(Guid iUserId)
{
var szServices = new DbHelperEfSql <AuthNodeButton>();
return(szServices.SearchListByCondition(c => c.UserID == iUserId));
}
public IList <Nodes> SearchListByValid()
{
var szServices = new DbHelperEfSql <Nodes>();
return(szServices.SearchListByCondition(c => c.IsValid == 1));
}
public IList <Nodes> SearchListByType(int pId, int nodeType)
{
var szServices = new DbHelperEfSql <Nodes>();
return(szServices.SearchListByCondition(c => c.IsLeftNode == 1 && c.ParentID == pId && c.NodeBizType == nodeType));
}
public IList <Nodes> GetListByLeftNode(int pId)
{
var szServices = new DbHelperEfSql <Nodes>();
return(szServices.SearchListByCondition(c => c.IsLeftNode == 1 && c.ParentID == pId));
}
public IList <Attachments> SearchListByPid(Guid pid, int tableType)
{
var szServices = new DbHelperEfSql <Attachments>();
return(szServices.SearchListByCondition(c => c.ParentGUID == pid && c.TableType == tableType));
}
public IList <tbOrgTLJGCongYe> SearchListByValid(Guid welfareCentreId)
{
var szServices = new DbHelperEfSql <tbOrgTLJGCongYe>();
return(szServices.SearchListByCondition(c => c.IsValid == 1 && c.WelfareId == welfareCentreId));
}
public IList <tbOrganization> SearchListByCondition()
{
var szSrevices = new DbHelperEfSql <tbOrganization>();
return(szSrevices.SearchListByCondition(c => c.IsValid == 1));
}
public IList <tbDictionary> SearchListByType(Guid welfareCentreId, int iType)
{
var szService = new DbHelperEfSql <tbDictionary>();
return(szService.SearchListByCondition(c => c.DictionaryType == iType && c.WelfareCentreID == welfareCentreId && c.IsValid == 1, true, c => c.DictionaryID));
}