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 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 Roles GetObjectById(Guid id)
{
var szServices = new DbHelperEfSql <Roles>();
return(szServices.SearchBySingle(c => c.RoleID == id));
}
public tbOrganization GetObjectById(Guid id)
{
var szServices = new DbHelperEfSql <tbOrganization>();
return(szServices.SearchBySingle(c => c.ID == id));
}
public Attachments GetObjectById(Guid id)
{
var szServices = new DbHelperEfSql <Attachments>();
return(szServices.SearchBySingle(c => c.AttachmentID == id));
}
public tbPaymentPlan GetById(Guid?welfareCentreId, Guid CustomerId)
{
var szServices = new DbHelperEfSql <tbPaymentPlan>();
return(szServices.SearchBySingle(c => c.WelfareCentreID == welfareCentreId && c.CustomerId == CustomerId && c.IsValid == 1));
}
/// <summary>
/// 根据Id获取单条数据...
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public V_ConstructionProject_Dept GetObjectDeptById(int iId)
{
var service = new DbHelperEfSql <V_ConstructionProject_Dept>();
return(service.SearchBySingle(c => c.ID == iId));
}
public vCustomer GetVijObjectById(Guid welfareCentreId, string BEDNO)
{
var szServices = new DbHelperEfSql <vCustomer>();
return(szServices.SearchBySingle(c => c.WelfareCentreID == welfareCentreId && c.BedNumber == BEDNO && c.IsValid == 1));
}
public Users LoginUsers(string szUserName, string password)
{
var szServices = new DbHelperEfSql <Users>();
return(szServices.SearchBySingle(c => (c.UserName == szUserName && c.Password == password && c.IsValid == 1)));
}
public Users LoginUsers(Guid id, string password)
{
var szServices = new DbHelperEfSql <Users>();
return(szServices.SearchBySingle(c => (c.UserID == id && c.Password == password && c.IsValid == 1)));
}
public Users LoginHgUsers(string szUserName, string password)
{
var szServices = new DbHelperEfSql <Users>();
return(szServices.SearchBySingle(c => (c.UserType == (int)EUserType.NursesAide || c.UserType == (int)EUserType.NursesAideBzz) && (c.UserName == szUserName && c.Password == password && c.IsValid == 1)));
}
public bool IsAuthNodeByCondition(Guid iUserId, int iNodeId)
{
var szServices = new DbHelperEfSql <AuthNode>();
return(szServices.SearchBySingle(c => c.UserID == iUserId && c.NodeId == iNodeId) != null);
}
/// <summary>
/// 根据Id获取单条数据
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
//public td_Service_1 GetObjectById(int iId)
//{
// return dbContext.SearchBySingle(c => c.ID == iId);
//}
/// <summary>
/// 根据Id获取单条数据(物理)
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public td_Service_1 GetObjectSer1ById(int iId)
{
var service = new DbHelperEfSql <td_Service_1>();
return(service.SearchBySingle(c => c.ID == iId));
}
public tbCustomer SearchByMaxAge()
{
var szSrevices = new DbHelperEfSql <tbCustomer>();
return(szSrevices.SearchBySingle(c => c.IsValid == 1, false, c => c.CustomerAge));
}
public vCustomer GetVObjectById(Guid Id)
{
var szServices = new DbHelperEfSql <vCustomer>();
return(szServices.SearchBySingle(c => c.ID == Id));
}
public Users GetObjectById(Guid id)
{
var szServices = new DbHelperEfSql <Users>();
return(szServices.SearchBySingle(c => c.UserID == id));
}
/// <summary>
/// 根据Id获取单条数据
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public V_Network_Dept GetObjectDeptById(int iId)
{
var service = new DbHelperEfSql <V_Network_Dept>();
return(service.SearchBySingle(c => c.ID == iId));
}
public NodeButton GetObjectByCondition(int nodeId, int buttonId)
{
var szServices = new DbHelperEfSql <NodeButton>();
return(szServices.SearchBySingle(c => c.NodeId == nodeId && c.ButtonId == buttonId));
}
public Nodes GetObjectById(int id)
{
var szServices = new DbHelperEfSql <Nodes>();
return(szServices.SearchBySingle(c => c.NodeId == id));
}
public Nodes GetObjectByName(string name)
{
var szServices = new DbHelperEfSql <Nodes>();
return(szServices.SearchBySingle(c => c.NodeName == name));
}
public vPaymentPlan GetVObjectById(Guid Id)
{
var szServices = new DbHelperEfSql <vPaymentPlan>();
return(szServices.SearchBySingle(c => c.ID == Id));
}
public bool AddOrUpdae(Users item)
{
try
{
var isAdd = true;
#region
var query = _context.Set <Users>().FirstOrDefault(c => c.UserID == item.UserID);
if (query == null)
{
isAdd = true;
var model = new Users();
model.UserID = item.UserID;
model.WelfareCentreID = item.WelfareCentreID;
model.Password = item.Password;
model.OperateDate = item.OperateDate;
model.UserCode = item.UserCode;
model.UserName = item.UserName;
model.RealName = item.RealName;
model.DeptID = item.DeptID;
model.RoleID = item.RoleID;
model.Remark = item.Remark;
model.UserType = item.UserType;
model.IcCardNo = item.IcCardNo;
model.CreateDate = item.CreateDate;
model.IsValid = item.IsValid;
_context.Set <Users>().Add(model);
}
else
{
isAdd = false;
query.UserID = item.UserID;
query.WelfareCentreID = item.WelfareCentreID;
if (item.Password != null && item.Password.Length > 0)
{
query.Password = item.Password;
}
query.OperateDate = item.OperateDate;
query.UserCode = item.UserCode;
query.UserName = item.UserName;
query.RealName = item.RealName;
query.DeptID = item.DeptID;
query.RoleID = item.RoleID;
query.Remark = item.Remark;
query.UserType = item.UserType;
query.IcCardNo = item.IcCardNo;
}
#endregion
#region tbUserWelfareCentre
if (item.UserType == (int)EUserType.YuanZhang)
{
var welfareCentreDao = new DbHelperEfSql <tbWelfareCentre>();
var welfareCentreItem = welfareCentreDao.SearchBySingle(c => c.ID == item.WelfareCentreID);
var query2 = _context.Set <tbUserWelfareCentre>().FirstOrDefault(c => c.WelfareCentreId == item.WelfareCentreID && c.UserName == item.UserName);
if (query2 == null)
{
var itemUserWelfareCentre = new tbUserWelfareCentre();
itemUserWelfareCentre.ID = Guid.NewGuid();
itemUserWelfareCentre.UserName = item.UserName;
if (item.Password != null && item.Password.Length > 0)
{
itemUserWelfareCentre.UserPassword = item.Password;
}
itemUserWelfareCentre.WebServiesUrl = Config.YuanZhan_URL;
itemUserWelfareCentre.IsUpdate = 1;
itemUserWelfareCentre.WelfareCentreId = item.WelfareCentreID;
itemUserWelfareCentre.WelfareCentreName = welfareCentreItem.WelfareCentreName;
itemUserWelfareCentre.IsValid = 1;
itemUserWelfareCentre.CreateDate = DateTime.Now;
itemUserWelfareCentre.Remark = "";
_context.Set <tbUserWelfareCentre>().Add(itemUserWelfareCentre);
}
else
{
query2.UserName = item.UserName;
if (item.Password != null && item.Password.Length > 0)
{
query2.UserPassword = item.Password;
}
query2.WebServiesUrl = Config.YuanZhan_URL;
query2.IsUpdate = 1;
query2.WelfareCentreId = item.WelfareCentreID;
query2.WelfareCentreName = welfareCentreItem.WelfareCentreName;
query2.IsValid = 1;
query2.CreateDate = DateTime.Now;
query2.Remark = "";
}
}
#endregion
_context.SaveChanges();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
MessageLog.WriteLog(new LogParameterModel()
{
ClassName = this.GetType().ToString(),
MethodName = "AddOrUpdaeUsers",
MethodParameters = "添加失败",
LogLevel = ELogLevel.Warn,
Message = ex.Message
});
return(false);
}
}
public AuthNodeButton GetObjectById(Guid id)
{
var szServices = new DbHelperEfSql <AuthNodeButton>();
return(szServices.SearchBySingle(c => c.AuthNodeButtonID == id));
}
public tbOrgTLJGCongYe GetObjectById(Guid id)
{
var szServices = new DbHelperEfSql <tbOrgTLJGCongYe>();
return(szServices.SearchBySingle(c => c.ID == 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));
}
public tbOrgTLJGCongYe GetObjectByWelfareId(Guid welfareId)
{
var szServices = new DbHelperEfSql <tbOrgTLJGCongYe>();
return(szServices.SearchBySingle(c => c.WelfareId == welfareId));
}
public tbOrganization GetObjectByWelfareId(Guid?welfareId)
{
var szServices = new DbHelperEfSql <tbOrganization>();
return(szServices.SearchBySingle(c => c.WelfareId == welfareId && c.IsValid == 1));
}
public Depts GetObjectById(Guid id)
{
var szServices = new DbHelperEfSql <Depts>();
return(szServices.SearchBySingle(c => c.DeptID == id));
}