public async Task <ResultData <QZ_Deparment_User> > Add(QZ_Deparment qZ_Deparment, QZ_User qZ_User)
{
var query = from du in ModelQZ.DatabaseContext.QZ_Deparment_User
where du.DeparmentId == qZ_Deparment.DeparmentId && du.UserId == qZ_User.UserId
select du;
QZ_Deparment_User data = query.FirstOrDefault();
if (data == null)
{
data = ModelQZ.DatabaseContext.QZ_Deparment_User.Add(new QZ_Deparment_User
{
DeparmentId = qZ_Deparment.DeparmentId,
UserId = qZ_User.UserId,
IsDeleteId = 0,
CreateTime = DateTime.Now.ToString(),
ModifyTime = DateTime.Now.ToString()
});
await ModelQZ.DatabaseContext.SaveChangesAsync();
}
ResultData <QZ_Deparment_User> result = new ResultData <QZ_Deparment_User> {
IsSuccessed = true, Data = data
};
return(result);
}
public async Task <ResultData <QZ_Deparment> > Add(QZ_Deparment qZ_Deparment)
{
//string message = "添加部门信息失败";
var query = from d in ModelQZ.DatabaseContext.QZ_Deparment
where d.DeparmentId == qZ_Deparment.DeparmentId
select d;
QZ_Deparment data = query.FirstOrDefault();
if (data == null)
{
qZ_Deparment.CreateTime = DateTime.Now.ToString();
qZ_Deparment.ModifyTime = DateTime.Now.ToString();
data = ModelQZ.DatabaseContext.QZ_Deparment.Add(qZ_Deparment);
await ModelQZ.DatabaseContext.SaveChangesAsync();
//message = string.Empty;
}
ResultData <QZ_Deparment> result = new ResultData <QZ_Deparment> {
IsSuccessed = true, Data = data
};
return(result);
}
public ResultData <QZ_Deparment> Query(QZ_Deparment qZ_Deparment)
{
string message = "没有该部门信息";
var query = from d in ModelQZ.DatabaseContext.QZ_Deparment
where d.DeparmentId == qZ_Deparment.DeparmentId
select d;
QZ_Deparment data = query.FirstOrDefault();
if (data != null)
{
message = string.Empty;
}
ResultData <QZ_Deparment> result = new ResultData <QZ_Deparment> {
IsSuccessed = data != null, Message = message, Data = data
};
return(result);
}
public ResultData <QZ_Deparment> QueryDeparmentByUser(QZ_User qZ_User)
{
string message = "没有该部门信息";
var query = from du in ModelQZ.DatabaseContext.QZ_Deparment_User
join d in ModelQZ.DatabaseContext.QZ_Deparment
on du.DeparmentId equals d.DeparmentId
where du.UserId == qZ_User.UserId
select d;
QZ_Deparment data = query.FirstOrDefault();
if (data != null)
{
message = string.Empty;
}
ResultData <QZ_Deparment> result = new ResultData <QZ_Deparment> {
IsSuccessed = data != null, Message = message, Data = data
};
return(result);
}
