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