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