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