/// <summary> /// 修改教室 /// </summary> /// <param name="model">教室实体</param> public bool EditRoom(Sys_ClassRoom model) { using (var conn = OpenConnection()) { const string sqlwhere = @"update Sys_ClassRoom set RoomName=@RoomName,RoomNumber=@RoomNumber,ColumnNumber=@ColumnNumber,RowNumber=@RowNumber,Memo=@Memo where Id=@Id"; var param = new { model.RoomName, model.RoomNumber, model.ColumnNumber, model.RowNumber, model.Memo, model.Id }; var result = conn.Execute(sqlwhere, param); return(result > 0); } }
/// <summary> /// 保存教室 /// </summary> /// <param name="form">表单数据</param> /// <param name="id">教室ID</param> /// <returns></returns> public JsonResult SubmitClassRoom(FormCollection form, int id) { var room = new Sys_ClassRoom { Id = id, Memo = form["roomMemo"], RoomName = form["roomName"].Trim(), RoomNumber = form["roomNumber"].StringToInt32(), RowNumber = form["roomRow"].StringToInt32(), ColumnNumber = form["roomCol"].StringToInt32(), LastUpdateTime = DateTime.Now, UserID = CurrentUser.UserId, IsDelete = 0 }; var flag = id == 0 ? RoomBl.AddRoom(room) : RoomBl.EditRoom(room); return (Json(flag ? new { result = 1, content = "成功" } : new { result = 0, content = "添加失败" }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 增加教室 /// </summary> /// <param name="model">教室实体</param> public bool AddRoom(Sys_ClassRoom model) { using (var conn = OpenConnection()) { const string sqlwhere = @"insert into Sys_ClassRoom (RoomName,RoomNumber,ColumnNumber,RowNumber,Memo,UserID,LastUpdateTime,IsDelete) values (@RoomName,@RoomNumber,@ColumnNumber,@RowNumber,@Memo,@UserID,@LastUpdateTime,@IsDelete) SELECT @@Identity as Id"; var param = new { model.RoomName, model.RoomNumber, model.ColumnNumber, model.RowNumber, model.Memo, model.UserID, model.LastUpdateTime, model.IsDelete }; var id = conn.Query <decimal>(sqlwhere, param).FirstOrDefault(); model.Id = decimal.ToInt32(id); return(model.Id > 0); } }
/// <summary> /// 修改教室 /// </summary> /// <param name="model">教室实体</param> public bool EditRoom(Sys_ClassRoom model) { return(roomDb.EditRoom(model)); }
/// <summary> /// 增加教室 /// </summary> /// <param name="model">教室实体</param> public bool AddRoom(Sys_ClassRoom model) { return(roomDb.AddRoom(model)); }