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)); }