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 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);
}
public bool AddOrUpdate2(td_Service_2 entity)
{
var service = new DbHelperEfSql <td_Service_2>();
if (entity.ID < 1)
{
service.Add(entity);
}
return(service.Update(entity, c => c.ID == entity.ID));
}
public string ReturnNodeName(int NodeId)
{
var NodeName = "";
var szServices = new DbHelperEfSql <Nodes>();
var item = szServices.SearchBySingle(c => c.NodeId == NodeId);
if (item != null)
{
NodeName = item.NodeName;
}
return(NodeName);
}
public bool PhysicalDelete(int[] eIds, int iCode)
{
if (iCode == 0)
{
return(dbContext.PhysicalDeleteByCondition(c => eIds.Contains(c.ID)));
}
else
{
var service = new DbHelperEfSql <td_Service_2>();
return(service.PhysicalDeleteByCondition(c => eIds.Contains(c.ID)));
}
}
public bool IsAuthRoleNodeButton(Guid iUserid, int iNodeId, int iButtonId, bool isSuper)
{
var szServices = new DbHelperEfSql <vAuthRoleNodeButton>();
if (isSuper)
{
return(szServices.Count(c => c.UserID == iUserid && c.NodeId == iNodeId && c.ButtonId == iButtonId) > 0);
}
else
{
return(szServices.Count(c => c.UserID == iUserid && c.NodeId == iNodeId && c.ButtonId == iButtonId && c.IsSuper == 0) > 0);
}
}
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 bool UpdateAuthRoleNode(List <string> ids, Guid iRoleId)
{
var szServices = new DbHelperEfSql <AuthRoleNode>();
IList <AuthRoleNode> list = ids.Select(cc => new AuthRoleNode
{
AuthRoleNodeID = Guid.NewGuid(),
RoleID = iRoleId,
NodeId = Convert.ToInt32(cc),
OperateDate = DateTime.Now
}).ToList();
return(szServices.TransDeleteCAddL(list, c => c.RoleID == iRoleId));
}
public bool UpdateAuthNodeButton(List <string> ids, Guid iUserId)
{
var szServices = new DbHelperEfSql <AuthNodeButton>();
IList <AuthNodeButton> list = ids.Select(cc => new AuthNodeButton
{
AuthNodeButtonID = Guid.NewGuid(),
UserID = iUserId,
NodeButtonId = Convert.ToInt32(cc) - 100000,
OperateDate = DateTime.Now
}).ToList();
return(szServices.TransDeleteCAddL(list, c => c.UserID == iUserId));
}
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 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 <vNodeButton> SearchByValid(bool isSuper)
{
var szServices = new DbHelperEfSql <vNodeButton>();
if (isSuper)
{
return(szServices.SearchByAll());
}
else
{
return(szServices.SearchListByCondition(c => c.IsSuper == 0));
}
}
public IList <vCustomer> SearchListByAutoName(string keyword, int limit, Guid wId)
{
var szServices = new DbHelperEfSql <vCustomer>();
var iTotalRecord = 0;
if (!string.IsNullOrEmpty(keyword))
{
return(szServices.SearchByPageCondition(c => c.CustomerName.Contains(keyword) && c.IsValid == 1 && c.WelfareCentreID == wId, true, c => c.CustomerName, 0, limit, ref iTotalRecord));
}
else
{
return(szServices.SearchByPageCondition(c => c.IsValid == 1 && c.WelfareCentreID == wId, true, c => c.CustomerName, 0, limit, ref iTotalRecord));
}
}
public IList <vCustomer> SearchListByAuto(string keyword, int limit, int isStage)
{
var szServices = new DbHelperEfSql <vCustomer>();
var iTotalRecord = 0;
if (!string.IsNullOrEmpty(keyword))
{
return(szServices.SearchByPageCondition(c => c.CustomerName.Contains(keyword) && c.Stage == isStage && c.IsValid == 1, true, c => c.CustomerName, 0, limit, ref iTotalRecord));
}
else
{
return(szServices.SearchByPageCondition(c => c.Stage == isStage && c.IsValid == 1, true, c => c.CustomerName, 0, limit, ref iTotalRecord));
}
}
public Boolean AddOrUpdate(Roles item)
{
var szServices = new DbHelperEfSql <Roles>();
if (item.RoleID == Guid.Empty)
{
item.RoleID = Guid.NewGuid();
return(szServices.Add(item));
}
else
{
return(szServices.Update(item, c => c.RoleID == item.RoleID));
}
}
/// <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);
}
}
}
//姓名下拉
public IList <tbOrgTLJGCongYe> SearchListByAuto(string keyword, int limit)
{
var szServices = new DbHelperEfSql <tbOrgTLJGCongYe>();
var iTotalRecord = 0;
if (!string.IsNullOrEmpty(keyword))
{
return(szServices.SearchByPageCondition(c => c.StaffName.Contains(keyword) && c.IsValid == 1, true, c => c.StaffName, 0, limit, ref iTotalRecord));
}
else
{
return(szServices.SearchByPageCondition(c => c.IsValid == 1, true, c => c.StaffName, 0, limit, ref iTotalRecord));
}
}
public bool AddOrUpdate(Depts item)
{
var szServices = new DbHelperEfSql <Depts>();
if (item.DeptID == Guid.Empty)
{
item.DeptID = Guid.NewGuid();
return(szServices.Add(item));
}
else
{
return(szServices.Update(item, c => c.DeptID == item.DeptID));
}
}
public bool AddOrUpdate(AuthNodeButton item)
{
var szServices = new DbHelperEfSql <AuthNodeButton>();
if (item.AuthNodeButtonID == Guid.Empty)
{
item.AuthNodeButtonID = Guid.NewGuid();
return(szServices.Add(item));
}
else
{
return(szServices.Update(item, c => c.AuthNodeButtonID == item.AuthNodeButtonID));
}
}
public bool AddOrUpdate(Users item, bool isAdd)
{
var szServices = new DbHelperEfSql <Users>();
if (isAdd)
{
var isFlag = szServices.Add(item);
return(isFlag);
}
else
{
var isFlag = szServices.Update(item, c => c.UserID == item.UserID);
return(isFlag);
}
}
public bool ChangePassword(Guid welfareCentreId, Guid id, string iNewPassword)
{
string sql = string.Format("UPDATE Users SET Password='******',OperateDate=getdate() where UserID ='{1}'", iNewPassword, id);
var isFlag = DbHelperSql.ExecuteNonQuery(sql) > 0;
if (isFlag == true)
{
var isFw = false;
if (isFw == false)
{
var userService = new DbHelperEfSql <Users>();
var userItem = userService.SearchBySingle(c => c.UserID == id);
}
}
return(isFlag);
}
/// <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 <tbOrganization> SearchListByCondition()
{
var szSrevices = new DbHelperEfSql <tbOrganization>();
return(szSrevices.SearchListByCondition(c => c.IsValid == 1));
}
public bool PhysicalDeleteByCondition(Guid id)
{
var szServices = new DbHelperEfSql <tbOrganization>();
return(szServices.PhysicalDeleteByCondition(c => c.ID == id));
}
public bool PhysicalDeleteByCondition(string[] ids)
{
var szServices = new DbHelperEfSql <tbOrganization>();
return(szServices.PhysicalDeleteByCondition(c => ids.Contains(c.ID.ToString())));
}
public tbOrganization GetObjectByWelfareId(Guid?welfareId)
{
var szServices = new DbHelperEfSql <tbOrganization>();
return(szServices.SearchBySingle(c => c.WelfareId == welfareId && c.IsValid == 1));
}
public tbOrganization GetObjectById(Guid id)
{
var szServices = new DbHelperEfSql <tbOrganization>();
return(szServices.SearchBySingle(c => c.ID == id));
}
public bool AddOrUpdate(tbOrganization item, bool isAdd)
{
var szServices = new DbHelperEfSql <tbOrganization>();
return(isAdd ? szServices.Add(item) : szServices.Update(item, c => c.ID == item.ID));
}
public tbOrganization SearchItemByNew(Guid?iWelfareId)
{
var szServices = new DbHelperEfSql <tbOrganization>();
return(szServices.SearchBySingle(c => c.IsValid == 1 && c.WelfareId == iWelfareId, true, c => c.OperateDate));
}
