public async Task <ActionResult <MeetingRoomModel> > PostMeetingRoomModel(MeetingRoomModel meetingRoomModel) { _context.MeetingRooms.Add(meetingRoomModel); await _context.SaveChangesAsync(); return(CreatedAtAction("GetMeetingRoomModel", new { id = meetingRoomModel.Id }, meetingRoomModel)); }
private void MeetingRoomsListViewModel_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e) { if (_meetingRoomsListViewModel.SelectedItemIndex >= 0) { _meetingRoom = _meetingRoomsListViewModel.ListItems[_meetingRoomsListViewModel.SelectedItemIndex]; } }
/// <summary> /// 添加会议室信息的方法 /// </summary> /// <param name="MeetingRoomM">会议室信息</param> /// <returns>被添加会议室ID</returns> public static int MeetingRoomAdd(MeetingRoomModel MeetingRoomM) { try { #region 设置参数 SqlParameter[] param = new SqlParameter[10]; param[0] = SqlHelper.GetParameter("@CompanyCD ", MeetingRoomM.CompanyCD); param[1] = SqlHelper.GetParameter("@RoomName ", MeetingRoomM.RoomName); param[2] = SqlHelper.GetParameter("@Place ", MeetingRoomM.Place); param[3] = SqlHelper.GetParameter("@PersonCount ", MeetingRoomM.PersonCount); param[4] = SqlHelper.GetParameter("@MultimediaFlag", MeetingRoomM.MultimediaFlag); param[5] = SqlHelper.GetParameter("@Remark ", MeetingRoomM.Remark); param[6] = SqlHelper.GetParameter("@UsedStatus ", MeetingRoomM.UsedStatus); param[7] = SqlHelper.GetParameter("@ModifiedDate ", MeetingRoomM.ModifiedDate); param[8] = SqlHelper.GetParameter("@ModifiedUserID", MeetingRoomM.ModifiedUserID); SqlParameter paramid = new SqlParameter("@id", SqlDbType.Int); paramid.Direction = ParameterDirection.Output; param[9] = paramid; #endregion //创建命令 SqlCommand comm = new SqlCommand(); SqlHelper.ExecuteTransStoredProcedure("officedba.insertMeetingRoom", comm, param); int MeetingRoomID = Convert.ToInt32(comm.Parameters["@id"].Value); return(MeetingRoomID); } catch { return(0); } }
public async Task <IActionResult> PutMeetingRoomModel(int id, MeetingRoomModel meetingRoomModel) { if (id != meetingRoomModel.Id) { return(BadRequest()); } _context.Entry(meetingRoomModel).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MeetingRoomModelExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void StackPanel_Loaded(object sender, RoutedEventArgs e) { var context = this.DataContext as MeetingRoomDetailViewModel; _model = context.MeetingRoom; ContentPanel.DataContext = _model; context.PropertyChanged += Context_PropertyChanged; }
public async Task <MeetingRoomModel> UpdateAsync(MeetingRoomModel entity) { var mapped = _mapper.Map <MeetingRoom>(entity); _context.MeetingRooms.Update(mapped); await _context.SaveChangesAsync(); return(entity); }
/// <summary> /// 添加会议室信息 /// </summary> /// <returns>是否更新成功</returns> public bool AddMeetingRoom(MeetingRoomModel model) { using (var dbcontext = new MissionskyOAEntities()) { dbcontext.MeetingRooms.Add(model.ToEntity()); dbcontext.SaveChanges(); return(true); } }
public static MeetingRoom ToEntity(this MeetingRoomModel model) { var entity = new MeetingRoom() { MeetingRoomName = model.MeetingRoomName, Capacity = model.Capacity, Equipment = model.Equipment, Remark = model.Remark, Status = model.Status, CreateUserName = model.CreateUserName, CreateDate = model.CreateDate }; return(entity); }
/// <summary> /// 编辑 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Edit(int?id) { if (id.HasValue && id.Value > 0) { ViewBag.Title = "编辑会议室信息"; var model = this.MeetingService.GetMeetingRoomById(id.Value); return(View(model)); } else { ViewBag.Title = "添加会议室"; MeetingRoomModel model = new MeetingRoomModel(); return(View(model)); } }
public ActionResult Edit(MeetingRoomModel model) { string action = Request["Submit"]; if (action == "cancel") { return(RedirectToAction("Index")); } if (string.IsNullOrEmpty(model.MeetingRoomName)) { ModelState.AddModelError("MeetingRoomName", "请输入会议室名."); } if (string.IsNullOrEmpty(model.Equipment)) { ModelState.AddModelError("Equipment", "请输入设备."); } if ((model.Capacity) == 0) { ModelState.AddModelError("Capacity", "请输入可容纳人数."); } if (ModelState.IsValid) { try { if (model.Id > 0) { this.MeetingService.UpdateMeetingRoom(model); } else { model.CreateDate = DateTime.Now; model.CreateUserName = CommonInstance.GetInstance().LoginUser.EnglishName; this.MeetingService.AddMeetingRoom(model); } return(RedirectToAction("Index")); } catch (Exception ex) { ViewBag.Message = ex.Message; } } return(View(model)); }
public static MeetingRoomModel ToModel(this MeetingRoom entity) { var model = new MeetingRoomModel() { Id = entity.Id, MeetingRoomName = entity.MeetingRoomName, Capacity = entity.Capacity, Equipment = entity.Equipment, Remark = entity.Remark, Status = entity.Status, CreateUserName = entity.CreateUserName, CreateDate = entity.CreateDate }; return(model); }
/// <summary> /// 更新会议室信息 /// </summary> /// <returns>是否更新成功</returns> public bool UpdateMeetingRoom(MeetingRoomModel model) { using (var dbcontext = new MissionskyOAEntities()) { var entity = dbcontext.MeetingRooms.FirstOrDefault(it => it.Id == model.Id); if (entity == null) { throw new KeyNotFoundException("找不到会议室"); } entity.MeetingRoomName = model.MeetingRoomName; entity.Equipment = model.Equipment; entity.Capacity = model.Capacity; entity.Status = model.Status; entity.Remark = model.Remark; dbcontext.SaveChanges(); return(true); } }
public static UpdateMeetingRoomViewModel UpdateMeetingRoomViewModel(MeetingRoomModel meetingRoom, List <LocationModel> locationModels) { return(new UpdateMeetingRoomViewModel { MeetingRoom = new UpdateMeetingRoomModel { Id = meetingRoom.Id, Name = meetingRoom.Name, Seats = meetingRoom.Seats, Location = new LocationModel { Id = meetingRoom.Location.Id, Name = meetingRoom.Location.Name }, }, LocationModels = locationModels }); }
/// <summary> /// 根据会议室ID修改会议室信息 /// </summary> /// <param name="MeetingRoomM">会议室信息</param> /// <returns>bool值</returns> public static bool UpdateMeetingRoom(MeetingRoomModel MeetingRoomM) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.MeetingRoom set "); sql.AppendLine("CompanyCD =@CompanyCD ,"); sql.AppendLine("RoomName =@RoomName ,"); sql.AppendLine("Place =@Place ,"); sql.AppendLine("PersonCount =@PersonCount ,"); sql.AppendLine("MultimediaFlag=@MultimediaFlag,"); sql.AppendLine("Remark =@Remark ,"); sql.AppendLine("UsedStatus =@UsedStatus ,"); sql.AppendLine("ModifiedDate =@ModifiedDate ,"); sql.AppendLine("ModifiedUserID=@ModifiedUserID"); sql.AppendLine(" WHERE "); sql.AppendLine("ID = @ID "); SqlParameter[] param = new SqlParameter[10]; param[0] = SqlHelper.GetParameter("@ID ", MeetingRoomM.ID); param[1] = SqlHelper.GetParameter("@CompanyCD ", MeetingRoomM.CompanyCD); param[2] = SqlHelper.GetParameter("@RoomName ", MeetingRoomM.RoomName); param[3] = SqlHelper.GetParameter("@Place ", MeetingRoomM.Place); param[4] = SqlHelper.GetParameter("@PersonCount ", MeetingRoomM.PersonCount); param[5] = SqlHelper.GetParameter("@MultimediaFlag", MeetingRoomM.MultimediaFlag); param[6] = SqlHelper.GetParameter("@Remark ", MeetingRoomM.Remark); param[7] = SqlHelper.GetParameter("@UsedStatus ", MeetingRoomM.UsedStatus); param[8] = SqlHelper.GetParameter("@ModifiedDate ", MeetingRoomM.ModifiedDate); param[9] = SqlHelper.GetParameter("@ModifiedUserID", MeetingRoomM.ModifiedUserID); SqlHelper.ExecuteTransSql(sql.ToString(), param); return(SqlHelper.Result.OprateCount > 0 ? true : false); } catch { return(false); } }
public MeetingRoomDetailViewModel(MeetingRoomsListViewModel listViewModel) { MeetingRoom = new MeetingRoomModel(); _meetingRoomsListViewModel = listViewModel; _meetingRoomsListViewModel.PropertyChanged += MeetingRoomsListViewModel_PropertyChanged; }
public ManageMeetingRoomWindow(IMeetingRoom meetingRoom) : this() { _viewModel = new MeetingRoomModel(meetingRoom); DataContext = _viewModel; }
/// <summary> /// 根据会议室ID修改会议室信息 /// </summary> /// <param name="MeetingRoomM">会议室信息</param> /// <returns>bool值</returns> public static bool UpdateMeetingRoom(MeetingRoomModel MeetingRoomM) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; LogInfoModel logModel = new LogInfoModel(); //操作日志 bool isSucc = false; //定义返回变量 #region 设置操作日志内容 //设置公司代码 logModel.CompanyCD = userInfo.CompanyCD; //设置登陆用户ID logModel.UserID = userInfo.UserID; //设置模块ID 模块ID在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_MEETINGROOM_LIST; //操作单据编号 会议室名称 logModel.ObjectID = MeetingRoomM.RoomName; //操作对象 操作的表信息 logModel.ObjectName = ConstUtil.TABLE_NAME_DOC; //涉及关键元素 涉及其他业务、表关系 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //备注 操作类型 logModel.Remark = ConstUtil.LOG_PROCESS_UPDATE; #endregion try { isSucc = MeetingRoomDBHelper.UpdateMeetingRoom(MeetingRoomM); } catch (System.Exception ex) { #region 操作失败时记录日志到文件 //定义变量 LogInfo logSys = new LogInfo(); //设置日志类型 需要指定为系统日志 logSys.Type = LogInfo.LogType.SYSTEM; //指定系统日志类型 出错信息 logSys.SystemKind = LogInfo.SystemLogKind.SYSTEM_ERROR; //指定登陆用户信息 logSys.UserInfo = userInfo; //设定模块ID logSys.ModuleID = ConstUtil.MODULE_ID_MEETINGROOM_LIST; //描述 logSys.Description = ex.ToString(); //输出日志 LogUtil.WriteLog(logSys); #endregion } if (isSucc)//操作成功 { logModel.Remark += "成功"; } else//操作失败 { logModel.Remark += "失败"; } //记录日志 LogDBHelper.InsertLog(logModel); return(isSucc); }