public void ManageRoom(int roomid, Model.RoomStatus status, int operatorid, string operateName, string comment = "")
{
DAL.wx_hotel_room roomDal = new DAL.wx_hotel_room();
Model.wx_hotel_room model = roomDal.GetModel(roomid);
model.Status = status;
using (TransactionScope scope = new TransactionScope())
{
roomDal.Update(model);
Model.wx_hotel_room_manage manageInfo = new Model.wx_hotel_room_manage();
manageInfo.RoomId = model.id;
manageInfo.Operator = operatorid;
manageInfo.OperateName = operateName;
manageInfo.OperateTime = DateTime.Now;
manageInfo.Comment = comment;
_dal.Add(manageInfo);
scope.Complete();
}
}
public int Add(Model.wx_hotel_room_manage model)
{
StringBuilder query = new StringBuilder();
query.Append("Insert Into[dbo].[wx_hotel_room_manage]");
query.Append(" ([RoomId],[Operator],[OperateName],[OperateTime],[Comment])");
query.Append("Values");
query.Append(" (@RoomId, @Operator, @OperateName, @OperateTime, @Comment)");
query.Append("Select @Id = Scope_Identity()");
using (IDbConnection db = DbFactory.GetOpenedConnection())
{
DynamicParameters dynamicParameters = new DynamicParameters();
dynamicParameters.AddDynamicParams(model);
dynamicParameters.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output);
db.Execute(query.ToString(), dynamicParameters);
return(dynamicParameters.Get <int>("@Id"));
}
}
public int Add(Model.wx_hotel_room_manage model)
{
return(_dal.Add(model));
}
