/// <summary>
/// 通过DepartmentID更新实体
/// </summary>
/// <param name="entity">实体</param>
public static bool UpdateByDepartmentID(Model.Admin.MSDepartmentInfo entity)
{
var sql = @"
UPDATE [MSDepartmentInfo]
SET
[DepartmentName] = @DepartmentName
,[UpdateTime] = @UpdateTime
,[UpdateUser] = @UpdateUser
WHERE
[DepartmentID] = @DepartmentID
";
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@DepartmentID", Value = entity.DepartmentID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@DepartmentName", Value = entity.DepartmentName
});
parameters.Add(new SqlParameter()
{
ParameterName = "@UpdateTime", Value = entity.UpdateTime
});
parameters.Add(new SqlParameter()
{
ParameterName = "@UpdateUser", Value = entity.UpdateUser
});
int i = SqlHelper.ExecuteNonQuery(sql, parameters.ToArray());
return(i > 0 ? true : false);
}
public ActionResult SaveClassCallBack(string departmentId, long majorId, string departmentName)
{
if (departmentName.IsNullOrWhiteSpace())
{
return(Json(new { Message = "班级名称无效" }));
}
departmentName = departmentName.Trim();
string msg;
Model.Admin.MSDepartmentInfo departmentInfo = new Model.Admin.MSDepartmentInfo()
{
DepartmentID = Converter.TryToInt64(departmentId, -1),
DepartmentName = departmentName,
DepartmentLevel = (int)Model.DepartmentLevel.班级,
ParentID = majorId, //专业ID
Deleted = 0,
CreateTime = DateTime.Now,
CreateUser = Model.Identity.LoginUserInfo.UserID,
UpdateTime = DateTime.Now,
UpdateUser = Model.Identity.LoginUserInfo.UserID,
};
if (BLL.Admin.MSDepartmentInfoBll.SaveDepartmentInfo(departmentInfo, out msg))
{
msg = "OK";
}
return(Json(new { Message = msg }));
}
/// <summary>
/// 增加实体
/// </summary>
/// <param name="entity">实体</param>
public static long Add(Model.Admin.MSDepartmentInfo entity)
{
var sql = @"
INSERT INTO [MSDepartmentInfo]
(
[DepartmentName]
,[DepartmentLevel]
,[ParentID]
,[CreateTime]
,[CreateUser]
,[Deleted]
)
VALUES
(
@DepartmentName
,@DepartmentLevel
,@ParentID
,@CreateTime
,@CreateUser
,@Deleted
);SELECT SCOPE_IDENTITY();
";
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@DepartmentName", Value = entity.DepartmentName
});
parameters.Add(new SqlParameter()
{
ParameterName = "@DepartmentLevel", Value = entity.DepartmentLevel
});
parameters.Add(new SqlParameter()
{
ParameterName = "@ParentID", Value = entity.ParentID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@CreateTime", Value = entity.CreateTime
});
parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUser", Value = entity.CreateUser
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Deleted", Value = entity.Deleted
});
return(Converter.TryToInt64(SqlHelper.ExecuteScalar(sql, parameters.ToArray())));
}
public static bool SetDirectorInfo(long departmentId, long directorId, int positionCode, out string errorMsg)
{
errorMsg = "";
//查询部门信息
Model.Admin.MSDepartmentInfo departmentInfo = DAL.Admin.MSDepartmentInfoDal.GetByDepartmentID(departmentId);
if (departmentInfo == null)
{
errorMsg = "数据不存在，请刷新列表重新操作！";
return(false);
}
//查询部门指定岗位信息
Model.Admin.MSPositionInfo positionInfo = DAL.Admin.MSPositionInfoDal.GetByDepartmentIdAndPositionType(departmentId, positionCode);
if (positionInfo == null)
{
errorMsg = "数据错误，请联系管理员！";
return(false);
}
//查询该岗位有没有绑定用户
List <Model.Admin.MSUserPositionRelation> relationList = DAL.Admin.MSUserPositionRelationDal.GetListByPositionID(positionInfo.PositionID);
if (relationList != null && relationList.Count > 0)
{
Model.Admin.MSUserPositionRelation relationEntity = relationList[0];
//更新用户ID
DAL.Admin.MSUserPositionRelationDal.UpdateUserIDByRelationId(relationEntity.RelationID, directorId);
}
else
{
//未绑定插入
Model.Admin.MSUserPositionRelation relationEntity = new MSUserPositionRelation()
{
PositionID = positionInfo.PositionID,
UserID = directorId,
Deleted = 0,
CreateTime = DateTime.Now,
CreateUser = Model.Identity.LoginUserInfo.UserID
};
DAL.Admin.MSUserPositionRelationDal.Add(relationEntity);
}
return(true);
}
